Variables of different types: merging files

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

mabrady
Posts: 9
Joined: Wed Sep 05, 2012 9:58 pm

Variables of different types: merging files

Postby mabrady » Tue Sep 11, 2012 7:11 am

I am matching two files. It appears that the variables are coded as different types on the two different files. The error I get when I attempt to merge them is:


Variable(s) with conflicting type:

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

hhrhid s6 hhrhid s5 hhrhid
hhrpid s8 hhrpid s7 hhrpid

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

Error # 5127
Mismatched variable types on the input files.
Execution of this command stops.

Note # 5145
The working file has been restored, and subsequent commands may access the
working file.

EXECUTE.

How do I deal with mis-matched types?
Penguin_Knight
Posts: 473
Joined: Thu Apr 05, 2012 5:58 pm

Re: Variables of different types: merging files

Postby Penguin_Knight » Tue Sep 11, 2012 12:19 pm

You'd have to work on each file separately to make sure the lengths of the string variables are the same.

Who is online

Users browsing this forum: No registered users and 2 guests

cron