topic Re: Using infile with several files (*) in SAS Programming

Using infile with several files (*)

juanvg1972 — Tue, 07 Jun 2016 18:55:19 GMT

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,

Re: Using infile with several files (*)

FreelanceReinh — Tue, 07 Jun 2016 19:29:01 GMT

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=...

Re: Using infile with several files (*)

jklaverstijn — Tue, 07 Jun 2016 19:32:18 GMT

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.

Re: Using infile with several files (*)

ballardw — Tue, 07 Jun 2016 19:32:34 GMT

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;

Re: Using infile with several files (*)

SASKiwi — Tue, 07 Jun 2016 19:33:02 GMT

Check out the FILENAME option on the INFILE statement:

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