variable equals text search in different variable

jmmedina25 — Wed, 08 Jan 2020 21:13:52 GMT

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

Re: variable equals text search in different variable

Ksharp — Thu, 09 Jan 2020 11:59:02 GMT

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;

topic Re: variable equals text search in different variable in SAS Programming

variable equals text search in different variable

Re: variable equals text search in different variable