PROC FORMAT ;
PICTURE Num .="NA"
OTHER= "000.00%";
run;
data test;
input Number ;
format Number num. ;
cards;
10910.63%
63.91%
75.56%
-77.08%
.
.
0.74%
-8.12%
.
run;
I want only missing value to be replaced by NA and others value remains same in percentage .
Why do you have % character in data you are reading in as numeric? This code works fine (note, its not a good idea to use reserved words as names of formats - or anything else for that matter):
proc format; picture mypcent .="NA" other= "000.00%"; run; data test; input number; format number mypcent.; cards; 10910.63 63.91 75.56 -77.08 . . 0.74 -8.12 . run;
You need to change your format slightly and add an informat to read the percentages
PROC FORMAT ;
value Num
.="NA"
other=[percentn8.2]
;
run;
data test;
input Number ;
informat number percent9.;
format Number num. ;
cards;
10910.63%
63.91%
75.56%
-77.08%
.
.
0.74%
-8.12%
.
run;
Why do you have % character in data you are reading in as numeric? This code works fine (note, its not a good idea to use reserved words as names of formats - or anything else for that matter):
proc format; picture mypcent .="NA" other= "000.00%"; run; data test; input number; format number mypcent.; cards; 10910.63 63.91 75.56 -77.08 . . 0.74 -8.12 . run;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: