I have different data bases with the following nomenclature (rescap_&year_&month) in dif routes than only have the following nomenclature (D.$YEAR), Years going to 1930 to 2021 and month from 01 to 12. I need specific info from each data bases , then i need to put the results in one database together in vertical way by using a "set". This exercise will be done as a acumulative process I tried this for the following example and it works: /*U N E R E S C A P 2 0 2 1*/ data WORK.rescap_2021_08 (keep=NoPoliza statuspoliza_orig FechaEmision fechavaluacion FechaFirmaCredito PlazoMeses FrecPago PrimaEmitida MontoSolicitado MontoSolicitadoSiniestro MontoPagadoSiniestro sumaasegurada_MN BEL_MN NuevaOPC_16_MN PVM TasaGPI CR_calc RC_calc CO_calc); set D2021.rescap_2021_08 (RENAME=(pe_2021_08=PrimaEmitida)); run; PROC SORT DATA=rescap_2021_08; BY NoPoliza; RUN; data WORK.rescap_2020_08 (keep=NoPoliza statuspoliza_orig FechaEmision fechavaluacion FechaFirmaCredito PlazoMeses FrecPago PrimaEmitida MontoSolicitado MontoSolicitadoSiniestro MontoPagadoSiniestro sumaasegurada_MN BEL_MN NuevaOPC_16_MN PVM TasaGPI CR_calc RC_calc CO_calc); set D2020.rescap_2020_08 (RENAME=(pe_2020_08=PrimaEmitida)); run; PROC SORT DATA=rescap_2020_08; BY NoPoliza; RUN; data WORK.rescap_2021_07 (keep=NoPoliza statuspoliza_orig FechaEmision fechavaluacion FechaFirmaCredito PlazoMeses FrecPago PrimaEmitida MontoSolicitado MontoSolicitadoSiniestro MontoPagadoSiniestro sumaasegurada_MN BEL_MN NuevaOPC_16_MN PVM TasaGPI CR_calc RC_calc CO_calc); set D2021.rescap_2021_07 (RENAME=(pe_2021_07=PrimaEmitida)); run; PROC SORT DATA=rescap_2021_07; BY NoPoliza; RUN; data WORK.rescap_2021_06 (keep=NoPoliza statuspoliza_orig FechaEmision fechavaluacion FechaFirmaCredito PlazoMeses FrecPago PrimaEmitida MontoSolicitado MontoSolicitadoSiniestro MontoPagadoSiniestro sumaasegurada_MN BEL_MN NuevaOPC_16_MN PVM TasaGPI CR_calc RC_calc CO_calc); set D2021.rescap_2021_06 (RENAME=(pe_2021_06=PrimaEmitida)); run; PROC SORT DATA=rescap_2021_06; BY NoPoliza; RUN; /*UNE BASES FINALES*/ DATA WORK.VERTICAL; SET rescap_2021_08 rescap_2021_08 rescap_2021_07; BY NoPoliza; RUN; PROC SORT DATA=VERTICAL; BY NoPoliza; RUN; But when i try this macro, i cant see the results %macro bdPrimasVertical; %do yr=2019 %to 2021; %do ms=1 %to 12; data earf.rescapi_&yr._&ms. (keep=NoPoliza statuspoliza_orig FechaEmision fechavaluacion FechaFirmaCredito PlazoMeses FrecPago PrimaEmitida MontoSolicitado MontoSolicitadoSiniestro MontoPagadoSiniestro sumaasegurada_MN BEL_MN NuevaOPC_16_MN PVM TasaGPI CR_calc RC_calc CO_calc); set D&yr..rescap_&yr._&ms. (RENAME=(pe_&yr_&ms.=PrimaEmitida)); run; PROC SORT DATA=rescapi_&yr._&ms.; BY NoPoliza; RUN; %end; %end; %mend; this is the log of the macro: 1 The SAS System 09:36 Monday, September 13, 2021 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Programa'; 4 %LET _CLIENTPROCESSFLOWNAME='Flujo del proceso'; 5 %LET _CLIENTPROJECTPATH='C:\Users\CRE-EARF\Documents\Cierres\RespaldoCierre09092021.egp'; 6 %LET _CLIENTPROJECTPATHHOST='510-CRE-EARF'; 7 %LET _CLIENTPROJECTNAME='RespaldoCierre09092021.egp'; 8 %LET _SASPROGRAMFILE=''; 9 %LET _SASPROGRAMFILEHOST=''; 10 11 ODS _ALL_ CLOSE; 12 OPTIONS DEV=PNG; 13 GOPTIONS XPIXELS=0 YPIXELS=0; 14 FILENAME EGSR TEMP; 15 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 16 STYLE=HtmlBlue 17 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css") 18 NOGTITLE 19 NOGFOOTNOTE 20 GPATH=&sasworklocation SYMBOLGEN: Macro variable SASWORKLOCATION resolves to "/work/SAS_work443E000071AA_sas-desa/SAS_work68B8000071AA_sas-desa/" 21 ENCODING=UTF8 22 options(rolap="on") 23 ; NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 24 25 GOPTIONS ACCESSIBLE; 26 27 %macro bdPrimasVertical; 28 29 %do yr=2019 %to 2021; 30 %do ms=1 %to 12; 31 32 data earf.rescapi_&yr._&ms. 33 (keep=NoPoliza statuspoliza_orig FechaEmision fechavaluacion FechaFirmaCredito 34 PlazoMeses FrecPago PrimaEmitida MontoSolicitado MontoSolicitadoSiniestro 35 MontoPagadoSiniestro sumaasegurada_MN BEL_MN NuevaOPC_16_MN PVM TasaGPI 36 CR_calc RC_calc CO_calc); 37 set D&yr..rescap_&yr._&ms. (RENAME=(pe_&yr_&ms.=PrimaEmitida)); 38 run; 39 40 PROC SORT DATA=rescapi_&yr._&ms.; 41 BY NoPoliza; 42 RUN; 43 44 %end; 45 %end; 46 %mend; 47 48 GOPTIONS NOACCESSIBLE; 49 %LET _CLIENTTASKLABEL=; 50 %LET _CLIENTPROCESSFLOWNAME=; 51 %LET _CLIENTPROJECTPATH=; 52 %LET _CLIENTPROJECTPATHHOST=; 53 %LET _CLIENTPROJECTNAME=; 54 %LET _SASPROGRAMFILE=; 55 %LET _SASPROGRAMFILEHOST=; 56 2 The SAS System 09:36 Monday, September 13, 2021 57 ;*';*";*/;quit;run; 58 ODS _ALL_ CLOSE; 59 60 61 QUIT; RUN; 62
... View more