We help IT Professionals succeed at work.

SAS-between not working

sam2929
sam2929 asked
on
Hi,
I am running below query getting no results but i can we have load_dte between
between 2012-01-23 and 2011-11-23 load_dte is numeric yymmdd10.

proc sql;
create table test1 as(
select count(*),LOAD_DTE from aa
where LOAD_DTE between 2012-01-23 and 2011-11-23
 );
quit;
Comment
Watch Question

Hi

The issue is that SAS is not recognizing the  dates as you are using them... Try change the code as follows: (note: EArlier date first)


select count(*),LOAD_DTE from aa where LOAD_DTE between
"23nov2011"d and 23jan2012"d ;
PS:
You may need a GROUP  statement:

select count(*),LOAD_DTE from aa where LOAD_DTE between
"23Nov2011"  and "23Jan2012"d
Group by LOAD_DTE;
Arghh, all the typos are killing me...

select count(*),LOAD_DTE from aa
 where LOAD_DTE between "23Nov2011"d and "23Jan2012"d
 Group by LOAD_DTE;

Explore More ContentExplore courses, solutions, and other research materials related to this topic.