Create new columns based on other column

[kz134]

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! 

[novinosrin · Accepted solution]

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;

[PeterClemmensen]

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;