Importing data problems (non-integral values)

Questions about the implementation and application of the PLS-SEM method, that are not related to the usage of the SmartPLS software.
Post Reply
Tatiana
PLS Junior User
Posts: 2
Joined: Mon Jun 11, 2018 10:57 am
Real name and title: Dr. Tatiana Andreeva

Importing data problems (non-integral values)

Post by Tatiana »

Hello everyone,
I am importing my data to SmartPLS and seems it does not import correctly.
My data is a combination of usual latent variables and pre-calculated indices that I am going to use as "observed" variables. These indices are mostly non-integral numbers (e.g., 4.58999 or 3.3333). I did this pre-calculations in SPSS, saved my data in csv. formal and exported it in SmartPLS. And I noticed that my data was not exported correctly. The non-integral variables get transformed in a crazy way - they get weird means, mins-max, etc. Could you please advise me how to solve this? Or SmartPLS cannot handle such data?

With many thanks
Tatiana
jmbecker
SmartPLS Developer
Posts: 1282
Joined: Tue Mar 28, 2006 11:09 am
Real name and title: Dr. Jan-Michael Becker

Re: Importing data problems (non-integral values)

Post by jmbecker »

You need to take care about both the symbol separating the different values in the columns (e.g., ";") and the symbol indicating the decimal point. For the second, you can choose between the European standard (i.e., use a "," as decimal separator) or the Anglo-American standard (i.e., use a "." as decimal separator). Based on your example, you want to choose the "."
Dr. Jan-Michael Becker, BI Norwegian Business School, SmartPLS Developer
Researchgate: https://www.researchgate.net/profile/Jan_Michael_Becker
GoogleScholar: http://scholar.google.de/citations?user ... AAAJ&hl=de
Tatiana
PLS Junior User
Posts: 2
Joined: Mon Jun 11, 2018 10:57 am
Real name and title: Dr. Tatiana Andreeva

Re: Importing data problems (non-integral values)

Post by Tatiana »

Thanks a lot!
Post Reply