Hi,
Iam getting error for the below condition
where (REQD_DT between '01APR2020'd and '31MAR2021') OR (date1 between '01APR2020'd and '31MAR2021'd)
ERROR: WHERE clause operator requires compatible variables
what is the correct code to compare two date variables with fixed date intervals.
There is a "D" missing after the first '31MAR2021'.
Hi,
Iam getting error for the below condition
where (REQD_DT between '01APR2020'd and '31MAR2021') OR (date1 between '01APR2020'd and '31MAR2021')
ERROR: WHERE clause operator requires compatible variables
what is the correct code to compare two date variables with fixed date intervals.
@Cho8 wrote:
where (REQD_DT between '01APR2020'd and '31MAR2021'd) OR (date1 between '01APR2020'd and '31MAR2021'd)
Now the d is/was missing after each '31MAR2021'-string.
There is a "D" missing after the first '31MAR2021'.
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.