The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » SPSS - Merging Household variables with Individual Women's dataset
Re: SPSS - Merging Household variables with Individual Women's dataset [message #2457 is a reply to message #2405] Fri, 20 June 2014 06:42 Go to previous messageGo to previous message
aligazan
Messages: 24
Registered: June 2014
Location: UK
Member
Dear Bridgette,

Thanks so much for your reply. I have done as you suggested but I get the message shown below. Does this mean there is a correction needed to the syntax?

Thanks again so much for your help.

Janet



Variable(s) incorrectly used in 'BY'

------Input1------ ------Input2------
Result Type Variable name Type Variable name

HHID s12 HHID s36 HHID

Codes: num = numeric; sn = string of length n

>Error # 5126
>The BY variable list is invalid. All the variables on the list must exist on
>all the input files, and each variable must be of the same type (numeric, or
>strings of the same length) on all the input files.
>Execution of this command stops.


Variable(s) with conflicting type:

-------Input1------- -------Input2-------
Result Type Variable name Type Variable name

HHID s12 HHID s36 HHID

Codes: num = numeric; sn = string of length n

>Error # 5127
>Mismatched variable types on the input files.

>Note # 5145
>The working file has been restored, and subsequent commands may access the
>working file.
EXECUTE.
SAVE OUTFILE='C:\Users\Janet\Documents\0 MPhil\DHS\Mali datasets\MLIR52sv\MLhR_iR.SAV'
/COMPRESSED.

 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Merge HIV and Couples
Next Topic: mv001, mv002 and mv034_1 do not uniquely identify observations
Goto Forum:
  


Current Time: Fri Apr 19 12:25:37 Coordinated Universal Time 2024