topic Re: How to convert decimal to precentage in SAS Procedures

How to convert decimal to precentage

Gil_ — Tue, 06 Mar 2018 14:46:08 GMT

I need to pull everything that is 50% or greater..
Here is my data step

Data reports;
Set reports;
Output=(max/balance)*100;
Run;

Max= 500. Balance=
output = 62.500
I need it to show 62
Thanks

Re: How to convert decimal to precentage

RW9 — Tue, 06 Mar 2018 14:58:59 GMT

And why does 62.5 = 62, are you rounding to lowest, rounding to nearest etc?

data reports;
  set reports;
  output=floor((max/balance)*100);
run;

Here I show to round down to nearest int. You could use round() function, or int() etc.

Re: How to convert decimal to precentage

Gil_ — Tue, 06 Mar 2018 15:21:33 GMT

Thank you