Date:         Thu, 30 Oct 2008 16:03:59 -0500
Reply-To:     "./ ADD NAME=Data _null_," <iebupdte@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "./ ADD NAME=Data _null_," <iebupdte@GMAIL.COM>
Subject:      Re: Transpose wide question
Comments: To: Mary <mlhoward@avalon.net>
In-Reply-To:  <07f101c93acf$53aa97e0$832fa8c0@HP82083701405>
Content-Type: text/plain; charset=ISO-8859-1

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
>