First, I have been assuming that March Basic variables identified as “Core” on your variable selection page, if selected, appear on the same line as the ASEC variables. Is this true? OR do they appear on separate rows that need to be extracted and merged?
If a line comes from a month other than March, can I assume that it is a part neither of the ASEC nor of the ASEC-associated Basic Monthly sample?
If a line comes from a month other than March, is there an easy way to tell if it comes from the Basic Monthly sample or one of the Supplements, and if the latter, which one? I observe that there are 15 Suppliments, so some months must have multiple Supplements.
If you select a Suppliment sample, and you have also selected variables from the ASEC-associated March Basic Monthly Core, will you automatically get those same variables from the March Basic Monthly associated with the month of the Suppliment?
I have been using the same sample selection for all my extracts, on the assumption that this will make them line up and I can just glue the columns together. But now I think I need to pull out all the rows that don’t come with the ASEC and then merge them back in, so that each line represents a single person-year combination.
Assume that one row per person-year (where a “year” actually refers to four consecutive months containing a March) is my goal, so that all the information (in the samples and variables I have selected) about a person during one 4-month interval ends up on a single row. (I am not looking at the Monthly samples except as they are associated with a supplement or the ASEC). This suggests that it does not make sense to put all the samples I am using in each extract, since I just need to pull them out again in order to merge them, creating an extra step. Does this seem right?
I am confused about how the Hispanic oversample plays in all this. I know that the ASEC Basic Monthly (Core) variables associated with this sample come from the preceding November . I suppose it means that MONTH alone is not a reliable way to distinguish whether an individual line in an extract is in or out of the ASEC Core, but I’m not sure that is all it means.