Hello,
I want to import the following data into SAS:
Description | Q12013 | Q22013 |
Industrial aggregate including unclassified businesses [00-91N] (5,6) | 15074374 | 15463301 |
Industrial aggregate excluding unclassified businesses [11-91N] (5,6) | 14835632 | 15219329 |
Goods producing industries [11-33N] (7) | 2700602 | 2829935 |
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