Transferring saved missing values to another file

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Transferring saved missing values to another file

bgreen
Hello,

Is it possible to copy designated missing values in one SPSS data
file to another. The data contains a number of values which vary per
variable that I wanted to designate as missing. If X.sav is the
original file can I via syntax designate the same values as missing
in X2.sav, assuming common variable names across files?

An alternative, assuming such a method was available, would be to
update X based on values on X2, where there was a difference in X2
compared to X.

Assistance with either option is appreciated.


Bob

=====================
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
Reply | Threaded
Open this post in threaded view
|

Re: Transferring saved missing values to another file

Jon K Peck
Yes.  Take a look at APPLY DICTIONARY (or its menu equivalent).


Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
new phone: 720-342-5621




From:        Bob Green <[hidden email]>
To:        [hidden email],
Date:        02/06/2013 12:26 PM
Subject:        [SPSSX-L] Transferring saved missing values to another file
Sent by:        "SPSSX(r) Discussion" <[hidden email]>




Hello,

Is it possible to copy designated missing values in one SPSS data
file to another. The data contains a number of values which vary per
variable that I wanted to designate as missing. If X.sav is the
original file can I via syntax designate the same values as missing
in X2.sav, assuming common variable names across files?

An alternative, assuming such a method was available, would be to
update X based on values on X2, where there was a difference in X2
compared to X.

Assistance with either option is appreciated.


Bob

=====================
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


Reply | Threaded
Open this post in threaded view
|

Re: Transferring saved missing values to another file

David Marso
Administrator
In reply to this post by bgreen
From the beloved FM:
--
APPLY DICTIONARY can apply variable and file-based dictionary information from an external
IBM® SPSS® Statistics data file or open dataset to the current active dataset. Variable-based
dictionary information in the current active dataset can be applied to other variables in the current
active dataset.
 The applied variable information includes variable and value labels, missing-value flags,
alignments, variable print and write formats, measurement levels, and widths.
 The applied file information includes variable and multiple response sets, documents, file
label, and weight.
 APPLY DICTIONARY can apply information selectively to variables and can apply selective
file-based dictionary information.
 Individual variable attributes can be applied to individual and multiple variables of the same
type (strings of the same character length or numeric).
 APPLY DICTIONARY can add new variables but cannot remove variables, change data, or
change a variable’s name or type.
 Undefined (empty) attributes in the source dataset do not overwrite defined attributes in the
active dataset.
bgreen wrote
Hello,

Is it possible to copy designated missing values in one SPSS data
file to another. The data contains a number of values which vary per
variable that I wanted to designate as missing. If X.sav is the
original file can I via syntax designate the same values as missing
in X2.sav, assuming common variable names across files?

An alternative, assuming such a method was available, would be to
update X based on values on X2, where there was a difference in X2
compared to X.

Assistance with either option is appreciated.


Bob

=====================
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
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"
Reply | Threaded
Open this post in threaded view
|

Re: Transferring saved missing values to another file

Rick Oliver-3
In reply to this post by Jon K Peck
The menu equivalent is: Data>Copy Data Properties

Rick Oliver
Senior Information Developer
IBM Business Analytics (SPSS)
E-mail: [hidden email]




From:        Jon K Peck/Chicago/IBM@IBMUS
To:        [hidden email],
Date:        02/06/2013 01:48 PM
Subject:        Re: Transferring saved missing values to another file
Sent by:        "SPSSX(r) Discussion" <[hidden email]>




Yes.  Take a look at APPLY DICTIONARY (or its menu equivalent).


Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
new phone: 720-342-5621





From:        
Bob Green <[hidden email]>
To:        
[hidden email],
Date:        
02/06/2013 12:26 PM
Subject:        
[SPSSX-L] Transferring saved missing values to another file
Sent by:        
"SPSSX(r) Discussion" <[hidden email]>




Hello,

Is it possible to copy designated missing values in one SPSS data
file to another. The data contains a number of values which vary per
variable that I wanted to designate as missing. If X.sav is the
original file can I via syntax designate the same values as missing
in X2.sav, assuming common variable names across files?

An alternative, assuming such a method was available, would be to
update X based on values on X2, where there was a difference in X2
compared to X.

Assistance with either option is appreciated.


Bob

=====================
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