topic Re: OR condition on two date variables in SAS Programming

OR condition on two date variables

Cho8 — Wed, 07 Apr 2021 08:25:33 GMT

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.

Cho8 — Wed, 07 Apr 2021 08:12:10 GMT

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.

andreas_lds — Wed, 07 Apr 2021 08:29:34 GMT

There is a "D" missing after the first '31MAR2021'.

andreas_lds — Wed, 07 Apr 2021 10:10:13 GMT

@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.