Your SAS programs, embedded in web apps and elsewhere

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

Accepted Solution Solved
Reply
Super Contributor
Posts: 497
Accepted Solution

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.

Posted in reply to DavidPhillips2

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;

View solution in original post


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.

Posted in reply to DavidPhillips2

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;

Super Contributor
Posts: 497

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

Saidi,

It worked. Thank you for your reply.

Super User
Posts: 11,343

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

Posted in reply to DavidPhillips2

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.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 477 views
  • 3 likes
  • 3 in conversation