Hi SAS Community users, I am trying to loop a large number of historical data tables, and stack them into a single table using datastep. For example, these tables named as comp_mmmyy, e.g., comp_jan24, comp_feb24,..., comp_jun24, and I am using the following code in EG: %macro test; data tmp; set %do lp = &lp_min. %to &lp_max.; comp_&put(intnx("month","31dec1990"d,&lp.,"e"),monyy5.) %end;; run; %mend; %test; I used to put function to convert a date format into mmmyy but got a warning for it, followed by errors in intnx(). Can you please let me where I am wrong? Thank you in advance.
... View more