https://communities.sas.com/t5/SAS-Programming/Removing-unwanted-characters-from-imported-data/m-p/279134#M311281 <P>Hello,</P><P>I want to import the following data into SAS:</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Description</TD><TD>Q12013</TD><TD>Q22013</TD></TR><TR><TD>Industrial aggregate including unclassified businesses [00-91N]&nbsp; (5,6)</TD><TD>15074374</TD><TD>15463301</TD></TR><TR><TD>Industrial aggregate excluding unclassified businesses [11-91N]&nbsp; (5,6)</TD><TD>14835632</TD><TD>15219329</TD></TR><TR><TD>Goods producing industries [11-33N]&nbsp; (7)</TD><TD>2700602</TD><TD>2829935</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>My question: I want to import the Description column but I do not want to include the numbers/letters/commas in brackets (whether squared or round). I also don't want the brackets. How do I code an infile statement to exclude all these components so I only have written descriptions in my SAS dataset? Thanks Jack</P> Tue, 21 Jun 2016 19:47:49 GMT Jack1 2016-06-21T19:47:49Z https://communities.sas.com/t5/SAS-Programming/Removing-unwanted-characters-from-imported-data/m-p/279134#M311281 <P>Hello,</P><P>I want to import the following data into SAS:</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Description</TD><TD>Q12013</TD><TD>Q22013</TD></TR><TR><TD>Industrial aggregate including unclassified businesses [00-91N]&nbsp; (5,6)</TD><TD>15074374</TD><TD>15463301</TD></TR><TR><TD>Industrial aggregate excluding unclassified businesses [11-91N]&nbsp; (5,6)</TD><TD>14835632</TD><TD>15219329</TD></TR><TR><TD>Goods producing industries [11-33N]&nbsp; (7)</TD><TD>2700602</TD><TD>2829935</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>My question: I want to import the Description column but I do not want to include the numbers/letters/commas in brackets (whether squared or round). I also don't want the brackets. How do I code an infile statement to exclude all these components so I only have written descriptions in my SAS dataset? Thanks Jack</P> Tue, 21 Jun 2016 19:47:49 GMT https://communities.sas.com/t5/SAS-Programming/Removing-unwanted-characters-from-imported-data/m-p/279134#M311281 Jack1 2016-06-21T19:47:49Z https://communities.sas.com/t5/SAS-Programming/Removing-unwanted-characters-from-imported-data/m-p/279136#M311282 <P>Look at the SCAN function with the [ as the delimiter.&nbsp;</P> Tue, 21 Jun 2016 19:51:20 GMT https://communities.sas.com/t5/SAS-Programming/Removing-unwanted-characters-from-imported-data/m-p/279136#M311282 Reeza 2016-06-21T19:51:20Z