Deriving own weights
Hope you are well.
My research focuses on the relationship between arts engagement (Wave 2) and wellbeing (Wave 5) using OLS regression. I understand that if I am using more than one wave, a longitudinal weight is more appropriate. But using that would lead to a significant drop in my sample size, therefore I would like to derive my own weight based on the the guidelines stated in "Understanding Society: Weighting and Sample Representation FAQ 2019". I have prepared the weighting codes and I would be extremely grateful if you could let me whether the coding is correct:
gen responseW5=1 if e_hidp!=. & b_hidp!=.
replace responseW5=0 if e_hidp==. & b_hidp!=.
logit responseW5 eventfqW2_v2 marstatW2 child16W2 ageW2
gen weightW25 = (1/p)*b_indscus_xw