There are several ways to create a rowvector object. First, you can enter the rowvector keyword (with an optional dimension) followed by a name:

The resulting rowvector will be initialized with zeros.

Alternatively, you may combine a declaration with an assignment statement. The new rowvector will be sized and initialized accordingly:

Graph creation views are discussed in detail in “Graph Creation Command Summary”.

To declare a rowvector and to fill it with data read from an Excel file:

To access a single element of the rowvector using direct indexing:

The rowvector may be used in standard matrix expressions:

clears the custom column labels from the rowvector RVEC1.

See also Rowvector::clearrowlabels.

Removes the rowvector’s history attribute, as shown in the label view of the rowvector.

The first line removes the history from the rowvector R1, and the second line displays the label view of R1, including the now blank history field.

See “Labeling Objects” for a discussion of labels and display names.

See also Rowvector::label.

Removes the rowvector’s remarks attribute, as shown in the label view of the rowvector.

The first line removes the remarks from the rowvector R1, and the second line displays the label view of R1, including the now blank remarks field.

See “Labeling Objects” for a discussion of labels and display names.

See also Rowvector::label.

clears the custom row label from the rowvector RVEC1.

See also Rowvector::clearcollabels.

Creates either a named or unnamed copy of the rowvector.

creates an unnamed copy of the rowvector R1.

creates R2, a copy of the rowvector R1.

See also copy.

Display the contents of a table, graph, or spool in the window of the rowvector object.

Display the contents of the table TAB1 in the window of the object ROWVECTOR1.

Most often used in constructing an EViews Add-in. See “Custom Object Output”.

Attaches a display name to a rowvector object which may be used to label output in tables and graphs in place of the standard rowvector object name.

Display names are case-sensitive, and may contain a variety of characters, such as spaces, that are not allowed in rowvector object names.

The first line attaches a display name “Hours Worked” to the rowvector object HRS, and the second line displays the label view of HRS, including its display name.

See “Labeling Objects” for a discussion of labels and display names.

See also Rowvector::label.

Saves the data used to display a histogram, kernel density, theoretical distribution, empirical CDF or survivor plot, or quantile plot to the workfile.

saves the distribution plot data specified by dist_type, where dist_type must be one of the following keywords:

The theoretical quantile-quantile plot type “theoryqq” takes the options described in qqplot under “Theoretical Options”.

For the remaining types, dist_options are any of the distribution type-specific options described in distplot.

Note that the graph display specific options such as “fill,” “nofill,” and “leg,” and “noline” are not relevant for this procedure.

You may use the “prompt” option to force the dialog display

creates the data used to draw a histogram from the rowvector RVEC1 with the anchor at 0, density scaling, and right-closed intervals, and stores that data in a matrix called MATRIX01 in the workfile.

generates the kernel density data computed with a biweight kernel at 50 grid points, using a bandwidth of 0.5 and linear binning, and stores that data in MATRIX02.

creates theoretical quantile-quantile data from RVEC1 using the ordinary quantile method to calculate quantiles. The theoretical distribution is the logit distribution, with the location parameter set to 0.5. The data is saved into the matrix MATRIX03.

For a description of distribution graphs and quantile-quantile graphs, see “Analytical Graph Types”.

See also distplot and qqplot.

The following options apply if iterative estimation of parameters is required:

The command

uses the default settings to test whether the elements of the rowvector RVEC1 come from a normal distribution. Both the location and scale parameters are estimated from the data in RVEC1.

See “Empirical Distribution Tests” for a description of the goodness-of-fit tests.

See also qqplot.

Follow the keyword with a name for the file. file_name may include the file type extension, or the file type may be specified using the “t=” option.

If an explicit path is not specified, the file will be stored in the default directory, as set in the File Locations global options.

The base syntax for writing Excel 2007 files is:

where the table_description may contain:

If the worksheet name contains spaces, it should be placed in single quotes. If the worksheet name is omitted, the cell range is assumed to refer to the currently active sheet. If only a top left cell is provided, a bottom right cell will be chosen automatically to cover the range of non-empty cells adjacent to the specified top left cell. If only a sheet name is provided, the first set of non-empty cells in the top left corner of the chosen worksheet will be selected automatically. As an alternative to specifying an explicit range, a name which has been defined inside the Excel workbook to refer to a range or cell may be used to specify the cells to read.

The command:

exports data in RVECTOR1 to a CSV file named “myrvector.CSV” in the default directory.

saves the contents of RVECTOR1 along with the column and row headers to a CSV (comma separated value) file named “myrvector.CSV” and writes all NA values as “NaN”.

writes the data of RVECTOR1 along with the column and row headers to a HTML file named “myrvector.HTM” at half of the original size.

exports the data in the second column to a CSV file named “myrvector.CSV”, and writes all NA values as “.”.

writes the data in RVECTOR1 to the preexisting “myrvector.XLSX” Excel file to the “Country” sheet at cell B5, where all cell formatting is cleared.

See also Rowvector::import.

