Building models with SAS Enterprise Miner, SAS Factory Miner, SAS Visual Data Mining and Machine Learning or just with programming

Query by Date and time

Reply
Regular Contributor
Posts: 218

Query by Date and time

HI All,

I am doing a query on date and it doesn't seem like working, can anyone help please.

I have values in 10JUL13:13:59:00 format and the following code is not excluding this values before Aug 01, 2013.

data want;

set have;

where Mydate>"01Aug2013"d;

run;

Thanks,te

Valued Guide
Posts: 860

Re: Query by Date and time

try this, your sign is backwards and you only want to pull the date, not the date and time:

where datepart(mydate)<'01Aug2013'd;

Ask a Question
Discussion stats
  • 1 reply
  • 202 views
  • 0 likes
  • 2 in conversation