[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: crosstab output as new data file
From: |
Joseph Saint Pierre |
Subject: |
Re: crosstab output as new data file |
Date: |
Thu, 16 Jan 2014 08:53:09 +0100 |
2014/1/15, Frans Houweling <address@hidden>:
> Maybe
> AGGREGATE OUTFILE=* /BREAK=doc /pages=N.
> will do the trick..
> Have fun
> Frans
Thank you for the idea. I thought I could use AGGREGATE but I could not see how.
The break has to be done with the other variable and repeated, and
then it is necessary the match (merge) files to get the file
corresponding to crosstab output. It probably can be simplified with
LOOP, but it works.
Joseph
select if (doc=1) .
AGGREGATE OUTFILE=ag1 /BREAK=ip /page1=N.
get file=ag1.
list /var=ip page1 .
get file=ag0.
select if (doc=2) .
AGGREGATE OUTFILE=ag2 /BREAK=ip /page2=N.
get file=ag2.
list /var=ip page2 .
get file=ag0.
select if (doc=3) .
AGGREGATE OUTFILE=ag3 /BREAK=ip /page3=N.
get file=ag3.
list /var=ip page3 .
get file=ag0.
select if (doc=4) .
AGGREGATE OUTFILE=ag4 /BREAK=ip /page4=N.
get file=ag4.
list /var=ip page4 .
get file=ag0.
select if (doc=5) .
AGGREGATE OUTFILE=ag5 /BREAK=ip /page5=N.
get file=ag5.
list /var=ip page5 .
get file=ag0.
select if (doc=6) .
AGGREGATE OUTFILE=ag6 /BREAK=ip /page6=N.
get file=ag6.
list /var=ip page6 .
get file=ag0.
select if (doc=7) .
AGGREGATE OUTFILE=ag7 /BREAK=ip /page7=N.
get file=ag7.
list /var=ip page7 .
get file=ag0.
select if (doc=8) .
AGGREGATE OUTFILE=ag8 /BREAK=ip /page8=N.
get file=ag8.
list /var=ip page8 .
get file=ag0.
select if (doc=9) .
AGGREGATE OUTFILE=ag9 /BREAK=ip /page9=N.
get file=ag9.
list /var=ip page9 .
get file=ag0.
select if (doc=10) .
AGGREGATE OUTFILE=ag10 /BREAK=ip /page10=N.
get file=ag10.
list /var=ip page10 .
get file=ag0.
select if (doc=11) .
AGGREGATE OUTFILE=ag11 /BREAK=ip /page11=N.
get file=ag11.
list /var=ip page11 .
get file=ag0.
select if (doc=12) .
AGGREGATE OUTFILE=ag12 /BREAK=ip /page12=N.
get file=ag12.
list /var=ip page12 .
get file=ag0.
select if (doc=13) .
AGGREGATE OUTFILE=ag13 /BREAK=ip /page13=N.
get file=ag13.
list /var=ip page13 .
get file=ag0.
select if (doc=14) .
AGGREGATE OUTFILE=ag14 /BREAK=ip /page14=N.
get file=ag14.
list /var=ip page14 .
get file=ag0.
select if (doc=15) .
AGGREGATE OUTFILE=ag15 /BREAK=ip /page15=N.
get file=ag15.
list /var=ip page15 .
get file=ag0.
select if (doc=16) .
AGGREGATE OUTFILE=ag16 /BREAK=ip /page16=N.
get file=ag16.
list /var=ip page16 .
get file=ag0.
select if (doc=17) .
AGGREGATE OUTFILE=ag17 /BREAK=ip /page17=N.
get file=ag17.
list /var=ip page17 .
get file=ag0.
select if (doc=18) .
AGGREGATE OUTFILE=ag18 /BREAK=ip /page18=N.
get file=ag18.
list /var=ip page18 .
match files
/file=ag1
/file=ag2
/file=ag3
/file=ag4
/file=ag5
/file=ag6
/file=ag7
/file=ag8
/file=ag9
/file=ag10
/file=ag11
/file=ag12
/file=ag13
/file=ag14
/file=ag15
/file=ag16
/file=ag17
/file=ag18
/by = ip.
recode page1 to page18 (sysmis=0).
save outfile=agg.