Check if at least one variable in list is not missing

[corkee]

Hi,

I have a long list of variables, code_1-code_170. I know the cmiss and nmiss functions can help you check whether the entire list of variables is missing, but is it possible to check if at least one variable in the list is NOT missing?

For example, if code_1 to code_4 are not missing but the rest are, then do...

If code_1 to code_169 are not missing but code_170 is, then do...

I'm not sure if there's an easy way to do this.

[novinosrin]

have you tried COALESCE to determine the first non missing value in the list?

So basically,

if coalesce(of code_1-code_170);

[corkee]

Hi, this seems like a great idea, but my variables are not numeric. 😞

[novinosrin · Accepted solution]

Hi @corkee   use 

COALESCEC 

for character variables 

[corkee]

This worked perfectly. Thank you!