Hi All, I need help on below code and below code is working fine but now we are having 500 monthly files in the watch-list folder. (/saswas/Lev1/Applications/SASAntiMoneyLaundering/5.1/BUJO/watchlist/) and i want to load the all file using the below code. What is the solution for this issue ? how can i loop these files and pass it to the %wl_dwjn_process macro ? how to create array with file name and store it ? %macro aml_dwjn_monthly; %local dwjn_file_monthly; %let dwjn_file_monthly=/saswas/Lev1/Applications/SASAntiMoneyLaundering/5.1/BUJO/watchlist/monthly.csv; %put &dwjn_file_monthly; /* Get the current runasofdate */ %aml_getrundate; %put NOTE: AML: RUNASOFDATE: &runasofdate; /* USER SETTINGS */ %wl_dwjn_process ( dwjn_file=&dwjn_file_monthly, load_type=N, allow_invalid=FULL, bulkload=%str(bulkload=yes) ); %mend aml_dwjn_monthly; many thanks in advance.
... View more