How do we create column from string where '\' is used to separate the sub string in SAS ?

[ballardw]

SHOW what your expected output should look like.

[vinayakraja]

The variable has long string and has to be divided into substrings and divided into columns of substrings. At the end we need to have total for each observation which has total for each populated coloumn. I hope i cleared it. Thanks for all the help.