Date:         Thu, 30 Oct 2008 16:14:46 -0500
Reply-To:     Mary <mlhoward@avalon.net>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Mary <mlhoward@AVALON.NET>
Subject:      Re: Transpose wide question
Comments: To: "./ ADD NAME=Data _null_," <iebupdte@GMAIL.COM>
Content-Type: text/plain; charset="iso-8859-1"

Yes, that did work.  Thank you so much!

-Mary
  ----- Original Message ----- 
  From: ./ ADD NAME=Data _null_, 
  To: SAS-L@LISTSERV.UGA.EDU 
  Sent: Thursday, October 30, 2008 4:03 PM
  Subject: Re: Transpose wide question


  I think you want...

  proc transpose data =affymetrix_long out =affymetrix_wide;
     by affy_full_hageman_nbr;
     var allele_coding;
     id snp_name;
    run;

  On 10/30/08, Mary <mlhoward@avalon.net> wrote:
  > 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
  >