| 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 |
|---|
|
| 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;
|