Follow the keyword with a list of values to place in the specified object. Each value should be separated by a comma.

Running out of values before the object is completely filled is not an error; the remaining cells or observations will be unaffected, unless the “l” option is specified. If, however, you list more values than the object can hold, EViews will not modify any observations and will return an error message.

The following example declares a four element rowvector MC, initially filled with zeros. The second line fills MC with the specified values and the third line replaces from column 3 to the last column with –1.

See “Matrix Language” for a detailed discussion of rowvector and matrix manipulation in EViews.

The freq command performs a one-way frequency tabulation.

Frequencies are computed for all of the elements in the rowvector. Missing values are dropped unless included by option. You may use options to control automatic binning (grouping) of values and the order of the entries of the table.

tabulates all values (no binning) of RVEC1, with entries in ascending value order. The table will display counts, percentages, and cumulative frequencies.

tabulates RVEC1 including NAs. The observations will be binned if RVEC1 has more than 200 distinct values; EViews will create at most 50 equal value-width bins. The number of bins may be smaller than 50.

tabulates RVEC1 with the table rows ordered from values with highest frequency to lowest.

See “One-Way Tabulation” for a discussion of frequency tables.

The hist command displays descriptive statistics and a histogram for the data in the rowvector.

Displays the histogram and descriptive statistics of RVEC1.

See “Histogram and Stats” for a discussion of the descriptive statistics reported in the histogram view.

See distplot for a more fully-featured and customizable method of constructing histograms and Rowvector::stats stats for a view with a more extensive set of basic descriptive statistics.

The syntax for reading Excel files is:

The following table_description elements may be used when reading Excel data:

The optional variables_description may be formed using the elements:

loads the active sheet of “Data.XLSX” into the ROWVEC_OBJ rowvector object.

reads the data contained in the “GDP data” sheet of “Data.XLS” into the ROWVEC_OBJ object.

The syntax for reading HTML pages is:

The following table_description elements may be used when reading an HTML file or page:

The optional variables_description may be formed using the elements:

loads into the RVEC object the data located in the HTML file “Data.HTML” located on the C:\ drive

loads into a rowvector RVEC the data with the given URL located on the website site “http://www.tradingroom.com.au”. The column header is set to three rows.

The syntax for reading text or binary files is:

If a table_description is not provided, EViews will attempt to read the file as a free-format text file. The following table_description elements may be used when reading a text or binary file:

A central component of the table_description element is the format statement. You may specify the data format using the following table descriptors:

The optional variables_description may be formed using the elements:

reads “Data.CSV” into a RVEC2, skipping the first 5 rows.

loads the comma delimited data “Date.TXT” into the RVEC2 rowvector object.

See also Rowvector::export.

As a procedure, label changes the fields in the rowvector label.

The first version of the command displays the label view of the rowvector. The second version may be used to modify the label. Specify one of the following options along with optional text. If there is no text provided, the specified field will be cleared.

The following lines replace the remarks field of rowvector RV1 with “Data from CPS 1988 March File”:

To append additional remarks to RV1, and then to print the label view:

To clear and then set the units field, use:

See “Labeling Objects” for a discussion of labels.

See also Rowvector::displayname.

See “Object Linking and Embedding (OLE)” for a discussion of using OLE with EViews.

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

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.

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.

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

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.

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.

resizes the rowvector RVEC1 to 20 columns, retaining the contents of any existing elements and initializing new elements to 0.

See also Rowvector::rowvector.

The rowvector command declares and optionally initializes a rowvector object.

You may optionally specify the size (number of columns) of the rowvector in parentheses after the rowvector keyword. If you do not specify the size, EViews creates a rowvector of size 1, unless the declaration is combined with an assignment.

By default, all elements of the rowvector are set to 0, unless an assignment statement is provided. EViews will automatically resize new rowvectors, if appropriate.

RVEC1 is a rowvector of size one with value 0. COEFVEC is a rowvector of size 20 with all elements equal to 2. NEWCOEF is also a rowvector of size 20 with all elements equal to the same values as COEFVEC.

See also Coef::coef and Vector::vector.

Sets the attribute attr to attr_value. Note that quoting the arguments may be required. Once added to an object, the attribute may be extracted using the @attr data member.

sets the “revised” attribute in the object A to the string “never”, and extracts the attribute into the string object S.

See “Adding Custom Attributes in the Label View” and “Adding Your Own Label Attributes”.

Follow the setcollabels command with a space delimited list of column labels. Note that each column label should not contain spaces unless it is enclosed in quotes. If you provide fewer labels than there are columns, EViews will keep the corresponding default column names (“C11”, “C12”, etc...).

sets the column label for the first column in rowvector MAT1 to USA, the second to UK, and the third to FRANCE.

See Rowvector::setrowlabels.

where format_arg is a set of arguments used to specify format settings. If necessary, you should enclose the format_arg in double quotes.

For rowvectors, setformat operates on all of the cells in the rowvector.

To format numeric values, you should use one of the following format specifications:

