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
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;
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
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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.