As others have mentioned, it has to do with leading zero's in some of your observations ssn's. Go to your Utah demog dataset from the previous project and add this: ID = PUT(NewID,z9.); before you string together your SSN using CatX. OR If that doesn't work the other code to try using Z9 in the SUBSTR as follows: SSN = CATX('-', SUBSTR(PUT(ID,Z9.),1,3), SUBSTR(PUT(ID,Z9.), 4,2), SUBSTR (PUT(ID,Z9.),6,4)); Good Luck.
... View more