topic Re: Need to delete certain rows for many firms in SAS Programming

Need to delete certain rows for many firms

bd_user_10 — Wed, 12 Sep 2018 13:06:06 GMT

Hi Everyone,

I have a daily dataset for more than 200 firms (firm id: isin) starting from 2000-01-01 to 2018-06-30. I would like to delete the dates after 2015-12-31 for all firms. Can anyone help?

In my SAS data set, the date format is YYMMDD10.

Thanks.

Re: Need to delete certain rows for many firms

PaigeMiller — Wed, 12 Sep 2018 13:07:23 GMT

if date > '31DEC15'd then delete;

Re: Need to delete certain rows for many firms

bd_user_10 — Wed, 12 Sep 2018 13:11:08 GMT

what a champ!

Re: Need to delete certain rows for many firms

RW9 — Wed, 12 Sep 2018 13:26:04 GMT

One thing I would say is that if you are using that dataset further, then you would be better off reading it with a where clause, as that may be quicker:

data want;
  set have (where=(date <="31dec2015"d));
  /*do your other code here */
run;

It may be a small difference but with lots of data could save some read/write time.