title: SAS Code that works like Excel's "VLOOKUP" function
body: <p>I'm looking for a SAS Code that works just like "VLOOKUP" function in Excel.</p>
  
  <p>I have two tables:
  table_1 has an ID column with some other columns in it with 10 rows. Table_2 has two columns: ID and Definition with 50 rows. I want to define a new variable "Definition " in table_1 and lookup the ID values from table_2.</p>
  
  <p>I haven't really tried anything other than merge. but merge keeps all the extra 40 variables from table_2 and that's not what I like.</p>
  
  <p>Thanks, SE</p>