SPSS Statistics

SPSS Statistics

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

 View Only
  • 1.  How to import a data base keeping variable labels/tags?

    Posted Wed March 10, 2021 09:41 PM

    I've imported a data base using both syntax and data files, but when I execute it from the syntax file, the file does not keep the variables names and values.

    However, the syntax file recognices them initially, every single variable.

    Help, please.






    #SPSSStatistics
    #Support
    #SupportMigration


  • 2.  RE: How to import a data base keeping variable labels/tags?

    Posted Wed March 10, 2021 09:46 PM


  • 3.  RE: How to import a data base keeping variable labels/tags?

    Posted Wed March 10, 2021 10:11 PM

    Please explain more about exactly what you are doing and what you see.






    #SPSSStatistics
    #Support
    #SupportMigration


  • 4.  RE: How to import a data base keeping variable labels/tags?

    Posted Wed March 10, 2021 10:17 PM

    Hello Jon

    Syntax shows me the value labels, but I can't command it to apply them to the database, so the labels are gone, and when I execute the data, it shows this:







    #SPSSStatistics
    #Support
    #SupportMigration


  • 5.  RE: How to import a data base keeping variable labels/tags?

    Posted Wed March 10, 2021 10:33 PM

    Unfortunately , this site doesn't allow images :-( You could email them to me at jkpeckSupport Member? What database?






    #SPSSStatistics
    #Support
    #SupportMigration


  • 6.  RE: How to import a data base keeping variable labels/tags?

    Posted Wed March 10, 2021 10:40 PM

    Oh that's a shame, I will copy the text down here to explain myself better:

    SET UNICODE=ON.

    SHOW LOCALE.

    PRESERVE LOCALE.

    SET LOCALE='en_UK'.

    GET DATA

     /TYPE=TXT

     /FILE='G:\.shortcut-targets-by-id\16uD4UBTVaTD2zSN-Z0T3HY8NjaH8J77b\GISaMA\Salud Mental- COVID\Datos SPSS\survey_736664_SPSS_data_file.dat'

     /DELCASE=LINE

     /DELIMITERS=","

     /QUALIFIER="'"

     /ARRANGEMENT=DELIMITED

     /FIRSTCASE=1

     /IMPORTCASE=ALL

     /VARIABLES=

     V1 F7

     V2 A16

     V3 DATETIME23.2

     V5 A19

     V6 DATETIME23.2

     V7 DATETIME23.2

     V8 F13.12

     V9 F1

     V10 F1

    ---------------------------------------------------------------------

    ARIABLE LABELS V6 "startdate".

    VARIABLE LABELS V7 "datestamp".

    VARIABLE LABELS V8 "¿Cuál es tu edad?".

    VARIABLE LABELS V9 "¿Cuál es tu sexo biológico?".

    VARIABLE LABELS V10 "[Otro] ¿Cuál es tu sexo biológico?".

    VARIABLE LABELS V11 "[Pública/s] La/s institución/es de salud en la/s cual/es trabajas es/son:".

    ---------------------------------------------------------------------

    (Variable name)

    V1 Numérico 3 0 Ninguno

    V2 Numérico 1 0 Ninguno

    V3 Fecha 22 2 Ninguno

    V4 Cadena 2 0 Ninguno

    V5 Fecha 22 2 Ninguno

    V6 Fecha 22 2 Ninguno

    V7 Numérico 13 10 Ninguno

    V8 Numérico 1 0 Ninguno



    The first two are from the syntax, and the latter is from the data sheet.


    I used LimeSurvey to download these data.


    When I executed the file from the syntax to show me the data, value labels are lost, instead of, for example sociodemographic variables to show age, sex, etc., turns into V3, V4.






    #SPSSStatistics
    #Support
    #SupportMigration


  • 7.  RE: How to import a data base keeping variable labels/tags?

    Posted Wed March 10, 2021 10:50 PM

    Where are you looking for these to appear? If you run a procedure, what do you see. Images would be helpful.






    #SPSSStatistics
    #Support
    #SupportMigration