topic Re: Multiple dates in SAS Programming

Multiple dates

BIDD — Thu, 01 Feb 2018 06:47:02 GMT

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.

Satish_Parida — Thu, 01 Feb 2018 07:28:48 GMT

But if the crash_date is characters then the following will work.

data output;
set input;
where input(crash_date,mmddyy10.) in ('05Nov2017'd, '31Dec2017'd, '04Jan2018'd);
run;

FredrikE — Thu, 01 Feb 2018 07:52:00 GMT

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

PeterClemmensen — Thu, 01 Feb 2018 08:04:33 GMT

data want;
   set have;
   where date in ('05nov2017'd, '31dec2017'd, '04jan2018'd);
run;

BIDD — Thu, 01 Feb 2018 09:08:51 GMT

Thanks for ur help, it works...cheers

BIDD — Thu, 01 Feb 2018 09:18:54 GMT

Thanks for ur help, it works...cheers