Help using Base SAS procedures

A quick question: Does the foramt of the numerical key variables matter in sql merge?

Accepted Solution Solved
Reply
Contributor
Posts: 36
Accepted Solution

A quick question: Does the foramt of the numerical key variables matter in sql merge?


I am trying to merge two data base based on two key variables, both are numerical variables. I used sql to merge the two database and got zero observation. I don't know if it is because  they  have differnt format ( digits).  One shows F6., two show  Best12., and the last show nothing when I view the column format.

Any suggestion?

Thanks in advance.


Accepted Solutions
Solution
‎02-15-2013 05:34 PM
Contributor
Posts: 36

Re: A quick question: Does the foramt of the numerical key variables matter in sql merge?

Never mind. It still not work after I changed format.

View solution in original post


All Replies
Solution
‎02-15-2013 05:34 PM
Contributor
Posts: 36

Re: A quick question: Does the foramt of the numerical key variables matter in sql merge?

Never mind. It still not work after I changed format.

Contributor
Posts: 36

Re: A quick question: Does the foramt of the numerical key variables matter in sql merge?

Thanks. I just figured out.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 137 views
  • 0 likes
  • 1 in conversation