BookmarkSubscribeRSS Feed
mlogan
Lapis Lazuli | Level 10

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

1 REPLY 1
Steelers_In_DC
Barite | Level 11

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

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

sas-innovate-2024.png

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!

How to choose a machine learning algorithm

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.

Discussion stats
  • 1 reply
  • 866 views
  • 0 likes
  • 2 in conversation