https://communities.sas.com/t5/SAS-Programming/Hi-i-want-to-split-a-string-and-create-new-columns/m-p/848867#M335609 <P>attached the data and its outputs in excel file.</P><P>&nbsp;</P><P>need code for output1 and output2</P> Sat, 10 Dec 2022 10:24:38 GMT tejarongli21 2022-12-10T10:24:38Z https://communities.sas.com/t5/SAS-Programming/Hi-i-want-to-split-a-string-and-create-new-columns/m-p/848867#M335609 <P>attached the data and its outputs in excel file.</P><P>&nbsp;</P><P>need code for output1 and output2</P> Sat, 10 Dec 2022 10:24:38 GMT https://communities.sas.com/t5/SAS-Programming/Hi-i-want-to-split-a-string-and-create-new-columns/m-p/848867#M335609 tejarongli21 2022-12-10T10:24:38Z https://communities.sas.com/t5/SAS-Programming/Hi-i-want-to-split-a-string-and-create-new-columns/m-p/848869#M335611 <P>What have you tried so far?</P> Sat, 10 Dec 2022 11:24:40 GMT https://communities.sas.com/t5/SAS-Programming/Hi-i-want-to-split-a-string-and-create-new-columns/m-p/848869#M335611 PeterClemmensen 2022-12-10T11:24:40Z https://communities.sas.com/t5/SAS-Programming/Hi-i-want-to-split-a-string-and-create-new-columns/m-p/848880#M335622 <P>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 <A href="https://blogs.sas.com/content/sastraining/2016/03/11/jedi-sas-tricks-data-to-data-step-macro/" target="_self">these instructions</A>. Do not provide data by attaching files. Do not provide data as screen captures.</P> <P>&nbsp;</P> <P>Also, as requested by <a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/31304">@PeterClemmensen</a> , show us what you have tried.</P> Sat, 10 Dec 2022 12:30:01 GMT https://communities.sas.com/t5/SAS-Programming/Hi-i-want-to-split-a-string-and-create-new-columns/m-p/848880#M335622 PaigeMiller 2022-12-10T12:30:01Z