Object Reference : Object View and Procedure Reference : Rowvector
Import data from a foreign disk file into a rowvector.
(This is a deprecated method of importing into a rowvector. See Rowvector::import for the currently supported method.)
May be used to import data into an existing workfile from a text, Excel, or Lotus file on disk.
vector_name.read(options) [path\]file_name
You must supply the name of the source file. If you do not include the optional path specification, EViews will look for the file in the default directory. Path specifications may point to local or network drives. If the path specification contains a space, you may enclose the entire expression in double quotation marks.
Force the dialog to appear from within a program.
File type options
t=dat, txt
ASCII (plain text) files.
t=wk1, wk3
Lotus spreadsheet files.
Excel spreadsheet files.
If you do not specify the “t” option, EViews uses the file name extension to determine the file type. If you specify the “t” option, the file name extension will not be used to determine the file type.
Options for ASCII text files
Specify text for NAs. Default is “NA”.
Treat tab as delimiter (note: you may specify multiple delimiter options). The default is “d=c” only.
Treat comma as delimiter.
Treat space as delimiter.
Treat alpha numeric characters as delimiter.
custom = symbol
Specify symbol/character to treat as delimiter.
Treat multiple delimiters as one.
rect (default) / norect
[Treat / Do not treat] file layout as rectangular.
skipcol = integer
Number of columns to skip. Must be used with the “rect” option.
skiprow = integer
Number of rows to skip. Must be used with the “rect” option.
comment= symbol
Specify character/symbol to treat as comment sign. Everything to the right of the comment sign is ignored. Must be used with the “rect” option.
Strings are in single quotes, not double quotes.
Do not treat strings as NA; simply drop them.
Treat numbers in parentheses as negative numbers.
Allow commas in numbers (note that using commas as a delimiter takes precedence over this option).
Options for spreadsheet (Lotus, Excel) files
letter_number (default=“b2”)
Coordinate of the upper-left cell containing data.
Sheet name for Excel 5–8 Workbooks.
rv1.read(t=dat,na=.) a:\mydat.raw
reads data into rowvector RV1 from an ASCII file MYDAT.RAW in the A: drive. The data in the file are listed by row, and the missing value NA is coded as a “.” (dot or period).
rv1.read(a2,s=sheet3) cps88.xls
reads data into rowvector RV1 from an Excel file CPS88 in the default directory. The upper left data cell is A2, and the data is read from a sheet named SHEET3.
rv2.read(a2, s=sheet2) "\\network\dr 1\cps91.xls"
reads the Excel file CPS91 into rowvector RV1 from the network drive specified in the path.
See “Importing Data” for a discussion and examples of importing data from external files.
See also Rowvector::export.