search across all the following databases:
Data and documentation
Common questions and answers.
Entire collection of data resources.
I am trying to merge two files using SAS and I am getting a message that says "variable stcnty has been defined as both character and numeric." The merge did not work.
Take a look at your input format statements. You have read your merging variable (stcnty) in as a character variable in one case, e.g., (stcnty $ 1-5) and as a numeric variable (stcnty 1-5) in the other. Change the format in one case so that they have the same format.
If this is a system file and you cannot see the input format, you can change the character variable to a numeric variable using these commands:
newid = stcnty*1;