topic Re: use date in a select range in SAS Procedures

use date in a select range

podarum — Fri, 03 Feb 2012 20:00:58 GMT

Hi, any reason why I can use the Date (format YYMMP7.) in a range? for example I want to select records that fall within if Date => 2001.01 and Date <= 2011.11

Thanks

use date in a select range

podarum — Wed, 22 Feb 2017 14:26:08 GMT

I got it.. if Date => "01Jan2001"d and Date <= "01Nov2011"d;

Shorthand that uses the equality operators but no need for AND:

  if  "01Jan2001"d <= Date <= "01Nov2011"d;

You could also use WHERE and BETWEEN (it really means between + the two dates) ...

where date between "01Jan2001"d and "01Nov2011"d;

this also works ...

where date between "01Nov2011"d and "01Jan2001"d ;

Re: use date in a select range

MikeZdeb — Fri, 03 Feb 2012 20:55:25 GMT

hi ... if you are using a SAS data set, you could also use WHERE and BETWEEN (it really means between + the two dates) ...

where date between "01Jan2001"d and "01Nov2011"d;

this also works ...

where date between "01Nov2011"d and "01Jan2001"d ;

Re: use date in a select range

udo_sas — Fri, 03 Feb 2012 21:03:47 GMT

Hi -

Just to confirm your understanding:

In SAS, every date is a unique number on a number line. Dates before January 1, 1960, are negative numbers; those after January 1, 1960, are positive.

To write a SAS date constant (in IF or WHERE statements for example), enclose a date in quotation marks in the standard SAS form ddMMMyyyy and immediately follow the final quotation mark with the letter D.

The D suffix tells SAS to convert the calendar date to a SAS date value. Of course you could also use the unformatted numeric value instead.

Example:

data want;

set sashelp.air(where=(date=0)) sashelp.air(where=(date="01JAN1960"d));

run;

Re: use date in a select range

podarum — Fri, 03 Feb 2012 21:06:41 GMT

Thanks Udo, I remembered after I posted it.. but thought there was a different approach with different formats.