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.
Proc Transpose:
proc transpose data=have out=want
(rename=(_name_=Month COL1= Value));
by ID;
run;
Proc Transpose:
proc transpose data=have out=want
(rename=(_name_=Month COL1= Value));
by ID;
run;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.