You might have a look at the reshape __package__, which I generally find
easier to use than the reshape function.

Kevin Wright


On Mon, Sep 14, 2009 at 9:41 AM, Luca Braglia <braglia@poleis.eu> wrote:

> Hello *
>
> I would like to reshape wide the following dataset:
>
>
> > rl <- read.dta("intermedi/rapporti_lavoro.dta")
> [c("id_rl","prog","sil_pi","sil_cf","sil_dat_avv")]
> > dim(rl)
> [1] 12964     5
> > object.size(rl)
> 1194728 bytes
>
> > head(rl)
>  id_rl prog      sil_pi           sil_cf sil_dat_avv
> 1   638    1 04567XXXXXX NLMDRE64A5XXXXXX  2000-08-03
> 2  1033    1 54872XXXXXX FLGOIP66A3XXXXXX  2000-11-28
> 3  1043    2 56849XXXXXX QPWOER52E2XXXXXX  2000-07-07
> 4  1508    2 54982XXXXXX FJKLSD67P4XXXXXX  2000-12-12
> 5  1532    2 56849XXXXXX QWERTG50T0XXXXXX  2000-03-30
> 6  3283    1 12345XXXXXX POIQWE74H0XXXXXX  1999-12-31
>
> Sil_cf and sil_pi are the idvar (sensible data too), prog is the timevar
> (now dataset is not sorted)
>
> > sapply(rl, class)
>      id_rl        prog      sil_pi      sil_cf sil_dat_avv
>  "integer"   "integer" "character" "character"      "Date"
>
> > apply(rl, 2, function(x) sum(duplicated(x)))
>      id_rl        prog      sil_pi      sil_cf sil_dat_avv
>          0       12863        6957        9886       10539
>
> > range(rl$prog)
> [1]   1 101
>
> > table(cut(rl$prog,5))
>
> (0.9,20.9]  (20.9,41]    (41,61]  (61,81.1] (81.1,101]
>     12784         75         42         40         23
>
>
>
>
> So i've scripted
>
> rl.wide  <- reshape(rl, idvar=c("sil_cf","sil_pi"), timevar="prog",
> direction="wide")
>
> but after a biblic time I got something like "Error: evaluation nested too
> deeply: infinite recursion".
>
> Any suggestion to perform that reshape?
>
> Many thanks
>
> Luca
>
> ______________________________________________
> R-help@r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>

	[[alternative HTML version deleted]]


