title: SAS Counting Keywords Across Columns
body: <p>I have list of keywords; CORPORATE, REAL ESTATE, COMPETITION, TRADE, DISPUTE</p>
  
  <p>I want to be able to count the number of occurrences these keywords appear between columns practice_area1—Practice_area10. Therefore, I want to scan across 10 columns and create new columns. Each new column will represent each of the keywords (above) and a count as a value e.g. Corporate 4</p>
  
  <p>Once this statement has ran and we have our new columns I want to create a new variable “Practice Group” which is populated with the highest count of the new variables we have just created. The dataset below is an example of how the data should look:</p>
  
  <p><a href="https://i.stack.imgur.com/pH1DB.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pH1DB.png" alt="enter image description here"></a></p>
  
  <p>Please could somebody offer me some advice of the best approach to do this?</p>
  
  <p>Many Thanks</p>
  
  <p>Chris</p>