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

[Belle]

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

     2

     3

     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]

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

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a003171706.htm

[Belle]

Hi Fugue,

I got what I want. Thank you!