topic Re: Convert Decimal to Percent % in SAS Procedures

Convert Decimal to Percent %

fredbell — Wed, 15 Sep 2010 16:06:42 GMT

How can i convert this decimal outcome to show percent %

proc sql;
create table test as
select _NAME_,
case
when (Y__Service_Level)=(BR_PercentServiceLevel)then 0
else Y__Service_Level - BR_PercentServiceLevel
end as PercentServiceLevel
from cscore.BRSmerge;
quit;

Re: Convert Decimal to Percent %

ArtC — Thu, 16 Sep 2010 03:00:37 GMT

Have you tried using the PERCENT format?

Re: Convert Decimal to Percent %

deleted_user — Thu, 16 Sep 2010 09:00:20 GMT

use the format percent12.2 or percent15.

ex:
proc sql;
create table a as select * a/b as c format percent12.2 from ;
quit;

Re: Convert Decimal to Percent %

fredbell — Thu, 16 Sep 2010 13:09:38 GMT

Thanks user4sas this was helpful, thanks for the example.

Fred

Re: Convert Decimal to Percent %

fredbell — Fri, 17 Sep 2010 11:59:08 GMT

Hello again

I'm looking for some doc. to help explain how the format percent12.2 works

How do i figure out to apply 12.2 or 8.1 or what?

If you can lead me to some information that would be great, i've looked online but can't find anything.

Thanks again.

Fred

Re: Convert Decimal to Percent %

art297 — Fri, 17 Sep 2010 23:05:06 GMT

Fred,

The documentation can be found at: http://support.sas.com/documentation/cdl/en/lrdict/63026/HTML/default/viewer.htm#a000205182.htm

or, if that wraps, in short form: http://xrl.us/bhznnr

In short, the first number indicates the width you want (including after the decimal), while the second number indicates the number of decimal places wanted.

HTH,
Art

Re: Convert Decimal to Percent %

Cynthia_sas — Sat, 18 Sep 2010 02:27:35 GMT

And, if you are using the PERCENT format, be sure to make the overall width "wide" enough -- usually 8.1 works for me if I have 1 decimal place:
From the Doc:
Tip: The width of the output field must account for the percent sign (% ) and parentheses for negative numbers, whether the number is negative or positive.

cynthia

Re: Convert Decimal to Percent %

fredbell — Fri, 24 Sep 2010 10:49:51 GMT

Thanks everyone