Hi everybody!
I have a doubt with Stata. I have a file with data with lots of files and just one column. The column has format text and has entries such as:
TIR SOCIAL: 7.31 - TIR SOCIAL: 6.53 - VAN SOCIAL: 322218 - VAN SOCIAL: 449425
or
TIR SOCIAL: 0 - TIR SOCIAL: 3.23 - TIR SOCIAL: 4.11
My point is that I need Stata to locate every time that TIR Social appears and generate column 2 with the number 7.31 and column 3 with the number 6.53. For the second row I need to have the value 0 in the second column, the value 3.23 in the 3rd column and the value 4.11 in the 4th columns.
Is it possible to do such a thing with Stata?
(I am usins Stata 11.2)
Best regards,
Alex
