Problem with SPSS data import

[cyberian]

@all problems with:

"Column XX (in my case 21, 25 and 57) has less or more lines than column 0"

The problem is probably that you named your variables in the first row all the same (or in your case 4x the same).

variablenames have to be unique!!

just rename them and everything should be fine. maybe this will get fixed and the variables automaticly renamed!

greets torben johannsen

[schroer]

Hi all,

because this topic seems to come up again every now and then, I thought I might point out that data management has become much easier using SPSS 15.

1) Using a SPSS Syntax like

SAVE TRANSLATE OUTFILE='FILENAME.XLS'
/TYPE=XLS
/MISSING=RECODE
[...] .

and only keeping numeric variables, of course, will produce a clean XLS with all missing values set to #NULL!. (The "/MISSING" option only exists in current versions of SPSS.)

2) The #NULL! values can then be replaced conveniently by a common value such as -99 to be used in SmartPLS (e.g. using an Excel macro).

3) Saving the XLS file as CSV will produce a clean and ready to use data file that can be imported into SmartPLS.

So far, I never had any problems with this procedure. I find that exchanging data between SPSS and SmartPLS and keeping the data sets consistent is much easier now. :-)

Best wishes from Wuerzburg,

Joachim

[els van de velde]

Hi,

I have a problem with importing data from the excel file (saved as a csv file) into PLS.

In case I use a komma "," in the excel file, I get the remark in PLS that every row (e.g. 1, 2, 3, ... has more or less columns than the header).

In case I use ";" in the excel file, I get the remark in PLS that for every row that it has an Invalid DOUBLE value in row xxx, column 0.

How can I solve these problems?
I would really like to continue to work with PLS.

Kind regards,
Els

[GDAVE]

I am having problem importing data from SPSS. From SPSS I saved the data set as an excel file, then saved it as a tab-delimted text file and then imported the file into SmartPLS. It only saves 10 rows (1 name + 9 data).
I had tried various recommendations available at this post, but none seems to work for me.
Please help.

Thanks

[Diogenes]

Hi George,
if the data base icon is green, everything is OK.

Run your model,
in the report you will see the complete data base:
Model / Specification / Manifest Variable Scores (Original)

Best regards.
Bido

[GDAVE]

Thanks Dr. Bido,
I see the entire dataset in the report.

Regards,
George

[normalinimk]

Hi SmartPls team

Im having problem with datafile conversion. Convert from SPSS follow CR steps in this blog. But after import to PLS. Shown ? with red color. How do I solve this issue? Please help. Thanks

Rgds
Lin

[Diogenes]

Hi,

In the data set, look for:
- Strings
- Missing values
- Special formats ($ etc.)

When I can not find the problem, I copy/past (the part of spreadsheet with data) to a new spreadsheet and I save it as *.csv.

Best regards,

Bido