Dear all,

I have tried to merge my datasets but appending was the approach that lead me to my results.

However, I would now like to ask whether there is a possibility to make my data that looks like this
id year var1 var2 var3
A 2007 36.565365
A 2007 3.8437979
A 2008 39.154861
A 2009 39.921722
A 2009 55.744255
A 2010 3.9122763
A 2010 38.319218

look like this (for the entire panel data set):
id year var1 var2 var3
A 2007 3.8437979 36.565365
A 2008 39.154861
A 2009 55.744255 39.921722
A 2010 3.9122763 38.319218

Also this might be a beginner problem, but I would like to delete an entire id group of my panel data set, say "C", how can I do this?
And the same questions regarding the year, since I might want to delete all observations after 2010 (>2010). How can I do this?

thank you very much in advance!

Best