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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.