Import fixed column data help

#1
Hi all,

I am having trouble structuring my data so that I can import it into Stata using "infix". I cannot delimit my data as there are blanks that indicate missing values. At present my data looks something like this:

ID Age Wealth
1 11 21
2 12 (blank)
3 13 23

Number Tags
31 41
32 42
33 43

ID Age Wealth
4 14 24
5 (blank) 25
6 16 26

Number Tags
34 44
35 45
36 46

and so forth.

However, I would to form a panel as follows so that each column represents the same type of information and I can proceed with the "infix" function to import my data into Stata:

ID Age Wealth Number Tags
1 11 21 31 41
2 12 (blank) 32 42
3 13 23 33 43
4 14 24 34 44
5 (blank) 25 35 45
6 16 26 36 46

Any help would be much appreciated.

Alex
 
Last edited: