topic Help with Removing Blanks in the field in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Help-with-Removing-Blanks-in-the-field/m-p/472520#M71002 <P>I have the product field with following info:</P> <P>&nbsp;</P> <P>Product</P> <P>&nbsp;</P> <P>Atrilin&nbsp; Amox HC&nbsp; Retin-A Micro</P> <P>Tobi Cream Luzu Cream</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>I want the output as follows:</P> <P>&nbsp;</P> <P>Product</P> <P>&nbsp;</P> <P><SPAN>Atrilin</SPAN><SPAN>&nbsp;&nbsp;</SPAN><SPAN>Amox</SPAN><SPAN>HC&nbsp; Retin-AMicro</SPAN></P> <P><SPAN>TobiCream LuzuCream</SPAN></P> <P>&nbsp;</P> <P>I tried compbl function but it does not work.</P> <P>&nbsp;</P> <P>I would appreciate any help with this.</P> Fri, 22 Jun 2018 15:33:35 GMT pp2014 2018-06-22T15:33:35Z Help with Removing Blanks in the field https://communities.sas.com/t5/SAS-Procedures/Help-with-Removing-Blanks-in-the-field/m-p/472520#M71002 <P>I have the product field with following info:</P> <P>&nbsp;</P> <P>Product</P> <P>&nbsp;</P> <P>Atrilin&nbsp; Amox HC&nbsp; Retin-A Micro</P> <P>Tobi Cream Luzu Cream</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>I want the output as follows:</P> <P>&nbsp;</P> <P>Product</P> <P>&nbsp;</P> <P><SPAN>Atrilin</SPAN><SPAN>&nbsp;&nbsp;</SPAN><SPAN>Amox</SPAN><SPAN>HC&nbsp; Retin-AMicro</SPAN></P> <P><SPAN>TobiCream LuzuCream</SPAN></P> <P>&nbsp;</P> <P>I tried compbl function but it does not work.</P> <P>&nbsp;</P> <P>I would appreciate any help with this.</P> Fri, 22 Jun 2018 15:33:35 GMT https://communities.sas.com/t5/SAS-Procedures/Help-with-Removing-Blanks-in-the-field/m-p/472520#M71002 pp2014 2018-06-22T15:33:35Z Re: Help with Removing Blanks in the field https://communities.sas.com/t5/SAS-Procedures/Help-with-Removing-Blanks-in-the-field/m-p/472529#M71003 <PRE><CODE class=" language-sas">y = tranwrd(x, " Cream", "Cream");</CODE></PRE> <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/11613">@pp2014</a>&nbsp;wrote:<BR /> <P>I have the product field with following info:</P> <P>&nbsp;</P> <P>Product</P> <P>&nbsp;</P> <P>Atrilin&nbsp; Amox HC&nbsp; Retin-A Micro</P> <P>Tobi Cream Luzu Cream</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>I want the output as follows:</P> <P>&nbsp;</P> <P>Product</P> <P>&nbsp;</P> <P><SPAN>Atrilin</SPAN><SPAN>&nbsp;&nbsp;</SPAN><SPAN>Amox</SPAN><SPAN>HC&nbsp; Retin-AMicro</SPAN></P> <P><SPAN>TobiCream LuzuCream</SPAN></P> <P>&nbsp;</P> <P>I tried compbl function but it does not work.</P> <P>&nbsp;</P> <P>I would appreciate any help with this.</P> <HR /></BLOCKQUOTE> <P>&nbsp;</P> Fri, 22 Jun 2018 15:54:33 GMT https://communities.sas.com/t5/SAS-Procedures/Help-with-Removing-Blanks-in-the-field/m-p/472529#M71003 Reeza 2018-06-22T15:54:33Z