Whole numbers in a column with decimals have odd zeroes behind them in proc print.

[DavidPhillips2]

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

[saidi · Accepted solution]

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;

[DavidPhillips2]

Saidi,

It worked. Thank you for your reply.

[ballardw]

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.