I have the following sample data.
I would like to split the string variable into the 8 variables separated by |. I tried the following code but obtained an error "cannot generate new variables using stub datestoretxn_numberupcqtywgtrewa".
I am hoping to get some help on this. Thank you.
Code:
datestoretxn_numberupcqtywgtrewa 2017-06-21|18|2*59*1526|2114002318|1|0.0|3.28|42086775550 2017-06-21|18|2*59*1526|3680026711|1|0.0|0.79|42086775550 2017-06-21|18|2*59*1526|61300872056|1|0.0|2.99|42086775550 2017-06-21|18|2*59*1526|7332107141|2|0.0|4.99|42086775550
Code:
split datestoretxn_numberupcqtywgtrewa, parse(|)

Comment