How to filter dates between two specific dates in SAS?

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 16
Accepted Solution

How to filter dates between two specific dates in SAS?

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


Accepted Solutions
Solution
‎01-16-2014 12:06 PM
Frequent Contributor
Posts: 83

Re: How to filter dates between two specific dates in SAS?

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;

View solution in original post


All Replies
Frequent Contributor
Posts: 114

Re: How to filter dates between two specific dates in SAS?

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

Solution
‎01-16-2014 12:06 PM
Frequent Contributor
Posts: 83

Re: How to filter dates between two specific dates in SAS?

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;

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 1044 views
  • 5 likes
  • 3 in conversation