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 (November 2004)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Mon, 29 Nov 2004 16:06:26 -0500
Reply-To:     "Zdaniuk, Bozena" <BZdaniuk@ucsur.pitt.edu>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         "Zdaniuk, Bozena" <BZdaniuk@ucsur.pitt.edu>
Subject:      avoid opening separate sessions?
Content-Type: text/plain; charset="us-ascii"

Hello, I am using version 12 of Spss. In previous versions, once I had a data file open, then I can click on (and open) as many syntax files as I wanted and they all opened within the same spss session. Now, if I just click on a syntax file instead of opening it from the main data file window, the new spss session opens. It drives me crazy. Is there a way to go back to the old way, where, in order to open a new spss session, one had to deliberately open it through the main icon? Thanks a lot. Bozena

Bozena Zdaniuk, Ph.D. University of Pittsburgh UCSUR, 6th Fl. 121 University Place Pittsburgh, PA 15260 Ph.: 412-624-5736 Fax: 412-624-4810 email: bozena@pitt.edu

-----Original Message----- From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of Hector Maletta Sent: Monday, November 29, 2004 2:09 PM To: SPSSX-L@LISTSERV.UGA.EDU Subject: Re: selecting cases with missing values

Wendy's advice is right except in that the syntax she offers would retain all missing cases and will exclude all the rest, when the original intent was the opposite ("I would like to select all the cases with these missing values for all the variables I'm interested in, and remove them from the dataset for further analysis"). To eliminate cases with missing values and retain the rest, the keyword NOT should be used before MISSING, e.g. SELECT IF (NOT(MISSING(var1))).

However, as Wendy rightly notes, this is rather drastic medicine, as those cases would be eliminated from the dataset altogether. At least, the resulting file with fewer cases should be saved under another name, and thus all cases be preserved in the original file. Also, one has to consider that those cases, with a missing value in some variables, may still contain valuable information in other variables, and could therefore be useful for further analysis.

Hector

> -----Original Message----- > From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] > On Behalf Of Johnson, Wendy RDECOM (PKI) > Sent: Monday, November 29, 2004 9:48 PM > To: SPSSX-L@LISTSERV.UGA.EDU > Subject: Re: selecting cases with missing values > > > Hi, Umesh. > > "Missing" used with a "Compute" or "Select if" > command identifies variables which are either system or user > missing. Please note that "select if" will delete the cases > in your data editor. You should save it under a different name. > > Get /file 'originalfile.sav'. > > Select if (missing(var1)). > > Save /outfile 'newfile.sav'. > > Get /file 'newfile.sav'. > > Or, if there are a number of variables you're interested in: > > Get /file 'originalfile.sav'. > * Create a marker variable and set it to zero. > Compute keep = 0. > > * Counts the number of missing variables. > Compute keep = Nmiss(var1, var2, var3). > > * Select those cases with missing variables. > Select if (keep gt 0). > > Save /outfile 'newfile.sav'. > Get /file 'newfile.sav'. > > Hope this helps, > > ~Wendy. > > > > -----Original Message----- > From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU]On > Behalf Of Umesh Persad > Sent: Monday, November 29, 2004 11:00 AM > To: SPSSX-L@LISTSERV.UGA.EDU > Subject: selecting cases with missing values > > > Dear List Members, > I have a basic SPSS question that deals with selecting > cases. I have a data set with variables that I am interested > in using containing missing values. I would like to select > all the cases with these missing values for all the variables > I'm interested in and remove them from the dataset for > further analysis. How do I easiily do this in SPSS? > > I've been using Excel before and I just selected the row when > the variable cell was blank. I've tried to use select cases > in SPSS, but I can't figure out what criteria to use for > selecting a missing value. > > Best Regards, > Umesh >


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