I currently have a dataset that contains multiple of the same values for a variable (industry_code) in different areas (different values of the variable area_flips) and for different codes (agglvl_code) with quarterly data. I want to narrow this to achieve just the 4 quarterly values for each industry code (so a total of all the areas and agglvl_codes for a single industry_code but whilst keeping quarterly observations and other variables for each quarter).
Related Posts with joining the same observations with particular criterion
Store mean of many variables in a new fileHello, everyone! Suppose there are v1, v2, v3, t1, t2 five variables, now I want to calculate mean …
Running a Tobit with panel dataHey all! As a part of my Master's thesis, I am conducting an analysis of underreporting of migratio…
Extract numbers and stringsHello, I am wondering if there is a way in Stata where you can extract both numbers and strings. I w…
Using fiscal year(t-1) values rather than calendar year(t-1) valuesDear Statalist Community, I'm currently analysing abnormal returns using company financials. In com…
QuantilesGood morning I have created new quantile variables for my data using xtile variable_4 = variable, n…
Subscribe to:
Post Comments (Atom)
0 Response to joining the same observations with particular criterion
Post a Comment