NULL RECORDS

[rakeshvvv]

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]

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

[rakeshvvv]

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

[Haikuo]

Check out CMISS function.

[stat_sas · Accepted solution]

data want;

set have;

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

run;

[Tom]

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)

or

CMISS(of _ALL_)