Exporting Large data Set from Excel to SPSS

[Manoj Arora (DEL/Abacus Analytics)]

Hi,

 

I have a dataset in excel with 25 variables and app 600,000 records. When I am importing this file in SPSS it is importing only 22404 records. I tried each and every option. Please suggest.

 

Regards

Manoj

 

Kantar Disclaimer ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

[Rick Oliver-3]

What version of SPSS Statistics? What version of Excel?

This syntax creates 700,000 cases, 30 variables, and exports to XLSX, then imports the XLSX data back into SPSS Statistics. All 700,000 cases are there when I run it. (Note that it takes a while to export and import the file.)

input program.
loop #i=1 to 700000.
do repeat x=var1 to var30.
compute x=trunc(rv.uniform(1,11)).
end repeat.
end case.
end loop.
end file.
end input program.
execute.

SAVE TRANSLATE OUTFILE='C:\TEMP\longfile.xlsx'
  /TYPE=XLS
  /VERSION=12
  /FIELDNAMES
  /CELLS=VALUES
  /REPLACE.

GET DATA
  /TYPE=XLSX
  /FILE='C:\TEMP\longfile.xlsx'
  /SHEET=name 'longfile'
  /CELLRANGE=FULL
  /READNAMES=ON.

Rick Oliver
Senior Information Developer
IBM Business Analytics (SPSS)
E-mail: [hidden email]



From:        "Arora, Manoj (IMDLR)" <[hidden email]>
To:        [hidden email]
Date:        01/29/2016 02:16 AM
Subject:        Exporting Large data Set from Excel to SPSS
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

Hi,
 
I have a dataset in excel with 25 variables and app 600,000 records. When I am importing this file in SPSS it is importing only 22404 records. I tried each and every option. Please suggest.
 
Regards
Manoj
 

Kantar Disclaimer
===================== To manage your subscription to SPSSX-L, send a message to LISTSERV@...(not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

[Maguin, Eugene]

More details would be nice. How are you importing? ODBC? Get Data? file->open? Get Translate?  Any warnings or errors? Exact text please always useful. Turning from the import operation, is there anything about record 22405 that is different from record 22404? Have you looked at the failure point records in excel?

Gene Maguin

 

 

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Arora, Manoj (IMDLR)
Sent: Friday, January 29, 2016 3:16 AM
To: [hidden email]
Subject: Exporting Large data Set from Excel to SPSS

 

Hi,

 

I have a dataset in excel with 25 variables and app 600,000 records. When I am importing this file in SPSS it is importing only 22404 records. I tried each and every option. Please suggest.

 

Regards

Manoj

 

Kantar Disclaimer

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

[Art Kendall]

Please post the     syntax you are using.

If you are using the GUI to draft your syntax, just exit via the <paste> button.