I need some help with what I think is simple but I cannot seem to get it to work or find anyone else posting this...I can parse a text string by array but I want to identify the number of the parsed string in the new variable name (match them up). I have lots of data fields that have selected more than one option and they are separated by commas. Since I have alot of these fields in my data I was hoping to find a less manual way of doing this. I want data to correspond to the variable name. Obviously, it is a character variable source but the source1-source8 I want as numeric. variable source has values 1,3,7 1,2,5 1,2,3,6,7 1 2,8 and so on. I want to separate by commas data into 8 variables (source1, source2...source8). But I want the '1,3,7, to show up in source1 as '1', source3 as '3', source7 as '7' and not source1 as '1', source2 as '3', and source3 as '7'. Thanks, JJ
... View more