SPSS - How to Convert String Variables into Numeric?
DESCRIPTION: Converting string variables into numeric ones can be done in variable view. However, a better option is fixing all variables with a single line of syntax such as ALTER TYPE V01 TO V10 (F8.2). Now, whatever method you choose, things get tricky if -values have a period or comma as decimal separator, -empty cells or even -illegal characters in some values. Sadly, none of the other videos deal with these common issues. So in this SPSS beginners video, I'll show how to do this the right way. Hope it helps! TIMESTAMPS: 01:39 example 1 - convert variable without decimals 04:01 SPSS f-format: "standard numeric" 05:54 example 2 - convert variable with period as decimal separator 07:20 SPSS comma format: period as decimal separator 08:22 example 3 - convert variable with comma as decimal separator 10:32 SPSS dot format: comma as decimal separator 11:32 WARNING: values may disappear when converting string variables! RESOURCES: Download example data file from: https://www.spss-tutorials.com/downloads/spss-string-to-numeric-variable.sps Download final syntax file from: https://www.spss-tutorials.com/downloads/string-to-numeric.sav FOLLOW US: Complete SPSS beginners course on Udemy: https://tinyurl.com/spss-beginners-course Official website: https://www.spss-tutorials.com/ YouTube: https://www.youtube.com/@statistics-made-simple LinkedIn: https://www.linkedin.com/company/spss-tutorials/ Facebook: https://www.facebook.com/spss.tutorials.website/ #spss #dataanalysis
Download
0 formatsNo download links available.