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

[Ken_oy]

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 · Accepted solution]

You are very close:

if not missing(string1) then test_string=1;

or:

test_string=not missing(string1);

Haikuo

[Ken_oy]

Thanks for the quick reply. your code works great.

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