FORMAT=CSV

Short for "Comma Separated Values", this is a text file with fields delimited with commas. (Any field which has text with an embedded comma needs to be enclosed in quotes—either single or double.) It’s a Labeled Table or Unlabeled format (depending upon the file) for both input and output of series, reports and matrices. For reading series, we recommend that you use the more general FORMAT=PRN instead. CDF is an older synonym for CSV.

RATS Instructions

data(format=csv)	read series from a CSV file into memory
store(convert=csv)	copy series from a CSV file to RATS format
copy(format=csv)	write series to CSV file
prtdata(format=csv)	write series from RATS format file to a CSV file
read(format=csv)	read scalars or arrays from a CSV file into memory
write(format=csv)	write scalars or arrays from memory to a CSV file

ORG options are required on DATA, STORE, COPY and PRTDATA.

Interface Operations

Data Wizard

You can read series using Data/Graphics—Data (Other Formats).

Series Window and RATS Data File Window

You can import series using File—Import... or the toolbar button. You can export series using File—Export..., the toolbar button, or the Export operation on the contextual menu.

Report Windows

You can write reports using File—Save As, File—Export, Edit—Copy; the and toolbar items, and the Export and Copy contextual menu operations.

Matrix Windows

You can write the contents of a matrix window to a file using File—Save As, File—Export; the and toolbars, and the Export contextual menu.

Details

On DATA and STORE, you can, if required, use the NOLABELS option to skip automatic label processing and use the LEFT and TOP options to isolate the data.