topic Re: How to Display Decimal values and Integer values in the same column. in SAS Procedures

How to Display Decimal values and Integer values in the same column.

Belle — Fri, 20 Sep 2013 22:02:14 GMT

Hi Member,

How to display decimal values and integer values in the same column? For example, I want my column looks like:

Column

1.62

1.59

Now the result I got is:

Column

1.20

2.00

3.00

1.17

Here is the program:

data test;

input A B;

C = round(A/B, .01);

cards;

6 5

8 4

9 3

7 6

;

run;

proc print data = test; run;

Is there a way that I don't need to show decimals when the number is integer (like 2), and keep the decimals when it is not integer (like 1.20).

Thank you for your help.

Fugue — Fri, 20 Sep 2013 22:11:42 GMT

Have you taken a look at formats like BESTDw.p?

Belle — Fri, 20 Sep 2013 23:24:03 GMT

Hi Fugue,

I got what I want. Thank you!