topic Search for a string with various special characters in SAS Programming

Search for a string with various special characters

Felix_ — Mon, 10 Aug 2020 15:57:33 GMT

Hi everyone,

I am reading several XML files as flat-files ... Imagine now i have a dataset XML3, with two columns:

xmlname (e.g.: XML_number1.xml), text1(several hundret alphanumeric characters, this is the xml-content).

DATA xml4_codesys(KEEP = xmlname codesys_flg);
      SET xml3;
      FORMAT codesys_flg best8.;
      codesys_string = INDEX(text1, %str(<name code="2" codeSystem="2.16.840.1.113883.3.989.5.1.1.5.1" codeSystemVersion="1.0" displayName="Master"/>));
        IF codesys_string NE 0 THEN DO;
          codesys_flg = 1;
        END;
        ELSE DO;
          codesys_flg = 0;
        RUN;
    RUN;

First attempt with the %str() masking did not help unfortunately 😞

The string i want to search for is exactly this one:

<name code="2" codeSystem="2.16.840.1.113883.3.989.5.1.1.5.1" codeSystemVersion="1.0" displayName="Master"/>

Does someone has an easy solution without complex PERL-Reg-Expressions? 🙂

Thank you in advance for any idea,

Felix

Re: Search for a string with various special characters

Shmuel — Mon, 10 Aug 2020 16:07:23 GMT

Try to change the %str with single quotes :

codesys_string = INDEX(text1, '<name code="2" codeSystem="2.16.840.1.113883.3.989.5.1.1.5.1" codeSystemVersion="1.0" displayName="Master"/>');

Re: Search for a string with various special characters

Felix_ — Tue, 11 Aug 2020 06:11:51 GMT

Sometimes, Solutions can be so easy 😄 Thank you 'Shmuel' !

... and sometimes you should Close the day after 10+ hours xD