DATA Step, Macro, Functions and more

subset

Reply
Super Contributor
Posts: 717

subset


 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?

Super User
Posts: 2,516

Re: subset

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.

 

Super Contributor
Posts: 717

Re: subset

it is OR not AND

Super User
Posts: 2,516

Re: subset

[ Edited ]

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?

Ask a Question
Discussion stats
  • 3 replies
  • 85 views
  • 0 likes
  • 2 in conversation