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
proceedures.

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
in excel.

HTH

--jim



-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of
Shauna Marie Wilhelm
Sent: Friday, December 08, 2006 9:40 AM
To: SPSSX-L@LISTSERV.UGA.EDU
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.