CODEWITHSUNDEEP
sas
Mayara
Mayara

Reputation: 9

Change column and row using SAS

My data set is: |ID | SNP | GEN | |:--:|:---:|:---:| |1 | A | AG | |2 | A | GG | |3 | A | AG | |4 | A | AG |

I need to do this: |SNP | ID1 | ID2 | ID3 | ID4 | |:---|:---:|:---:|:---:|:---:| |A | AG | GG | AG | AG |

I've tried to use the following command, but it did not work:

proc transpose data=data1; run;

Someone knows how to make this using SAS?

Upvotes: 0

Views: 83

Answers (1)

Tom
Tom

Reputation: 51621

You just need to add more options to your PROC TRANPOSE call to get it to do what you want.

proc transpose data=data1 out=WANT prefix=ID ;
  by SNP;
  id ID;
  var GEN;
run;

The BY statement will process each value of SNP as a separate set to transpose. Make sure data is sorted by SNP if there are more values than in your example. The ID statement tells it which variable to use to generate the new variable name. The VAR statement tells it which variable to transpose, to transpose character variables you must use a VAR statement. The PREFIX= option lets you specify characters to use as prefix for the generated variable names.

Upvotes: 1

Related Questions