One of the biggest PROs to using SPSS is its familiar look and feel. When you open it – it almost feels like home – so familiar – so much like Excel! The rows representing individual cases or observations and the columns representing variables. Only thing, is that in SPSS the Data View – is just that – a view of the data, a container for the data. You cannot create any new variables in this view – in Excel we can move our cursor to a new cell and type in a formula – you CANNOT do this in SPSS.
Note at the bottom there are 2 tabs: Data View and Variable View. We are currently in the Data View. If you select the Variable View tab – things look a lot different from Excel. We now have rows to match our variables (or columns in the Data View) and the columns in the Variable View represent different pieces of information about our variables (or metadata).
Excel Data into SPSS
Let’s take a step back and work through an example of bringing a dataset into SPSS. For the purposes of this part of the workshop, please download the following 2018 Trial Data excel file. A small 10 observation file with 4 variables. Two of the variables contain letters and 2 are numbers for weight and height measurements.
Let’s work together and bring the file into SPSS. Believe it or not, it is as simple as doing the following:
- Navigate to the folder where you saved the data
- Change the Files of Type: to Excel
- Select the file
- Answer the Wizard questions
- Select the correct worksheet – if there are more than 1
- Double check the Preview to ensure that it looks correct
- When you are satisfied – Click OK
That was pretty straight forward wasn’t it?
Two things happened when you Clicked OK – SPSS opened a second window – the SPSS Statistics Viewer or Output window and your data popped into SPSS as we expected. In the Data View, notice the icons associated with each variable – we will talk more about these in a moment.
Click on Variable View – notice how your 4 variables are now listed as the rows and some of the information regarding the variables has been filled in. Let’s work through each one separately. I will talk about the first variable here, and you will fill in the remaining 3 variables as an exercise.
Name – lists the name of the variable as it was read in from Excel. Please note that you should keep these as small and as informative as possible. Please review the Best Practices for entering your data in Excel here.
The second column is the Type – if you select the word Type you will be presented with the options that are available to you in SPSS. Generally speaking we tend to primarily use the String and Numeric types. However, you may also have the occasion to use the Date type.
Width – is the width of the variable we have – so how many spaces are we willing to accept as data. For ID it is set to 3. You can change this at any time. Decimals goes along with the Width. Our data has no decimals, but you can change this at any time as well. Note that when we create new variables, SPSS will, by default assign 2 decimal places to the new variable.
Label – Ah… the lovely label. I highly recommend that you complete the Label and the next Values column if you plan to use SPSS for your analysis. It will save you a lot of time. So, what is it? Our variable names are short and sometimes not very informative. In this case, Weight? Weight of what? What units of measure were used? You can add all this information in the label field. How about for weight – Weight measured at 24 months of age in lbs. This comes in extremely handy if you are working with surveys and are using Q1, Q2, etc.. as variable names. In the label field you can add the entire question. What is really nice about this – when you run your statistics, in the output window rather than seeing weight or Q1, you will see the label you typed in here. So, if you’re like me – no more loose papers with notes!
I referred to the next column, Values, as another really handy one to have and to complete. When you click on Values you are presented with a small dialogue box where you can enter the Value and its Label. Let’s use an example: Treatment, many folks may use a numbering system for their treatments, so a 1, 2, 3, 4 or a lettering system, A, B, C, D. But no one knows what each treatment refers to. This is the spot where you can add that label. So if treatment 1 = 20% Iron; 2 = 25% Iron; 3 = No Iron; 4 = Control. We can add all of that here!
Missing is our next one. Another example – let’s say I have collected data and for one reason or another I have some missing data – maybe the equipment broke down one day, and one of the areas I was supposed to go measure was flooded and I couldn’t get to it. Chances are you are going to document that somewhere – in a lab book or your notes. But what about the data? We tend to leave it blank right? We have no data so we’ll leave it blank. Another way to handle it is to provide a value that is NOT a possible value for your data – so 999 for age or maybe 9999, and add that value to your dataset. Now, we don’t want it to be included in any statistical analysis, so in SPSS we add that value to the Missing column in Variable view.
Columns and Align – are ways to make your Data View prettier or neater.
Measure – ah the important one! You have 3 options:
We will review these in the workshop as they are VERY important when you go to run any statistics and creating Charts in SPSS.
The output window is where you will see all of your results and the log. The Log part of SPSS tells you what SPSS has done every step of the way and it also provides you with the syntax that SPSS used to get the results. Yes, one of the strengths to SPSS is its user-friendly interface, but if you want to learn to code in SPSS, that option is there as well! I’ll talk more about that in a bit.
How can you save your results in SPSS Output window? Well, you can just save them, but they will only be accessible when you are using the SPSS software. You can export them to PDF, Word, Excel, etc… by using the File – Export option. But, personally I really like the Copy and Paste option.
If you select the tables and/or charts you want to save for later, Copy the selected materials, then simply Paste them into your Word document. Works like a charm EXCEPT on a Mac. On the Macs, if you are trying to Copy and Paste a Chart you will need to Copy Special – select image, and then Paste it into Word. This has happened on a PC as well at times.
OK Paste Reset Cancel Help
When you start running any analysis in SPSS, you will recognize these 5 words – they appear everywhere. So a quick definition may be handy.
OK – go ahead and run the analysis
Paste – opens a Syntax window and will “paste” the syntax that SPSS will use to run the analysis you are trying to set up. If you want to learn how to write syntax in SPSS, this is a great way to do that!
Reset – reset the dialogue box to its original state
Cancel – we know this one
Help – we know this one as well.
A quick overview to get you started using SPSS.
One thought on “SPSS: Introduction and Getting the Data In”