Using infile with several files (*)

[juanvg1972]

Hi,

I am doing a datastep with infile. In my infile I have several files with same structure, and with similar name

I use:

data customers;

infile "/home/aps/source/customers_group*;

...

run;

then I read files customer_group1, customer_group2,...., customer_group8 SAS dataset.

I would likee to know if is possible to create a field with the name of the file of each rows.

For example

source= customer_group1 for rows from this file.

Perhaps a system var??

I don't have any other field in the files to identify this information.

Thanks in advance,

[FreelanceReinh · Accepted solution]

Hi @juanvg1972,

You can use the FILENAME= option of the INFILE statement to obtain the file name:

data customers;
length fname $300
       source $30; 
infile "/home/aps/source/customers_group*" filename=fname;
source=scan(fname,-1,'/');
...
run;

Variable FNAME is automatically dropped and receives the full path of the currently opened input file, hence the additional assignment statement SOURCE=...

[jklaverstijn]

Have a look at the FILEVAR on the FILENAME statement. It May be what you're lookin for.

https://support.sas.com/techsup/technote/ts581.pdf

Hope this helps,

Jan.

[ballardw]

The option on the INFILE statement is FILENAME. The option creates a temporary variable so you need to assign the result to a datastep variable to become a permanent part of the data set.

data new;

  /* the dataset name will be in varaible dsname you need to ensure the length of it and the temporary variable are long enough to hold the path and name */

   length dsname myfile $ 200;

   infile  "/home/aps/source/customers_group*"   filename=myfile;

   dsname = myfile;

run;

[SASKiwi]

Check out the FILENAME option on the INFILE statement:

http://support.sas.com/documentation/cdl/en/lestmtsref/68024/HTML/default/viewer.htm#n1rill4udj0tfun...