Hello! I'm trying to create a one-column dataset that goes from a start date of January 24th, 2020 to today's date. I've been updating the end date weekly, but I'd really like to make this dynamic. How do I properly use the SAS macro variable SYSDATE9 to accomplish this? Right now I'm getting this error: ERROR: Invalid date/time/datetime constant '&sysdate9'd. ERROR 77-185: Invalid number conversion on '&sysdate9'd. Here is the code I have: %put &=sysdate9; data date; length Date 8; do Date = '24JAN2020'd to '&sysdate9'd; output; end; format date yymmdd10.; run; Thanks in advance!
... View more