i.e. authors space year (in bracket) tab number nospace forward/slash
nospace number tab number nospace forward/slash nospace number. I want to
end up with six columns of variables in Stata i.e. authors year (without
brackets) number number number number.
I am at lost as to what to do with what looks like a very structured data
set and should be able to be accomplished without difficulty. I checked [U]
24 Commands to input data and [R] infile, infix and insheet for help but
without success.
I tried to copy and paste into stata editor and ended up with three columns
of variable i.e. authors and years, number/number and number/number. In this
situation, I do not know how (beyond me - to create a do-file) to 'clean'
the data e.g. 'demerging' authors and years from one column to two columns
and likewise for number/number from one column to number number in two
separate columns.