@HWSteinberg wrote: All now works fine, my program does what I want it to do. But I'm still wondering why &%upcase(line) does not work but &&%upcase(line) works as posted on 04-27-2019 08:18 AM, just for my understanding. Not sure WHY it doesn't work. But HOW it doesn't work is that the value &LINE is not put into the macro variable.  Instead the value &%upcase(line) is put into the macro variable. 1719 %let one=&%upcase(line); 1720 %let two=&&%upcase(line); 1721 %put one=%superq(one); one=&%upcase(line) 1722 %put two=%superq(two); two=&LINE I suspect something about how it is breaking the string into tokens.  So with one & it treats it as one token without any macro code to resolve. With two & it sees it as two tokens. The first converts to & and the stops and the second converts to LINE. ... View more

data have (drop=i);   retain X1-X10 claim_type y1-y10 (21*1);   do i=1 to 3;     output;   end; run; data to_add;   informat claim_amt comma8.;   informat claim_no $3.;   input claim_amt claim_no;   cards; 86.42 001 5,680.00  002 257.00  003 ; data want;   set have;   set to_add; run; proc sql noprint;   select varnum     into :first_end       from dictionary.columns         where libname="WORK" and               memname="WANT" and               name="claim_type"   ;                 select name     into :reorder separated by " "       from         (select name            from dictionary.columns              where libname="WORK" and                    memname="WANT" and                    varnum lt &first_end.         outer union corr         select name            from dictionary.columns              where libname="WORK" and                    memname="WANT" and                    varnum gt &first_end.         outer union corr         select name            from dictionary.columns              where libname="WORK" and                    memname="WANT" and                    varnum eq &first_end.        ) ; quit; data want;   retain &reorder.;   set want; run; ... View more

proc sql; create table x as select  subjid, aeterm, min(aestdt) as mindate format=date9. from test group by subjid having aestdt = min(aestdt); quit; proc print; run; ... View more