Hi everyone,
I am working on the British Labour Force Survey (LFS) data to explore the effects of migration on the native employment rate using spatial correlations approach. Spatial units are 17 regions. Therefore, I want to aggregate data at the regional level. However, I am not sure how to transform quarterly variables into annual ones?
LFS is a quarterly household data (60,000 households, also includes personal level data) Each quarter's LFS sample of UK households is made up of five "waves". The same number of Wave 1 (new) addresses are selected each quarter. So, in any given quarter, about one-fifth of the addresses in the entire sample are in Wave 1, one-fifth in Wave 2, and so on. Thus, between any two consecutive quarters, about 80% of the selected addresses are in common. In other words, each wave is interviewed in five successive quarters, such that in any one quarter, one wave will be receiving their first interview, one waves their second, and so on, with one wave receiving their fifth and final interview.
I want to regress native employment rate - stock of natives in employment divided by the native working-age population on the ratio of immigrants to the native population, vector of variables for the demographics of individuals, the dummy variable for year t, the dummy variable for region i. But, I am not sure how to get from quarterly variables (gathered as stated above) to annual variables?
I would appreciate if you could offer some help. Thank you in advance.
Related Posts with Transforming Quarterly Variables into Annual Variables - British Labour Force Survey
Predictive Modeling using StataAny in depth books or tutorials on modeling with Stata that might be recommended? …
dstdize and standardisation by genderI followed the guidance on sex standardisation from here https://www.stata.com/manuals13/rdstdize.pd…
Stata commmands to analyze data where each record contains monthly totals: aggregate data problem but not really a wide to long solutionHi, I have some health centre data from Africa where each record consists of fields that represent …
How to handle missing data?Hi all, I am investigating health disparities in some Sub-Saharan Africa countries. Ethnicity is one…
Interaction with treatment in cubic spine plotDear Statalist, I want to plot the hazard ratio for survival over age using a restricted cubic spli…
Subscribe to:
Post Comments (Atom)
0 Response to Transforming Quarterly Variables into Annual Variables - British Labour Force Survey
Post a Comment