@Desi2003 wrote: Thank you for your input, but I did not use an INPUT statement. I also made sure both sets are character variable with 49 length.  That is not consistent with your earlier post of Posted 8 hours ago (188 views)  |   In reply to Desi2003 A follow-up: I have just realized that TRACT_NAME in Geo_Reference_Table is 49 in length and PhysicalActivity is 48 in length (they are both character variables). Could this be the problem? How do I address this? which explicitly says they are different lengths, or your example of the text getting truncated.   ... View more

Thanks, this worked perfectly. The last piece I am struggling with is the SexCd. How do I make the values uniform? ... View more