Date: Tue, 11 Apr 2006 19:38:41 -0700
Reply-To: David L Cassell <davidlcassell@MSN.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: David L Cassell <davidlcassell@MSN.COM>
Subject: Re: weblog to normal form
Content-Type: text/plain; format=flowed
>I have weblog in the following form:
>input name $ value $;
>I need this normal form:
>var1 var2 var3
>abc efg hij
>klm nop qrs
>I haven't been able to use proc transpose to do this transformation. Would
>someone be so kind as to point me to a datastep solution.
 As Alan pointed out, you have something that isn't a weblog. What is
 I wouldn't call this a 'normal' form. An abnormal form, yes. :-)
I sort of wonder why you want this second form, since it looks like
it will make your work a lot harder.
 So I won't point out that a quick sort before your transpose would
probably solve your problem, since I think that may be leading you down the
 So what are you trying to do, and why do you think this transposed
format is going to help you? If all you're doing is data display, consider
PROC TABULATE or PROC REPORT instead. If the second variable is really
something from a weblog, then it may be way too long to conveniently
display as an 'across' variable in output.
David L. Cassell
3115 NW Norwood Pl.
Corvallis OR 97330
Express yourself instantly with MSN Messenger! Download today - it's FREE!