I’m trying to pull cases which are =< to the last date of the month based on a certain date variable (DISPOSITION_DATE). The dataset contains data for all 12 months of the year so I’m not sure of to take this into account.
It depends on the relation between your disposition date and the last date of the month.
You'll need to provide some more information on your criteria and some sample data with expected output is always helpful.
If you had a fixed date something like the following would work.
Proc sql;
create table want as
select distinct var1, var2, var3
from have
where datepart(disposition_date) <= '31jul2012'd
;
quit;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.