Hi all,

as the title suggests I would like to add as new observations string values included in a string and separated by a comma.
So, for instance if I have the following:

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input obs str114 atc3_ephmra
1 "A10H, S1X"
2 "A10X, C1D, J2A, L4X, D5B"
3 "B10X, F1A, J2C, S4B, K5D"
I would like to end up with:
Code:
input obs str114 atc3_ephmra
1 A10H
2 S1X
3 A10X
4 C1D
5 J2A
6 L4X
7 D5B
8 B10X
9 F1A
10 J2C
11 S4B
12 K5D


I guess thee first step is to split at the comma if stripos(atc3_ephmra,","), but I then am unable to go on.
Any help is appreciated.

Thank you all.