Hi, UT_RECORDS dataset has 7 observations which have ID with 8 digits. The ID should have typically 9 digits as it is a SSN. Here the first digit of 0 needs to be added to make it work. This is the reason why 36-78-8134 in HypTabs.CONTACT and HypTabs.DEMOG didn't merge with 036-78-8134 in HypTabs.VITALS. You need to add the following when you create your CONTACT_UT and DEMOG_UT datasets which you created before: IDChar = PUT(ID, 9.); SSN = CATX("-", SUBSTR(IDChar, 1, 3), SUBSTR(IDChar, 4, 2), SUBSTR(IDChar, 6, 4)); IF ID < 100000000 THEN SSN = "0" || SSN; This ensures that if the ID has 8 digits, then a 0 is added as a prefix to the SSN. Once you make this change and generate the updated CONTACT and DEMOG datasets, you should get 573 observations. Please let me know if this doesn't work. Thanks, Adhuna Mukhopadhyay
... View more
