topic Re: Filling in Missing Values in SAS Programming

Filling in Missing Values

RandyStan — Tue, 12 Nov 2019 05:52:31 GMT

Dear All

My data is as follows

ID IDA

CO CO

I I

HUF HUF

B B

I want to fill in the two missing values in IDA

ID IDA

CO CO

I I

HUF HUF

. NO_CAT

B B

I wrote these lines

Data want; set have;

if IDA = '.' then do ; IDA = NO_CAT: end ;

run;

What mistake am I making

Randy

Re: Filling in Missing Values

unison — Tue, 12 Nov 2019 06:27:40 GMT

NO_CAT must be a string. In addition to that, missing for character values are indicated with '' rather than '.'

if IDA = '' then IDA = 'NO_CAT';

-unison

Re: Filling in Missing Values

SASKiwi — Tue, 12 Nov 2019 06:12:14 GMT

Maybe this? Not sure if there is a real dot in IDA or not. If not then remove it.

Data want; set have;

if IDA = '.' then do ; 
IDA = 'NO_CAT';
end ;

run;

Re: Filling in Missing Values

JJP1 — Tue, 12 Nov 2019 06:25:51 GMT

Hi @RandyStan ,

i followed as per @SASKiwi it is working fine.

If it is character variable then we should not use . just simply ' ';please have a look on below code and it is working as expected.

Data have;
input IDA $3. IDA1 $6.;
datalines;
ID    IDA
CO  CO
I   I
HUF HUF
.    
. 
B   B
;
run;

Data want; 
set have;

if IDA = ' ' then do IDA1 = 'NO_CAT';
end;


run;

Re: Filling in Missing Values

sustagens — Tue, 12 Nov 2019 07:14:08 GMT

Check if the variable IDA is of character- or numeric- type.

Null values in character variables are assigned a blank ('')
while in numeric variables it is a period (.)

Hence if IDA is numeric, your condition will just be:
if IDA = .

But if IDA is character, your condition will be:
if IDA = ''

The only time you will need to use:
if IDA = '.' is when a character variable intentionally has a period for a value.