Help using Base SAS procedures

how to round the numbers in proc report

Accepted Solution Solved
Reply
Highlighted
Frequent Contributor
Posts: 76
Accepted Solution

how to round the numbers in proc report

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

 

var1var2
7827.87237927.5
1285.8438451.44
11680.36208512.33
12102.79281037.47

 

Thanks,

Ss


Accepted Solutions
Solution
Wednesday
Super User
Super User
Posts: 9,402

Re: how to round the numbers in proc report

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.

View solution in original post


All Replies
Solution
Wednesday
Super User
Super User
Posts: 9,402

Re: how to round the numbers in proc report

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.

☑ This topic is solved.

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

Discussion stats
  • 1 reply
  • 106 views
  • 0 likes
  • 2 in conversation