I try to use a macro variable "num" like this, proc sql;      select max(num) into :num      from dsn2; quit; data asd2;      set asd;      array a _COL3-_COL#      arrat b COL3-COL#      do i= 1 to dim(&num);      b(i)=input(a(i),best12.); run; well, it doesn't work, but if I do this, It seems works proc sql;      select max(num) into :num      from dsn2; quit; *******; %let numb=# data asd2;      set asd;      array a _COL3-_COL&numb;      arrat b COL3-COL&numb;      do i= 1 to dim(&numb);      b(i)=input(a(i),best12.); run; I don't why. Anyone can pls tell me? THX! ... View more

Hi, I get string variable like this,  2001-12 I'd like to transfer this variable into date format like yyyymm; How should I deal with this? THX! ... View more