topic Re: How to extract text data from a variable in SAS Programming

How to extract text data from a variable

vraj1 — Wed, 04 Apr 2018 11:25:55 GMT

I have below text data

"If IsEqualTo Inclusion 1 then... set datapoint value for ILIST in Inclusion Criteria to LIST #1 - The subject is a boy or girl, aged ≥7 and <12years (patients who turn 12 years during the study will be allowed to continue in the game)., and execute the ""Return True"" custom function".

In this text i need to extract "The subject is a boy or girl, aged ≥7 and <12years (patients who turn 12 years during the study will be allowed to continue in the game)" i.e whenever it starts with "-" and ends with ".," then i need the text in between.

Any help

Re: How to extract text data from a variable

RW9 — Wed, 04 Apr 2018 12:05:35 GMT

If your logic is acurate then that is simple:

/* Gets all text from - */
inter=substr(have,index(have,"-"));
/* gets all text up to . */
want=substr(inter,1,index(inter,"."));

Assumes both are present etc.

Re: How to extract text data from a variable

Clash — Wed, 04 Apr 2018 12:19:11 GMT

HI!

If your text is in a variable called "text", then this would work -->

want = scan(scan(text,2,'-'),1,'.') ;

Best regards,

Claes

Re: How to extract text data from a variable

gamotte — Wed, 04 Apr 2018 12:58:54 GMT

Hello,

A solution with a regexp :

data have;
    string='If  IsEqualTo Inclusion 1 then... set datapoint value for ILIST in Inclusion Criteria to LIST #1 - The subject is a boy or girl, aged ≥7 and <12years (patients who turn 12 years during the study will be allowed to continue in the game)., and execute the ""Return True"" custom function';
    extract=prxchange("s/.*-(.*)\..*/$1/",1,string);
run;