what will you do with single job titles that have multiple keywords? This is a good point. Ultimately, these keywords are used to code indoor jobs so it won't affect the outcome as both the nurse and the analyst will be indoor jobs. However, I do want to have accurate coding and planned to review the coding done in SAS and make adjustments as needed for these situations. Is the search supposed to be case sensitive? Is the search to be exact word of does matching part of a word count as found? The responses in the data are all in capital letters. Additionally, they are a mix of "admin", "administration", "administrative", etc. There are many spelling mistakes so there are some "Administratin" as well. "Pull from" would sort of imply "remove" the keyword from the title. Is that what you want to do? Or set an indicator that the key word appears in the text of the variable? I would prefer to set an indicator that the key word appears. I will look into the Index and Find functions. It would help to provide some example data and what you would expect the result to look like for that example. It likely will help if show exactly how you intend to use the "pulled values" as well. Is this an example of the job titles. Ultimately this would need to be represented by a 4-digit CCDO code. The ones listed here may technically be represented by different codes, but as they ultimately will be classified as indoor jobs this is less important. I just need to match them all to the most general account code. There are thousands of jobs listed so I wanted to bulk code some of the easier ones and manually code the more complex jobs. ACCOUNT EXECUTIVE ACCOUNT MANAGER ACCOUNT MANAGER / SALES ACCOUNT MANAGER AT A BANK ACCOUNT MANAGER, SALES ACCOUNT SUPERVISOR ACCOUNTANT This is the CCDO job titles and codes. Inspectors and Regulatory Officers, Government 1111 Officials and Administrators Unique to Government, n.e.c. 1113 Production Management Occupations 1115 Management Occupations, Construction Operations 1116 Inspectors and Regulatory Officers, Non-Government 1119 Occupations Related to Management and Administration, n.e.c. 1130
... View more
