Problem with Importing Data (Missing Values) from SAV to CSV to SmartPLS
Posted: Wed Oct 31, 2018 7:23 am
Hi,
I am struggling with the import of my CSV-Files in terms of missing values.
The data are covered in SAV-Files and missing values are coded with "-999999". I have a lot of those files and therefore I am using a script in R to automatically save them as CSV-Files in order to make them usable for PLS.
The CSV-Files seem to be correct, because the number of missing values is identical with the CSV-File I manually save from SPSS. So there is no mistake with the script from R. But when it comes to importing the data into SmartPLS (and after coding the missing values there!) the number of missing values is far below the actual number. The funny thing is, that if I do the same thing with the CSV-File, which I manually saved from SPSS, the number of missing values is correct.
So both CSV-Files have the same amount of missing values, but when I import them, one has less missing values than the other. Any ideas how to solve this? Or any suggestions where the problem is located?
Thanks in advance!
Best Regards
Flo
I am struggling with the import of my CSV-Files in terms of missing values.
The data are covered in SAV-Files and missing values are coded with "-999999". I have a lot of those files and therefore I am using a script in R to automatically save them as CSV-Files in order to make them usable for PLS.
The CSV-Files seem to be correct, because the number of missing values is identical with the CSV-File I manually save from SPSS. So there is no mistake with the script from R. But when it comes to importing the data into SmartPLS (and after coding the missing values there!) the number of missing values is far below the actual number. The funny thing is, that if I do the same thing with the CSV-File, which I manually saved from SPSS, the number of missing values is correct.
So both CSV-Files have the same amount of missing values, but when I import them, one has less missing values than the other. Any ideas how to solve this? Or any suggestions where the problem is located?
Thanks in advance!
Best Regards
Flo