topic Re: checking dates in sql in SAS Procedures

checking dates in sql

ren2010 — Fri, 05 Feb 2010 20:59:29 GMT

I have a date variable where dates are stored as mmddyyyy format,
how do i check the date variable using sql where condition?
Suppose i want to select all records whre date is greater than 01012009
what will be sql for this.

Re: checking dates in sql

sbb — Fri, 05 Feb 2010 21:33:25 GMT

Suggest you search the forum archives - a popular post/topic/question. Also, how about the SAS support http://support.sas.com/ website with a suitable search there as well?

Scott Barry
SBBWorks, Inc.

Re: checking dates in sql

venkatesh — Mon, 08 Feb 2010 03:52:08 GMT

proc sql;
select *from dataset name
where date ge '01012009'd ;
quit;

Re: checking dates in sql

Cynthia_sas — Mon, 08 Feb 2010 04:22:55 GMT

Hi:
Please refer to the documentation on using constants in expressions:
http://support.sas.com/documentation/cdl/en/lrcon/61722/HTML/default/a000780334.htm

Particularly, the use of date constants requires that the date constant be expressed in the form: ddMMMyy or ddMMMyyyy, as shown below:
[pre]
Use the following patterns to create date and time constants:

date='1jan2006'd;

date='01jan04'd;

[/pre]

cynthia