topic How to separate out information in a string in SAS Programming https://communities.sas.com/t5/SAS-Programming/How-to-separate-out-information-in-a-string/m-p/777921#M247587 <P>Hi,</P> <P>&nbsp;</P> <P>I have a string that is like this&nbsp;&nbsp;Date : 2020/12/18Notes :this was done in July&nbsp;(WASH-797)/WASHER-797-LUV/p</P> <P>&nbsp;</P> <P>What I would like is two variables that separate the information from Date part and Notes part i.e</P> <P>&nbsp;</P> <P>Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Notes:</P> <P>2020/12/18&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;this was done in July&nbsp;(WASH-797)/WASHER-797-LUV/p</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Thank yo in advance</P> <P>&nbsp;</P> Tue, 02 Nov 2021 14:07:53 GMT Dregerator 2021-11-02T14:07:53Z How to separate out information in a string https://communities.sas.com/t5/SAS-Programming/How-to-separate-out-information-in-a-string/m-p/777921#M247587 <P>Hi,</P> <P>&nbsp;</P> <P>I have a string that is like this&nbsp;&nbsp;Date : 2020/12/18Notes :this was done in July&nbsp;(WASH-797)/WASHER-797-LUV/p</P> <P>&nbsp;</P> <P>What I would like is two variables that separate the information from Date part and Notes part i.e</P> <P>&nbsp;</P> <P>Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Notes:</P> <P>2020/12/18&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;this was done in July&nbsp;(WASH-797)/WASHER-797-LUV/p</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Thank yo in advance</P> <P>&nbsp;</P> Tue, 02 Nov 2021 14:07:53 GMT https://communities.sas.com/t5/SAS-Programming/How-to-separate-out-information-in-a-string/m-p/777921#M247587 Dregerator 2021-11-02T14:07:53Z Re: How to separate out information in a string https://communities.sas.com/t5/SAS-Programming/How-to-separate-out-information-in-a-string/m-p/777928#M247592 <P>You are probably going to need to look at <A href="https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lefunctionsref/n0bj9p4401w3n9n1gmv6tf**bleep**9m.htm" target="_self">PRXMATCH</A> and the related functions</P> Tue, 02 Nov 2021 14:31:57 GMT https://communities.sas.com/t5/SAS-Programming/How-to-separate-out-information-in-a-string/m-p/777928#M247592 AMSAS 2021-11-02T14:31:57Z