Hello everyone, I want to know how to go from panel data to time series. I have this dataset:
ID year cons
1 2008 19600
1 2010 24400
1 2012 29000
1 2014 24200
1 2016 16200
2 2008 9600
2 2010 15000
2 2012 13680
2 2014 15480
2 2016 18425
3 2008 17900
3 2010 18700
I would like to have it as:
year 1 2 3
2010 19600 9600 17900
2012 24400 15000 18700
2014 29000 .................
2016 ........................
Thank you a lot
Related Posts with from panel data to time series
Retaining the entire ID if there are certain variables in the panel dataGood Morning world English is not my language so google help me. Please understand me. I have stat…
Replacing missing values with draws from a subset of nonmissing valuesI am replicating an imputation procedure for a household survey, and I'm struggling to find a elegan…
Collapsing multiple variables using the count optionHi all, I have a dataset where every row represents a study. Each row contains a column describing …
Random effects: logit with ibn. vs melogitI would like to model the predictors of remaining married (dichotomous) in a variety of countries (c…
How to organize a dataset in order to have years in one column and countries in another columnHello, I import data (related to one single variable "stringency" in excel to stata. However it app…
Subscribe to:
Post Comments (Atom)
0 Response to from panel data to time series
Post a Comment