deleting obs with conditions

Amalik — Sat, 02 Jun 2018 03:02:17 GMT

Hi,

My data looks like follows,

Now, I want to delete permno's if all observations from T1 through T516 are missing.

And then I also want to delete permno's which have less than 24 observations from T1 through T516 (as there are missing values in my data set)

Can someone suggest on how to do this?

Thanks.

Re: deleting obs with conditions

mkeintz — Sat, 02 Jun 2018 03:08:19 GMT

data want;
   set have;
   array t {*} t1-t516;
   if n (of t{*}) > 24;
run;