topic Re: Delete all rows up to the first Non-missing row in SAS Programming

Delete all rows up to the first Non-missing row

hhchenfx — Thu, 24 Feb 2022 23:46:59 GMT

Hi Everyone,

My data have few first rows with missing data. How can I delete them?

There are other missing but inside the good data and I need to keep those missing.

In the data below, I want to delete row row 1 and 2.

Thank you,

HHC

data have; 
input n v1;
datalines;
1 . 
2 . 
3 4 
4 66
5 .
6 66
7 3
8 .
9 8
;run;

Re: Delete all rows up to the first Non-missing row

Patrick — Thu, 24 Feb 2022 23:55:09 GMT

One option

data want(drop=_:);
  set have;
  retain _del_flg 1;
  if _del_flg then 
    do;
      _del_flg=missing(v1);
      if _del_flg then delete;
    end;
run;

Re: Delete all rows up to the first Non-missing row

hhchenfx — Fri, 25 Feb 2022 01:08:21 GMT

Thank you,

It works nicely.

HHC

Re: Delete all rows up to the first Non-missing row

ballardw — Fri, 25 Feb 2022 15:38:34 GMT

@hhchenfx wrote:

Hi Everyone,

My data have few first rows with missing data. How can I delete them?

There are other missing but inside the good data and I need to keep those missing.

In the data below, I want to delete row row 1 and 2.

Thank you,

HHC
data have; 
input n v1;
datalines;
1 . 
2 . 
3 4 
4 66
5 .
6 66
7 3
8 .
9 8
;run;

I suggest that perhaps you want to look at how you READ that data into SAS. Especially if you are reading multiple files and keep having these missing rows appear and the number is the same.

If you already know the number of missing rows, such as 2

data want;
   set have (firstobs=3);
run;

The firstobs option says to keep the observations starting with the 3rd one.