Hi all,
I have a question on combining some data sets with macro. I have 4 tests and 12 grades. I would like to combine all of the grades for each relevant test. I don't get any error with the below code but it is taking only grade 12. Could you help me with what I am missing?
Thanks
%macro combine(k);
data &k._pl_all_n;
%do i=1 %to 12;
set pls_&k._gr_&i. ;
%end;
run;
%mend;
%combine(listening);
%combine(writing);
%combine(speaking);
%combine(reading);