Anybody know how to create a list of dates (date9.) starting at a specified date and ending on the present date? The start date will be given by proc sql and I need every possible date between then and the present date.
To give context, I'm trying to run a query to get a snapshot of information at a point in time starting from the beginning of my company until the present.
From there, I plan on iterating through this list in a macro so I'll be creating the list similar to:
select unit_pk into :Units1 - :Units99999
I'm not as skilled as you, this is what I did with your first post:
/* load dates */
format date date9.;
do date = '15SEP1999'd to today();
/* load dates into macro variable */
select "'"||put(date,date9.)||"'d" into :dates1 - :dates99999