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

How to filter dates between two specific dates in SAS?

Roger — Thu, 16 Jan 2014 06:00:52 GMT

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

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

umashankersaini — Thu, 16 Jan 2014 06:26:35 GMT

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

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

overmar — Thu, 16 Jan 2014 17:06:41 GMT

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;