Hi! I came from the class Canvas discussion page, I'm in your class so I tried out your dataset with my code as well as your code with your dataset and it worked fine for me. This is what I get from running your code with your dataset.  Maybe try re-running your dataset before you run your code? Also make sure your LIBNAME statements are correct and that it's referring to the right file. ... View more

Hi!   I had a similar issue with the Utah dataset. I realized that some of the SSN from the Utah dataset were missing a leading 0 and were therefore only 8 digits long. I went back to Prog 2 and added this to where we created Contact_UT which fixed it for me. IDLength=Lengthn(IDCHAR); IF IDLength=8 THEN IDCHAR=CAT(0,IDCHAR); It's odd that you are missing all data for Utah though, maybe the Utah SSNs are not matching up to the other SSNs for some reason. If you want to share your code from Prog 2 where you created Contact_UT I can take a look for you.   Also, I'm not sure if you need this whole thing: /* IF InNDI = 0 THEN HypRelDeathInd = 0; */ IF InNDI = . THEN HypRelDeathInd = 0; ELSE IF InNDI = 0 THEN HypRelDeathInd = 0; ELSE IF InNDI = 1 THEN HypRelDeathInd = 1;  If you're trying to get HypRelDeathInd to be 0 where it's missing data, all you would need is: IF HypRelDeathInd = . THEN HypRelDeathInd = 0; ... View more

You can try: IF LAST.userid=1 THEN DO; OUTPUT; ... View more