topic Convert 10.75% to 10.75. Both values are numeric. in SAS Programming

Convert 10.75% to 10.75. Both values are numeric.

aakash93 — Thu, 27 Sep 2018 19:15:46 GMT

Hi,

I need help converting a percentage to a number. For example, 10.75% to 10.75 as opposed to 0.1075. The conversion has to be done for 10+ columns.

Thank you,

Re: Convert 10.75% to 10.75. Both values are numeric.

Kurt_Bremser — Thu, 27 Sep 2018 19:21:46 GMT

Please supply some example data (in a data step with datalines), so we can see from where we have to start.

If you have a numeric variable with a percent format, replace the format with sonething like 6.2, and multiply the value with 100.

Re: Convert 10.75% to 10.75. Both values are numeric.

Reeza — Fri, 28 Sep 2018 02:16:21 GMT

You can also format 10.75 to 10.75% using a custom format.

proc format;                           
   picture mypct (round) low-high='009.99%';   
run; 

proc tabulate data=sashelp.class;
   class age sex;
   var weight height; 
   table age, sex*(weight height)*(pctsum*f=mypct.);
run;

https://support.sas.com/kb/38/001.html