OutPut from a table

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

OutPut from a table

Sean McKenzie
Using the below command I get the below output...now this is pretty much
what i want but....

What I am doing is I will generate these frequency tables for a bunch of
different characteristics for a bunch of different offices... The idea is to
have tables from each office.

What I realy want is to write the data for each office to a specific cell in
an specific Excel SS.

Any Ideas?


OMS
/SELECT TABLES
/IF COMMANDS = ["Frequencies"]
      SUBTYPES = ["Frequencies"]
           /DESTINATION FORMAT = TABTEXT OUTFILE =
"h:\childcare\smckenzie\spss\outtable.xls".




Frequencies

OfficeName
                Frequency       Percent Valid Percent   Cumulative Percent
Valid   ANCHORAGE CHILD CARE    1       0       0       0
        CATHOLIC COMM. SVC.     529     9.4     9.4     9.4
        CORDOVA CHILD CARE      11      0.2     0.2     9.6
        FNSB CHILD CARE ASST    539     9.5     9.5     19.1
        HAINES/SKAGWAY  17      0.3     0.3     19.4
        HOMER CHILD CARE        97      1.7     1.7     21.2
        KENAI CHILD CARE        433     7.7     7.7     28.8
        KODIAK CHILD CARE       97      1.7     1.7     30.5
        MAT SU CHILD CARE       605     10.7    10.7    41.3
        METLAKATLA CHILD CAR    33      0.6     0.6     41.8
        MUNICIPALITY OF ANCH    3061    54.2    54.2    96.1
        NOME, BARROW, KOTZ.,    15      0.3     0.3     96.3
        SEWARD CHILD CARE       44      0.8     0.8     97.1
        SITKA CHILD CARE        76      1.3     1.3     98.5
        VALDEZ CHILD CARE       41      0.7     0.7     99.2
        WRANGELL CHILD CARE     46      0.8     0.8     100
        Total   5645    100     100