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.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.