Hello, I have a huge dataset (>3 million records) with approximately 600,000 individuals (many have more than one visit). First, I would like to be able to generate code to fill in gender and race/ethnicity from one record of an individual to their other records if some records are missing this information. For example, say I have the following records: ID     Gender     Race/Ethnicity 1          1              3 1          .               3 1          1               . 2          .               1 2          0              1 2          0               . I would like the missing cells to be replaced with information from the other records that are available for that same person. Then, I would like to randomly select one visit that contains complete information (age, gender, race/ethnicity) for each person if they have more than one visit; however if complete information is unavailable, I would still like to select at least one record for each person. I hope this makes sense. Thank you in advance for your thoughts and help on this issue. Kindly, ARR ... View more

I am trying to figure out how to run a censored normal regression in SAS. I have cross-sectional data that I am analyzing to examine the association of an independent variable with systolic blood pressure (SBP). The observed SBP in treated individuals (HTNMed=1) is right censored, therefore I have been told to use censored normal regression. I have found how to do this in STATA (cnreg), but I can't seem to figure it out in SAS.  Does anyone know how to do this? Thank you! Amanda ... View more

Hi All, I am trying to link records in my data by whether a few conditions apply. I want to create a new variable to determine contact with an infected classmate. I have my data so that for every day a student is in a particular school there is a separate record. I want to create a new variable "contact" that indicates whether a student was at the same school on the same day as any of the infected students (does not matter if it was one infected student or 10). I also need a way to prevent it saying it was in contact with an infected student if the infected student was himself (I hope that makes sense). Please help! Thank you in advance. ... View more