topic Re: Whole numbers in a column with decimals have odd zeroes behind them in proc print. in Developers

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

DavidPhillips2 — Mon, 12 Jan 2015 18:12:54 GMT

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

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

saidi — Mon, 12 Jan 2015 18:32:32 GMT

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;

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

DavidPhillips2 — Mon, 12 Jan 2015 18:38:01 GMT

Saidi,

It worked. Thank you for your reply.

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

ballardw — Mon, 12 Jan 2015 18:40:07 GMT

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.