FORMAT=WKS

This is the native format used by the Lotus 1-2-3 spreadsheet and successor programs. While it’s no longer the main format used by any current software, there are many legacy datasets which used it. It’s a Labeled Table or Unlabeled format (depending upon the file) for both input and output of series, reports and matrices, available in all versions of RATS.

RATS Instructions

data(format=wks)	read series from WKS into memory
store(convert=wks)	copy series from WKS to RATS format
copy(format=wks)	write series to WKS file
prtdata(format=wks)	write series from RATS format file to WKS
read(format=wks)	read scalars or arrays from WKS into memory
write(format=wks)	write scalars or arrays from memory to WKS file
report(format=wks)	(with ACTION=FORMAT) write a report to WKS file

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.

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