|SAS Companion for UNIX Environments|
You can reference an external file directly by specifying its pathname in the FILE, INFILE, or %INCLUDE statements, or you can reference the file indirectly by specifying a fileref and a pathname in the FILENAME statement and then using the fileref in the FILE, INFILE, or %INCLUDE statements.
Whether you reference a file directly or indirectly,
you will need to specify its pathname in the appropriate statement. In most
cases, you must enclose the name in quotes. For example, the following INFILE
statement refers to the file
infile '/users/pat/cars';The following FILE statement directs output to the specified terminal:
The level of specification depends on your current directory. You can use the character substitutions shown in Character Substitutions in Pathnames to specify the pathname. You can also use wildcards as described in Using Wildcards in Pathnames (Input Only).
You can omit the quotes on a filename if
.dat, and the %INCLUDE statement assumes a file extension of
For example, if the current directory is
/users/mkt/report and it includes file
qtr.sas, you can reference
qtr.sas in any of the following statements:
%include '/users/mkt/report/qtr.sas'; %include 'qtr.sas'; file 'qtr.sas';If there is no QTR fileref already defined, you can omit the quotes and the filename extension on the %INCLUDE statement:
|Using Wildcards in Pathnames (Input Only)|
You can use the *, ?, and [ ] wildcards to specify pathnames in the FILENAME (only if the fileref is to be used for input), INFILE, and %INCLUDE statements and the INCLUDE command.
|*||matches one or more characters, except for the period at the beginning of filenames.|
|?||matches any single character.|
|[ ]||matches any single character from the set of characters defined within the brackets. You can specify a range of characters by specifying the starting character and ending character separated by a hyphen.|
The following example reads input from every file in
the current directory that begins with the string
wild and ends with
filename wild 'wild*.dat'; data; infile wild; input; run;
The following example reads input from every file in every subdirectory of the current working directory:
filename subfiles '*/*'; data; infile subfiles; input; run;If new files are added to any of the subdirectories, they can be accessed with the
subfilesfileref without changing the FILENAME statement.
You can also use wildcards in filenames, but not in directory names, when you use aggregate syntax:
filename curdir "."; data; infile curdir('wild*'); input; run;The period in the FILENAME statement refers to the current directory. See Character Substitutions in Pathnames for information on other characters substitutions available on UNIX.
The following statement associates the fileref
myref with all files that begin
with alphabetic characters. Files beginning with numbers or other characters
such as the period or tilde are excluded.
filename myref '[a-zA-Z]*.dat';The following statement associates
myrefwith any file beginning with
sales(in either uppercase, lowercase, or mixed case) and a year between 1990 and 1999:
filename myref '[Ss][Aa][Ll][Ee][Ss]199[0-9].dat';
Top of Page
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.