topic Re: How to get complete file names in many folders in SAS Data Management

How to get complete file names in many folders

wutao9999 — Fri, 08 Jan 2016 18:18:45 GMT

I have many folders. In each of them, there are a number of files. Is there a quick way to get all file names automatically? For example, for the attached figure, I hope to get names, such as ABB006.dat, ABB0012.data, etc.

Thank you.

Re: How to get complete file names in many folders

LinusH — Fri, 08 Jan 2016 18:40:08 GMT

"Automatically" is a strong word, what is your requirement? And what shall you do with them?

You could use data step extrnal file functions, or use a filename to pipe the dir/ls command.

Are you using DI Studio?

Re: How to get complete file names in many folders

FreelanceReinh — Fri, 08 Jan 2016 18:51:28 GMT

How about this?

filename flist pipe 'dir C:\Temp /a-d/b/s'; /* please enter your parent folder */

data fnames;
length fname $400; /* please adapt the length up/down as necessary/convenient */
infile flist;
input;
fname=scan(_infile_,-1,'\');
run;