Please advise syntax to reshape long to wide format for variables "fs_b4exit fsY1 fsY2 fsY3 fsY4" each coded 0/1 for the time period "delay". ID is "personid"
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input double personid float(delay10 fs_b4exit fsY1 fsY2 fsY3 fsY4) 2337 3 0 0 0 1 0 2337 3 0 0 0 0 0 2337 3 0 0 0 0 0 2337 3 0 0 0 0 0 2337 3 0 0 0 0 0 2337 3 0 0 0 0 0 2337 3 0 0 0 0 0 2337 3 0 0 0 0 0 2337 3 0 0 0 0 0 2337 3 0 0 0 0 0 2337 3 0 0 0 0 0 2337 3 0 0 0 0 0 2337 3 0 0 0 0 0 2337 3 0 0 0 0 0 2337 3 0 0 0 0 0 2337 3 0 0 0 0 0 2337 3 0 0 0 0 0 2337 3 0 0 0 0 0 2337 3 0 0 0 0 0 2337 3 0 0 0 0 0 2337 3 0 0 0 0 0 2337 3 0 0 0 0 0 2337 3 0 0 0 0 0 2337 3 0 0 0 0 0 2337 3 0 0 0 0 0 2337 4 0 0 0 0 1 2337 4 0 0 0 0 0 2337 4 0 0 0 0 0 2337 4 0 0 0 0 0 2337 4 0 0 0 0 0 2337 4 0 0 0 0 0 2337 4 0 0 0 0 0 2337 4 0 0 0 0 0 2337 4 0 0 0 0 0 2337 4 0 0 0 0 0 2337 4 0 0 0 0 0 2337 4 0 0 0 0 0 2337 4 0 0 0 0 0 2337 4 0 0 0 0 0 2337 4 0 0 0 0 0 2337 4 0 0 0 0 0 2337 4 0 0 0 0 0 2337 4 0 0 0 0 0 2337 4 0 0 0 0 0 2337 4 0 0 0 0 0 2337 4 0 0 0 0 0 2337 4 0 0 0 0 0 2337 4 0 0 0 0 0 2337 4 0 0 0 0 0 2337 4 0 0 0 0 0 2337 4 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 2337 5 0 0 0 0 0 end
Comment