deleting row with missing observation

[wschnell1]

Hi,

I have a large number of columns and rows.

I want to delete a row of data if one specific variable is missing (FIRMID) which is a character variable

I tried the following but it didn't seem to work

data want;

     set have;

     if FIRMID = " " then delete;

     run;

Any help appreciated

[PGStats · Accepted solution]

Your code should work, unless FIRMID contains non printable characters. Try this test instead

if notspace(FIRMID)=0 then delete;

PG

[Rick_SAS]

Did you try using the MISSING function?

if missing(firmid) then delete;