How to format the ratio and create percent variable?

[ybz12003]

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;

[HB]

    format ratio percent8.2;

[Reeza]

Try a FORMAT statement.

http://documentation.sas.com/?docsetId=lestmtsref&docsetTarget=n0d5oq7e0oia0wn13nsins0x8nmh.htm&docs...

List of formats are available here:

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

[Astounding · Accepted solution]

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.

[ybz12003]

Thank you so much for your great help!