SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
K1235
Fluorite | Level 6

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;
1 ACCEPTED SOLUTION

Accepted Solutions
PaigeMiller
Diamond | Level 26

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

--
Paige Miller

View solution in original post

4 REPLIES 4
BrunoMueller
SAS Super FREQ

Use the PERCENTN format and all is good

K1235
Fluorite | Level 6

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

PaigeMiller
Diamond | Level 26

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

--
Paige Miller
ballardw
Super User

@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;

sas-innovate-white.png

Special offer for SAS Communities members

Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 2503 views
  • 0 likes
  • 4 in conversation