proc reg "where" statement for numerical dates

[RACHEL2425]

Hi everyone-

I am currently doing a simple linear regression of a variable over time. My date format right now is in the format (mmddyyyy) [no forward slashes, no letters]. Whenever I try to include a "where" statement when I do proc reg, errors come up. Can anyone help with this? I have included two of the codes that I have tried below: 

PROC REG DATA=work.ELYRIA PLOTS = (FITPLOT);
where '03/24/2021'd <= sasdate <= '04/25/2021'd ;
MODEL LOGMGC = sasdate;
RUN;

or 

PROC REG DATA=work.ELYRIA PLOTS = (FITPLOT);
where 03/24/2021'd <= sasdate <= 04/25/2021 ;
MODEL LOGMGC = sasdate;
RUN;

[RACHEL2425]

PROC REG DATA=work.ELYRIA PLOTS = (FITPLOT);
where 03/24/2021 <= sasdate <= 04/25/2021 ;
MODEL LOGMGC = sasdate;
RUN;

^error with second code in original post. I have fixed it here.

[Kurt_Bremser · Accepted solution]

A SAS date literal must be in the form

"DDMMMYYYY"d

where DD is the day of the month, MMM the three-letter month abbreviation (e.g JAN for January), and YYYY is the year. Therefore, your WHERE statement must be

where "24mar2021"d <= sasdate <= "25apr2021"d;

[RACHEL2425]

Kurt, YOU ARE A GENIUS. I cannot thank you enough. This worked. After a three hour long battle.

You are the best.

Have a lovely day.

Rachel