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!
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.