topic how to round the numbers in proc report in SAS Procedures

how to round the numbers in proc report

sathya66 — Wed, 13 Jun 2018 13:37:36 GMT

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,

Re: how to round the numbers in proc report

RW9 — Wed, 13 Jun 2018 13:56:16 GMT

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.