topic Re: Inserting symbols in data values in SAS Procedures

Inserting symbols in data values

Anilsk — Thu, 15 Jul 2010 09:30:37 GMT

I have done a simple computation for percentage as
data td.sample;
set td.sample;
Percentage=(total/3);
run;
proc print data=td.sample;
run;

It is working fine, new column Percentage comes up with the right values, but i want to add "%" symbol along with each data values in the Percentage Column

like

Percentage
45.33333%
49.66667%
55%
63%
63.66667%
65.33333%
80.33333%
86%

and i also want to limit the decimal space for two digits.

Re: Inserting symbols in data values

DataShare — Thu, 15 Jul 2010 10:03:13 GMT

1. using custom format
proc format lib=library;
picture perc low-high ='000.00 %';
run;
data Test1;
c1=1.1234;
run;
data Test2;
format c2 perc.;
set Test1;
c2=c1;
run;

2. read about percentw.d format

Re: Inserting symbols in data values

andreas_lds — Thu, 15 Jul 2010 10:04:56 GMT

You can change the value of the calculated variable to include the %-symbol, but I recommend using the format statement to change the way the value is displayed.
[pre]data td.sample;
set td.sample;
format Percentage percent10.2;
Percentage=(total/300);
run;[/pre]
Please notice the description of the format found in the SAS online documentation:
The PERCENTw.d format multiplies values by 100, formats them the same as the BESTw.d format, and adds a percent sign (%) to the end of the formatted value, while it encloses negative values in parentheses.

Re: Inserting symbols in data values

Anilsk — Thu, 15 Jul 2010 10:52:05 GMT

Thanks andreas_lds , It worked!!!