Date: Fri, 8 Dec 2006 09:48:35 -0600
Reply-To: "Marks, Jim" <Jim.Marks@lodgenet.com>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: "Marks, Jim" <Jim.Marks@lodgenet.com>
Subject: Re: Saving data from SPSS to Excel file.
Content-Type: text/plain; charset="US-ASCII"
Recode your system missing values to a known number:
RECODE v1 v2 v3 (SYSMIS = -999).
MISSING VALUES v1 v2 v3 (-999).
The second command will tell spss to ignore the -999 values in
The number -999 should appear in your data when exported. Excel will
think it is a valid result, so be careful with formulas and calculations
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of
Shauna Marie Wilhelm
Sent: Friday, December 08, 2006 9:40 AM
Subject: Saving data from SPSS to Excel file.
I am trying to save a very large data set into an excel file, but when I
open up the excel file all of the system missing cells have "Null!" Does
anyone have a suggestion as to how I can export the data into excel
without having the cells in excel show Null! I have tried to copy and
paste the data, but the data file is too large to copy all at once and I
am afraid I might forget some cases if I only copy a small section of
data at a time.
Thank you for your assistance in advance.