topic Re: Check if at least one variable in list is not missing in SAS Programming

Check if at least one variable in list is not missing

corkee — Fri, 22 Nov 2019 17:56:02 GMT

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.

Re: Check if at least one variable in list is not missing

novinosrin — Fri, 22 Nov 2019 18:04:47 GMT

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

So basically,

if coalesce(of code_1-code_170);

Re: Check if at least one variable in list is not missing

corkee — Fri, 22 Nov 2019 18:05:24 GMT

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

Re: Check if at least one variable in list is not missing

novinosrin — Fri, 22 Nov 2019 18:08:56 GMT

Hi @corkee use

COALESCEC

for character variables

Re: Check if at least one variable in list is not missing

corkee — Fri, 22 Nov 2019 18:09:36 GMT

This worked perfectly. Thank you!