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;
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!
Submit your idea!
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.