topic Re: looping the file name input in SAS macro in SAS Programming

looping the file name input in SAS macro

MG18 — Sun, 23 Dec 2018 17:33:11 GMT

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.

Re: looping the file name input in SAS macro

error_prone — Mon, 24 Dec 2018 06:16:37 GMT

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.

Re: looping the file name input in SAS macro

MG18 — Mon, 24 Dec 2018 10:02:54 GMT

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.

Re: looping the file name input in SAS macro

LittlesasMaster — Mon, 24 Dec 2018 10:49:55 GMT

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

Re: looping the file name input in SAS macro

MG18 — Mon, 24 Dec 2018 15:58:28 GMT

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