02-01-2018 01:47 AM
I am doing some research on Crash data and I want to investigate few crashes happened on particular dates.
My data is in MDY format and these are the dates i want to investigate (11/5/2017),(12/31/2017) &(01/04/2018)
I know the function to select dates between two periods, not sure of selecting particular dates.
Your advice is much appreciated.
02-01-2018 02:28 AM
data output; set input; where crash_date in ('05Nov2017'd, '31Dec2017'd, '04Jan2018'd); run;
data output; set input; where input(crash_date,mmddyy10.) in ('05Nov2017'd, '31Dec2017'd, '04Jan2018'd); run;
02-01-2018 02:52 AM
Depends on the actual format of the dates stored in your table.
If the dates are in text format this might work:
if date in ('11/5/2017' '12/31/2017' '01/04/2018');
If the dates are in numeric format then this might work:
if date in ('05NOV2017'd '31DEC2017'd '04JAN2018'd);
Need further help from the community? Please ask a new question.