Topic
48 replies Latest Post - ‏2014-05-22T12:27:41Z by Stefanie.van.den.Berg
YoSee
YoSee
31 Posts
ACCEPTED ANSWER

Pinned topic SPSSINC MERGE TABLES not working

‏2011-03-31T15:01:09Z |
I'm using the "Merge Viewer Tables ..." dialog box to merge 2 simple CTABLES output tables. (Table 1)
Tried allmost every combination and the result is allways the same: (Table 2)
The Proportions Table doesn't apear in the result, just it's header and a part of it's footnote.

What am I doing wrong?
Updated on 2013-04-04T16:37:41Z at 2013-04-04T16:37:41Z by SystemAdmin
  • YoSee
    YoSee
    31 Posts
    ACCEPTED ANSWER

    Re: SPSSINC MERGE TABLES not working

    ‏2011-03-31T15:18:29Z  in response to YoSee
    This is the Syntax of my last attempt

    SPSSINC MERGE TABLES MATCHLABEL="count" ATTACH=ROWS
    MODE=MERGE
    /OPTIONS HIDE=YES APPENDTITLE=YES APPENDCAPTION=YES ADDLABELLEAF=YES
    HALIGN=CENTER SEPARATOR="\n".
  • SystemAdmin
    SystemAdmin
    2077 Posts
    ACCEPTED ANSWER

    Re: SPSSINC MERGE TABLES not working

    ‏2011-03-31T15:20:41Z  in response to YoSee
    Please post the syntax you are using.
    • YoSee
      YoSee
      31 Posts
      ACCEPTED ANSWER

      Re: SPSSINC MERGE TABLES not working

      ‏2011-03-31T15:47:21Z  in response to SystemAdmin
      This is the CTABLES syntax

      MRSETS
      /MCGROUP NAME=$v188 LABEL="האם נהגת לצפות בעונה הקודמת של הסדרה פולישוק ששודרה לפני כשנתיים בערוץ 2, ואם כן האם"
      VARIABLES=V311 v311a.
      CTABLES
      /FORMAT EMPTY=BLANK MISSING='.' /SMISSING VARIABLE
      /TABLE $v188 [C][COLPCT.COUNT PCT40.0, TOTALShttp://COUNT PAREN40.0]
      BY edu[c]+ inc[c]+ agex[C]
      /SLABELS POSITION=ROW VISIBLE=NO
      /CATEGORIES VARIABLES=$v188 ORDER=A KEY=VALUE EMPTY=EXCLUDE TOTAL=YES LABEL='N=' POSITION=AFTER
      /COMPARETEST TYPE=PROP ALPHA=0.1 ADJUST=NONE ORIGIN=COLUMN
      /TITLES TITLE="צפיה בעבר בסדרה פולישוק - נעזר ".
      and This is the pasted Syntax from the Merge dialog box:
      DATASET ACTIVATE DataSet1.
      SPSSINC MERGE TABLES MATCHLABEL="Count" ATTACH=COLUMNS
      MODE=MERGE
      /OPTIONS HIDE=YES APPENDTITLE=YES APPENDCAPTION=YES ADDLABELLEAF=YES
      HALIGN=RIGHT SEPARATOR="\n".
      • SystemAdmin
        SystemAdmin
        2077 Posts
        ACCEPTED ANSWER

        Re: SPSSINC MERGE TABLES not working

        ‏2011-03-31T16:35:55Z  in response to YoSee
        This table is deceptively simple. It contains in the rows a hidden statistics label. You need to specify that label as the match point. The default label is Count, but your table just has percentages, so you need to specify that hidden label as MATCHLABEL.

        This syntax will do it.

        SPSSINC MERGE TABLES ATTACH=ROWS MATCHLABEL="Column N %"
        MODE=MERGE
        /OPTIONS HIDE=YES APPENDTITLE=YES APPENDCAPTION=YES ADDLABELLEAF=YES
        HALIGN=RIGHT SEPARATOR="\n".
        HTH,
        Jon Peck
        • YoSee
          YoSee
          31 Posts
          ACCEPTED ANSWER

          Re: SPSSINC MERGE TABLES not working

          ‏2011-03-31T16:40:51Z  in response to SystemAdmin
          worked like a charm!

          tank you very much
          • ZStatman
            ZStatman
            10 Posts
            ACCEPTED ANSWER

            Re: SPSSINC MERGE TABLES not working

            ‏2012-08-29T15:29:32Z  in response to YoSee
            How many times have I been down this "error road" I had to do a reinstall of both V20 & Python

            Running the following:

            CTABLES
            /VLABELS VARIABLES=educ jobcat DISPLAY=LABEL
            /TABLE educ [C] BY jobcat [C] http://COUNT F40.0, ROWPCT.COUNT PCT40.1, COLPCT.COUNT PCT40.1
            /CATEGORIES VARIABLES=educ ORDER=A KEY=VALUE EMPTY=INCLUDE TOTAL=YES POSITION=AFTER
            MISSING=EXCLUDE
            /CATEGORIES VARIABLES=jobcat ORDER=A KEY=VALUE EMPTY=INCLUDE MISSING=EXCLUDE.

            SPSSINC MODIFY TABLES subtype="Custom Table"
            SELECT="%"
            DIMENSION= COLUMNS
            LEVEL = -1 PROCESS = PRECEDING
            /STYLES APPLYTO=DATACELLS
            BACKGROUNDCOLOR=255 255 0.

            And get this error:\
            >Error # 6890. Command name: BEGIN PROGRAM
            >Configuration file spssdxcfg.ini is invalid.
            >Execution of this command stops.
            Configration file spssdxcfg.ini is invalid because the LIB_NAME is NULL.

            Tks
            • SystemAdmin
              SystemAdmin
              2077 Posts
              ACCEPTED ANSWER

              Re: SPSSINC MERGE TABLES not working

              ‏2012-08-29T15:40:05Z  in response to ZStatman
              I have no idea why this keeps coming up for you, but it doesn't have to do specifically with MERGE TABLES. The Python plugin is not installed or is not installed correctly. If uninstalling and reinstalling it doesn't clear this up, please contact Technical Support.

              Regards,
              Jon
              • ZStatman
                ZStatman
                10 Posts
                ACCEPTED ANSWER

                Re: SPSSINC MERGE TABLES not working

                ‏2012-08-29T16:59:00Z  in response to SystemAdmin
                Thanks Jon, figured it was the Python install so will go that suggested route

                BTY, what version is used by V21? I know it should install with the full installation but just in case can it be installed separately and if so, where available?

                Tks
                W
                • SystemAdmin
                  SystemAdmin
                  2077 Posts
                  ACCEPTED ANSWER

                  Re: SPSSINC MERGE TABLES not working

                  ‏2012-08-29T17:09:37Z  in response to ZStatman
                  Version 21 has a corresponding Python Essentials 21 that is included on the installation media and downloadable with the Statistics product. You no longer go to the SPSS Community site to get it. It is still a separate install. It uses Python 2.7, which is the same Python version as V20. On Windows, Python will be installed as part of the Essentials install if needed.

                  The V21 Essentials includes some additional extension commands compared with V20 that you used to have to get from the SPSS Community site (but there are still plenty of others up there).

                  Regards,
                  Jon
                  • ZStatman
                    ZStatman
                    10 Posts
                    ACCEPTED ANSWER

                    Re: SPSSINC MERGE TABLES not working

                    ‏2012-08-29T18:02:18Z  in response to SystemAdmin
                    Thanks again Jon
                  • YoSee
                    YoSee
                    31 Posts
                    ACCEPTED ANSWER

                    Re: SPSSINC MERGE TABLES not working

                    ‏2012-10-25T11:42:25Z  in response to SystemAdmin
                    hello jon,

                    We chenged or SPSS to version 20.
                    Installed Python Ess. as i did in version 18.
                    When trying to run SPSSINC MERGE TABLES with the same syntax:
                    SPSSINC MERGE TABLES MATCHLABEL="Column N %" ATTACH=ROWS
                    MODE=MERGE
                    /OPTIONS HIDE=YES APPENDTITLE=YES APPENDCAPTION=YES ADDLABELLEAF=YES
                    HALIGN=LEFT SEPARATOR="\n".

                    The significance table is not merged into the primary table and
                    i get this warning:

                    Warnings
                    16602,The index is out of bounds.,

                    What seems to be the problem?
                    • SystemAdmin
                      SystemAdmin
                      2077 Posts
                      ACCEPTED ANSWER

                      Re: SPSSINC MERGE TABLES not working

                      ‏2012-10-25T15:49:13Z  in response to YoSee
                      We recently found a bug having to do with tables that have hidden layers, which is common with CTABLES output.

                      To get around this, try changing your preference setting to use legacy tables (Edit > Options > Pivot Tables).

                      You might also want to report this to Technical Support and request a hot fix.
                      Regards,
                      Jon
                      • YoSee
                        YoSee
                        31 Posts
                        ACCEPTED ANSWER

                        Re: SPSSINC MERGE TABLES not working

                        ‏2012-12-02T20:41:07Z  in response to SystemAdmin
                        Hi jon,
                        Heres the thing!
                        We want to upgrade our spss to version 21.
                        Our DP is currently using version 15.
                        In this version we have a .sbs script that is doing exactly what SPSSINC MERGE TABLES does.
                        It merges the significance table with the main table in all the CTABLES within a viewer output (let say 10 of these) in less than two minutes.
                        After I created the output, all I have to do is to push the scripts button and ... voila!
                        To do this whith version 21, i had to include the syntax mentioned above (SPSSINC MERGE TABLES) after each and every one of the CTABLES syntax.
                        Thats not a big problem,
                        The big problem is that it takes 15 to 20 minutes ( depending on the amount of rows/columns in the tables ) to accomplish the same task.
                        Our DP was surprised as we were. Because of that they dont want to upgrade to the newer version, and were stuck.
                        Need your help to solve this ...
                        We even tried it on a faster machine (based on I7 cpu) but still the difference was not convincing.
                        The appearance of the combined tables is very important. We need a much faster solution here ... plz.
                        I have to mention that my Python Knowledge is very poor.
                        Why is it so slow? is there something in the SPSSINC MERGE TABLES python code that is time consuming? can you think of another solution?

                        Regards
                        Yossi
                        • SystemAdmin
                          SystemAdmin
                          2077 Posts
                          ACCEPTED ANSWER

                          Re: SPSSINC MERGE TABLES not working

                          ‏2012-12-02T21:23:21Z  in response to YoSee
                          Please post an spv file and syntax that you are using or send it to peck AT us.ibm.com if you prefer. It should certainly not be so slow even if the tables are enormous.

                          And are you using the legacy or fast setting for pivot tables?
                          • YoSee
                            YoSee
                            31 Posts
                            ACCEPTED ANSWER

                            Re: SPSSINC MERGE TABLES not working

                            ‏2012-12-03T10:34:16Z  in response to SystemAdmin
                            Hi Jon,
                            An example : On version 15 it takes about a minute, on 21 close to 10!!
                          • YoSee
                            YoSee
                            31 Posts
                            ACCEPTED ANSWER

                            Re: SPSSINC MERGE TABLES not working

                            ‏2012-12-03T10:45:20Z  in response to SystemAdmin
                            And the syntax,
                          • YoSee
                            YoSee
                            31 Posts
                            ACCEPTED ANSWER

                            Re: SPSSINC MERGE TABLES not working

                            ‏2012-12-03T10:46:20Z  in response to SystemAdmin
                            and .sbs script we use on version 15
                          • YoSee
                            YoSee
                            31 Posts
                            ACCEPTED ANSWER

                            Re: SPSSINC MERGE TABLES not working

                            ‏2012-12-03T10:56:39Z  in response to SystemAdmin
                            Oh .. yes i use legacy as you suggested in your previous post or else i get an error message
                            • SystemAdmin
                              SystemAdmin
                              2077 Posts
                              ACCEPTED ANSWER

                              Re: SPSSINC MERGE TABLES not working

                              ‏2012-12-03T13:57:09Z  in response to YoSee
                              I believe that the problem has been fixed for an upcoming maintenance release, but I need the spv file as it was before doing the merges in order to make sure.
                              • YoSee
                                YoSee
                                31 Posts
                                ACCEPTED ANSWER

                                Re: SPSSINC MERGE TABLES not working

                                ‏2012-12-03T14:49:39Z  in response to SystemAdmin
                                There is no before nor after. This spv is the result of running the attached syntax.
                                Do you mean running the syntax without the SSPSSINC MERGE TABLES commands?
                                • SystemAdmin
                                  SystemAdmin
                                  2077 Posts
                                  ACCEPTED ANSWER

                                  Re: SPSSINC MERGE TABLES not working

                                  ‏2012-12-03T15:06:06Z  in response to YoSee
                                  Yes.
                                  • YoSee
                                    YoSee
                                    31 Posts
                                    ACCEPTED ANSWER

                                    Re: SPSSINC MERGE TABLES not working

                                    ‏2012-12-03T15:23:55Z  in response to SystemAdmin
                                    Attached.
                                    • SystemAdmin
                                      SystemAdmin
                                      2077 Posts
                                      ACCEPTED ANSWER

                                      Re: SPSSINC MERGE TABLES not working

                                      ‏2012-12-03T15:28:56Z  in response to YoSee
                                      Did you run this with Fast tables? That's what I need that in order to check the fix.
                                      • YoSee
                                        YoSee
                                        31 Posts
                                        ACCEPTED ANSWER

                                        Re: SPSSINC MERGE TABLES not working

                                        ‏2012-12-03T16:00:19Z  in response to SystemAdmin
                                        Run with Fast Tables
                                      • YoSee
                                        YoSee
                                        31 Posts
                                        ACCEPTED ANSWER

                                        Re: SPSSINC MERGE TABLES not working

                                        ‏2012-12-04T15:19:32Z  in response to SystemAdmin
                                        Hi Jon,
                                        Any good news?

                                        Regards,
                                        Yossi
                                        • SystemAdmin
                                          SystemAdmin
                                          2077 Posts
                                          ACCEPTED ANSWER

                                          Re: SPSSINC MERGE TABLES not working

                                          ‏2012-12-04T15:24:11Z  in response to YoSee
                                          I have not had time to look at this yet. It will be later today or tomorrow before I can check it.
                                        • SystemAdmin
                                          SystemAdmin
                                          2077 Posts
                                          ACCEPTED ANSWER

                                          Re: SPSSINC MERGE TABLES not working

                                          ‏2012-12-05T20:36:55Z  in response to YoSee
                                          Using the Statistics 21 version currently in development for the next V21 fixpack, I ran SPSSINC MERGE on several of your large tables using the spv file you sent. They all merged correctly, and each merge took less than five seconds to run. Under IBM rules, I can't comment on when that will be released, however.

                                          Regards,
                                          Jon
                                          • YoSee
                                            YoSee
                                            31 Posts
                                            ACCEPTED ANSWER

                                            Re: SPSSINC MERGE TABLES not working

                                            ‏2012-12-06T19:14:58Z  in response to SystemAdmin
                                            Hi Jon,
                                            Thank you very much,

                                            Is there a fixpack for this on v20?
                                            • SystemAdmin
                                              SystemAdmin
                                              2077 Posts
                                              ACCEPTED ANSWER

                                              Re: SPSSINC MERGE TABLES not working

                                              ‏2012-12-06T19:33:42Z  in response to YoSee
                                              I don't know whether this was included in fixpack2 for V20, but it is available for download, so you can try it.
                                          • YoSee
                                            YoSee
                                            31 Posts
                                            ACCEPTED ANSWER

                                            Re: SPSSINC MERGE TABLES not working

                                            ‏2012-12-11T12:32:48Z  in response to SystemAdmin
                                            Hi Jon,

                                            Thank you again for all your help,

                                            We will probably wait for the fixpack on v21. Just one more request:

                                            Could you send me the output of your runs with the fix,
                                            I would like to see if the result is similar to mine.

                                            Thx in advance,
                                            Yossi
                                            • SystemAdmin
                                              SystemAdmin
                                              2077 Posts
                                              ACCEPTED ANSWER

                                              Re: SPSSINC MERGE TABLES not working

                                              ‏2012-12-11T16:52:51Z  in response to YoSee
                                              Here is the output for the merge of one large CTABLES command. The merge syntax was the same as in your file.
                                              • YoSee
                                                YoSee
                                                31 Posts
                                                ACCEPTED ANSWER

                                                Re: SPSSINC MERGE TABLES not working

                                                ‏2012-12-12T12:09:06Z  in response to SystemAdmin
                                                Hi Jon,

                                                Sorry, but this is the output that i sent you, with the separated tables.

                                                I ment, if you could send me the result after running the MERGE TABLES, with the fix for fast tables
                                                (that you mentioned in a previous post) that will be included in the next fixpack.
                                                i want to see if the apearance of the merged table is the same as when we run it in legacy mode.
                                                • SystemAdmin
                                                  SystemAdmin
                                                  2077 Posts
                                                  ACCEPTED ANSWER

                                                  Re: SPSSINC MERGE TABLES not working

                                                  ‏2012-12-12T14:07:29Z  in response to YoSee
                                                  Sorry, I attached the wrong output file.
                                                  • SystemAdmin
                                                    SystemAdmin
                                                    2077 Posts
                                                    ACCEPTED ANSWER

                                                    Re: SPSSINC MERGE TABLES not working

                                                    ‏2012-12-12T14:08:28Z  in response to SystemAdmin
                                                    here's the file
                                                    • YoSee
                                                      YoSee
                                                      31 Posts
                                                      ACCEPTED ANSWER

                                                      Re: SPSSINC MERGE TABLES not working

                                                      ‏2012-12-12T15:37:12Z  in response to SystemAdmin
                                                      It looks good.
                                                      THX.

                                                      one more thing to complete the picture:
                                                      What changes to the MERGE syntax do i have to make in order to get the row letters in the significance table ( marked yellow in the attachment ),
                                                      to apear in the merged table.
                                                      • SystemAdmin
                                                        SystemAdmin
                                                        2077 Posts
                                                        ACCEPTED ANSWER

                                                        Re: SPSSINC MERGE TABLES not working

                                                        ‏2012-12-12T16:03:14Z  in response to YoSee
                                                        The default syntax from the MERGE TABLES dialog box specifies appending the label. Here's an example. It's the ADDLABELLEAF keyword that specifies this.

                                                        SPSSINC MERGE TABLES MATCHLABEL="Count" ATTACH=COLUMNS
                                                        MODE=MERGE
                                                        /OPTIONS HIDE=YES APPENDTITLE=YES APPENDCAPTION=YES ADDLABELLEAF=YES
                                                        HALIGN=RIGHT SEPARATOR="\n".
                                                        • SystemAdmin
                                                          SystemAdmin
                                                          2077 Posts
                                                          ACCEPTED ANSWER

                                                          Re: SPSSINC MERGE TABLES not working

                                                          ‏2012-12-12T16:52:52Z  in response to SystemAdmin
                                                          The reason you are not getting those labels is because the attachment point is in the rows. If you put the statistics in the columns, you would get the column labels you want.
                                                          • YoSee
                                                            YoSee
                                                            31 Posts
                                                            ACCEPTED ANSWER

                                                            Re: SPSSINC MERGE TABLES not working

                                                            ‏2013-03-17T10:22:56Z  in response to SystemAdmin
                                                            Hello Jon,
                                                            I saw that SPSS Statistics 21.0 FP1 was released.
                                                            I went over the fix list and didnt find anything regarding the issues
                                                            we talked about in this thread, Especially the error issue when using
                                                            SPSSINC MERGE TABLES in fast tables mode (as opposed to legacy mode wich is very vey slow)
                                                            Am i right? or did I miss somthing?

                                                            Regards,
                                                            Yossi
                                                            • SystemAdmin
                                                              SystemAdmin
                                                              2077 Posts
                                                              ACCEPTED ANSWER

                                                              Re: SPSSINC MERGE TABLES not working

                                                              ‏2013-03-17T13:30:28Z  in response to YoSee
                                                              Did you try the fixpack? The list of fixes is not complete. It just lists the main items. Minor, rare, and esoteric items are generally not included as it would make the list too difficult for users to understand.
                                                              • YoSee
                                                                YoSee
                                                                31 Posts
                                                                ACCEPTED ANSWER

                                                                Re: SPSSINC MERGE TABLES not working

                                                                ‏2013-04-04T15:35:42Z  in response to SystemAdmin
                                                                Hi Jon,

                                                                Tried the fixpack and we like the speed of it.
                                                                However, in order to upgrade to v21 we need an adjustment, which i hope you could help me with.

                                                                In the attachment you can see in Fig.1 a simple output of a CTABLES syntax.
                                                                In Fig. 2 is the result of running MERGE TABLES.

                                                                However, our clients are used to get this output as presented in Fig.3 (the result of running a script on the output of SPSS v15).
                                                                If you can notice we get the letters (A, B, C ...) from the Significance Table in the columns labels.
                                                                The output in Fig.2 doesnt have it.

                                                                I even tried running CTABLES with statistics in the columns.
                                                                Surprisingly, if i use in the CTABLES comand the following:
                                                                /SLABELS POSITION=COLUMNS VISIBLE=NO
                                                                and run MERGE TABLES, it merges only the headers and footnotes of the two tables, without the letters in the table
                                                                but if i use VISIBLE=YES then the result is described in Fig.4 , not what we expect and our clients are used to.

                                                                What can be done to get the output we are used to ( Fig.3 )?

                                                                Attachments

                                                                • SystemAdmin
                                                                  SystemAdmin
                                                                  2077 Posts
                                                                  ACCEPTED ANSWER

                                                                  Re: SPSSINC MERGE TABLES not working

                                                                  ‏2013-04-04T16:37:41Z  in response to YoSee
                                                                  You normally do get the letter labels in the merged output. Run this example with the employee data.sav file shipped with Statistics. I used V21.

                                                                  CTABLES
                                                                  /VLABELS VARIABLES=educ jobcat DISPLAY=DEFAULT
                                                                  /TABLE educ [C]http://COUNT F40.0 BY jobcat [C]
                                                                  /CATEGORIES VARIABLES=educ jobcat ORDER=A KEY=VALUE EMPTY=INCLUDE MISSING=EXCLUDE
                                                                  /COMPARETEST TYPE=PROP ALPHA=0.05 ADJUST=BONFERRONI ORIGIN=COLUMN INCLUDEMRSETS=YES
                                                                  CATEGORIES=ALLVISIBLE MERGE=NO.

                                                                  SPSSINC MERGE TABLES MATCHLABEL="Count" ATTACH=COLUMNS
                                                                  MODE=MERGE
                                                                  /OPTIONS HIDE=YES APPENDTITLE=YES APPENDCAPTION=YES ADDLABELLEAF=YES
                                                                  HALIGN=RIGHT SEPARATOR="\n".

                                                                  We might need to look at your data and syntax more closely. ADDLABELLEAF=YES or NO controls this.
                                          • Stefanie.van.den.Berg
                                            5 Posts
                                            ACCEPTED ANSWER

                                            Re: SPSSINC MERGE TABLES not working

                                            ‏2014-05-21T13:33:00Z  in response to SystemAdmin

                                            Dear John, 

                                            I have exactly the same problem as Yossi stated above. I've upgraded my SPSS from SPSS 15 to SPSS 21, and before we always used a SBS-script which directly merged the numbers of significance in to the first table. 

                                            I would like to do this too in SPSS 21, but the script is not working anymore. Now I've seen a topic in which the first thing you are doing is exactly what I want to do: 

                                            https://www.ibm.com/developerworks/community/blogs/ab16c38e-2f7b-4912-a47e-85682d124d32/entry/coloring_significance_in_spss_statistics_custom_tables_output

                                            But I don't need to change the color of the significances. 

                                            Now I understand from this topic that I have to use the SPSSINC MERGE FILES - command. (of go to utilities in SPSS output and choose Merge Viewer Tables, but I can not find this command.) Now  it seems like I do not have the right Python Essentials. I'm looking for a download link for the Python Essentials, but I really can't find this anywhere.

                                            Can you help me with this problem? Or is there another way to merge the significance numbers in to the table above? 

                                            Regads, Stefanie

                                             

                                            • JonPeck
                                              JonPeck
                                              317 Posts
                                              ACCEPTED ANSWER

                                              Re: SPSSINC MERGE TABLES not working

                                              ‏2014-05-21T15:02:25Z  in response to Stefanie.van.den.Berg

                                              Your old script ought to work as long as you change the Application ID to the 16+ name, but MERGE TABLES is a much more powerful tool.

                                              Have you already installed the Python Essentials?  If not, you need to get that from the same location where you got Statistics 21 itself.  (In Statistics 22 it is fully integrated into the main Statistics install.)

                                              Once you have the Essentials installed, you can add any of the Python- based extension commands not included in the Essentials by downloading from the Extension Commands collection under the SPSS Community site and installing via Utilities > Extension Bundles.  Here is a link to that collection.

                                              Extension Commands

                                              Note that when you install extensions, you probably need to start Statistics using Run As Administrator so that it has sufficient permission to install the necessary files.

                                              • Stefanie.van.den.Berg
                                                5 Posts
                                                ACCEPTED ANSWER

                                                Re: SPSSINC MERGE TABLES not working

                                                ‏2014-05-22T07:18:33Z  in response to JonPeck

                                                Hi Jon, thanks for your reply.

                                                I did download the extension command 'merge tables' and the option 'merge viewer tables' is added to utilities. But when trying this, an error occurs, I think this is because I did not install the Python Essentials.

                                                But actually, I do not know where to find the Python Essentials. I have downloaded SPSS V21 from a CD-ROM, but there is no python essential on this CD?

                                                Looking forward to your reply,

                                                Stefanie

                                              • Stefanie.van.den.Berg
                                                5 Posts
                                                ACCEPTED ANSWER

                                                Re: SPSSINC MERGE TABLES not working

                                                ‏2014-05-22T07:55:32Z  in response to JonPeck

                                                I found how to download the python essentials! I think I will find out how to use the merge tables right now.. thanks for your help!

                                              • Stefanie.van.den.Berg
                                                5 Posts
                                                ACCEPTED ANSWER

                                                Re: SPSSINC MERGE TABLES not working

                                                ‏2014-05-22T08:56:55Z  in response to JonPeck

                                                And here I am again..

                                                I have downloaded the Python Essentials and the Extension commands. When it starts to run the Merge Tables command, the following error occurs:

                                                Warning # 6894. Command name: BEGIN PROGRAM

                                                The external program exit unexpectedly and lost its content, a new external

                                                program will startup to execute the rest of job.

                                                 Have you ever seen this before and do you know what is going on?

                                                • JonPeck
                                                  JonPeck
                                                  317 Posts
                                                  ACCEPTED ANSWER

                                                  Re: SPSSINC MERGE TABLES not working

                                                  ‏2014-05-22T12:15:34Z  in response to Stefanie.van.den.Berg

                                                  The Essentials are supposed to be on the CD.  You should be able to see them on the autoplay menu or at least in an obviously named directory on the disk.  The other option is to use the Passport Advantage site to down them.

                                                  I see you say that you downloaded the Essentials.  Presumably you ran the installer that you downloaded.  As a check, open a syntax window and run this code

                                                  begin program.
                                                  import spss
                                                  print 'ok'
                                                  end program.

                                                  If that works, then there might be a problem with the specific command.  If you can post an spv file and the MERGE TABLES syntax you are using, and we can take a look.

                                                   

                                                  • Stefanie.van.den.Berg
                                                    5 Posts
                                                    ACCEPTED ANSWER

                                                    Re: SPSSINC MERGE TABLES not working

                                                    ‏2014-05-22T12:27:41Z  in response to JonPeck

                                                    Thanks for your reply.

                                                    The begin programm command turns out red in my syntax. It says 'Syntax block is missing a closing period.'

                                                    Attached you find my syntax and output.

                                                    Attachments