General form, FILENAME
statement:
FILENAME fileref ('external-file1' 'external-file2'
...'external-filen');
fileref
is any SAS name that
is eight characters or fewer.
external-file
is the physical name
of an external file. The physical name is the name that is recognized
by the operating environment.
|
filename qtr1 ('c:sasusermonth1.dat''c:sasusermonth2.dat' 'c:sasusermonth3.dat'), data work.firstqtr; infile qtr1; input Flight $ Origin $ Dest $ Date : date9. RevCargo : comma15.; run;
----+----10---+----20---+----30---+----40 IA10200 SYD HKG 01JAN2000 $191,187.00 IA10201 SYD HKG 01JAN2000 $169,653.00 IA10300 SYD CBR 01JAN2000 $850.00 IA10301 SYD CBR 01JAN2000 $970.00 IA10302 SYD CBR 01JAN2000 $1,030.00 |
----+----10---+----20---+----30---+----40 IA10200 SYD HKG 01FEB2000 $177,801.00 IA10201 SYD HKG 01FEB2000 $174,891.00 IA10300 SYD CBR 01FEB2000 $1,070.00 IA10301 SYD CBR 01FEB2000 $1,310.00 IA10302 SYD CBR 01FEB2000 $850.00 |
----+----10---+----20---+----30---+----40 IA10200 SYD HKG 01MAR2000 $181,293.00 IA10201 SYD HKG 01MAR2000 $173,727.00 IA10300 SYD CBR 01MAR2000 $1,150.00 IA10301 SYD CBR 01MAR2000 $910.00 IA10302 SYD CBR 01MAR2000 $1,170.00 |
9 filename qtr1 ('c:sasusermonth1.dat''c:sasusermonth2.dat' 10 'c:sasusermonth3.dat'), 11 data work.firstqtr; 12 infile qtr1; 13 input Flight $ Origin $ Dest $ 14 Date : date9. RevCargo : comma15.; 15 run; NOTE: The infile QTR1 is: File Name=c:sasusermonth1.dat, File List=('c:sasusermonth1.dat' 'c:sasusermonth2.dat' 'c:sasusermonth3.dat'), RECFM=V,LRECL=256 NOTE: The infile QTR1 is: File Name=c:sasusermonth2.dat, File List=('c:sasusermonth1.dat' 'c:sasusermonth2.dat' 'c:sasusermonth3.dat'), RECFM=V,LRECL=256 NOTE: The infile QTR1 is: File Name=c:sasusermonth3.dat, File List=('c:sasusermonth1.dat' 'c:sasusermonth2.dat' 'c:sasusermonth3.dat'), RECFM=V,LRECL=256 NOTE: 50 records were read from the infile QTR1. The minimum record length was 33. The maximum record length was 37. NOTE: 50 records were read from the infile QTR1. The minimum record length was 33. The maximum record length was 37. NOTE: 50 records were read from the infile QTR1. The minimum record length was 33. The maximum record length was 37. NOTE: The data set WORK.FIRSTQTR has 150 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 4.02 seconds cpu time 0.93 seconds |