title: SAS multiplying columns in one table with matching names with columns in another table
body: <p>I am working in SAS.</p>
  <p>I have two tables each with the same column names.
  Var1-Var189
  but it skips numbers.
  I basically need to multiply each matching column name by its partner. Due to the size of table 1 doing this through transpose takes 4+ hours. Need to find a way to do it quicker.</p>
  <p>Table 1</p>
  <pre><code>|Var1| Var2 | Var6 | Var9 |
  |:---|:-----|:-----|:-----|
  |1.2 |1.4   | 1.3  | 0.68 |
  |1.4 |1.8   |1.6   | 0.85 |
  </code></pre>
  <p>Table 2</p>
  <pre><code>|Var1| Var2 | Var6 | Var9 |
  |:---|:-----|:-----|:-----|
  |1   |0     | 0    | 1    |
  </code></pre>
  <p>Table 3 (want):
  Table 1</p>
  <pre><code>|Var1| Var2 | Var6 | Var9 |
  |:---|:-----|:-----|:-----|
  |1.2 |0     | 0    | 0.68 |
  |1.4 |0     |0     | 0.85 |
  </code></pre>
  <p>Table 2 will always have 1 or 0, but they shift. It will also only have 1 row.</p>