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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.