How to call many times a macro function and gather all the information in one dataset

alepage — Thu, 14 Jan 2021 21:48:21 GMT

Hello,

I need help because, I don't have any idea , how to do that.

First, from a root directory, I have gathered in one dataset the complete path of each subfolder that are not empty and does not contains the name old. I have put those various path's name in the dataset subdirectories under the variable foldername.

from there, I would like to use the following macro function and gather the information about the files hosted in each of those subfolders.

%macro FindFile(Path= , Command=);
/*This proc is to check if xcmd is enable. It must be enable
in order to use the unix command below*/
proc options option=xcmd;
run;

/*The %put is to see the value of FileName and Path into the logFile*/

%put &Command;
%put &Path;

/*Using the UNIX Commands find with (PIPE)*/

filename findfile PIPE "ls &Path. -l --time-style=long-iso | grep ^- | tr -s ' ' | cut -d ' ' -f 5,6,8";

data sasuser.fileslist;
infile findfile truncover;
input filelisting $200.;
run;
%mend FindFile;

So I am looking a way to pick one by one the name of the subfolder from the subdirectories dataset, and use it

%FindFile(Path=Path1);

%FindFile(Path=Path2);

...

%FindFile(Path=Path11);

and gather all the information in one dataset.

How do we do that?

Thanks in advance for help

Re: How to call many times a macro function and gather all the information in one dataset

Tom — Fri, 15 Jan 2021 05:30:35 GMT

PROC APPEND is your friend. So create one dataset with the DATA step and then use PROC APPEND to append it to the aggregate dataset you are trying to create. (PS Avoid using SASUSER as it will be readonly if you happen to be running more than one SAS session at the same time.)

data current_list;
  infile findfile truncover;
  input filelisting $200.;
run;
proc append base=full_list data=current_list force;
run;

topic Re: How to call many times a macro function and gather all the information in one dataset in SAS Enterprise Guide

How to call many times a macro function and gather all the information in one dataset

Re: How to call many times a macro function and gather all the information in one dataset