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
Generate a new variable adding observations of a different columnHello, I have the following dataset: Code: * Example generated by -dataex-. To install: ssc insta…
Write ado command with function defined on MataI am writing an ado file and I use structures like: program define XX, eclass myfunction() ereturn m…
Calculating Marginal EffectsDear all, I have had some trouble calculating one of the marginal effects of my regression. I am ru…
Difference-in-differenceHi everyone, I conducted an experiment where 2 parameters (alpha, beta) using 6 different methods w…
how to report nagelkerke and index in logit regressionhow can I report nagelkerke and index for the model fit f in logit regresion? I tried fitstat after…
Subscribe to:
Post Comments (Atom)
0 Response to reshaping from long to long data
Post a Comment