I think you want...
proc transpose data =affymetrix_long out =affymetrix_wide;
On 10/30/08, Mary <email@example.com> 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;
> 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;