topic Re: How to format the ratio and create percent variable? in SAS Programming

How to format the ratio and create percent variable?

ybz12003 — Thu, 05 Oct 2017 17:20:56 GMT

Hello:

I have the following codes. I would like to format the ratio shown as .12345 and create percent variable as 12.35%. Please advice how to do it. Thanks.

data poverty;

set poverty;

BelowPoverty=Under50+Under50to99;

Ratio=belowpoverty/total;

run;

Re: How to format the ratio and create percent variable?

HB — Thu, 05 Oct 2017 17:39:57 GMT

format ratio percent8.2;

Re: How to format the ratio and create percent variable?

Reeza — Thu, 05 Oct 2017 17:44:29 GMT

Try a FORMAT statement.

http://documentation.sas.com/?docsetId=lestmtsref&docsetTarget=n0d5oq7e0oia0wn13nsins0x8nmh.htm&docsetVersion=9.4&locale=en

List of formats are available here:

http://support.sas.com/documentation/cdl/en/leforinforref/64790/HTML/default/viewer.htm#n0p2fmevfgj470n17h4k9f27qjag.htm

Re: How to format the ratio and create percent variable?

Astounding — Thu, 05 Oct 2017 17:47:27 GMT

format ratio 7.5;

That would actually get you 0.12345, not .12345. But eliminating the leading zero is trouble, and not worth the effort.

To create a PERCENT variable:

percent = put(ratio, percent9.2);

The width needs to be 9, because the percent formats automatically include a leading and a trailing blank (and you may have to be able to express 100%). Because of the leading blank, you may want to apply this statement as well:

percent = left(percent);

Note that PERCENT will be a character field, not something that you can use to perform math.

Re: How to format the ratio and create percent variable?

ybz12003 — Thu, 05 Oct 2017 18:39:21 GMT

Thank you so much for your great help!