Hi, again! thank you. it created the character string date. However, i have multiple years and the sort function does not appear to work.
... View more
Hi everyone, I am currently trying to sort a dataset based on date, and it wont sort correctly as the current date format is a numeric date9. format. How do i convert this variable to a date variable? Please note that I do not want to just change the format, I want to either create a new date variable based on the date9. variable or convert the variable altogether. Thank you, Rachel
... View more
Is the following regression appropriate? For example: PROC REG DATA=work.wastewater PLOTS = (FITPLOT); where '30nov2021'd <= sasdate <= '9jan2022'd ; MODEL LOGMGC = sasdate / clb; RUN;
... View more
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
... View more
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.
... View more
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;
... View more