SAS Statements under Windows |
Valid in: | a DATA step |
Windows specifics: | Valid values for encoding-value, file-specification, and host-options |
See: | INFILE Statement in SAS Language Reference: Dictionary |
Syntax | |
Details | |
Examples | |
Example 1: Referencing External Files | |
See Also |
Syntax |
INFILE file-specification <ENCODING='encoding-value'><options> <host-options>; |
identifies the source of input data records, usually an external file. The file-specification argument can be any of the file specification forms that are discussed in Referencing External Files. The reserved fileref CARDS enables the INFILE statement to reference instream data.
Note: The words AUX, CON, NUL, PRN, LPT1 - LPT9, and COM1 - COM9 are reserved words under Windows. Do not use them as filerefs.
specifies the encoding to use when reading from the external file. The value for ENCODING= indicates that the external file has a different encoding from the current session encoding.
When you read data from an external file, SAS transcodes the data from the specified encoding to the session encoding.
For valid encoding values, see Encoding Values in SAS Language Elements in SAS National Language Support (NLS): Reference Guide.
names external I/O statement options that are specific to the Windows operating environment. They can be any of the following:
specifies the number of bytes that are physically read or written in an I/O operation. The default is 8K. The maximum is 1M.
is used only in the context of named pipes. This option indicates whether the client is to wait if no data is currently available. The default value is BLOCK.
is used only in the context of named pipes. This option indicates the type of pipe. The default value is BYTE.
is used only in the context of named pipes and is valid only when defining the server. This option indicates that if an end-of-file (EOF) character is received from a client, the server should try to connect to the next client.
is used only in the context of Dynamic Data Exchange (DDE). For a complete description and an example of using this option, see Using the DDE HOTLINK.
is used in the context of I/O operations on variable record format files. When this option is specified, any occurrence of ^Z is interpreted as character data and not as an end-of-file marker.
specifies the record length (in bytes). Under Windows, the default is 256. The value of record-length can range from 1 to 1,073,741,823 (1 gigabyte).
is used only in the context of Dynamic Data Exchange (DDE). This option enables you to use nontab character delimiters between variables. For more information about this option, see Using the NOTAB Option with DDE.
controls the record format. The following are valid values under Windows:
The S370 values are valid with z/OS types of files only. That is, they are valid in files that are binary, have variable-length records, and are in EBCDIC format. If you want to use a fixed-format z/OS file, first copy it to a variable-length, binary z/OS file.
is used only in the context of named pipes. This option specifies how long a named pipe client should wait for a busy pipe. The minimum (and default) value for seconds is 10.
is used only in the context of named pipes. This option specifies the mode of a named pipe. The default value is SERVER.
specifies the end-of-line character for the file. Use this option to share files between the UNIX and Windows operating environments. The following are valid values under Windows:
Details |
If the INFILE statement includes the ENCODING argument and CARDS, CARDS4, DATALINES, or DATALINES4 as the file-specification, then SAS issues an error message. The ENCODING value in the INFILE statement overrides the value of the ENCODING system option.
Examples |
You can reference external files from a concatenated list of files or directories. The wildcard character * can be used in the INFILE statement:
data new; infile ('c:\myfiles\*.*','c:\myotherfiles\abc.dat'); input; run;
See Also |
Named Pipe Examples for examples of using some of these options
DDE Examples for examples of using some of these options.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.