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.
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;
data w;
k=14.65;
k1=compress(put(k,z9.2),'.');
run;
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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.