There are several ways to create a vector object. Enter the vector keyword (with an optional dimension) followed by a name:

Alternatively, you may declare a vector using an assignment statement. The vector will be sized and initialized, accordingly:

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

You should follow the classify keyword with any desired options, a specification spec, the “@”-sign, the name to be given the output series, and optionally the name for a valmap object describing the classification.

The form for the specification spec will depend on which of the four supported methods for classification is employed (using the “method=” option).

classifies the values of VEC1 into bins of width 100 starting at 200 and ending at the data maximum times 1.05. The classification results are saved in the vector VEC1_CT.

classifies VEC1 into bins of size 100, from 200 through 1100. The output vector VEC1_CT1 will contain classification values taken from the right endpoints of the classification intervals. Rows with out-of-range values will be assign an NA.

defines 9 equally sized bins, starting at 200 and ending at 1100, and classifies the data into the vector VEC1_CT2. The bins are closed on the right, and out-of-range values will generate an error.

classifies the values of VEC1 into quartiles (using the Gumbel definition) in the vector VEC1_CT3. Rows with NA values in VEC1 will be encoded as 0 in the output vector.

See “Generate by Classification” for additional discussion.

clears the custom column label from the vector VEC1.

See Vector::clearrowlabels.

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

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

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

See also Vector::label.

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

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

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

See also Vector::label.

clears the custom row labels from the vector VEC1.

See Vector::clearcollabels.

Creates either a named or unnamed copy of the vector.

creates an unnamed copy of the vector V1.

creates V2, a copy of the vector V1.

See also copy.

You should specify keywords indicating the statistics you wish to display from the list below, optionally followed by the keyword @partial and the name of a conditioning matrix. In the matrix view setting, the columns of the matrix should contain the conditioning information, and the number or rows should match the original matrix.

You may specify keywords from one of the four sets (Pearson correlation, Spearman correlation, Kendall’s tau, Uncentered Pearson) corresponding the computational method you wish to employ. (You may not select keywords from more than one set.) Note that the Kendall’s tau measures are not particularly interesting since they generally will be equal, or nearly equal, to 1.

If you do not specify keywords, EViews will assume “cov” and compute the Pearson variance.

Note that cases, obs, and wgts are available for each of the methods.

displays a table containing the Pearson correlation, t-statistic for testing for zero correlation, and associated p-value, for the vector VEC1.

computes the Kendall’s tau-b, score statistic, and p-value for the score statistic.

For simple forms of the calculation see @cov.

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

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

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

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

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

The first line attaches a display name “Coef Results” to the vector V1, and the second line displays the label view of V1, including its display name.

The first line attaches a display name “Means by State” to the vector V1. The line graph view of V1 will use the display name as the legend.

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

See also Vector::label and Graph::legend.

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 vector VEC1 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 VEC1 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 data in the vector VEC1 comes from a normal distribution. Both the location and scale parameters are estimated from the data in VEC1.

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 VECTOR1 to a CSV file named “myvector.CSV” in the default directory.

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

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

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

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

See Vector::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” (loop) option is specified. If, however, you list more values than the vector can hold, EViews will not modify any observations and will return an error message.

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

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

The freq command performs a one-way frequency tabulation.

Frequencies are computed for all of the rows in the vector. Rows with NAs 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 VEC1, with entries in ascending value order. The table will display counts, percentages, and cumulative frequencies.

tabulates VEC1 including NAs. The observations will be binned if VEC1 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 VEC1 with the table rows ordered from values with highest frequency to lowest.

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

This function only applies to vectors, rowvectors and coef objects. The contents of the vector will be replaced with the first N elements of the workfile C coefficient vector, where N is the length of the vector object. This may be useful for storing starting values used in estimation.

Creates a vector object with 5 rows, and then copies the first 5 elements of the C vector into it.

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

Displays the histogram and descriptive statistics of VEC1.

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 Vector::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 VEC_NAME vector object.

reads the data contained in the “GDP data” sheet of “Data.XLS” into the VEC_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 VEC1 vector object the data located in the HTML file “Data.HTML” located on the C:\ drive

loads into a vector object called VEC1 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 VEC2, skipping the first 5 rows.

loads the comma delimited data DATE.TXT into the VEC01 vector object.

See Vector::export.

Display or change the label view of the vector, including the last modified date and display name (if any).

Used as a procedure, label changes the fields in the vector label.

The first version of the command displays the label view of the vector. 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 LWAGE with “Data from CPS 1988 March File”:

To append additional remarks to LWAGE, 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 Vector::displayname.

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

