Hello again, I have a very similar follow-up question to my previous question. I have an unspecified number of tables (AAA1, AAA2, AAA3,...) that I want to transpose, and call them BBB1, BBB2,...etc. I am using the same solution to counting my AAA-tables, as suggested by the solution given here previously, which seems to work fine here too. The Proc Transpose-part, however does not work. I get the following error messages: NOTE: Line generated by the invoked macro "TRANSP". 52 data=AAA&no. out=BBB&no. (drop=_name_ _label_); id A; var B; ____ 180 for each table. And in the end: ERROR 180-322: Statement is not valid or it is used out of proper order. From what I understand, this error message is common when missing a semi-colon or similar. I have tried but not been able to fix it. Any suggestions? %macro transp;
proc sql noprint;
select count(memname) into :num from dictionary.tables where libname='WORK' and memtype='DATA'
and memname eqt "AAA";
quit;
proc transpose
%DO no=1 %TO &num.;
data=AAA&no. out=BBB&no. (drop=_name_ _label_);
id A;
var B;
%END;
run;
%mend;
%transp
... View more