topic Re: How to use Filename indata pipe to get the file names in a directory from Unix environment. in New SAS User

How to use Filename indata pipe to get the file names in a directory from Unix environment.

karthic2612 — Tue, 16 Jul 2019 06:52:39 GMT

Hi,

Could someone help me to get the file names in a directory from Unix environment

Below code is for Windows,

filename indata pipe 'dir "/home/euqyi/shared_folder/user_data/Vishal/pah/Inflated/Data Month March 2019/pah_dx_??????.txt" /b';

Will it work for Unix environment ?

I am using the below piece of code

filename indata pipe 'dir "/home/eupoq/shared_folder/user_data/Richard/pah/Inflated/Data Month March 2019/pah_dx_??????.txt" /b';

data file_list;
length fname $50;
infile indata truncover; /* infile statement for file names */
input fname $50.; /* read the file names from the directory */
call symput ('num_files',_n_); /* store the record number in a macro variable */
run;

And getting below error in Output data

fname

1 dir: cannot access /home/euqyi/shared_folder/user_

2 dir: cannot access /b: No such file or directory

Please help me on this.

Thanks,

Vishal

Re: How to use Filename indata pipe to get the file names in a directory from Unix environment.

koyelghosh — Tue, 16 Jul 2019 07:03:38 GMT

@karthic2612 I think for Unix the dir counterpart is ls. May be you can try.

Re: How to use Filename indata pipe to get the file names in a directory from Unix environment.

koyelghosh — Tue, 16 Jul 2019 07:05:12 GMT

What is the purpose of /b in Windows?

Re: How to use Filename indata pipe to get the file names in a directory from Unix environment.

karthic2612 — Tue, 16 Jul 2019 07:14:38 GMT

we can use the DOS command "dir" with the /B option to list only the file names.

Thanks,

Vishal

Re: How to use Filename indata pipe to get the file names in a directory from Unix environment.

koyelghosh — Tue, 16 Jul 2019 07:23:10 GMT

Then just replacing dir with ls and not using /b is my suggestion. May be this will work.

Re: How to use Filename indata pipe to get the file names in a directory from Unix environment.

Kurt_Bremser — Tue, 16 Jul 2019 07:42:21 GMT

A simple

ls

is the UNIX equivalent of dir with the /b option.

Re: How to use Filename indata pipe to get the file names in a directory from Unix environment.

karthic2612 — Tue, 16 Jul 2019 09:13:07 GMT

Thanks...

It worked for me. By replacing ls with dir and /b option.

Re: How to use Filename indata pipe to get the file names in a directory from Unix environment.

koyelghosh — Tue, 16 Jul 2019 09:14:43 GMT

All the best