variable equals text search in different variable

[jmmedina25]

Hello, I'm trying to figure out how to get the "name" from variable2 that corresponds to the "id" in variable1.

In addition, if variable1 isn't found in variable2 than the output would just be the number in variable1.

Example:

Variable1     Variable2                                                                                                                                        Want

1                    <OPTIONS><OPTION id="1" name="Yes"/><OPTION id="2" name="No"/></OPTIONS>          Yes

2                   <OPTIONS><OPTION id="1" name="Yes"/><OPTION id="2" name="No"/></OPTIONS>            No

33                  <OPTIONS/>                                                                                                                                  33

[Ksharp · Accepted solution]

data have;
input var1 $ var2 & $80.;
cards;
1                    <OPTIONS><OPTION id="1" name="Yes"/><OPTION id="2" name="No"/></OPTIONS>       
2                   <OPTIONS><OPTION id="1" name="Yes"/><OPTION id="2" name="No"/></OPTIONS>          
33                  <OPTIONS/>      
;

data want;
 set have;
p=find(var2,cats('id="',var1,'"')); 
if p then want=scan(substr(var2,p),4,'"');
 else want=var1;
run;