Hi all,
I have a question regarding missing data and multiple imputation. In the following example, the variable "riwstat" was not imputed. I want this variable to be static across imputations. So for example, if riwstat = 1 at wave 12, I would like this to be 1 at every iteration at wave 12. In this example, keduc_rc_copyk is imputed, and functions properly, but has data filled in waves in which the respondent didn't exist. I assume this is the product of reshaping to wide to impute the longitudinal data, and then flipping back to long, creating rows that didn't previously exist. Is my main issue of riwstat not staying static because I didn't use "mi register regular"?
I have a question regarding missing data and multiple imputation. In the following example, the variable "riwstat" was not imputed. I want this variable to be static across imputations. So for example, if riwstat = 1 at wave 12, I would like this to be 1 at every iteration at wave 12. In this example, keduc_rc_copyk is imputed, and functions properly, but has data filled in waves in which the respondent didn't exist. I assume this is the product of reshaping to wide to impute the longitudinal data, and then flipping back to long, creating rows that didn't previously exist. Is my main issue of riwstat not staying static because I didn't use "mi register regular"?
Code:
. list hhidpn kidid wave riwstat keduc_rc_copyk _mi_miss _mi_m _mi_id if hhidpn == 911735020 , sepby(hhidpn kidid)
+---------------------------------------------------------------------------------+
| hhidpn kidid wave riwstat keduc_~k _mi_miss _mi_m _mi_id |
|---------------------------------------------------------------------------------|
499849. | 911735020 9117350101 5 . . 1 0 499849 |
499850. | 911735020 9117350101 6 . . 1 0 499850 |
499851. | 911735020 9117350101 7 . . 1 0 499851 |
499852. | 911735020 9117350101 8 . . 1 0 499852 |
499853. | 911735020 9117350101 9 . . 1 0 499853 |
499854. | 911735020 9117350101 10 1.resp,a 13 0 0 499854 |
499855. | 911735020 9117350101 11 1.resp,a 13 0 0 499855 |
499856. | 911735020 9117350101 12 1.resp,a 13 0 0 499856 |
|---------------------------------------------------------------------------------|
499857. | 911735020 9117350102 5 . . 1 0 499857 |
499858. | 911735020 9117350102 6 . . 1 0 499858 |
499859. | 911735020 9117350102 7 . . 1 0 499859 |
499860. | 911735020 9117350102 8 . . 1 0 499860 |
499861. | 911735020 9117350102 9 . . 1 0 499861 |
499862. | 911735020 9117350102 10 1.resp,a 17 0 0 499862 |
499863. | 911735020 9117350102 11 1.resp,a 17 0 0 499863 |
499864. | 911735020 9117350102 12 1.resp,a 17 0 0 499864 |
|---------------------------------------------------------------------------------|
499865. | 911735020 9117350103 5 . . 1 0 499865 |
499866. | 911735020 9117350103 6 . . 1 0 499866 |
499867. | 911735020 9117350103 7 . . 1 0 499867 |
499868. | 911735020 9117350103 8 . . 1 0 499868 |
499869. | 911735020 9117350103 9 . . 1 0 499869 |
499870. | 911735020 9117350103 10 1.resp,a 14 0 0 499870 |
499871. | 911735020 9117350103 11 1.resp,a 14 0 0 499871 |
499872. | 911735020 9117350103 12 1.resp,a 14 0 0 499872 |
|---------------------------------------------------------------------------------|
499873. | 911735020 9117350104 5 . . 1 0 499873 |
499874. | 911735020 9117350104 6 . . 1 0 499874 |
499875. | 911735020 9117350104 7 . . 1 0 499875 |
499876. | 911735020 9117350104 8 . . 1 0 499876 |
499877. | 911735020 9117350104 9 . . 1 0 499877 |
499878. | 911735020 9117350104 10 1.resp,a 14 0 0 499878 |
499879. | 911735020 9117350104 11 1.resp,a 14 0 0 499879 |
499880. | 911735020 9117350104 12 1.resp,a 14 0 0 499880 |
|---------------------------------------------------------------------------------|
652393. | 911735020 9117350101 5 . 15 . 1 499849 |
652394. | 911735020 9117350101 6 . 15 . 1 499850 |
652395. | 911735020 9117350101 7 . 14 . 1 499851 |
652396. | 911735020 9117350101 8 . 13 . 1 499852 |
652397. | 911735020 9117350101 9 . 13 . 1 499853 |
|---------------------------------------------------------------------------------|
652398. | 911735020 9117350102 5 . 17 . 1 499857 |
652399. | 911735020 9117350102 6 . 17 . 1 499858 |
652400. | 911735020 9117350102 7 . 17 . 1 499859 |
652401. | 911735020 9117350102 8 . 17 . 1 499860 |
652402. | 911735020 9117350102 9 . 17 . 1 499861 |
|---------------------------------------------------------------------------------|
652403. | 911735020 9117350103 5 . 14 . 1 499865 |
652404. | 911735020 9117350103 6 . 14 . 1 499866 |
652405. | 911735020 9117350103 7 . 14 . 1 499867 |
652406. | 911735020 9117350103 8 . 14 . 1 499868 |
652407. | 911735020 9117350103 9 . 14 . 1 499869 |
|---------------------------------------------------------------------------------|
652408. | 911735020 9117350104 5 . 14 . 1 499873 |
652409. | 911735020 9117350104 6 . 14 . 1 499874 |
652410. | 911735020 9117350104 7 . 14 . 1 499875 |
652411. | 911735020 9117350104 8 . 14 . 1 499876 |
652412. | 911735020 9117350104 9 . 14 . 1 499877 |
|---------------------------------------------------------------------------------|
804585. | 911735020 9117350101 5 . 13 . 2 499849 |
804586. | 911735020 9117350101 6 . 13 . 2 499850 |
804587. | 911735020 9117350101 7 . 13 . 2 499851 |
804588. | 911735020 9117350101 8 . 13 . 2 499852 |
804589. | 911735020 9117350101 9 . 13 . 2 499853 |
|---------------------------------------------------------------------------------|
804590. | 911735020 9117350102 5 . 12 . 2 499857 |
804591. | 911735020 9117350102 6 . 12 . 2 499858 |
804592. | 911735020 9117350102 7 . 14 . 2 499859 |
804593. | 911735020 9117350102 8 . 17 . 2 499860 |
804594. | 911735020 9117350102 9 . 17 . 2 499861 |
|---------------------------------------------------------------------------------|
804595. | 911735020 9117350103 5 . 14 . 2 499865 |
804596. | 911735020 9117350103 6 . 14 . 2 499866 |
804597. | 911735020 9117350103 7 . 14 . 2 499867 |
804598. | 911735020 9117350103 8 . 14 . 2 499868 |
804599. | 911735020 9117350103 9 . 14 . 2 499869 |
|---------------------------------------------------------------------------------|
804600. | 911735020 9117350104 5 . 14 . 2 499873 |
804601. | 911735020 9117350104 6 . 14 . 2 499874 |
804602. | 911735020 9117350104 7 . 14 . 2 499875 |
804603. | 911735020 9117350104 8 . 14 . 2 499876 |
804604. | 911735020 9117350104 9 . 14 . 2 499877 |
|---------------------------------------------------------------------------------|
956777. | 911735020 9117350101 5 . 13 . 3 499849 |
956778. | 911735020 9117350101 6 . 13 . 3 499850 |
956779. | 911735020 9117350101 7 . 13 . 3 499851 |
956780. | 911735020 9117350101 8 . 13 . 3 499852 |
956781. | 911735020 9117350101 9 . 13 . 3 499853 |
|---------------------------------------------------------------------------------|
956782. | 911735020 9117350102 5 . 17 . 3 499857 |
956783. | 911735020 9117350102 6 . 17 . 3 499858 |
956784. | 911735020 9117350102 7 . 17 . 3 499859 |
956785. | 911735020 9117350102 8 . 17 . 3 499860 |
956786. | 911735020 9117350102 9 . 17 . 3 499861 |
|---------------------------------------------------------------------------------|
956787. | 911735020 9117350103 5 . 14 . 3 499865 |
956788. | 911735020 9117350103 6 . 14 . 3 499866 |
956789. | 911735020 9117350103 7 . 14 . 3 499867 |
956790. | 911735020 9117350103 8 . 14 . 3 499868 |
956791. | 911735020 9117350103 9 . 14 . 3 499869 |
|---------------------------------------------------------------------------------|
956792. | 911735020 9117350104 5 . 14 . 3 499873 |
956793. | 911735020 9117350104 6 . 14 . 3 499874 |
956794. | 911735020 9117350104 7 . 14 . 3 499875 |
956795. | 911735020 9117350104 8 . 14 . 3 499876 |
956796. | 911735020 9117350104 9 . 14 . 3 499877 |
|---------------------------------------------------------------------------------|
1108969. | 911735020 9117350101 5 . 13 . 4 499849 |
1108970. | 911735020 9117350101 6 . 13 . 4 499850 |
1108971. | 911735020 9117350101 7 . 13 . 4 499851 |
1108972. | 911735020 9117350101 8 . 13 . 4 499852 |
1108973. | 911735020 9117350101 9 . 13 . 4 499853 |
|---------------------------------------------------------------------------------|
1108974. | 911735020 9117350102 5 . 16 . 4 499857 |
1108975. | 911735020 9117350102 6 . 16 . 4 499858 |
1108976. | 911735020 9117350102 7 . 16 . 4 499859 |
1108977. | 911735020 9117350102 8 . 17 . 4 499860 |
1108978. | 911735020 9117350102 9 . 17 . 4 499861 |
|---------------------------------------------------------------------------------|
1108979. | 911735020 9117350103 5 . 14 . 4 499865 |
1108980. | 911735020 9117350103 6 . 14 . 4 499866 |
1108981. | 911735020 9117350103 7 . 14 . 4 499867 |
1108982. | 911735020 9117350103 8 . 14 . 4 499868 |
1108983. | 911735020 9117350103 9 . 14 . 4 499869 |
|---------------------------------------------------------------------------------|
1108984. | 911735020 9117350104 5 . 14 . 4 499873 |
1108985. | 911735020 9117350104 6 . 14 . 4 499874 |
1108986. | 911735020 9117350104 7 . 14 . 4 499875 |
1108987. | 911735020 9117350104 8 . 14 . 4 499876 |
1108988. | 911735020 9117350104 9 . 14 . 4 499877 |
|---------------------------------------------------------------------------------|
1261161. | 911735020 9117350101 5 . 13 . 5 499849 |
1261162. | 911735020 9117350101 6 . 13 . 5 499850 |
1261163. | 911735020 9117350101 7 . 13 . 5 499851 |
1261164. | 911735020 9117350101 8 . 13 . 5 499852 |
1261165. | 911735020 9117350101 9 . 13 . 5 499853 |
|---------------------------------------------------------------------------------|
1261166. | 911735020 9117350102 5 . 17 . 5 499857 |
1261167. | 911735020 9117350102 6 . 17 . 5 499858 |
1261168. | 911735020 9117350102 7 . 17 . 5 499859 |
1261169. | 911735020 9117350102 8 . 17 . 5 499860 |
1261170. | 911735020 9117350102 9 . 17 . 5 499861 |
|---------------------------------------------------------------------------------|
1261171. | 911735020 9117350103 5 . 14 . 5 499865 |
1261172. | 911735020 9117350103 6 . 14 . 5 499866 |
1261173. | 911735020 9117350103 7 . 14 . 5 499867 |
1261174. | 911735020 9117350103 8 . 14 . 5 499868 |
1261175. | 911735020 9117350103 9 . 14 . 5 499869 |
|---------------------------------------------------------------------------------|
1261176. | 911735020 9117350104 5 . 14 . 5 499873 |
1261177. | 911735020 9117350104 6 . 14 . 5 499874 |
1261178. | 911735020 9117350104 7 . 14 . 5 499875 |
1261179. | 911735020 9117350104 8 . 14 . 5 499876 |
1261180. | 911735020 9117350104 9 . 14 . 5 499877 |
