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;
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.
Ready to level-up your skills? Choose your own adventure.