(This is a deprecated method of importing into a vector. See Vector::import for the 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 vector V1 from an ASCII file MYDAT.RAW in the A: drive. The missing value NA is coded as a “.” (dot or period).

reads the Excel file CPS91 into vector V1 from the network drive specified in the path.

See “Importing Data” for a discussion and examples of importing data from external files.

See also Vector::export.

You should follow the resample keyword and options and an output_spec containing a list of names or a wildcard expression identifying the series to hold the output. If a list is used to identify the targets, the number of target series must match the number of names implied by the keyword.

creates a new vector VEC1 by drawing with replacement from the rows of VEC1 in the current workfile sample. If VEC1_B already exists in the workfile and is a vector object, it will be overwritten. If VEC1_B exists and is not a vector, EViews will error.

The rows in the source vector will be drawn from with probabilities proportional to the corresponding values in the WT vector. WT must have the same number of rows as VEC1 and must have non-missing, non-negative values.

See “Resample” for a discussion of the resampling procedure. For additional discussion of wildcards, see Appendix A. “Wildcards”.

See also @resample and @permute for sampling from matrices.

resizes the vector VEC1 to 20 rows, retaining the contents of any existing elements and initializing new elements to 0.

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 the column label. Note that the column label should not contain spaces unless it is enclosed in quotes.

sets the column label to “MyResults”.

See also Vector::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 vectors, setformat operates on all of the cells in the vector.

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 vector to fixed 5-digit precision, simply provide the format specification:

Other format specifications include:

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

This function only applies to vectors, rowvectors and coef objects. The contents of the vector will be copied into the first N elements of the workfile C coefficient vector, where N is the length of the vector object. This may be useful for re-specifying starting values for estimation.

Copies the contents of VEC1 into the workfile C vector.

See also Coef::coef

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.

sets the indentation for the vector spreadsheet view to 2.

See Vector::setwidth and Vector::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 vector VEC1.

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

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

sets the row label for the first row in vector VEC1 to USA, the second to UK, and the third to FRANCE.

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 the vector to 12 width units.

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

displays and prints the spreadsheet view of vector V1.

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 V1 spreadsheet. If custom labels have not been set the default labels will be displayed.

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

See Vector::setcollabels and Vector::setrowlabels.

The statby view displays descriptive statistics for the elements of a vector classified into categories by a vector or columns of a matrix.

You should follow the vector name with a period, the statby keyword, and a name (or a list of names) for the vector or matrix containing row values by which to classify.

The options control which statistics to display and in what form. By default, statby displays the means, standard deviations, and counts.

displays the mean, standard deviation, maximum, and minimum of the vector VEC1 by (possibly binned) values of the matching length vector VEC2.

See “By-Group Statistics” for a list of functions to compute by-group statistics. See also “Stats by Classification” for discussion.

See also Series::statby and boxplot.

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

displays the descriptive statistics view of the elements of the vector VEC1.

See “Descriptive Statistics & Tests” for a discussion of the descriptive statistics views of series.

See also boxplot and Vector::hist.

Test equality of the mean, median, or variance of the data in a vector across categories defined by the row values of a vector or matrix.

Follow the testby keyword by a list of the names of the vector or matrix whose rows contain the classifier values.

By default, testby will test for equality of means, but you may specify instead tests of medians or variances as an option, choose whether to use balanced or unbalanced samples, and control binning.

tests equality of means of VEC1 across groups classified by values of the matching length vector VEC2, with binning of the average cell count is less than 10.

tests equality of medians of VEC1 across groups classified by VEC2, with no automatic binning on the basis of the number of unique VEC2 values.

See “Equality Tests by Classification” for a discussion of equality tests.

See also Series::testby.

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 VEC1 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 VEC1 is equal to 4.

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

See also Series::teststat.

The vector command declares and optionally initializes a (column) vector object.

The keyword vector should be followed by the name you wish to give the vector. You may also provide an optional argument specifying the size of the vector. If you do not provide a size, EViews will create a single element vector. Once declared, vectors may be resized by repeating the command with a new size.

You may combine vector declaration and assignment. If there is no assignment statement, the vector will initially be filled with zeros.

VEC1 is declared as a single element vector initialized to 0. COL3 is a 10 element column vector containing the value 3. ROW3 is declared as a row vector of size 10 containing the value 3. Although declared as a column vector, VEC3 is reassigned as a row vector of size 10 with all elements equal to 3.

See “Matrix Language” for a discussion of matrices and vectors in EViews.

See also Coef::coef and Rowvector::rowvector.

Creates a foreign format disk file containing data in a vector object. 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 Vector::export.

Follow the name of the vector 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 vector 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 vector V1 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 V1 in an Excel file “Results.xls” in the specified directory.

See “Exporting to a Spreadsheet or Text File” for a discussion. See also Vector::export and Vector::read.