The following code separates all the words (depending on the length of the address you might have to change the code, perhaps a macro will help you). Here is the code data want1; set have; j=index(string," "); add1=substr(string,1,j-1); restadd=substr(string,j+1); j = index(restadd," "); add2=substr(restadd,1,j-1); restadd=substr(restadd,j+1); j = index(restadd," "); add3=substr(restadd,1,j-1); restadd=substr(restadd,j+1); j = index(restadd," "); add4=substr(restadd,1,j-1); restadd=substr(restadd,j+1); j = index(restadd," "); add5=substr(restadd,1,j-1); restadd=substr(restadd,j+1); j = index(restadd," "); add6=substr(restadd,1,j-1); restadd=substr(restadd,j+1); j = index(restadd," "); add7=substr(restadd,1,j-1); restadd=substr(restadd,j+1); drop j restadd; run; output string add1 add2 add3 add4 add5 add6 add7 46 Siwash Creek Rd Tonasket Wa 98855 46 Siwash Creek Rd Tonasket Wa 98855 Po Box 124 Ford Wa 99013 Po Box 124 Ford Wa 99013 99013 Po Box 292 Ford Wa 99013 Po Box 292 Ford Wa 99013 99013 Po Box 124 Welpinit Wa 99040 Po Box 124 Welpinit Wa 99040 99040 Po Box 47 Wellpinit Wa 99040 Po Box 47 Wellpinit Wa 99040 99040 Po Box 267 Wellpinit Wa 99040 Po Box 267 Wellpinit Wa 99040 99040 Po Box 276 Wellpinit Wa 99040 Po Box 276 Wellpinit Wa 99040 99040 5443 Ford Wellpinit Rd Wellpinit Wa 99040 5443 Ford Wellpinit Rd Wellpinit Wa 99040 Po Box 188 Wellpinit Wa 99040 Po Box 188 Wellpinit Wa 99040 99040 Po Box 416 Wellpinit Wa 99040 Po Box 416 Wellpinit Wa 99040 99040 5962a Martha Boardman Rd Wellpinit Wa 99040 5962a Martha Boardman Rd Wellpinit Wa 99040 Po Box 35 Wellpinit Wa 99040 Po Box 35 Wellpinit Wa 99040 99040 2915 Number One Canyon Rd Wenatchee Wa 98801-2462 2915 Number One Canyon Rd Wenatchee Wa 785 Skidmore Rd Colville Wa 99114 785 Skidmore Rd Colville Wa 99114 99114
... View more