I am trying to do a "lookup" if you like into one dataset and replace the matching values in another dataset. EG
Dataset A has the following values
And dataset B has the following values
What i want to do is look into dataset A and grab the corresponding values - so in this case I want to replace 0100 with 23001 in Dataset B and likewise, 0101 will be replaced to 23002 by looking into Dataset A for the value.
I resolved this issue by using firstly a join (PROC SQL) on the two datasets. I had to do this twice because I wanted to update two columns in the dataset to be updated. Then i did a MERGE on the two VIEWS I created (via proc sql) - the merge was on a key field (serial number).