EXPORT procedure

Saves data structures to Excel, Quattro, dBase, SPlus, Gauss, MatLab, Instat and text files, PC Windows only (D.B. Baird).


Options

OUTFILE = text
Data file to be written

METHOD = string
Action to take if the file already exists (add, overwrite, prompt, fail); default prompt in interactive mode, fail in batch mode

PLAINNAMES = text
Whether to leave the column names in the file in plain form rather than decorating them with the column type information i.e. ! for factors, :D for dates etc (yes, no) default no

SHEETNAME = text
Name of new sheet to be added to an existing Excel file


Parameter

DATA = identifiers
The data structures to be written to the file, these must be compatible (i.e. of the same length)


Description

EXPORT saves the data structures specified by the DATA parameter to a disk file specified by the OUTFILE option in a foreign data format specified by the extension of the file name. The available extensions are: .XLS for Excel, .WQ1 for Quattro, .DBF for dBase, .FMT for Gauss, .SDD for SPlus, .RDA for R, .WOR for Instat, .MAT for MatLab, .ARFF for Weka Attribute, .TXT for plain ASCII text, and .CSV for comma delimited text. The SHEETNAME option allows you to specify the name of the sheet to add to an Excel file, rather than using the default 'GenStat data'. The maximum name length that will be used is 12 characters, and the name should only contain letters, numbers and spaces.

   The METHOD option controls how EXPORT behaves when asked to overwrite an existing file. The available settings are add, overwrite, prompt and fail, with a default of prompt in interactive mode, and fail in batch mode.

   The PLAINNAMES option allows you to suppress the additional type information that GenStat adds by default to the column names (! for factors, :D for dates etc).

   (Note: EXPORT replaces the procedure %DSAVE from earlier editions of GenStat.)

 

Options: OUTFILE, METHOD, PLAINNAMES, SHEETNAME.

Parameter: DATA.


Method

The procedure calls the FSPREADSHEET procedure to create a temporary GSH file, which is translated to the required file type using the DATALOAD.DLL library.


Action with RESTRICT

Any restrictions are ignored. However, if the restrictions on the structures are not consistent, a fault will occur.