Recent Enhancements

CL is now a Unicode program provided RCP UNITEXT is used and Unicode scripts (with BOM) are used.  There is no longer any need to set the Locale in the Control Panel.  CL will also now work with UTF-8 set as the Locale.

Reflect files produced since 2018.1 use the extension .qrfx instead of .qrf. Companion Reflect can be used to process both types of files.

Please use Companion Reflect 22.1 or above which replaces the classic QPSMR Reflect.  The main Companion program can also be used to process reflect files (no licence needed).

IMPORTANT: significance markers are now output to the CSV tables preceded by a space - for example now " aB", not "aB" to avoid a problem with Excel.

We recommend the use of the UNITEXT RCP for all projects except those with binary data.

We recommend that all setup files are now stored as UTF-8 with BOM (use Notepad).

Tables can be formatted with a table of contents using QPSMR Companion.

Conversion and formatting of CSV tables to Excel is much faster with QPSMR Companion 22.1.3 version or above.

The "20" is now dropped from the version numbers.

Use Companion 22.2 or above to run setups or convert CSV files to Excel.

Most recent listed first.


If using Companion to convert tables to formatted Excel, use RCP CSV2I... to output Information lines.  These will be used by Companion to control the cell formats used in Excel.


2022.1f. New character format CMS, default CMS'~', sets the character to use for cells hidden under RCP MINSHOW.

2022.1e. Maximum record length for data files is increased to 350000.

2022.1e. Column identifiers for significance marking can now use letters in any language that have upper and lower case equivalents, including those with diacritics see Format SHG.

2022.1d. New label control <&SHEET> to control CSV tables to Excel using QPSMR Companion (no Companion licence needed)

New RCP UNITEXT (recommended) makes CL run as a Unicode program when not using binary data files.

If UNITEXT RCP is used and setup and data files are UTF-8 with BOM or UTF-16 with BOM:

You no longer need to set the Locale in the Control panel.

Character variables and data files can handle any languages.

All output files are now Unicode UTF-8 encoded with BOM, unless UNICODE16 RCP is used.

CSV tables can be formatted in Excel (OpenXML) using QPSMR Companion (no Companion licence needed).

SPSS export now adds SCORE variables containing the score value for variables with <V> (score value for averages).


The output tables CSV file is now Unicode UTF-8 encoded with BOM, see UNICODE.


%RIM now shows weighting efficiency in the log file.


2020.2f. New CSV2 settings.

New setting of +?+ to test a column against all following columns, see format SHG.


2020.1j. New overlap formula settings for formats SIG and TTV

2020.1j. New format MCM to set minimum column base for mean score significance tests

2020.1f. Short SERIAL command for CSVDATA that contains serial numbers

Default for format SHG is now SHG11.

Format setting TTV0 suppresses significance testing on mean scores/averages

Using <b> in rows causes an RT line to be output to the CSV tables file


2019.2g. New RCP CSV2Z option to use zero formats CAZ, CNZ and CZP in the CSV tables output.

New format UAU is now needed to use underscores around text for underlining, see Underlining text.

RCPs NOPPINDB and NOPPINCSV are deprecated, please use preprocessor commands *NOPPINDB and *NOPPINCSV instead.

New preprocessor command *PPINFO for extra information during preprocessing.


2019.1h. New format SIG settings to use t tests instead of Z tests when testing table rows.

2019.1d. Default formats changed to SMA'+'/SMB'+'/ESS, see formats SMA, SMB, and ESS.

CL can now read STP scripts and CSV data as UTF8 files and Unicode files with the appropriate BOM.

QPSMR portable CSV data files can now be processed with CL, see RCP CSVDATA.

Individual data files such as the CATI Partial file can be marked as fixed length, see RCP C (cards).


2018.2h. Format PUC now honoured in CSV tables, output as a UC row.

QPSMR CL is now a 64 bit program.


2018.1u. New format ANV excludes records with undefined value used as rows of VDT tables.

