Hi,
My data looks like the copy I made hereafter. I copied 3 months for 1 company here. Currently, my I have 12 different variables on 12 separate rows instead of 1 row per month with all 12 variables. Could you please help me to get my data to1 row per month?
Kind regards,
Bob Rotman
My data looks like the copy I made hereafter. I copied 3 months for 1 company here. Currently, my I have 12 different variables on 12 separate rows instead of 1 row per month with all 12 variables. Could you please help me to get my data to1 row per month?
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input int CompanyID byte VariableID double d float(Date MV P OI CASH CASHG TA STD LTD CSO BVS BVSF) 1 1 298.87 516 298.87 . . . . . . . . . . 1 2 2.87 516 . 2.87 . . . . . . . . . 1 3 1224990 516 . . . . . . . . . . . 1 4 35480 516 . . 35480 . . . . . . . . 1 5 120876 516 . . . 120876 . . . . . . . 1 6 173581 516 . . . . 173581 . . . . . . 1 7 948036 516 . . . . . 948036 . . . . . 1 8 11588 516 . . . . . . 11588 . . . . 1 9 105405 516 . . . . . . . 105405 . . . 1 10 103112 516 . . . . . . . . 103112 . . 1 11 2.255 516 . . . . . . . . . 2.255 . 1 12 2.255 516 . . . . . . . . . . 2.255 1 1 284.7 517 284.7 . . . . . . . . . . 1 2 2.74 517 . 2.74 . . . . . . . . . 1 3 1224990 517 . . . . . . . . . . . 1 4 35480 517 . . 35480 . . . . . . . . 1 5 120876 517 . . . 120876 . . . . . . . 1 6 173581 517 . . . . 173581 . . . . . . 1 7 948036 517 . . . . . 948036 . . . . . 1 8 11588 517 . . . . . . 11588 . . . . 1 9 105405 517 . . . . . . . 105405 . . . 1 10 103112 517 . . . . . . . . 103112 . . 1 11 2.255 517 . . . . . . . . . 2.255 . 1 12 2.255 517 . . . . . . . . . . 2.255 1 1 292.5 518 292.5 . . . . . . . . . . 1 2 2.81 518 . 2.81 . . . . . . . . . 1 3 1224990 518 . . . . . . . . . . . 1 4 35480 518 . . 35480 . . . . . . . . 1 5 120876 518 . . . 120876 . . . . . . . 1 6 173581 518 . . . . 173581 . . . . . . 1 7 948036 518 . . . . . 948036 . . . . . 1 8 11588 518 . . . . . . 11588 . . . . 1 9 105405 518 . . . . . . . 105405 . . . 1 10 103112 518 . . . . . . . . 103112 . . 1 11 2.255 518 . . . . . . . . . 2.255 . 1 12 2.255 518 . . . . . . . . . . 2.255 end format %tm Date
Kind regards,
Bob Rotman
Comment