🔒 This topic is solved and locked.
Need further help from the community? Please
sign in and ask a new question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 10-11-2017 02:16 PM
(2502 views)
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
first divide your number by 100, then use the nlpctn6.2 format
--
Paige Miller
Paige Miller
4 REPLIES 4
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Use the PERCENTN format and all is good
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thank you for replying @BrunoMueller. But PERCENTN didnt solve. It outputs as (75.43%). I want to display as -0.75%.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
first divide your number by 100, then use the nlpctn6.2 format
--
Paige Miller
Paige Miller
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
@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;