Unable to export only a "specify others" through a DMS script

Technote (FAQ)


Is it possible to export only "specify other" values through a DMS script? The select statement only selects the "specify others" category but nonetheless the base question is always included in the export.


By default when exporting a "specify others", the base question will always be included as the specify other is seen as a slice. It is possible to specify a different name in the SQL and then the export will only contain the "specify others". E.g. instead of using "SELECT Q1._4 from vdata", use "SELECT Q1._4 as Q1_4 from vdata". More information is available in the DDL topic called "Filtering Data in a DMS File".

Document information

More support for:

SPSS Data Collection

Software version:

Not Applicable

Operating system(s):


Reference #:


Modified date:


Translate my page

Content navigation