SPSS Statistics

SPSS Statistics

Your hub for statistical analysis, data management, and data documentation. Connect, learn, and share with your peers! 

 View Only
Back to discussions
Expand all | Collapse all

/APPEND subcommand doesn't work in SAVE TRANSLATE

  • 1.  /APPEND subcommand doesn't work in SAVE TRANSLATE

    Posted Thu September 29, 2022 08:49 AM
    Edited by System Admin Fri January 20, 2023 04:43 PM
    Hello. Since June this year I've used SPSS 28.0.1.0 (142). It seems that SAVE TRANSLATE command may be bugged. I would like to create a single spreadsheet of a dataset containing two sheets - with values and second with labels. When I run the second instance of SAVE TRANSLATE with the same file path in /OUTFILE and /APPEND instead of /REPLACE I always get 6452 error. Back in version 27 I didn't encounter such problems. 
    *** VALUES.
    save translate
    /outfile = "test_2022-09-29.xlsx"
    /type = xls
    /version = 12
    /fieldnames value = names
    /cells = values
    /exceloptions sheet = "VALUES"
    /replace.
    execute.

    *** LABELS - /append generates 6452 error.
    save translate
    /outfile = "test_2022-09-29.xlsx"
    /type = xls
    /version = 12
    /fieldnames value = labels
    /cells = labels
    /exceloptions sheet = "LABELS"
    /append.
    execute.
    What could be a reason for this problem?

    Note: this problem occurs both in Unicode and Windows-1250 codepage.

    ------------------------------
    Konrad Gałuszko
    ------------------------------
    #SPSSStatistics


  • 2.  RE: /APPEND subcommand doesn't work in SAVE TRANSLATE

    Posted Fri September 30, 2022 09:48 AM
    Hi. I have the current version on my Mac at the moment (v29), and am not seeing this error. I'll install 28.0.1 later on and see if it replicates.

    ------------------------------
    Rick Marcantonio
    Quality Assurance
    IBM
    ------------------------------

    Original Message


Related Content