There are some discrepancies with the most recent data set (02/10/2019). There are 96 observations that seem to have no SMISTID or RELKIDS input, but do have PartIDs and EG numbers, though the EGs are all recent (The EGs are 70-74). Also some of the total scores are not yet calculated. I will create and include a subset of the 96 problem observations with the email.
| variables | types | missing_count | missing_percent | unique_count | unique_rate |
|---|---|---|---|---|---|
| PartID | numeric | 0 | 0.000000 | 3070 | 1.0000000 |
| nFORMCID | numeric | 0 | 0.000000 | 1082 | 0.3524430 |
| SMISTID | numeric | 96 | 3.127036 | 1049 | 0.3416938 |
| TxWLC | haven_labelled | 0 | 0.000000 | 2 | 0.0006515 |
| Program | haven_labelled | 0 | 0.000000 | 2 | 0.0006515 |
| EG | numeric | 0 | 0.000000 | 71 | 0.0231270 |
| RELKIDS | haven_labelled | 96 | 3.127036 | 7 | 0.0022801 |
| PREDERSTOTALRAWSCORE | numeric | 1048 | 34.136808 | 115 | 0.0374593 |
| POSTDERSTOTALRAWSCORE | numeric | 1690 | 55.048860 | 106 | 0.0345277 |
| D90DERSTOTALRAWSCORE | numeric | 2074 | 67.557003 | 101 | 0.0328990 |
| D180DERSTOTALRAWSCORE | numeric | 2310 | 75.244300 | 94 | 0.0306189 |
| PREOQTOTALSCORE | numeric | 1985 | 64.657980 | 117 | 0.0381107 |
| POSTOQTOTALSCORE | numeric | 3070 | 100.000000 | 1 | 0.0003257 |
| D90OQTOTALSCORE | numeric | 3070 | 100.000000 | 1 | 0.0003257 |
| D180OQTOTALSCORE | numeric | 3070 | 100.000000 | 1 | 0.0003257 |
| PREOQTOTAL | numeric | 1067 | 34.755700 | 123 | 0.0400651 |
| POSTOQTOTAL | numeric | 1701 | 55.407166 | 117 | 0.0381107 |
| D90OQTOTAL | numeric | 2076 | 67.622150 | 113 | 0.0368078 |
| D180OQTOTAL | numeric | 2310 | 75.244300 | 110 | 0.0358306 |
| PRERDASTOTAL | numeric | 1553 | 50.586319 | 65 | 0.0211726 |
| POSTRDASTOTAL | numeric | 2063 | 67.198697 | 65 | 0.0211726 |
| D90RDASTOTAL | numeric | 2282 | 74.332248 | 61 | 0.0198697 |
| D180RDASTOTAL | numeric | 2541 | 82.768730 | 57 | 0.0185668 |
| PREPAFASPARENTING | numeric | 1814 | 59.087948 | 45 | 0.0146580 |
| POSTPAFASPARENTING | numeric | 2234 | 72.768730 | 46 | 0.0149837 |
| D90PAFASPARENTING | numeric | 2455 | 79.967427 | 43 | 0.0140065 |
| D180PAFASPARENTING | numeric | 2686 | 87.491857 | 31 | 0.0100977 |
| PREPAFASFAMADJUSTMENT | numeric | 1819 | 59.250814 | 33 | 0.0107492 |
| POSTPAFASFAMADJUSTMENT | numeric | 2287 | 74.495114 | 32 | 0.0104235 |
| D90PAFASFAMADJUSTMENT | numeric | 2454 | 79.934853 | 31 | 0.0100977 |
| D180PAFASFAMADJUSTMENT | numeric | 2614 | 85.146580 | 28 | 0.0091205 |
| PREDCITOTALSCORE | numeric | 3070 | 100.000000 | 1 | 0.0003257 |
| POSTDCITOTALSCORE | numeric | 3070 | 100.000000 | 1 | 0.0003257 |
| D90DCITOTALSCORE | numeric | 3070 | 100.000000 | 1 | 0.0003257 |
| D180DCITOTALSCORE | numeric | 3070 | 100.000000 | 1 | 0.0003257 |
| PREDCITOTAL | numeric | 1518 | 49.446254 | 108 | 0.0351792 |
| POSTDCITOTAL | numeric | 2026 | 65.993485 | 103 | 0.0335505 |
| D90DCITOTAL | numeric | 2343 | 76.319218 | 99 | 0.0322476 |
| D180DCITOTAL | numeric | 2535 | 82.573290 | 96 | 0.0312704 |