Date:         Thu, 4 Jun 2009 07:15:57 -0400
Reply-To:     "Nallapeta, Kiran K (GE Money)" <kiran.nallapeta@GE.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Nallapeta, Kiran K (GE Money)" <kiran.nallapeta@GE.COM>
Subject:      Re: Difference Operation
Comments: To: ash007 <RamsamyAshley@GMAIL.COM>
In-Reply-To:  A<82fa82e4-dc35-4af1-8c1c-3cf7035d3a1e@z7g2000vbh.googlegroups.com>
Content-Type: text/plain; charset="us-ascii"

Hi...

Below is probably a simple way to do it:

proc sql;
        create table seuil
        as select
                a.section,
                sum(b.effectif_last, -a.effectif) as difference
        from
                mut_synthese as a, mut_synthese_last as b
        where
                a.section = b.section
        ;
quit;

Thanks,
Kiran


-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
ash007
Sent: Thursday, June 04, 2009 3:21 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Difference Operation

hello,

how can do a difference in a proc sql ? thanks.

proc sql;
        create table seuil
        as select
                a.section,
                ??????????(b.effectif_last,a.effectif) as difference
        from
                mut_synthese as a, mut_synthese_last as b
        where
                a.section = b.section
        ;
quit;