topic Create new columns based on other column in SAS Programming

Create new columns based on other column

kz134 — Wed, 05 Sep 2018 19:24:05 GMT

Hello,

I have a dataset:

ID_1	Value
A	1
A	2
A	3
B	4
B	5
B	6
C	7
C	8

I want to make ID_1 unique and create new columns for all the values. So I want:

ID_1	Value_1	Value_2	Value_3
A	1	2	3
B	4	5	6
C	7	8

Hope someone can help me. Thanks!

Re: Create new columns based on other column

novinosrin — Wed, 05 Sep 2018 19:26:27 GMT


data have;
input ID_1 $	Value;
cards;
A	1
A	2
A	3
B	4
B	5
B	6
C	7
C	8
;

proc transpose data=have out=want prefix=value;
by id_1;
var value;
run;

Re: Create new columns based on other column

PeterClemmensen — Wed, 05 Sep 2018 19:27:31 GMT

Do like this

data have;
input ID_1 $ Value;
datalines;
A 1
A 2
A 3
B 4
B 5
B 6
C 7
C 8
;

proc transpose data=have out=want(drop=_NAME_) prefix=value_;
    by ID_1 ;
    var Value;
run;