Solved
Valued Guide
Posts: 539

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

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

Accepted Solutions
Solution
‎01-12-2015 01:32 PM
Occasional Contributor
Posts: 10

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

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;

All Replies
Solution
‎01-12-2015 01:32 PM
Occasional Contributor
Posts: 10

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

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;

Valued Guide
Posts: 539

Saidi,

Super User
Posts: 12,330

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

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.

🔒 This topic is solved and locked.