topic Re: subset in SAS Programming

subset

SASPhile — Wed, 06 Sep 2017 05:20:39 GMT

proc sql;
    create table want as
      select * from have
   where prxmatch("/1|Y|yes/i",Results_In_Death)
   union
        select * from have
        where prxmatch("/fatal/i",OutCome)
  union
  select * from have
  where prxmatch("/death|dead|fatal|(subject|patient|participant).*(expire)/i",Term_Verbatim)
  union
       select * from have
       where prxmatch("/na/i",Death_Date)=0;
quit;

the idea is to subset the dataset have that meet the where condition.but the results are not expected. for example results_in_death is showing values like 0,na etc.
    also outcome is showing values like disease progression etc
how to subset the data just based on where conditions?

Re: subset

ChrisNZ — Wed, 06 Sep 2017 05:43:55 GMT

Don't you mean


proc sql;
    create table want as
      select * from  have
   where prxmatch("/1|Y|yes/i",Results_In_Death)
     and prxmatch("/fatal/i",OutCome)
     and prxmatch("/death|dead|fatal|(subject|patient|participant).*(expire)/i",Term_Verbatim)
     and prxmatch("/na/i",Death_Date)=0;
 quit;

Note that the parentheses in the third test seem oddly placed.

Re: subset

SASPhile — Wed, 06 Sep 2017 05:46:56 GMT

it is OR not AND

Re: subset

ChrisNZ — Wed, 06 Sep 2017 05:50:38 GMT

If you use OR then you will get dates not equal to NA or results_in_death not equal to yes. Why are you surprised?