Empty Excel Sheets into SPSS

[M'hammed Abdous]

Dear all,

I'm importing data from multiple Excel sheets. Some of the sheets have
empty cells, but I still need the variables name, format and type.

Using this syntax with:

GET DATA /TYPE=XLS
 /FILE=!pathSource + "\" + !gouv91 + !a1 +".XLS"
 /SHEET=name 'SancElev'
 /CELLRANGE=full
 /READNAMES=on
 /ASSUMEDSTRWIDTH=32767.

returns this error message:

>Warning.  Command name: GET DATA
>(2101) The column contained no recognized type; defaulting to
>"Numeric[8,2]"
>* Column 1


My manual workaround is to add manually add data into the Excel Sheet, and
delete it after it's imported using:

SELECT IF NOT INDEX(NumeSanc,".") GT 0.
SAVE OUTFILE=!pathDonnees+ !a1 + "\"+ !partie4+ "\4.4_" + !gouv91 + !a1
+ "_SancElev.sav".


Any suggestions to automate this process?

Thank you in advance.

M'hammed.

[Luca Meyer]

M'hammed,

This isn't actually an error but rather a warning. That is your data are not
affected by this message. SPSS is simply telling you that where it expected
a numeric value found a missing one - but it could indeed be that it found
an string too - and it substitute it with a missing value.

What I usually do in such a case is to ignore the warnings and to substitute
missing values with the desired numeric value afterwards.

HTH,
Luca

Mr. Luca MEYER
Market research, data analysis & more
www.lucameyer.com - Tel: [phone]


-----Messaggio originale-----
Da: SPSSX(r) Discussion [mailto:[hidden email]] Per conto di
M'hammed Abdous
Inviato: domenica 9 settembre 2007 19.00
A: [hidden email]
Oggetto: Empty Excel Sheets into SPSS

Dear all,

I'm importing data from multiple Excel sheets. Some of the sheets have empty
cells, but I still need the variables name, format and type.

Using this syntax with:

GET DATA /TYPE=XLS
 /FILE=!pathSource + "\" + !gouv91 + !a1 +".XLS"
 /SHEET=name 'SancElev'
 /CELLRANGE=full
 /READNAMES=on
 /ASSUMEDSTRWIDTH=32767.

returns this error message:

>Warning.  Command name: GET DATA
>(2101) The column contained no recognized type; defaulting to
>"Numeric[8,2]"
>* Column 1


My manual workaround is to add manually add data into the Excel Sheet, and
delete it after it's imported using:

SELECT IF NOT INDEX(NumeSanc,".") GT 0.
SAVE OUTFILE=!pathDonnees+ !a1 + "\"+ !partie4+ "\4.4_" + !gouv91 + !a1
+ "_SancElev.sav".


Any suggestions to automate this process?

Thank you in advance.

M'hammed.

No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.485 / Virus Database: 269.13.12/997 - Release Date: 09/09/2007
10.17


No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.485 / Virus Database: 269.13.12/997 - Release Date: 09/09/2007
10.17