Archives

I met a SPSS user last week that worked with very big numbers and wanted to add 2 together as a key variable. You will get problem if the variable you work with has a format bigger than 17 [...]

If you have a lot of similar string variables that you would like to convert to numeric, then you should be aware of the smart recoding for all at the same time. Let’s start with this [...]

I got a question from my French colleague and the question was how to convert these 2 numeric variables to string variables and then put them together to a new stringvariable with the CONCAT [...]

I got this question last week, “What is the maximum length of string variables?” See the example of the string variable to the right in this data file: Many years ago I remember the [...]

I got a question from a user who wanted to know if there were a smart way to recode string variables – that was automatically created when opening an Excel data file into SPSS Statistics. [...]

You can open other data files into SPSS Statistics and the most common, I Think, is an Excel data file. Here below you see an Excel data file. I have marked a yellow Square around all columns [...]

Next Monday I will show you how easy it is to do an automatic recode of string variables to numeric variables, but you will get the alphabetic order and there were a user who asked for an own [...]

Hi, last week I got the question how to place the 3 first characters from a variable to a new one. Here is my example data file: