What do you want to see as values?
What kinds of SPSS values are ending up as #NULLs?
One approach would be to recode values that are being passed a #NULL
to something else. What to use are arguments in RECODE would depend
on the specifics of your situation.
If you cannot produce the value with with RECODE, you can always
RECODE to an arbitrary specific value and then do a replace in
EXCEL to get what you want?
If the variables are numeric, are those #NULLs coming from values
that are sysmis?
recode varlist (sysmis = -99999999) (else = copy) into newvarlist.
If the variables are strings, are those #NULLs coming from values
that are empty or all blanks?
recode varlist ("" = "blank") (else = copy) into newvarlist.
Art Kendall
Social Research Consultants
On 10/21/2010 3:11 PM, David L. Peck wrote:
Is there a way to do a Save Translate to an
.xls file, but
not have the null values show as #NULL!?
Thanks!
David.
This E-mail, including any attachments, may be intended solely
for the personal and confidential use of the sender and
recipient(s) named above. This message may include advisory,
consultative and/or deliberative material and, as such, would be
privileged and confidential and not a public document. Any
Information in this e-mail identifying a client of the
Department of Human Services or the Department of Children and
Families is confidential. If you have received this e-mail in
error, you must not review, transmit, convert to hard copy,
copy, use or disseminate this e-mail or any attachments to it
and you must delete this message. You are requested to notify
the sender by return e-mail.
=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (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
Art Kendall
Social Research Consultants
Locked
