One trick advised in this list some time ago was as follows: you create a fictitious case with the appropriate value in the relevant variables. To that case you assign a very small weight (for instance 0.0001); if you are not presently weighting the cases, this is done by creating a weighting variable which equals 1 for all other cases, and 0.0001 for the fictitious case, and using that variable for weight. When you obtain a table, the row or column for the category is created, but the frequency is zero because a very small weight is rounded down to zero. However, this is valid as such only for frequencies in categorical variables, not necessarily for totals and means in interval variables. Suppose one of your variables in your table is an interval variable for which you ask the total or the mean, and that variable has large values, such as annual income. If you give the fictitious case a plausible income (say, $100,000) this income of the fictitious case (whichever it is) would be multiplied by 0.0001 and this may still give a non-zero result (100,000 x 0.0001 = 10). To avoid this, put also a very small income in the fictitious case (fifty cents per year, for instance), so all totals and averages for that case would be rounded down to zero.

Hope this helps.

Hector

> -----Original Message----- > From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] > On Behalf Of Yehuda Dayan > Sent: Friday, June 11, 2004 1:00 PM > To: SPSSX-L@LISTSERV.UGA.EDU > Subject: Forcing categories in frequency table > > > Hi, > > Could anyone advice me if it's possible to 'force' all > categories in a frequencies table? > > Just to clarify- > As far as I am aware of, when the frequency of a certain > category is zero, SPSS ignores that category and does not > display it in the table. > > I think the 'Tables' add-on does keep all categories defined, > but I do not have it installed. > > > Many Thanks, > Yehuda > ### This e-mail and all attachments it may contain is > confidential and > intended solely for the use of the individual to whom it is > addressed. Any views or opinions presented are solely those > of the author and do not necessarily represent those of Ipsos > UK and its associated companies. If you are not the intended > recipient, be advised that you have received this e-mail in > error and that any use, dissemination, printing, forwarding > or copying of this e-mail is strictly prohibited. Please > contact the sender if you have received this e-mail in error. ### >