Well, you have to merge/join the table somehow. Do you want to match them based on observation number...? Some kind of Id column generally is the best/common way to do it.
About the multiplying part: you have to convert your character column to numeric first by using the input function:
input(sal,best.)
/Linus
Data never sleeps
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.