It is a little hard to figure out the purpose of the different steps. But it seems to me that should move the call to zero out the numeric variables BEFORE the step where you are converting them to character variables. %_CONVERT_MV_TO_ZERO(cur_wk_fig) data cur_wk_fig; length relationship $5; set cur_wk cw_totals; cwhapct=divide(cwhapart,cmeligcount); eligc = put(cmeligcount,comma12.); hapct = put(cwhapct,percent12.1); part= put(cwhapart, comma12.); run; Or maybe even before take the sums. ... View more

Change %let nums=; to %let nums=0; When there are no records selected INTO will not change the value of the target macro variable. ... View more

I would recommend making the new key variable a different name than the raw variable that you are inputing. Also I am not sure why you want to remove the link to the value of the ADD variable on the extra rows. This code should do what you want. data temp;   length key $10 id 8 ;   input id1 id2 id3 add $ no$;   array ids id1-id3 ;   n=0;   do i=1 to dim(ids);     if ids(i) ne . then do;       id = ids(i);       n+1;       if n > 1 then add=' ';       key = catx('_',no,n);       output;     end;   end;   drop i n ; cards; 1  2 3  xyz a .   5  6  lkj b 6  7  .  mnb c 8  .  .   klm d .  .  10  sdf e run; proc print width=min; run; Obs  key  id   id1  id2  id3  add  no 1   a_1    1    1    2    3   xyz   a 2   a_2    2    1    2    3         a 3   a_3    3    1    2    3         a 4   b_1    5    .    5    6   lkj   b 5   b_2    6    .    5    6         b 6   c_1    6    6    7    .   mnb   c 7   c_2    7    6    7    .         c 8   d_1    8    8    .    .   klm   d 9   e_1   10    .    .   10   sdf   e ... View more

For this to work the macro code will need to change to : ... in (&&&list) ... ... View more

The problem is getting the commas past the macro call. You can quote them.   %test(%str(&list1)); You should also just test whether you need the commas at all.  You do not need them for the IN operator in normal SAS, but they might be required by MYSQL. In SAS code you can write : data new;    set old;   where id in (101 102 103); run; ... View more

You will have to read the file more than once. data length / view=length ;    infile &fileRef delimiter='09'x dsd end=eof truncover ;    length x1-x10 $200 ;    input x1-x10;    array var x1-x10;    array len len1-len10;    do over x; len = lengthm(x); end; run; proc summary data=length;     var len1-len10;    output out=lengths max= ; run; ... View more

Why? Have you considered just using the compress=yes option so that SAS will not waste space storing the extra blanks. You can either use: options compress=yes; To apply it to all future datasets.  Or use it as a dataset option. data new (compress=yes);    infile ...;    input ... ; run; ... View more