## How to traspose a table?

Solved
Frequent Contributor
Posts: 75

# How to traspose a table?

Hallo, I have a table like this

Date                       ID               return

....

....

and I would like to transpose it to have something like

date                100048              100055

Can anyone tell me how can I get this? Thanks alot

Accepted Solutions
Solution
‎11-20-2012 07:30 PM
Posts: 5,543

## Re: How to traspose a table?

This is a basic transposition problem. However, the resulting variable names cannot be numbers, with the following code, they will be like V100048 and V100055 :

proc sort data=have; by date; run;

proc transpose data=have out=want(drop=_ prefix=V;

by date;

id id;

var return;

run;

PG

PG

All Replies
PROC Star
Posts: 8,169

## Re: How to traspose a table?

proc sort data=have;

by date;

run;

proc transpose data=have out=want (drop=_;

var return;

id id;

by date;

run;

Solution
‎11-20-2012 07:30 PM
Posts: 5,543

## Re: How to traspose a table?

This is a basic transposition problem. However, the resulting variable names cannot be numbers, with the following code, they will be like V100048 and V100055 :

proc sort data=have; by date; run;

proc transpose data=have out=want(drop=_ prefix=V;

by date;

id id;

var return;

run;

PG

PG
Frequent Contributor
Posts: 75

Thank you !!

Super User
Posts: 10,787

## Re: How to traspose a table?

Assuming id is a numeric variable.

```data have;
do date='31aug2011'd to '31dec2011'd;
id=100048;return=2;
output;
end;
do date='31jan1980'd to '30apr1980'd;
id=100055;return=2;
output;
end;
run;
proc sql;
select distinct cats('have(rename=(return=_',id,') where=(id=',id,'))') into : list separated by ' '
from have;
quit;
data want;
merge &list ;
by date ;
run;

```

Ksharp

🔒 This topic is solved and locked.