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
What is "same" in where clause?
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.
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.