Re: weblog to normal form
>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!
|Thread||Thread Starter||Forum||Replies||Last Post|
|weblog to normal form||Ian Whitlock||Newsgroup comp.soft-sys.sas||0||04-15-2006 05:05 PM|
|Re: weblog to normal form||Sigurd Hermansen||Newsgroup comp.soft-sys.sas||0||04-12-2006 09:13 PM|
|Re: weblog to normal form||Michael Murff||Newsgroup comp.soft-sys.sas||0||04-11-2006 04:56 PM|
|Re: weblog to normal form||Alan Churchill||Newsgroup comp.soft-sys.sas||0||04-11-2006 03:15 PM|
|Re: weblog to normal form||toby dunn||Newsgroup comp.soft-sys.sas||0||04-11-2006 02:32 PM|