DATA Step, Macro, Functions and more

Invalid date/time/datetime constant

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 11
Accepted Solution

Invalid date/time/datetime constant

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.

 

 

 

 

 

 


Accepted Solutions
Solution
‎01-07-2016 05:07 PM
Super User
Posts: 10,487

Re: Invalid date/time/datetime constant

[ Edited ]

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);

View solution in original post


All Replies
Solution
‎01-07-2016 05:07 PM
Super User
Posts: 10,487

Re: Invalid date/time/datetime constant

[ Edited ]

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);

New Contributor
Posts: 3

Re: Invalid date/time/datetime constant

Thank you for this solution. I've battled my program for 30 mins now...
New User
Posts: 1

Re: Invalid date/time/datetime constant

[ Edited ]

I have the same problem but your solution doesn't work. 

 

where=('01MAI2011'd <= Date_decision_octroi <= '30AVR2012'd)

 

Date_decision_octroi is mmddyy10.

 

 

 

 

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 2002 views
  • 4 likes
  • 4 in conversation