Hi,
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.
data want;
set have;
where date in ('05nov2017'd, '31dec2017'd, '04jan2018'd);
run;
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;
Depends on the actual format of the dates stored in your table.
If the dates are in text format this might work:
data...
set ...
if date in ('11/5/2017' '12/31/2017' '01/04/2018');
run;
If the dates are in numeric format then this might work:
data...
set ...
if date in ('05NOV2017'd '31DEC2017'd '04JAN2018'd);
run;
//Fredrik
data want;
set have;
where date in ('05nov2017'd, '31dec2017'd, '04jan2018'd);
run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.