Hi , May i ask why not proc sql? Thanks ... View more

Your second one does work-->   %let x2 = %sysfunc(tranwrd(&pow,t,%quote(Table )));/*add another closing parenthesis*/ %put x=&x2;   I will not recommend using macro execution functions such as quote or bquote and its NR mate in quoting constant text, I'd rather use %str as it is powerful to quote at the time of macro compilation.    %let x2 = %sysfunc(tranwrd(&pow,t,%str(Table ))); %put x=&x2;   Regards, Naveen Srinivasan ... View more

Here is another way:   data existing;    infile datalines delimiter=',';    input id $ monthid new_demand month1 month2 month3;    datalines;                      1,1,2,3,4,5 1,2,3,.,.,. 1,3,0,.,.,. 1,4,3,.,.,. 1,5,1,.,.,. 2,1,2,3,4,5 2,2,3,.,.,. 2,3,0,.,.,. 2,4,3,.,.,. 2,5,1,.,.,. ; run;       data desired; length   _month1 _month2 _month3 8; retain      _month1 _month2 _month3; if (_n_ = 1) then do;     declare hash myhash();     rc = myhash.definekey('id');     rc = myhash.definedata('_month1','_month2','_month3');     myhash.definedone();  end;  set existing;  by id;  if first.id then do;  myhash.clear(); _month1= new_demand; _month2=month1 ; _month3=month2; myhash.add(); end; else do; myhash.find(); month1=    _month1; month2=    _month2; month3=    _month3; _month1= new_demand; _month2=month1 ; _month3=month2; myhash.replace(); end; drop _: rc; run;   Regards, Naveen Srinivasan ... View more

Do they all share the same datatype?, if yes, would something like this help:   proc sql; select catx('_',name,'Base') into :name separated by ' ' from dictionary.columns where libname='YOUR_LIBREF' and memname='YOUR_DATASET_NAME'; quit;   data want; set thave; retain &name ' '; RUN;     ... View more

I trust you have written a nice code to get the combined codes using array and are only looking for combined description. If your datasets are exactly like the sample, here is one easy solution:     data want; if _n_=1 then do; if 0 then set have;    declare hash h(dataset:'your_lookup_table');    h.definekey('code');    h.definedata('description');    h.definedone();    end;    set your_combined_codes_table;    length combined_description $50;    array ch(*)abc_check--ni_check;    do _n_=1 to dim(ch);    if not missing(ch(_n_)) then do;    temp=ch(_n_);       rc=h.find(key:temp);    combined_description=catx(':',combined_description,description);    end;    else continue;    end;    drop temp; run;   I am too lazy and tired to test at 12:05AM past midnight in Chennai. I hope that works for you.   Regards, Naveen Srinivasan   ... View more

data want; set have; if length(var)<5 then var=reverse(substr(strip( reverse(var))||'00000000',1,5) );  run;   Regards, Naveen Srinivasan ... View more

@Rick_SAS Very neat and thank you. I really appreciate the response. ... View more

You cannot use column input to read nonstandard data such numbers that has comma. You would need a formatted input like: input @(column position) Salary comma6.; /*Column position is the column pointer to which the input pointer should be instructed to move in the input buffer and start reading values from that point.*/   HTH, Naveen Srinivasan ... View more