How to reshape a dataset?

Hi,

I have a dataset with stock returns for around 50 stocks, which I attached to the question. The time period is from 1962-2016. I would like to reshape it.

Right now it looks like this:

ID RET dates

10000 0.5 date1

10000 0.2 date2

10001 1 date1

.

.

.

10050 0.3 last date of stock 50

I would like it to look like this

date 1 date2 date3 .....

RET1 of stock1 RET2 of stock 1 RET3 of stock 1

REt1 of stock2 RET2 of stock 2 RET3 of stock 2

. . .

. . .

. . .

Data description

ID the id of diffrent stocks

dates daily observation

RET daily returns.

The ID variable is not really needed in the new table it just has to be 1 row.

Optimali the date variable would be the names of the column but if it is not possible it can also be the the first row.

Does someone know how to do that?

Thanks in advance

Answer 1

[Sean de Wolski]

• Convert the dataset to the much more modern and supported table using dataset2table.
• Look at unstack()

[Luca]

Thank you it worked.