Reshape data to wide format

[Rodrigo Badilla]

Hi all,

I am trying to format my data (dta file) to wide format.

I did try with collapse but lamentably gave me a long format, example

clear all
webuse auto
collapse (sum) mpg, by(foreign rep78)

My desired data format looks like:

table foreign rep78, c(sum mpg)

Please any advice could help me.
Thanks in advance.
Rodrigo.

[Sergiy Radyakin]

Try

clear all
sysuse auto
collapse (sum) mpg, by(foreign rep78)
drop if missing(rep78)
reshape wide mpg, i(foreign) j(rep78)
list

Produces:

     +---------------------------------------------+
     |  foreign   mpg1   mpg2   mpg3   mpg4   mpg5 |
     |---------------------------------------------|
  1. | Domestic     42    153    513    166     64 |
  2. |  Foreign      .      .     70    224    237 |
     +---------------------------------------------+

[Rodrigo Badilla]

Thanks Sergiy Radyakin works greats!

Regards.