Date: Thu, 21 Dec 2006 11:41:58 +0100
Reply-To: Stéphane COLAS <scolas@DATAMETRIC.FR>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Stéphane COLAS <scolas@DATAMETRIC.FR>
Subject: substracting values
In-Reply-To: <200612211006.kBKMu7CG029135@malibu.cc.uga.edu>
Content-Type: text/plain; charset=ISO-8859-1
Hi all,
I have a simply question about a measurement.
if you have a table like that :
Name;post;value
stef;A;30
stef;B;15
stef;C;10
joan;A;40
joan;B;15
joan;C;5
...
and you want to add a line for each name that represents the diffrence between
A-C values and that I want to name D.
Name;post;value
stef;A;30
stef;B;15
stef;C;10
stef;D;20 <= substract from A-C
joan;A;40
joan;B;15
joan;C;5
joan;D;35 <= substract from A-C
...
without transposing, how you do that ?
Stéphane.