I have a dataset that contains decimal numbers and non-decimal numbers. When I run a proc print the decimals with trailing zeroes show up following whole digit values, which is odd formatting. Do I need to convert to text strings and then format the numbers using a few formatting lines or is there a single line format command? Using SAS 9.2.
Default Output
1.01
1.00
Ideal Output
1.01
1
Use Format statement in proc print
data test;
input int;
cards;
1.01
1.00
;
run;
proc print data=test;
format int 4.2;
run;
Use Format statement in proc print
data test;
input int;
cards;
1.01
1.00
;
run;
proc print data=test;
format int 4.2;
run;
Saidi,
It worked. Thank you for your reply.
proc print data=test;
format int best.;
run;
Might be what you are looking for. Most formats that use a decimal assignment such as 4.2 will always display the specified number of decimals padding with 0 as needed per your experience.
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.