topic Re: Null variable in SAS Procedures

Null variable

rakeshvvv — Mon, 06 Apr 2015 19:19:58 GMT

I have data-set with 10 variables, ID, R1,R2,R3,R4,R5,R6,R7,R8,R9....I have to write in such a way that output should contain records where R1-R9 is not null for atleast one of them......

Re: Null variable

ballardw — Mon, 06 Apr 2015 19:24:25 GMT

data want;

set have;

if nmiss(of r1-r9) <9;

run;

would be one way.

Re: Null variable

naveen_srini — Mon, 06 Apr 2015 19:28:57 GMT

Same as Ballard, with the N function:

data want;

set have;

if n(of r1-r9) >=1;

run;