Hi @owndan, welcome to the SAS Communities forum and thanks for supplying the data in the form of a data step.
Does the following help?
data want;
set have;
length car_brand $ 10;
retain car_brand;
if notdigit(strip(id)) then
car_brand = id;
run;
Thanks & kind regards,
Amir.
... View more