Turn rows into columns

[polpel]

Hello,

Basically i have a dataset that i would like to transform so that my rows become columns.

here's the data:

group number    |      number of people in group

group1               |         450

group2               |         256

group3               |         214

and i would like this:

 group1     |      group2    |        group3

450           |       256        |           214

[PeterClemmensen]

data have;
input groupnumber $ numberingroup;
datalines;
group1 450
group2 256
group3 214
;

proc transpose data=have out=want(drop=_:);
    id groupnumber;
    var numberingroup;
run;