Hello,  I am working with a data set called PRAMS and it uses a complex sampling design. It has several racial categories and years. I would like to include one year of data and two racial categories (non-Hispanic). However, from reading it says I cannot delete cases because it will mess up the weighting. How can I exclude cases for the purposes of my analysis? Also, how can I identify non hispanic black and non hispanic white if there are two separate variables. I have a MAT_RACE variable with categories 1, 2,3 (white black other that include non hispanic and hispanic ethnicity) I also have Hispanic BC that includes 1 yes hispanic and 2 not hispanic. What code can I use to create a variable for non hispanic black white and other ( I would like to use this as my analytic sample).    Finally, I have non PRAMS data that I have merged with PRAMS data. I was wondering if I had to create weights for that data as well? My dependent variables (outcomes) come from PRAMS and my independent variables come from another data set that I created and merged with PRAMS data. I am doing a state level analysis..so the outcomes are nested within states. I know that will be a multilevel model. To run the statistical models I have to apply weights to the PRAMS data. Should I also create weights for the other (independent variables) as well? ... View more