Thank you. I am little confused with "where libname = "xxxxxx" and memname = "YYYYY" ". What am I supposed to fillup for the xxxxxx and YYYYY? I have posted a sample of my program, and can you please help me to correct it? I have struggled for few hours on this....:( %do i= 1 %to 2; %let PRIN1 = %scan(%bquote(&PRINLST), &i, ' '); %put &prin1; %do j = 1 %to 2; %let POS1 = %scan(%bquote(&POS),&j, ' '); %put &POS1; %do m=1 %to 2; %let CLSYRMTH1 = %scan(%bquote(&CLSYRMTH),&m, ' '); %put &CLSYRMTH1; %Basetable(&PRIN1, &POS1, &CLSYRMTH1); /*Gather base table*/ proc sql noprint; select nobs into :nobs from WORK.T_&PRIN1._&POS1._&CLSYRMTH1 where libname = "WORK" and memname = "YYYYY" ;quit; %if &nobs ne 0 %then %do; %TRANSPOSE(&PRIN1, &POS1, &CLSYRMTH1); /*Transpose step*/ %end; %end; %end; %end;
... View more