looping the file name input in SAS macro

[MG18]

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.

[error_prone]

You didn't post any data, the source code of the macros used or rhw log generated, making it really difficult to help you.

If all files have the same structure, you don't nee macro code, you can import all with a single data-step using wildcards in the infile-statement you will find many posts explaining the this further.

[MG18]

Hi @error_prone,

I have added the piece of code which is running successfully with single file (i.e. monthly.csv ) but now we are having 500 file with same format as old file. 

%let dwjn_file_monthly=/saswas/Lev1/Applications/SASAntiMoneyLaundering/5.1/BUJO/watchlist/monthly.csv;

Can you please provide the link for the single data-step using wildcards ? This will be a great help.

[LittlesasMaster]

Hi,

If you want to read multiple files into one single step, you can simply use wildcards in infile statement

Lets your file names are 

monthly1

monthly2

monthly3

....

......

monthly500

THen you can simple write a code -

Data mydateste;

 infile "/saswas/Lev1/Applications/SASAntiMoneyLaundering/5.1/BUJO/watchlist/monthly*.csv" DSD;

run;

Limitation-

All files should have same structure 

[MG18]

Can we use same method to pass the file name for sas macro ? I have mentioned whole running SAS macro code .