topic Re: proc reg "where" statement for numerical dates in SAS Programming

proc reg "where" statement for numerical dates

RACHEL2425 — Wed, 01 Jun 2022 17:10:09 GMT

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;

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

Re: proc reg "where" statement for numerical dates

RACHEL2425 — Wed, 01 Jun 2022 17:11:44 GMT

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.

Re: proc reg "where" statement for numerical dates

Kurt_Bremser — Wed, 01 Jun 2022 17:20:57 GMT

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;

Re: proc reg "where" statement for numerical dates

RACHEL2425 — Wed, 01 Jun 2022 17:24:01 GMT

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