This is my first post on here, my apologies for any errors.
My data is organized by State and Year. There are hundreds of observations per State-Year that have been used to calculate a new variable x that is the same value for every observation within the state-year group. I just want a simple table that lists the first observation of X in each state-year group (or just the value of X for each state year group). The final table might look something like:
State Year X
AL 1980 ##
AL 1982 ##
.
.
WY 1980 ##
WY 1982 ##
I know this should be an easy fix, but I haven't been able to figure it out. The closest I can get gives me error messages about mixing 'by' and 'in' commands.
Using:
by State Year: list X
Gives me every the value of X for observation with the state-year...and all the values of X are the same within that state-year group.
-Will
Related Posts with Time Series Panel Data
Help with interpreting a log-log fixed effect modelHello! Thank you to all who takes the time to answer the questions in this forum, you are doing a g…
Looping over a list of phrasesI have a variable called color which records the fine-grained color of each observation. I would lik…
Testing nonlinear restrictions after estimating a system of equationsDear all I have a system of five equations that I want to estimate and then test for nonlinear rest…
cross sectional by each year and each industryHi all! I am new to Stata, but I need to run quite a complicated regression. Please help me. I have…
Loop for calculating OR in 2x2 tables (cci)Hi, I am doing a systematic review and I am comparing ORs. For most of the studies, I can only extr…
Subscribe to:
Post Comments (Atom)
0 Response to Time Series Panel Data
Post a Comment