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

Technote (FAQ)


Question

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.

Answer

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

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

SPSS Data Collection

Software version:

Not Applicable

Operating system(s):

Windows

Reference #:

1628781

Modified date:

2013-03-18

Translate my page

Machine Translation

Content navigation