topic Re: how to make a percent (%) of variable values in SAS in SAS Programming

how to make a percent (%) of variable values in SAS

Barkamih — Mon, 03 Dec 2018 13:51:59 GMT

Hi all

I wanna to convert the variable values from normal to percentages.

for example, I want to have 3 of 0.03 .... etc.

regards

Ibrahim

Re: how to make a percent (%) of variable values in SAS

PeterClemmensen — Mon, 03 Dec 2018 13:56:53 GMT

data _null_;
   a=0.03;
   put a;
   format a percent.;
run;

Re: how to make a percent (%) of variable values in SAS

Kurt_Bremser — Mon, 03 Dec 2018 13:57:31 GMT

Use the percent. format:

data want;
x1 = .03;
format x1 percent6.;
run;

Re: how to make a percent (%) of variable values in SAS

Barkamih — Mon, 03 Dec 2018 14:08:13 GMT

thanks a lot, but I need just a number, I don't want a percent sign (%) to appear in my data?

regards

Re: how to make a percent (%) of variable values in SAS

PeterClemmensen — Mon, 03 Dec 2018 14:11:03 GMT

Then multiply by 100?

Re: how to make a percent (%) of variable values in SAS

RW9 — Mon, 03 Dec 2018 14:11:43 GMT

As always, post test data in the form of a datastep, and what you want to see out at the end. Your post says nothing. Do you have 3 or 0.03? You don't want percent apparently from the other posts, so what do you want, 3/100=0.03?

Re: how to make a percent (%) of variable values in SAS

PeterClemmensen — Mon, 03 Dec 2018 14:18:19 GMT

Proud of this one 🙂

Re: how to make a percent (%) of variable values in SAS

RW9 — Mon, 03 Dec 2018 14:50:52 GMT

Don't know how you come up with them

Re: how to make a percent (%) of variable values in SAS

FreelanceReinh — Mon, 03 Dec 2018 17:21:56 GMT

Hi @Barkamih,

While it may seem trivial to implement the suggestion "multiply by 100," you should remember the pitfall of numeric representation issues:

1    data _null_;
2    a=0.07;
3    a=100*a;
4    if a>7 then put 'Surprise! It looks like ' a '> 7.';
5    run;

Surprise! It looks like 7 > 7.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds

So, use the ROUND function to avoid such surprises:

a=round(100*a, 1e-9);

(in place of a=100*a; )