I know this is a basic request (I'm a relatively new SAS user), but I keep getting the following error message:
ERROR: Invalid date/time/datetime constant '08/31/2010'd.
ERROR: Invalid date/time/datetime constant '03/01/2011'd.
ERROR: Syntax error while parsing WHERE clause.
This is my code:
data caperfy11mo01_07;
set caper.caperfy11mo01_12;
where ('08/31/2010'd < encdate1 < '03/01/2011'd);
run;
encdate1 is formatted mmddyy.10 in caper.caperfy11mo01_12; and when I look at the data, the values for encdate1 appear as I've written them in the code.
Any help is greatly appreciated. Thank you.
where ('08/31/2010'd < encdate1 < '03/01/2011'd); is attempting use date literals. SAS requires literals to be ddMONyy or ddMONyyyy
use
where ('31AUG2010'd < encdate1 < '01MAR2011'd);
where ('08/31/2010'd < encdate1 < '03/01/2011'd); is attempting use date literals. SAS requires literals to be ddMONyy or ddMONyyyy
use
where ('31AUG2010'd < encdate1 < '01MAR2011'd);
I have the same problem but your solution doesn't work.
where=('01MAI2011'd <= Date_decision_octroi <= '30AVR2012'd)
Date_decision_octroi is mmddyy10.
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.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.