SAS Dates

[robertrao]

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

[stat_sas]

What is "same"  in where clause?

[ballardw]

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.

[jakarman]

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