topic Re: add two conditions in proc sql in SAS Procedures

add two conditions in proc sql

michtka — Thu, 10 Jan 2013 13:28:39 GMT

Hi guys, I got the next problem:

*Because I dont have AE collected by day (colldate) in the dataset ae, we need to assign AE to the collection date (colldate) from a dataset called drugs;

1) in the below code I can assign the AE: start AE (aefdate) <= colldate and stop AE (aetdate) <= colldate

      proc sql noprint;
        create table symptomx as
        select ae.pid, ae.aefdate,ae.aetdate, ae.prefcode, ae.preftext, ae.aercaus,ae.aecaus, a.colldate,
        a.factdat,a.lactdat,a.cpevent,a.visit
        from ae
        left join drugs a
        on ae.pid=a.pid
        and ae.aefdate le a.colldate le ae.aetdate;
      quit;

2) My problem is that I need to assign also AEs that stop before the colldate, i.e the condition ae.aetdate le a.colldate

Is possible to add this extra condition to the above proc sql code, or I need to create another proc sql table?

Thnaks.

Re: add two conditions in proc sql

never — Thu, 10 Jan 2013 17:30:11 GMT

I'm not sure I completely understand your problem... but i think this is what you're looking for...

      proc sql noprint;
        create table symptomx as
        select   ae.pid,

ae.aefdate,

ae.aetdate,

ae.prefcode,

ae.preftext,

ae.aercaus,

ae.aecaus,

a.colldate,
a.factdat,

a.lactdat,

a.cpevent,

                    a.visit
        from ae left join drugs a
             on ae.pid = a.pid
        where ae.aefdate le a.colldate

and a.colldate le ae.aetdate

and ae.aetdate le a.colldate ;
quit;

If not, can you clarify what all these things are... perhaps tell me what AE means for context.