I use "retain" to make variables in order.
But I don't know how to do the following:
I have a SAS dataset like:
A1 A2 A3 ... A300 B1 B2 B3 ... B300 C1 C2 C3 ... C300;
I want to make it in the following order;
A1 B1 C1 A2 B2 C2 A3 B3 C3 ... A300 B300 C300;
How?
Thanks
untested code:
%macro test;
data want;
retain %do i=1 %to 300;
a&i b&i c&i
%end;;
set have;
run;
%mend;
%test
untested code:
%macro test;
data want;
retain %do i=1 %to 300;
a&i b&i c&i
%end;;
set have;
run;
%mend;
%test
@Linlin
Thanks, your code works perfectly!
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.