If you want Quanvert to export a grid axis to SAS or SPSS on a row-by-row basis rather than a column-by-column basis, place the keyword:

on the l statement for that axis. This keyword has no effect on the Quantum tables.

When a Quanvert user exports a grid axis in SAS or SPSS format, Quanvert exports it on a column-by-column basis so that each cell of each column becomes a separate SAS or SPSS variable. For example, if the grid axis is defined in Quantum as:

Quanvert creates one SAS or SPSS variable per brand. However, if the grid is specified as:

each variable would contain data from more than one column of the data (it would be multicoded) so Quanvert creates one variable for each cell of the column instead. In this example, the SAS or SPSS data contains one variable for each combination of brand and rating, for example, Brand A Excellent, Brand A Very good, and so on.

With this example, it is not a problem to write the grid in the first format so that the SAS or SPSS data contains one variable per brand which is usually what is required. However, not all grids are as simple, so Quantum allows database administrators to flag grid axes that need to be exported in Quanvert on a row-by-row basis rather than in the standard column-by-column way. The keyword that does this is byrows and it is used on the l statement. It has no effect in Quantum.

Using the examples shown here, if you did not want to rewrite the rating2 axis as it was shown in the example called rating1, you could add byrows to the l statement of rating2 to achieve the same set of SAS or SPSS variables in Quanvert: