Back to Browse

SPSS - How to Convert String Variables into Numeric?

6.0K views
May 28, 2024
14:47

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 formats

No download links available.

SPSS - How to Convert String Variables into Numeric? | NatokHD