Hi Everyone,
I have a dataset that I want to reshape it from long format to long format. My dataset looks like this:
isim year y_Albaraka y_Kuveytturk y_Trfinans
AKTİF TOPLAMI 2010 8406301.00 9727117.00 10691860.00
AKTİF TOPLAMI 2011 10460885.00 14897592.00 13528353.00
AKTİF TOPLAMI 2012 12327654.00 18910513.00 17616504.00
Personel Giderleri 2010 117292.00 60272.00 190704.00
Personel Giderleri 2011 141882.00 206915.00 210236.00
Personel Giderleri 2012 201416.00 259321.00 242839.00
NET FAALİYET 2010 165676.00 201123.00 252779.00
NET FAALİYET 2011 202163.00 245456.00 293421.00
NET FAALİYET 2012 241225.00 309256.00 361826.00
I need to transpose it like this:
isim year AKTİF TOPLAMI Personel Giderleri NET FAALİYET
y_Albaraka 2010
y_Albaraka 2011
y_Albaraka 2012
y_Kuveytturk 2010
y_Kuveytturk 2011
y_Kuveytturk 2012
y_Trfinans 2010
y_Trfinans 2011
y_Trfinans 2012
Any suggestions on how this could work?
thanks!
Related Posts with reshaping from long to long data
ReorderingHi everyone, I have a Birth history dataset with given mother id, child id, children birth order. I…
Inconsistent results between xtpoisson and marginsHi Statalisters, I am using -xtpoisson,fe- count data model to analyze my panel data. The dependent…
How to find the mean of subset of individualsI have data from several thousand observations on education level (discrete variable that ranges fro…
How to apply maximum value to a whole group using StataHello, I want to generate a variable (max_count) wherein, for a given group ID, if the value of "co…
Split string variables into different partsHi, I am using Stata 16 and would need some help in splitting a string variable and destring the va…
Subscribe to:
Post Comments (Atom)
0 Response to reshaping from long to long data
Post a Comment