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
try this, your sign is backwards and you only want to pull the date, not the date and time:
where datepart(mydate)<'01Aug2013'd;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Register now!
Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.
Find more tutorials on the SAS Users YouTube channel.