Show empty categories in tables (second method)

*(Q) My survey allows for 10 possible responses (1 to 10) for a given question 
	but not all responses were selected by person completing the survey. 
*	How can I include the options which have not been selected in my Table
	summarising the answers?.

*(A) Posted by Ray to spss newsgroup on 2002/05/10.


* Preparatory work.
DATA LIST FREE /a.
BEGIN DATA
1 2 3 4 5 6 7 8 9 10.
END DATA.
COMPUTE wgt=.00001.
SAVE OUTFILE='c:\temp\temp.sav'.

* Dummy data for illustration purposes.
DATA LIST LIST /a.
BEGIN DATA
1
2
4
2
4
END DATA.
LIST.

COMPUTE wgt=1.
TABLES
  /FORMAT BLANK MISSING('.')
  /TABLES a
  BY (STATISTICS)
  /STATISTICS
  count( ( F5.0 )).


ADD FILES FILE=* /FILE='c:\temp\temp.sav'.
WEIGHT BY wgt.

* Basic Tables includes all 10 categories.
TABLES
  /FORMAT BLANK MISSING('.')
  /TABLES a
  BY (STATISTICS)
  /STATISTICS
  count( ( F5.0 )).