topic Re: Convert numeric with decimal to character with leading zeros in SAS Programming

Convert numeric with decimal to character with leading zeros

fieldsa83 — Fri, 26 Jan 2018 19:47:09 GMT

I have HRLYEARN which is infiled as 6.2

So 14.65

but I would like to convert it to an 8-character variable with no decimals ie: '001465'

Been trying for way too long at this point but I can't get it to work.

novinosrin — Fri, 26 Jan 2018 19:54:53 GMT

data w;
k=14.65;
k1=compress(put(k,z9.2),'.');
run;

Tom — Fri, 26 Jan 2018 19:59:49 GMT

Do you want to keep the same name? If so you need to rename the old variable.

data want ;
  set have ;
     new =put(HRLYEARN*100,Z8.);
     rename new=HRLYEARN HRLYEARN=old_HRLYEARN ;
run;