Transform panel data into a time series

[arshad hayat]

Dears,

I have a panel data of countries and years. I need to make it look like a time series. I want to get a new variable id e.g. 11, 12 (first country first year, first country second year). Could you please help me get that in stata?

Regards,

Arshad

[Carlo Lazzaro]

Arshad:
If I get you query right, there's no need to create a new variable.
Simply type:

sort id (year)

[arshad hayat]

Thank you Carlo for reply.
Actually only id variable is 1.2.3.4.....
i want something like that would indicate country as well. e.g. (id such that, id=11, 12, 13 (for US year 1, year 2, year3), id=21, 22, 23 (for canada year1, year 2, year 3)

I hope i explained it right.

ARSHAD

[Marcos Almeida]

Hello Arshad,

Carlo gave insightful advice.

Again, since you didn't give much information, it is sort of guessing, so to speak.

Therefore, I kindly suggest to share data - full, abridged or a mock example - under CODE delimiters or by installing the SSC dataex, as recommended in the FAQ.

That said, provided we have a time variable as well the ID variable, we are supposed to use xtset for a panel data analysis and tsset for time series analysis.

Hope that helps.

[Carlo Lazzaro]

Arshad:
thanks for further clarifications.
Provided that Marcos' advice still holds, I would think about something like:

. bysort id (year): g index=sum(1)

. g new_var=egen concat( idcode index)

. egen  new_var=concat( idcode index)

[Nick Cox]

Carlo Lazzaro's second line of code was I think left in by mistake and certainly it would not run. It's the first and third lines that are pertinent.

[Carlo Lazzaro]

Nick is right.
Sorry for the mishap.

[Jamel Saadaoui]

I tried something here: https://www.jamelsaadaoui.com/from-p...es-with-stata/

Any comments or remarks are welcome.

Kind regards,

Jamel