Help using Base SAS procedures

add two conditions in proc sql

Accepted Solution Solved
Reply
Super Contributor
Posts: 301
Accepted Solution

add two conditions in proc sql

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.


Accepted Solutions
Solution
‎01-10-2013 12:30 PM
Occasional Contributor
Posts: 5

Re: add two conditions in proc sql

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.

View solution in original post


All Replies
Solution
‎01-10-2013 12:30 PM
Occasional Contributor
Posts: 5

Re: add two conditions in proc sql

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.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 226 views
  • 0 likes
  • 2 in conversation