Hi i want to split a string and create new columns

[tejarongli21]

attached the data and its outputs in excel file.

need code for output1 and output2

[PeterClemmensen]

What have you tried so far?

[PaigeMiller]

Many people here refuse to download Microsoft Office files as they can be a security threat. Please provide sample data as WORKING SAS data step code, which you can type in yourself or you can follow these instructions. Do not provide data by attaching files. Do not provide data as screen captures.

Also, as requested by @PeterClemmensen , show us what you have tried.