Hi DB_ECON
You can do that very easily by just appending and then sorting them.
Suppose your dataset name is A and you need output in B
Program:-
data B;
set A A;
run;
proc sort data=B;
by ID;
run;
You will get your required result in B dataset.
You can try the following code( as single is your original data set )
data new ;
set single;
do i=1 to 2;
output;
end;
run;
proc print data=new(drop=i) noobs;
run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.