topic how to search a "not missing" string in data step? in SAS Procedures

how to search a "not missing" string in data step?

Ken_oy — Mon, 18 Mar 2013 19:48:46 GMT

Hello

I am looking for a command (not missing?) that I can do the following:

if string1 'NOTMISSING' then test_string=1;

I tried:

if string1 then test_string=1;

but it did not work correctly. Any suggestions?

Thanks.

Haikuo — Mon, 18 Mar 2013 19:56:02 GMT

You are very close:

if not missing(string1) then test_string=1;

or:

test_string=not missing(string1);

Haikuo

Ken_oy — Mon, 18 Mar 2013 20:01:20 GMT

Thanks for the quick reply. your code works great.

it makes me recall how I looked for the "where notin (xxx)" statement. :smileylaugh: