SPSS Statistics

SPSS Statistics

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


#Analytics
#SPSSStatistics
#Analyticstools
 View Only
  • 1.  Syntax for importing data from ODBC data source

    Posted 11/04/20 03:58 PM

    I am able to succesfully import data from a SQL DataWareHouse, but unlike when importing data from a local file I am not able to paste to get the used syntax.

    Is it possible to import data from a SQL DWH with only syntax?






    #SPSSStatistics
    #Support
    #SupportMigration


  • 2.  RE: Syntax for importing data from ODBC data source
    Best Answer

    Posted 11/04/20 04:30 PM

    If you are using the Database Wizard to generate the import, the last panel gives you the option to paste the syntax. It doesn't have a Paste button, but there is a radio button higher up in the panel.






    #SPSSStatistics
    #Support
    #SupportMigration