Help using Base SAS procedures

How to convert decimal to precentage

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 114
Accepted Solution

How to convert decimal to precentage

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

Accepted Solutions
Solution
‎03-06-2018 10:20 AM
Super User
Super User
Posts: 9,599

Re: How to convert decimal to precentage

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.

View solution in original post


All Replies
Solution
‎03-06-2018 10:20 AM
Super User
Super User
Posts: 9,599

Re: How to convert decimal to precentage

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.

Frequent Contributor
Posts: 114

Re: How to convert decimal to precentage

Thank you
☑ This topic is solved.

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

Discussion stats
  • 2 replies
  • 141 views
  • 0 likes
  • 2 in conversation