Date: Tue, 27 Feb 2007 20:04:22 +0000
Reply-To: toby dunn <tobydunn@HOTMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: toby dunn <tobydunn@HOTMAIL.COM>
Subject: Re: Proc transpose help (SAS/QC preparation)
In-Reply-To: <5849E9717D973D4680AD52C26826723E0797B4D8@KDCP4PMBX06.cof.ds.capitalone.com>
Content-Type: text/plain; format=flowed
Add this to yoru proc transpose
ID _Name_ ;
Toby Dunn
To sensible men, every day is a day of reckoning. ~John W. Gardner
The important thing is this: To be able at any moment to sacrifice that
which we are for what we could become. ~Charles DuBois
Don't get your knickers in a knot. Nothing is solved and it just makes you
walk funny. ~Kathryn Carpenter
From: "Wainwright, Andrea" <andrea.wainwright@CAPITALONE.COM>
Reply-To: "Wainwright, Andrea" <andrea.wainwright@CAPITALONE.COM>
To: SAS-L@LISTSERV.UGA.EDU
Subject: Proc transpose help (SAS/QC preparation)
Date: Tue, 27 Feb 2007 15:00:08 -0500
At least I think I need transpose.
I've got a dataset like the following:
Population _name_ var1 var2 var3 var4...
A X 1 2 5 8
A S 2 3 1 1
A N 5 6 7 5
B X 7 2 3 9
B S 9 7 9 3
B N 3 3 2 6
C X 6 9 7 2
C S 1 1 5 9
C N 8 2 8 8
(Yes, I've already done one transpose to get the var1-varN across the
top)
And what I want is:
Population var1X var1S var1N var2X var2S var2N ...
A 1 2 5 2 3 6
B 7 9 3 2 7 3
C 6 1 8 9 1 2
So how do I append the value of _NAME_ to the variable while doing the
transpose?
For the QC tie-in, I'm building my HISTORY dataset. X is the mean, S is
the standard deviation, and N is the nobs.
The information contained in this e-mail is confidential and/or proprietary
to Capital One and/or its affiliates. The information transmitted herewith
is intended only for use by the individual or entity to which it is
addressed. If the reader of this message is not the intended recipient,
you are hereby notified that any review, retransmission, dissemination,
distribution, copying or other use of, or taking of any action in reliance
upon this information is strictly prohibited. If you have received this
communication in error, please contact the sender and delete the material
from your computer.
_________________________________________________________________
The average US Credit Score is 675. The cost to see yours: $0 by Experian.
http://www.freecreditreport.com/pm/default.aspx?sc=660600&bcd=EMAILFOOTERAVERAGE
