I have a data set that contains participant data for multiple months. The data for each month contains a string of data that I want to parse out into different variables. The data within the string changes from month to month. ID Jan17 Feb17 Mar17 1 I - 2 - 0 - 056 - 0029 - 22 - 561 C - 4 - 0 - 056 - 0029 - 22 - 561 C - 4 - 1 - 056 - 0029 - 22 - 561 2 P - 4 - 23 - 056 - 0029 - 22 - 561 P - 4 - 23 - 056 - 0016 - 22 - 561 B - 1 - 23 - 056 - 0016 - 22 - 561 3 P - 4 - 33 - 007 - 0140 - 03 - 071 N - 4 - 33 - 007 - 0140 - 03 - 071 N - 4 - 33 - 007 - 0140 - 03 - 071 I wrote an array that will parse the string from a single month, but I can't figure a macro that will run for every month and create the output variables to include the month it is from. array STRING(*) var1 var2 var3 var4 var5 var6 var7 _char_;
i=1;
do while(scan(Jan17, i, " - ") ne "");
STRING(i) =scan(Jan17, i, " - ");
i+1;
end; Hopefully it would look something like this. I will have a ton of columns, but I can't think of a better way to do it. ID Jan17var1 Jan17var2 Jan17var3 Jan17var4 1 I 2 0 056 2 P 4 23 056 3 P 4 33 007 Thanks!
... View more