Hi: I need some guidance on a SAS program I am trying to code. I have a table of 18,000 industry names and codes. I want to load the data into a 2 dimensional array of 2 columns X 18000 rows. The first column of the array will be industry name and the second column of the array will be industry code. Then I want to sequentially read a file of company names, and check to see if any word in the company name matches an industry name. If it does I want to append the industry name and number to the company name. For example: Industry Name Table (18,000 rows) Industry Name Industry Code Electrical 001 Plumbing 002 Masonry 003 Company name Input Table (1 field called company name): Company Name Steve's Plumbing Desired Output (3 fields: company name, industry name, industry code) Company Na Industry Name Industry COde Steve's Plumbing Plumbing Electrical HELP! Thanks
... View more