Help using Base SAS procedures

Deleting rows in a final dataset?

Reply
Occasional Contributor
Posts: 9

Deleting rows in a final dataset?

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!

Contributor
Posts: 45

Re: Deleting rows in a final dataset?

The delete statement can be used conditionally.

data want;

set have;

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

OR

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

then delete;

run;

Respected Advisor
Posts: 3,899

Re: Deleting rows in a final dataset?

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

Ask a Question
Discussion stats
  • 2 replies
  • 153 views
  • 0 likes
  • 3 in conversation