topic Re: Proc Report Format percentage in SAS Programming

Proc Report Format percentage

K1235 — Wed, 11 Oct 2017 18:18:05 GMT

I have a dataset which one of the column has a value of "-0.75" but in proc report I want to display as "-0.75%". When I apply the format percent9.2 it converts to "(75.435)". But I want to display as "-0.75%".

data Percent;
format x BEST8. 
 p1 PERCENT7.1;
label x = "Raw value"
 p1 = "PERCENT7.1";
input x @@;
p1 = x;
 
datalines;
1.85185 3.44498 -0.92507 -0.7543456
;

proc print data=Percent noobs label; run;

Re: Proc Report Format percentage

BrunoMueller — Wed, 11 Oct 2017 18:54:09 GMT

Use the PERCENTN format and all is good

Re: Proc Report Format percentage

K1235 — Wed, 11 Oct 2017 22:09:58 GMT

Thank you for replying @BrunoMueller. But PERCENTN didnt solve. It outputs as (75.43%). I want to display as -0.75%.

Re: Proc Report Format percentage

PaigeMiller — Wed, 11 Oct 2017 22:28:58 GMT

first divide your number by 100, then use the nlpctn6.2 format

Re: Proc Report Format percentage

ballardw — Wed, 11 Oct 2017 22:47:48 GMT

@K1235 wrote:

Thank you for replying @BrunoMueller. But PERCENTN didnt solve. It outputs as (75.43%). I want to display as -0.75%.

Show the code. One suspects you missed the format spelling. And a value to appear as -0.75% would have to be -.0075 as a decimal.

data junk;
   x=-.007543;
run;
proc print data=junk;
   format x percentn10.4;
run;