Manipulating dataset: (from column variables to row observations)

Accepted Solution Solved
Reply
Contributor
Posts: 35
Accepted Solution

Manipulating dataset: (from column variables to row observations)

Dear All,

I have the following dataset:

data have;

     input ID Jan Feb;

datalines;

100     1     2  

200     3     4    

;


I would like to put the values of the two columns Jan and Feb in a unique column, named value, and add a column named month which should indicate whether the value comes from the column Jan or Feb of the dataset have. That is, I would like to obtain the following dataset:


data want;

     input ID month value;

datalines;

100     Jan     1    

100     Feb     2    

200     Jan     3

200     Feb     4

;


Any help would be highly appreciated.


Accepted Solutions
Solution
‎02-07-2015 11:58 AM
Grand Advisor
Posts: 17,338

Re: Manipulating dataset: (from column variables to row observations)

Proc Transpose:

proc transpose data=have out=want

  (rename=(_name_=Month COL1= Value));

by ID;

run;

View solution in original post


All Replies
Solution
‎02-07-2015 11:58 AM
Grand Advisor
Posts: 17,338

Re: Manipulating dataset: (from column variables to row observations)

Proc Transpose:

proc transpose data=have out=want

  (rename=(_name_=Month COL1= Value));

by ID;

run;

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 140 views
  • 0 likes
  • 2 in conversation