topic Re: NULL RECORDS in SAS Procedures

NULL RECORDS

rakeshvvv — Thu, 12 Jun 2014 15:09:54 GMT

I Have a dataset with 5 variables a, b, c, d and e

I have to write a program to find out if the variable is null(individual vaaribles) for all recs. If so, then output ‘NULL’ to Comment column.

Jchapman — Thu, 12 Jun 2014 15:15:16 GMT

null for all fields or null for any? are all variables numeric? char? mix?

rakeshvvv — Thu, 12 Jun 2014 15:18:52 GMT

Null for any and variables are mix.....

Haikuo — Thu, 12 Jun 2014 15:27:08 GMT

Check out CMISS function.

stat_sas — Thu, 12 Jun 2014 15:31:34 GMT

data want;

set have;

if cmiss(of a,b,c,d,e)=5 then comment='NULL';

run;

Tom — Fri, 13 Jun 2014 21:31:20 GMT

Note that you have used the OF styntax wrong. Since you also included commas the OF only applies to the variables listed up until the first comma.

So CMISS(of A,B,C,D,E) is the same as CMISS(A,B,C,D,E) .

The power of the OF syntax is when you want to use variable lists or just eliminate the annoying commas.

CMISS(of A B C D E)

CMISS(of _ALL_)