Need to delete certain rows for many firms

[bd_user_10]

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.

[PaigeMiller · Accepted solution]

if date > '31DEC15'd then delete;

[bd_user_10]

what a champ!

[RW9]

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.