| Date: | Thu, 30 Oct 2008 15:37:22 -0500 |
|---|
| Reply-To: | Mary <mlhoward@avalon.net> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Mary <mlhoward@AVALON.NET> |
|---|
| Subject: | Transpose wide question |
|---|
| Content-Type: | text/plain; format=flowed; charset="iso-8859-1";
reply-type=original |
|---|
Could someone please tell me how to transpose this? I've got:
data affymetrix_long;
set myoracle.affymetrix_long;
keep affy_full_hageman_nbr snp_name allele_coding;
run;
What I want is one line per affy_full_hageman_nbr, with the snp_name as the
variable, and the allele_coding
as the value. I tried this below but it is not right, somehow I need to
tell it that I want the
snp_name to be the variable names.
proc transpose data =affymetrix_long out =affymetrix_wide;
id affy_full_hageman_nbr;
var allele_coding;
run;
-Mary
| 
