Home > Data Services > Catalog . Restricted Data . Census . ACS

Search Data Services

Meta Search
search across all the following databases:

Data Catalog
Data and documentation

KnowledgeBase
Common questions and answers.

Resources
Entire collection of data resources.


Latest Data News

RSS Feed icon

Tools: Data as Text

More fun with names

Counting Same-Sex Couples

The Antidote for “Anecdata”: A Little Science Can Separate Data Privacy Facts from Folklore

Big Data: NYC Taxi Cab Trips

Data Services Knowledge Base

Q:  

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.

A:  

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;

Related Question Groups: