How to filter dates between two specific dates in SAS?

[Roger]

Hello,

I have a large data set that I need to subset the data set between two specific dates. I would need to get the sales data only from 01/01/2005 to 12/31/2005.

Data set name: sales

variable name: sales_date

variable name: sold_item

variable name: quantity

------------------------------------------------------

sales_date | sold_item | quantity

12/24/2003 | printer | 233

11/10/2005 | printer | 130

07/24/2005 | phone | 256

09/26/2005 | ipad | 239

01/24/2006 | ipad | 542

01/17/2006 | notebook | 328

Thanks,

Roger

[umashankersaini]

Hi Roger,

Have you tried with Proc sql with where clause includeing between and and.

like : where sales_date between  12/24/2003 and 07/24/2005

Regards

Uma Shanker Saini

[overmar · Accepted solution]

Essentially,

proc sql;

create table want as

select *

from have

where sales_date between '01JAN2012'd and '31DEC2012'd;

quit;

OR you could do it in data step.

data want;

     set have;

     where '01JAN2012'd<=sales_date<='31DEC2012'd;

run;