topic Re: Extracting only file names from the folders in SAS Programming

Extracting only file names from the folders

srinath3111 — Mon, 26 Feb 2018 06:44:34 GMT

Hi,

I have a folder in my local d drive. in that folder i have various Excel, Csv workbooks and Tab files with different names.

So here i wanted to just extract the name's and type of the file and size of the file into a data set.

Thanks

Re: Extracting only file names from the folders

andreas_lds — Mon, 26 Feb 2018 08:21:03 GMT

Look at the f-function: finfo, fopen and the dopen-function together with dread and dnum to iterate over the contents of the directory. If you can execute shell commands, use dir or ls (depending on the os) together with filename statement. There are many examples out there, i am sure you will useful ideas.

Re: Extracting only file names from the folders

Kurt_Bremser — Mon, 26 Feb 2018 08:57:09 GMT

If your SAS session runs on a remote server, you most probably won't have access to your local drives from SAS code.

Re: Extracting only file names from the folders

srinath3111 — Mon, 26 Feb 2018 09:06:58 GMT

Hi,

When I provide server path's also it wont work?.

Thanks.

Re: Extracting only file names from the folders

Kurt_Bremser — Mon, 26 Feb 2018 09:08:46 GMT

If the resources as seen on your desktop (eg your D:\ drive) are not somehow mounted on the server, then your SAS process can't "see" them.

Re: Extracting only file names from the folders

srinath3111 — Mon, 26 Feb 2018 09:22:02 GMT

Hi,

I am working out in server along with the server path's.

Thanks.

Re: Extracting only file names from the folders

Kurt_Bremser — Mon, 26 Feb 2018 09:40:24 GMT

Please make up your mind. Quote from your original post:

"I have a folder in my local d drive."

(emphasis by me)

Are we talking about server resources, or resources on your desktop?

Please specify in-depth information about your SAS setup, and which data on which location you want to inspect for filenames.