Re: weblog to normal form

mysasbox@GMAIL.COM wrote:
>I have weblog in the following form:
>
>data weblog;
>input name $ value $;
>datalines;
>var1 abc
>var2 efg
>var3 hij
>var1 klm
>var2 nop
>var3 qrs
>var1 tuv
>;
>run;
>
>
>I need this normal form:
>
>var1 var2 var3
>
>abc efg hij
>klm nop qrs
>tuv
>
>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.

Mike:

[1] As Alan pointed out, you have something that isn't a weblog. What is
it?

[2] 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.

[3] 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
wrong path.

[4] 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
using
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.

HTH,
David
--
David L. Cassell
mathematical statistician
Design Pathways
3115 NW Norwood Pl.
Corvallis OR 97330

__________________________________________________ _______________
Express yourself instantly with MSN Messenger! Download today - it's FREE!
http://messenger.msn.click-url.com/g...ave/direct/01/