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.
if date > '31DEC15'd then delete;
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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: