Hello dear community,
I need help aggregating tables using a SAS macro language.
So assuming I have the following monthly tables 'table_201001, table_201002, table_201003, ..., table_201312' with a variable named 'date_month ' (201001, 201002, 201003, ..., 201312). I would like to create a macro that I can allow me to assess the performance over a period of time.
For example to check the perfo from 201001 to 201003 (numeric values) i create the following macro:
%let starting_date=201001;
%let ending_date=201003;
proc sql;
create table as table_report as
select t1,*,t2.date_month
from t1 left join t2 on (t1.x=t2.y)
where t2.date_month between &starting_date. and &ending_date.;
quit;
I am trying to create a macro that can generate a perfo using a starting date and include increments like +15 to obtain a ending date.
I tried using intnx('month','20nov2002'd,1,"sameday"); but my values for date_month are numeric. Any suggestions?
