topic better way to delete empty rows in SAS Procedures

better way to delete empty rows

George_S — Thu, 29 Mar 2012 15:12:05 GMT

How to delete rows with missing values in every column?

Is there any simple way?

Thanks

better way to delete empty rows

Haikuo — Thu, 29 Mar 2012 15:15:45 GMT

You need to provide some samples. for one of the simplest senarios:

data have;

input a1-a4;

cards;

1 2 3 4

. . . .

5 6 7 8

;

data want;

set have;

if n(of a1-a4);

run;

proc print;run;

Regards,

Haikuo

Re: better way to delete empty rows

Haikuo — Thu, 29 Mar 2012 15:24:45 GMT

I know there are better solutions out there, but for a more general approach, this is what I came up:

data have;

input a1-a4;

cards;

1 2 3 4

. . . .

5 6 7 8

. 1 . .

;

proc sql;

select count(name) into :names from dictionary.coluMNs

where libname='WORK' AND MEMNAME='HAVE';

QUIT;

data want;

set have;

if CMISS(OF _ALL_)<&NAMES;

run;

proc print;run;

better way to delete empty rows

George_S — Thu, 29 Mar 2012 21:26:31 GMT

CMISS not support SAS 9.1.3

better way to delete empty rows

Haikuo — Thu, 29 Mar 2012 22:02:21 GMT

In that case, there is an old fashion way hopefully to meet your need:

data have;

input a1-a4 (c1-c3) ($);

cards;

1 2 3 4 a b c

. . . . . . .

5 6 7 8 . . f

. 1 . . . . .

;

data want;

set have;

array c _character_;

if n(of _numeric_)=0 then

do over c;

if not missing(c) then

do;

output;

return;

end;

else output;

run;

proc print;run;

Regards,

Haikuo

better way to delete empty rows

Ksharp — Fri, 30 Mar 2012 03:05:05 GMT

OH. Hope you could have SAS 9.2 as fast as you can.

data have;
input name $ a1-a4;
cards;
q 1 2 . 4
. . . . .
w 5 6 7 8
;
run;
options missing=' ';
data want;
 set have;
 if missing(cats(of _all_)) then delete;
run;

Ksharp