how to round the numbers in proc report

[sathya66]

Hi All,

is there any way we can  round the numbers in proc report .

 I have two columns with decimal numbers ,

I want to round the numbers

var1	var2
7827.87	237927.5
1285.84	38451.44
11680.36	208512.33
12102.79	281037.47

Thanks,

Ss

[RW9 · Accepted solution]

Well, you can apply a format to the variable which doesn't allow decimals.  However I would really advise you not to.  Proc print/report are not for data manipulation, datasteps are.  So be explicit in this change to the data by:

data want;
  set have;
  value=round(value,...);
  /* or */
  value=int(value);
run;

I.e. sort out the number explicitly by stating this in the code.  Trust me, reviewing it later on you will be glad to see it done that way so its easy to see.