DATA Step, Macro, Functions and more

SAS Dates

Reply
Super Contributor
Posts: 1,041

SAS Dates

I have the dates like shown below used in the dataset and so I put those in Macro variables.

The date is numeric also

%let start =20130901;

%let end =20140831;

Could you help me understand why I am getting this kind of error?????

data Want;

set have(keep=Account Date Numerator Denominator);

where Numerator=1;

where same and Date between "&start"D and "&end"D ;

run;

ERROR: Invalid date/time/datetime constant "20130901"D.

ERROR: Invalid date/time/datetime constant "20140831"D.

ERROR: Syntax error while parsing WHERE clause.

NOTE: WHERE clause has been cleared.

Thanks

Trusted Advisor
Posts: 1,228

Re: SAS Dates

Posted in reply to robertrao

What is "same"  in where clause?

Super User
Posts: 11,343

Re: SAS Dates

Posted in reply to robertrao

SAS date literals MUST be in the form ddMMMyy or ddMMMyyyy such as '31AUG2014'd NOT '20140831'D as you used them in the code.

Trusted Advisor
Posts: 3,211

Re: SAS Dates

Posted in reply to robertrao

Use date constants as documented.   Using mmm is the char abrevation not numbers.  SAS(R) 9.4 Language Reference: Concepts, Third Edition

SAS(R) 9.4 Statements: Reference, Third Edition

The constant  will be convert behind to a number. The date variable is coming in... same type? (you should know)

same is now a variable, new one, getting initialized with (missing). As a boolean it is false.

..... update: same is accepted syntax as is between with where statement.

Between an known with SQL SAS(R) 9.4 SQL Procedure User's Guide not in a normal datastep if statement SAS(R) 9.4 Language Reference: Concepts, Third Edition  

The between is however found at where processing SAS(R) 9.4 Language Reference: Concepts, Third Edition

The same and is also there.  Nice, getting the old interactive approach back from my memory (FSP). 
I only do not understand the "same and" coding in a batch/code programming way

---->-- ja karman --<-----
Ask a Question
Discussion stats
  • 3 replies
  • 231 views
  • 0 likes
  • 4 in conversation