Date: Tue, 29 Apr 2008 09:00:22 0400
ReplyTo: wcw2 <wcw2@CDC.GOV>
Sender: "SAS(r) Discussion" <SASL@LISTSERV.UGA.EDU>
From: wcw2 <wcw2@CDC.GOV>
Subject: Subtracting Values in a Single Column
ContentType: text/plain; charset=ISO88591
Subtracting Values in a Single Column
Hello funseekers...I want to *groan* subtract the AUC values of DRUG B 
DRUG A and DRUG C  DRUG A and so on (for x # of drugs) BY PATIENT, to
produce the output on the right (BA and CA), in order to do a signed rank
test on the differences. I was thinking about sorting by patient, then
drug, and then using the DIF function. Would this work? Or, if there’s an
easier way (other than rearranging the whole dataset), I’d so much
appreciate any help......many thanks!
Patient Drug AUC BA CA
1 A 10 30 90
2 A 20 40 100
3 A 30 50 80
1 B 40
2 B 60 > >
3 B 80
1 C 100
2 C 120
3 C 150
