Having solved my last issue leads me directly to the next one..
My goal is to reshape the variable year in a wide format as well as I would like to keep the variable bond and both float variables in the long format. Moreover, it should be possible then to subidivide each bond within the variable of maturity and yield.
Firstly, I thought I do it through the command reshape already in the Editor file .. But this is not working since the variables maturity and yield are both float variables and I want to keep a date as well as a value within one column.
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str13 bond int maturity_ float(yield_ year) "NW1993211223" 23365 .03200178 1993 "RP1994120124" . . 1993 "SH2009031219" . . 1993 "ST2017250627" . . 1993 "ST20173011262" . . 1993 "NW1993211223" 23365 -.008574378 1996 "RP1994120124" 23387 -.01659639 1996 "SH2009031219" . . 1996 "ST2017250627" . . 1996 "ST20173011262" . . 1996 "NW1993211223" 23365 .019262526 1997 "RP1994120124" 23387 .016719231 1997 "SH2009031219" . . 1997 "ST2017250627" . . 1997 "ST20173011262" . . 1997 "NW1993211223" 23365 .04211741 1998 "RP1994120124" 23387 .04110777 1998 "SH2009031219" . . 1998 "ST2017250627" . . 1998 "ST20173011262" . . 1998 "NW1993211223" 23365 .010383962 1999 "RP1994120124" 23387 .010108948 1999 "SH2009031219" . . 1999 "ST2017250627" . . 1999 "ST20173011262" . . 1999 end format %td maturity_
many thanks in advance,
Freddy
0 Response to table issue again
Post a Comment