I want to combine three cycles of NHANES data (2013-2014, 2011-2012, and 2009-2010), and I have a question about the weights. I want to exclude participants who did not answer a particular question. However, if I remove these people from the dataset, my weights will not add up to 100. Is this OK to not have the weights add up to 100 or do I have to multiply each individual weight by a number across the board so that the sum adds up to 100?
For example, let's say I have 100 people, and I want to exclude 5 of them, for the remaining 95, would I multiple their weight by 1.053? (95*1.053=100)
Thank you all for your help!