Frequently Asked Questions

This topic provides answers to some frequently asked questions about working with IBM® SPSS® Data Collection Survey Reporter.

Q. How can I search for specific text in a variable or category?

A. Press Ctrl+F to open the Find dialog box, and enter the text you want to search for. See the topic Finding Tables or Variables for more information.

Q. Can I sort variables?

A. Yes. You can sort variables in the list view of the Variables pane. To display the list view, choose

from the menu or press Alt+2.

See the topic Sorting Variables for more information.

Q. My results show a lot of empty rows and columns. How do I display tables without these?

A. By default, all rows and columns are displayed. To hide empty rows and columns:

Press F4 to open the Table Properties dialog box.

Choose the Hide tab.

Select the Hide rows and Hide columns check boxes. By default, this hides rows or columns where the value is zero.

Choose OK.

See the topic Hiding a Row or Column for more information.

Q. Can I copy and paste a chart directly into another application without needing to export it?

A. Yes. Right-click on the chart and choose Copy from the context menu. This copies the chart to the Windows clipboard and you can then paste it into another application.

Q. When I change a variable, the changes apply to all tables where that variable is used. How do I change a variable on just one table?

A. When you select a variable in the Variables pane and use the Edit Variable menu option, the changes apply to the variable wherever it is used. If you want the changes to apply to a single table, first add the variable to the table, then select the variable on the table in the Design pane and use the Edit Table Variable option on the Variables menu to edit it. See the topic Editing variables for more information.

Q. I want to create a table using a variable that contains verbatims, but I get an error message when I try to do this. Is it possible to tabulate this type of variable?

A. You can tabulate text variables, and any other variables for which you want to see individual responses rather than aggregated data, using a profile table. To create a new profile table, choose

from the menu, or press Ctrl+R. See the topic Creating a Profile Table for more information.

Q. Can I copy from one table to another?

A. Yes. You can either copy the table syntax or you can copy the entire table. Copying an entire table copies all the information for the table, including any table properties or filters that you have set up. See the topic Copying a table for more information. Copying the table syntax copies just the structure (the variables on the top and side of the table). See the topic Copying table syntax for more information.