Hi Tom,   Thank you so much. At first sight it seems like it worked but at the end I saw weird results log says NOTE: There were 1 observations read from the data set WORK2.TEMP2. NOTE: 1 observations added. NOTE: The data set NZlib.abc has . observations and 2 variables.   Please advise    Thanks  Jagdeep ... View more

yes temp2 itself is my final table which I want to load to Netezza. Is there a way I can upload it to Netezza as I already have the table metadata in the Netezza but with a different name.  ... View more

Thank you so much team. ... View more

I am able to run that macro by manually putting multiple values for macro variables. but not able to loop macro variable values automatically. for eg: %let dt = 201901 %let dt = 201902 %let dt = 201903 %let dt = 201904 but I want it like to be resolved automatically each time of invocation.    ... View more

This one is getting file name as  bnk_mkt_scr_201407,201508,201605,201706,201804,201905.xlsx' but we need it like individual files  bnk_mkt_scr_201407.xlsx bnk_mkt_scr_201508.xlsx and so on ... View more

but when I am running this macro outside of the call execute keeping the same out = dataset name it is working absolutely fine. ... View more

Proc import step is running fine out of macro. secondly I tried running giving only yearmonth as macro variable name , in the log file names are resolving correctly but everything is getting replaced by last yearmonth call ... View more

I am getting below error after running the suggested code. But this macro call is running fine if I am running it out of data step i.e. not using call execute for one yearmonth. ERROR: An exception has been encountered. Please contact technical support and provide them with the following traceback information: The SAS task name is [IMPORT (] Segmentation Violation Traceback of the Exception: /apps/sas/sashome/dev/cmp/SASFoundation/9.4/sasexe/sas(+0x16840e) [0x55cea7c3c40e] /apps/sas/sashome/dev/cmp/SASFoundation/9.4/sasexe/sas(+0x4eddf) [0x55cea7b22ddf] /apps/sas/sashome/dev/cmp/SASFoundation/9.4/sasexe/tkmk.so(bkt_signal_handler+0x144) [0x2b9bf27a6ac4] /usr/lib64/libpthread.so.0(+0xf630) [0x2b9bf1448630] /apps/sas/sashome/dev/cmp/SASFoundation/9.4/sasexe/saswzsu(wzsdoff+0xa5) [0x2b9c0490f2c5] /apps/sas/sashome/dev/cmp/SASFoundation/9.4/dbcs/sasexe/sasxkern(ypfmtc+0x11f) [0x2b9bffa18cef] /apps/sas/sashome/dev/cmp/SASFoundation/9.4/dbcs/sasexe/sasxkern(+0x7dc5d) [0x2b9bffa2ac5d] /apps/sas/sashome/dev/cmp/SASFoundation/9.4/dbcs/sasexe/sasxkern(ypslf+0xa54) [0x2b9bffa29c54] /apps/sas/sashome/dev/cmp/SASFoundation/9.4/dbcs/sasexe/sasxkern(ypmpstr+0x2e3) [0x2b9bffa25343] /apps/sas/sashome/dev/cmp/SASFoundation/9.4/dbcs/sasexe/sasxkern(ypmstr+0x9d) [0x2b9bffa2504d] /apps/sas/sashome/dev/cmp/SASFoundation/9.4/dbcs/sasexe/sasyh(+0x385a9) [0x2b9c044395a9] /apps/sas/sashome/dev/cmp/SASFoundation/9.4/dbcs/sasexe/sasyh(+0x377b7) [0x2b9c044387b7] /apps/sas/sashome/dev/cmp/SASFoundation/9.4/dbcs/sasexe/sasyh(yyhlock+0x8e5) [0x2b9c04434d15] /apps/sas/sashome/dev/cmp/SASFoundation/9.4/dbcs/sasexe/sasyoio(yddel3+0xaba) [0x2b9c38b6bc8a] /apps/sas/sashome/dev/cmp/SASFoundation/9.4/dbcs/sasexe/sasyoio(yddel2+0x60) [0x2b9c38b6b1b0] /apps/sas/sashome/dev/cmp/SASFoundation/9.4/sasexe/sasimctr(import+0x3f3) [0x2b9c5588d993] /apps/sas/sashome/dev/cmp/SASFoundation/9.4/sasexe/sasimctr(parsexe+0x24b) [0x2b9c5588cb9b] /apps/sas/sashome/dev/cmp/SASFoundation/9.4/sasexe/sasimpor(sasimpor+0x275) [0x2b9c55382df5] 3 The SAS System Wednesday, May 18, 2022 10:17:00 AM /apps/sas/sashome/dev/cmp/SASFoundation/9.4/sasexe/sas(vvtentr+0x18a) [0x55cea7b2293a] /usr/lib64/libpthread.so.0(+0x7ea5) [0x2b9bf1440ea5] /usr/lib64/libc.so.6(clone+0x6d) [0x2b9bf1e908dd] ... View more

Here is my full macro definition : libname output '/sas/out/data'; %macro creating_tables (out_table = ,in_file = ); PROC IMPORT OUT= &out_table DATAFILE= "sas/repo/files/&in_file..xlsx" DBMS=xlsx REPLACE; GETNAMES=YES; RUN; DATA &out_table; SET &out_table; LOAD_TIME = datetime(); yearmonth = "&yearmonth"; FORMAT LOAD_TIME datetime20.; RUN; proc append base = output.&out_table data = &out_table; run; %mend creating_tables; %creating_tables(out_table = Canada_bkn_score ,in_file = qtr_src_file_&yearmonth..xlsx ); and I want to call this macro multiple times for different values of yearmonth. So I can have those values either stored in a macro variable or as a column value in a dataset. ... View more

Thanks again but in the output if you see dates are coming as march, dec, september, june but we are expecting it to be like jan, apr, July, October.      ... View more

Sorry accidently accepted as solution. so I have like 100 quarterly files out of which user wants to select as per demand files. file names have quarter end dates like. So here let say I am selecting files for last 7 quarters customer_scn_bb_bdk_20220430.xls, customer_scn_bb_bdk_20220131.xls customer_scn_bb_bdk_20220730.xls customer_scn_bb_bdk_20210131.xls customer_scn_bb_bdk_20210430.xls customer_scn_bb_bdk_20210731.xls customer_scn_bb_bdk_20211031.xls   So if I can create a table of date values as per given start date I can choose files accordingly.   Kajal     ... View more