2014/1/15, Frans Houweling <fhouwel...@email.it>: > 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. _______________________________________________ Pspp-users mailing list Pspp-users@gnu.org https://lists.gnu.org/mailman/listinfo/pspp-users
