topic Re: deleting row with missing observation in SAS Programming

deleting row with missing observation

wschnell1 — Mon, 18 Nov 2013 02:34:31 GMT

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 — Mon, 18 Nov 2013 03:48:11 GMT

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

if notspace(FIRMID)=0 then delete;

Rick_SAS — Mon, 18 Nov 2013 14:15:28 GMT

Did you try using the MISSING function?

if missing(firmid) then delete;