Hello I have a string variable which contains letters and ';' signs. for example: A;B;A;A;B;C The length of these strings is not constant and varies by observations, so the next observation may be something like A;B or even a single B I need to create variables to store each letter separately. for example for the first string, I need 6 separate variables, say alpha1, alpha2, alpha3, alpha4, alpha5 and alpha6 which each of them only contains one of the 6 letters appeared in the string. so alpha1 will be A, alpha2 will be B, alpha3 will be A and so on For the second string, I will only need alpha1 to store A and alpha2 to storeB and finally for the third string, I just need alpha1 to store B and all other alpha variables to be empty. My data base contains about 1 million observations so having a lot of if,then statements may not be the smartest solution. Any suggestion is greatly appreciated!
... View more