User guide
Introduction
CL contents
Recent Enhancements
Limits
Introduction
EULA
CL window and menu
QPSMR Companion
QPSMR Export
Companion Reflect
File name changes
Set-up overview
Character set
Set-up lines
Commands
Stages
Control Stage
Data stage
Tables stage
Manip Stage
Print stage
Split set-ups
Steps
Compile Step
Execute Step
Print Step
Export Step
Step combinations
Running a set-up
Script
First set-up
Control stage (in first set-up)
Data stage (in first set-up)
Tables stage (in first set-up)
Data
Data input and output
Data overview
CSV data (portable)
Character data
Data locations (character data)
Codes (character data)
Character data input
Character data output
Column binary data
Card types (buffers)
Data locations (columns)
Codes (binary data)
Single card records with no card number
Multiple card records
Unusual card identifiers
Multiple record cards
Hierarchical records (trailers)
Card buffer allocation (binary data)
Column binary data output
Input data streams (A,B,C,D)
Editing data
IDF data
Interactive data processing
Variables
Variables
Variable types
Variable names
Variable lengths
Variable texts
Variable redefinition
$col
$field
$spreadfield
$colbin
$svar
$mvar
$ivar
$wvar
$cvar
Substrings (parts of cvars)
Reserved variable names
Constants
Constants
code
mask
bit
iconstant
wconstant
literal
Tables
Tables index
Table names
Table IDs
Table types
Table size
Table texts
Table redefinition
Stub
Banner
part-id
Cell
Weighting
Weighting
Score values
Respondent weighting
Quantity weighting
Grossing up or down using known factors
Target weighting
Rim weighting
Pre weighting
Logic
Logical expressions
Simple tests
Simple test on col
Simple test on field
Simple test on spreadfield
Simple test on svar
Simple test on mvar
Simple test on ivar
Simple test on wvar
Simple test on cvar
Simple test on cell
Negative simple tests
CT function
Relational tests
Logical operator
Arithmetic
Arithmetic expressions
Arithmetic expressions (variables)
Table arithmetic
Text
Text
Special characters in text
Text delimiters
Underlining text
Label controls in text
Text for Report
Labels (text for tables)
Label definition
Global label definitions
Labels with the same text
Label concatenation
Labels for title
Labels for stub
Labels for banner
Labels for filters
Labels for special
Text in tables for printing
Go to
Program control (jumps/skips)
Branching
Destinations
Interactive branching
Exports
Export overview
Creating files for use with Companion Reflect
Exporting data
DTV generation and use
DTV layout
Exporting tables
Errors
Errors
Print styles
Define a print style
Print style printer
Print style margins
Print style font
Print style line spacing
Print style extra fonts
Print style line underline
Print style logo
Page layout - technical
Reference
RCPs
Run control parameters list
Run Control Parameter overview
ADDTAB
ADDWRT
B (background)
BIG
BINARYDATA
BRA
BRP
C (cards)
CARDCOLS
CC
CEPX
CHARSET
CSV2 [GILMR]
CSV2 first column
CSVDATA
EXPORT
FIRSTPAGE
FIXED READ
*header
H (here)
IC (ignore card)
IDF
INFO
INTED
INTERACTIVE
INTPRT
INX
ITF
MARKERSEP
MAT
MAXIDF
MAXPPOUT
MAXREC
MINSHOW
NOADDINI
NODIS
NOLOOP
NOLST
NOLSUM
NOPPINCSV
NOPPINDB
NOPRINTITF
NORPT
NOTAB
NOWRITE
O (output)
OLDNAMES
OLDWQ
PP
PPONLY
P (punch)
RPTLPP
RPTSPL
SHORTCHARTEST
STRIPRPT
TERSE
TIDY
UNDEFINED
UNICODE(16)
UNITEXT
XNOTTEMP
XREF
XTABML
Y (yes, overwrite files)
Pre-processor
The Pre-processor
Tips for PP
Syntax
Indices
Naming conventions
Arithmetic expressions
Substitutions
[+index]
ODBC cell references
Data set references
Compiler object references
Subroutines
Nested PP code
*ASK
*BLOCK
*DATA
*DBCLOSE
*DBCOLUMN
*DBEND
*DBFINDROW
*DBLINES
*DBLOOP
*DBOPEN
*DO
*DSEP
*END
*FOR
*HOLD
*INSERT
*LAST
*LINES
*PPINCSV
*PPINDB
*PPINFO
*POP
*PUSH
*SET
*SKIP
*label
Error handling in PP
Commands
Commands
Command List
! (comment)
@ (position)
% (special)
A (accept)
ARRAY TEMP
BT (base titles)
CARD CHARACTERS BINARY
CARD NUMBERS
CK (check)
CP (checkpoint)
COUNT
D (define)
String definitions
Matrix definitions
Logical definitions
Arithmetic definitions
Data look up definitions
Countlist definitions
Function definitions
Table look up definitions
Cell definitions
Field transfer definitions
Literal definitions
Character definitions
Concatenation definitions
Expansion definitions
Colbin definitions
EL (edit and list)
F (format)
FILTER
FINISH
FL (filter labels)
FT (footnote title)
GLOBAL
GO BACK
GO OUT TO
GO TO
H (horizontal label)
HOLD
HT (horizontal title)
IF
IGNORE
IT (identifier title)
L (list)
M (make)
MT (manip table)
ORD (OR define)
ORDER
PRESERVE TEMPORARY
PRINT
PT (print table)
PUNCH
READ
RECORD LENGTH
REPLY
SELECT
SELECT LEVEL
SERIAL
SHOW
START
STOP
T (tabulate)
T (tabulate) -distribution
T (tabulate) value distribution
T (tabulate) - statistics
TEMPORARY
UL (unless)
UNLOAD
V (vertical label)
VT (vertical title)
WRITE
WRITE BACK example
X (text)
XT (text title)
Z (zero)
Specials
Special texts
Specials in FORMSPEC.STP files
List of specials
AVG
BST
BTP
BTT
CHI
DAT
DOF
EVR
FAZ
FNZ
FSL
FTP
FUV
HTP
HTT
ILH
ILL
ITP
ITT
JF
JFT
JH
JHT
KST
MED
MSE
MWW
PAG
PRC
PRO
PTC
PTR
PUC
RTH
RTI
RTT
RTV
SDV
SER
SSQ
SUM
TCI
TID
TTF
TTT
UNC
UND
UNR
VTP
VTT
Label controls
Label controls < >
<n> (spaces)
<(text)n>
<A>
<B>
<C>
<Dn>
<E>
<F=>
<Gnx>
<Hwconstant>
<In>
<JR>
<JL>
<JC>
<J+>
<K=>
<Lwconstant>
<MLn>
<MLWn>
<MRn>
<MRWn>
<On>
<P>
<Q>
<R>
<S>
<T=>
<U>
<Vwconstant> (score value for averages)
<X>
<Y>
<Z>
<&CONTINUATION>
<&DD>
<&HH>
<&Lx>
<&MM>
<&MONTH>
<&NN>
<&PAG>
<&SHEET>
<&SS>
<&TABLEIDENTIFICATION>
<&TID>
<&TPHID>
<&TPID>
<&TOTALCELL>
<&YEAR>
<&YY>
Functions
Functions
%ATAN
%CAL
%CLEN
%COS
CT
EXP
%EXP
%EXP10
%FRP
%INDEX
%JUL
%LOG
%LOG10
%MAX
%MIN
%RAND
%RIM
%RNK
%ROUND
%SIGD
%SIGE
%SIGI
%SIN
%SQRT
%STA
%STR
%TAVG
%TEX
%TMAX
%TMED
%TMIN
%TMODE
%TNEG
%TRUN
%TSTA
%TSUM
%TVAL
%WMAX
%WMIN
Formats
Format introduction
FORMSPEC.STP
Settings on individual tables
Format settings within text
Formats by category
Format list - widths and indents
Format list - line spacing
Format list - figures
Format list - statistics
Format list - total rows and columns
Format list - minimum value suppress
Format list - compile options
Format list - execution controls
Format list - miscellaneous
Format ABF
Format ADF
Format AID
Format ANC
Format ANF
Format ANR
Format ANV
Format ATF
Format ATN
Format AVG
Format BAL
Format BCS
Format BRS
Format BST
Format BTR
Format BTS
Format BTV
Format CAP
Format CAZ
Format CDH
Format CDI
Format CDL
Format CDO
Format CDS
Format CHG
Format CHI
Format CIT
Format CKT
Format CLG
Format CLW
Format CNF
Format CNT
Format CNZ
Format CON
Format CPC
Format CRH
Format CRV
Format CTU
Format CUM
Format CUV
Format CZP
Format DAT
Format DBL
Format DIS
Format DPA
Format DPL
Format DPR
Format DPS
Format DPT
Format DPW
Format EMS
Format EMU
Format ESR
Format ESS
Format EVR
Format FAZ
Format FNZ
Format FSL
Format FTC
Format FTL
Format FUV
Format HAL
Format HLS
Format HTN
Format IAJ
Format IAT
Format IBF
Format IBH
Format IBJ
Format IBM
Format IBR
Format IBT
Format ICC
Format ICT
Format IFB
Format IFF
Format ILE
Format ILH
Format ILL
Format IMB
Format IRO
Format ITB
Format ITC
Format ITR
Format KST
Format LAB
Format LAH
Format LBB
Format LBF
Format LBH
Format LBJ
Format LBR
Format LBS
Format LBT
Format LMA
Format LMB
Format LPP
Format LST
Format MCB
Format MCF
Format MCM
Format MCS
Format MCT
Format MDR
Format MED
Format MMC
Format MOD
Format MPS
Format MRC
Format MSE
Format MWW
Format OBJ
Format OFD
Format OFO
Format OFU
Format ONO
Format PBL
Format PBT
Format PCB
Format PCS
Format PCT
Format PCZ
Format PEC
Format PGN
Format PHG
Format PHT
Format PLM
Format PNL
Format PNN
Format PNS
Format POP
Format PRC
Format PRO
Format PSD
Format PSP
Format PSV
Format PTB
Format PTC
Format PTP
Format PTR
Format PUC
Format PVT
Format RBA
Format RBL
Format RHW
Format RLW
Format RMN
Format RMX
Format RNA
Format RNB
Format RNC
Format RNI
Format RNK
Format RNS
Format RTH
Format RTI
Format RTT
Format RTV
Format RWU
Format SDV
Format SER
Format SFR
Format SFX
Format SHG
Format SIG
Format SLA
Format SLB
Format SLC
Format SLD
Format SMA
Format SMB
Format SMS
Format SPL
Format SPN
Format SSQ
Format STN
Format SUM
Format TID
Format TLT
Format TOC
Format TPC
Format TRU
Format TTB
Format TTF
Format TTR
Format TTT
Format TTV
Format UAU
Format UCB
Format UCH
Format UCL
Format UCR
Format UCS
Format UNC
Format UNE
Format UNO
Format UNR
Format UPC
Format URH
Format URS
Format UZA
Format VNL
Format VWL
Format WBJ
Format WBZ
Format WFS
Format WOF
Format WRT
Format WRV
Format WSH
Format WST
Format WVT
Format ZBD
Raw data
Data convert raw data
Data files for use with QPSMR
Data file type descriptions
Syntax
Syntax summary
Syntax summary 1
Syntax summary 2
Syntax summary 3