add two conditions in proc sql

[michtka]

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.

V.

[never · Accepted solution]

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.