topic Replacing missing Numeric value with NA and not changing format of others in SAS Programming

Replacing missing Numeric value with NA and not changing format of others

subrat1 — Mon, 21 Aug 2017 08:03:09 GMT


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 .

Re: Replacing missing Numeric value with NA and not changing format of others

ChrisBrooks — Mon, 21 Aug 2017 08:28:36 GMT

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;

Re: Replacing missing Numeric value with NA and not changing format of others

RW9 — Mon, 21 Aug 2017 08:31:34 GMT

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;