SPSSX Discussion

Creating a summary table of item results

Classic

List

1 message

I have some code that generates a nice table of survey item results (percent correct).

I run this monthly for several categories of subjects (schools in this case).

There are a couple steps that still require manual edits I would like to automate.

Here is some sample code:

* Create subscale labels .

COMPUTE sPolicy = 0 .

COMPUTE sMeals = 0 .

VARIABLE LABELS

sPolicy ‘*** Policy ***’

sMeals ‘*** School Meals ***’ .

* Rescale answers so mean yields a percentage

(I01 is scaled as 0 if wrong or 1 if right) .

COMPUTE S01 = I01 * 100 .

COMPUTE S02 = I02 * 100 .

. . .

* Produce the summary table .

SUMMARIZE

Tables= sPolicy S01 S02 S03 S04 S05 S06

sMeals S08 to S11

by Cohort

/Cells= Mean .

This produces a table with:

a) a line to mark the start of each subcale

(sPolicy and sMeals are dummy variables to marking subscales)

b) a line for each item with results expressed as a percentage

(The Sxx variables are coded as 0 if wrong or 100 if right —the mean represents the percent correct )

The problem is that I still have to do a bit of formatting by hand:

a) The table cells default to something like F6.2,

I have to select the cells and change cell format F3.0 manually

b) The dummy variables (eg, sPolicy) produce a row of 0s that I have to delete manually

I welcome any suggestions to eliminate these extra steps! Thanks!