Existing STP files can be run using the QPSMR Companion with an appropriate licence.

Tables CSV files can be converted to Excel/OpenXML files using the QPSMR Companion.

Reflect databases now create .qrfx files.

You can now test against the total and other columns at the same time using formats SHG11-13, for example SHG11/SMA'+'/SMB'+'.

Text embedded within string definitions can now use colon (:) or semicolon(;) as the separator.

Serial numbers can now be up to 15 digits.

New DJ $ivar =  to define an integer variable that can hold up to 15 digits, see $ivar and iconstant.

CSV tables output now has option CSVG to put format FSL sig level information only in the job header..


CSV output now shows additional SHG column markers (+...+) with RCP CSV2L.


The main STP file can now be Unicode (not UTF8) text.


New *ASK(M) PP command for multi-select from a list..


Only minor enhancements at this version.


Format UPC now works in CSV tables.


New RCP SHORTCHARTEST means character constants do not need trailing blanks.


Only minor enhancements at this version.


Format PNS is now used in CSV tables output.


2013.2j. Base rows <B> now show figures in CSV output with NPRC.

2013.2c. The maximum length of a data record is now 250,000 columns.


2013.1c. Maximum items in svars and mvars increased to 30,000.

2013.1c. Maximum table rows increased to 30,000.


2012.2m. The maximum length of a data record is now 200,000 columns

If a cvar is used as rows of a table without specifying (max) after, a default of (1000) will be used, see T (tabulate) value distribution section.

Extended format option ILE can now be set up to 100.  ILE100 gives percentiles.

Max PP data set items increased to 2,000,000 (from 250,000).


2012.1b. New RCP option CSV2 L to make a separate "CM" row for column identifiers for statistics in CSV tables.

2012.1b. Format HAL is now honoured in CSV tables and creates an extra column for each table column so that the percentages are alongside the raw counts.

2012.1b. Cell text set with %TEX is now honoured in CSV tables.

2012.1b. New format DPW (Decimal Places for Weight variables) used for the weight values when a VDT table has a weight variable as the rows.


2011.2d. Format FSL (footnote for significance levels) now output to CSV tables.

CARD CHARACTERS and data records can now use up to 250000 columns.


Significance testing using marker letters can now test against additional columns, see format SHG.


Only minor enhancements at this version.


Only minor enhancements at this version.


2009.2f.  CSV tables now honour formats TTB and CHI.

2009.2e. Triple-s 2.0 export puts out score values.

2009.2e.  Format SMS99 causes all markers to be put on next line.

Cvars can now be up to 2000 characters wide.


Program has been restructured to reduce startup and run times:

The file windows.dtl is no longer used; the settings are built in to the program.

There are fewer DLL files.


No user changes.


Limit on IDF record size increased from 32767 to 200000.

Default temporary variable size set to 10000.

New format POP to alter statistics formulae for entire population.

CARD NUMBERS can now use up to 999 card types.

CARD CHARACTERS and data records can now use up to 100000 columns.


Mvars can now have up to 9999 true responses (was 999 in earlier releases).

The relational test field.relop.constant will treat field as a wvar if it is more that 9 columns wide.

Exported blank mvars are now left empty (not all zeroes).

SPSS export of mvars (not spreadfield) have labels changed.


New formats for effective sample sizes and effective bases in statistics for respondent weighted tables:

New format ESS to use the effective bases instead of unweighted bases in statistics and significance marking.

New format ESR to print the effective sample sizes as a total row.

New format PEC to print the effective sample size for every cell.

IMPORTANT: When using statistics or significance marking on respondent weighted data you should set format ESS.

Significance markers using column letters now overflow onto a second line if there are too many to fit within the column.


A CSV data listing can have a header row and can be tab-delimited, see L (list) command.

The run start date, time and set-up file name are available in the pre-processor, see [*SET...].

Tables can be output as an XtabML file, see RCP XTABML.