To specify a format that groups digits into thousands using a comma separator, place a “t” after the format character. For example, to obtain a fixed number of decimal places with commas used to separate thousands, use “ft[.precision]”.

To use the period character to separate thousands and commas to denote decimal places, use “..” (two periods) when specifying the precision. For example, to obtain a fixed number of characters with a period used to separate thousands, use “ct[..precision]”.

If you wish to display negative numbers surrounded by parentheses (i.e., display the number -37.2 as “(37.2)”), you should enclose the format string in “()” (e.g., “f(.8)”).

To set the format for all cells in the rowvector to fixed 5-digit precision, simply provide the format specification:

Other format specifications include:

See Rowvector::setwidth, Rowvector::setindent and Rowvector::setjust for details on setting spreadsheet widths, indentation and justification.

where indent_arg is an indent value specified in 1/5 of a width unit. The width unit is computed from representative characters in the default font for the current spreadsheet (the EViews spreadsheet default font at the time the spreadsheet was created), and corresponds roughly to a single character. Indentation is only relevant for non-center justified cells.

The default indentation setttings are taken from the Global Defaults for spreadsheet views ( “Spreadsheet Data Display”) at the time the spreadsheet was created.

For rowvectors, setindent operates on all of the cells in the rowvector.

To set the indentation for all the cells in a rowvector object:

See Rowvector::setwidth and Rowvector::setjust for details on setting spreadsheet widths and justification.

where format_arg may be set to left, center, right, or auto (strings are left-justified and numbers are right-justified). Default display settings can be set in General Options; see “Spreadsheet Data Display”.

left-justifies the cells in the spreadsheet view of the rowvector ROW1.

See Rowvector::setwidth and Rowvector::setindent for details on setting spreadsheet widths and indentation.

Follow the setrowlabels command with a row label. Note that the row label should not contain spaces unless it is enclosed in quotes.

sets the row label to “USA”.

See Rowvector::setcollabels.

where width_arg specifies the width unit value. The width unit is computed from representative characters in the default font for the current spreadsheet (the EViews spreadsheet default font at the time the spreadsheet was created), and corresponds roughly to a single character. width_arg values may be non-integer values with resolution up to 1/10 of a width unit.

sets the width of all columns in rowvector RV1 to 12 width units.

See Rowvector::setindent and Rowvector::setjust for details on setting spreadsheet indentation and justification.

displays and prints the spreadsheet view of rowvector RV1.

where mode is either 0 or 1 where 0 displays the default row and column labels and 1 displays the custom row and column labels (if present).

displays the custom row and column labels for the R1 spreadsheet. If custom labels have not been set the default labels will be displayed.

displays the default row and column labels for the R1 spreadsheet.

See also Rowvector::setcollabels and Rowvector::setrowlabels.

Computes and displays a table of means, medians, maximum and minimum values, standard deviations, and other descriptive statistics for a rowvector.

The stats command computes the statistics for each column. Note that in the case of a rowvector, this will be for a single observation.

displays the descriptive statistics view of rowvector RV1.

See “Descriptive Statistics & Tests” and (here) for a discussion of the descriptive statistics views of series and groups.

Specify the type of test and the value under the null hypothesis as an option. You must specify at least one hypothesis.

For tests of means, you may either estimate the variance or specify the variance as an option.

tests the null hypothesis that the mean of RVEC1 is equal to 7, using an estimated standard deviation.

tests the null that the mean is 7, using an estimated standard deviation, and also assuming that the standard deviation is known to be 2.

tests the null hypothesis that the variance of RVEC1 is equal to 4.

See “Descriptive Statistics & Tests” for a discussion of simple hypothesis tests.

Creates a foreign format disk file containing EViews data. May be used to export EViews data to another program.

This routine should realistically only be used in the oft-hand chance that you wish to write into a Lotus file. Improved Excel, text, and other format writing is available in Rowvector::export.

Follow the name of the rowvector object by a period, the keyword, and the name for the output file. The optional path name may be on the local machine, or may point to a network drive. If the path name contains spaces, enclose the entire expression in double quotation marks. The entire rowvector will be exported.

Note that EViews cannot, at present, write into an existing file. The file that you select will, if it exists, be replaced.

If you omit the “t=” option, EViews will determine the type based on the file extension. Unrecognized extensions will be treated as ASCII files. For Lotus and Excel spreadsheet files specified without the “t=” option, EViews will automatically append the appropriate extension if it is not otherwise specified.

writes the rowvector RV1 into an ASCII file named DAT1.CSV on the A: drive. NAs are coded as “.” (dot).

writes the same file in the default directory.

saves the contents of RV1 in an Excel file “Results.xls” in the specified directory.

See “Exporting to a Spreadsheet or Text File” for a discussion.

See also Rowvector::export and Rowvector::read.

Computes and displays a table of means, medians, maximum and minimum values, standard deviations, and other descriptive statistics for the data in the rowvector.

displays the descriptive statistics view of the elements of the rowvector RVEC1.