LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (January 2008)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Thu, 17 Jan 2008 08:49:44 -0600
Reply-To:     Melissa Ives <mives@chestnut.org>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Melissa Ives <mives@chestnut.org>
Subject:      Re: CASESTOVARS when a variable is currently missing
Comments: To: Dennis Deck <DDeck@rmccorp.com>
Content-Type: text/plain; charset="us-ascii"

Dennis,

Look into the /AUTOFIX=No and /FIXED subcommands in CASETOVARS. It allows you to specify which items are fixed (so would only need one response) or not fixed (and would need to have all values calculated).

The AUTOFIX subcommand evaluates candidate variables and classifies them as either fixed or as the source of a variable group.

An original variable that does not vary within the row group is classified as a fixed variable and is copied into a single variable in the new data file.

An original variable that does vary within the row group is classified as the source of a variable group. It becomes a variable group in the new data file.

The FIXED subcommand names the variables that should be copied from the original data to the new data file.

CASESTOVARS assumes that variables named on the FIXED subcommand do not vary within row groups in the original data. If they vary, a warning message is generated and the command is executed.

Fixed variables appear as a single column in the new data file. Their values are simply copied to the new file.

Melissa

-----Original Message----- From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of Dennis Deck Sent: Wednesday, January 16, 2008 9:11 PM To: SPSSX-L@LISTSERV.UGA.EDU Subject: [SPSSX-L] CASESTOVARS when a variable is currently missing

Context: Responses to an online survey are captured in a database. The original database table stores a record for each response to each item on the survey. In SPSS I roll up the item responses for a particular time point into a single record using CASESTOVARS. There are periodicl updates so over time we willl have multiple records for each individual.

Problem: There are a few items to which no respondent has yet responded to so CASESTOVARS fails to create these in the data set. For now i must add them by brute force (I use a series of commands like "COMPUTE VarX = $sysmis.") but would prefer a more elegant solution because I will have no warning when someone eventually completes these items. This COMPUTE will over write the actual responses.

Can anyone offer a solution? I thought about adding a dummy set of records with all the items defined when i read the file and then remove the resulting dummy record after the CASESTOVARS but this would be awkward.

Dennis Deck, PhD RMC Research Corporation 111 SW Columbia Street, Suite 1200 Portland, Oregon 97201-5843 voice: 503-223-8248 x715 voice: 800-788-1887 x715 fax: 503-223-8248 ddeck@rmccorp.com

======= To manage your subscription to SPSSX-L, send a message to LISTSERV@LISTSERV.UGA.EDU (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

PRIVILEGED AND CONFIDENTIAL INFORMATION This transmittal and any attachments may contain PRIVILEGED AND CONFIDENTIAL information and is intended only for the use of the addressee. If you are not the designated recipient, or an employee or agent authorized to deliver such transmittals to the designated recipient, you are hereby notified that any dissemination, copying or publication of this transmittal is strictly prohibited. If you have received this transmittal in error, please notify us immediately by replying to the sender and delete this copy from your system. You may also call us at (309) 827-6026 for assistance.

===================== To manage your subscription to SPSSX-L, send a message to LISTSERV@LISTSERV.UGA.EDU (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD


Back to: Top of message | Previous page | Main SPSSX-L page