Deleting rows in a final dataset?

slivingston — Wed, 28 Aug 2013 06:26:40 GMT

Hi all!

I have a simple problem and I know it will be a simple answer however after alot of searching all day, I still do not have the answer. I have a dataset with 6 variables and 2 variables contain null values (var5 and var6). I would like to filter out the null values for each variable (var5 and var6), and if there is a null value for the row, then the row is deleted.

For example.

ID var1 var2 var3 var4 var5 var6

1001 23 Yes 560 22 No

1002 54 No 6

1003 42 No 652 33

1004 60 Yes

1005 32 YES 5

Final would look like this

ID var1 var2 var3 var4 var5 var6

1002 54 No 6

^Only left due to having complete values for Var5 and Var 6.

Thanks in adance!

Re: Deleting rows in a final dataset?

Murray_Court — Wed, 28 Aug 2013 08:20:12 GMT

The delete statement can be used conditionally.

data want;

set have;

if var5="" /*null value for character variable */

var6=. /*null value for numeric variable */

then delete;

run;

Re: Deleting rows in a final dataset?

Patrick — Wed, 28 Aug 2013 08:48:50 GMT

IF cmiss(var5,var6) ne 0 then delete;

topic Re: Deleting rows in a final dataset? in SAS Procedures

Deleting rows in a final dataset?

Re: Deleting rows in a final dataset?

Re: Deleting rows in a final dataset?