I have output looks like this:
rownum meat col01 col02
1 beef a1 a2
1 chicken b1 b2
1 pork c1 c2
2 beef a3 a4
2 chicken b3 b4
2 pork c3 c4
I want to change into format like below:
rownum colnum beef chicken prok
1 01 a1 b1 c1
2 01 a3 b3 c3
1 02 a2 b2 c2
2 02 a4 b4 c4
How can I do it in sql?
Thanks!
Do you need to do that using proc sql? Quite easy using proc transpose:
proc transpose data=have out=want name=colnum; var col01 col02; by rownum; id meat; run; data want; set want; colnum=compress(colnum,,'kd'); run;
Art, CEO, AnalystFinder.com
Do you need to do that using proc sql? Quite easy using proc transpose:
proc transpose data=have out=want name=colnum; var col01 col02; by rownum; id meat; run; data want; set want; colnum=compress(colnum,,'kd'); run;
Art, CEO, AnalystFinder.com
@leonzheng Requesting you to kindly mark the question as answered and close the thread. Thank you!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.