This is a different approach, but you could do it in a left join:
data new;
input ServiceDescription & $28. new_ServiceDescription & $22.;
datalines;
Ground FlatRate
FedEx Economy Standard
FedEx 2Day 2Day
FedEx 2Day AM 2Day AM
FedEx Standard Overnight Standard Overnight
FedEx Priority Overnight Priority Overnight
FedEx First Overnight First Overnight
FedEx International Priority International Priority
;
run;
proc sql;
create table want as
select a.other_columns /* other columns, sans ServiceDescription */
,case
when b.ServiceDescription is not null
then b.new_ServiceDescription
else a.ServiceDescription
end as ServiceDescription
from TMP.FINAL a
left join new b
on a.ServiceDescription = b.ServiceDescription
;
quit;
... View more