Posts filed under '1. Getting data into SPSS'

Importing data from an ASCII file

1.5

First refer to Importing data into SPSS. If you have read it, than you can continue below.
Typically, columns of data in an ASCII file are separated by a space, tab, comma, or some other character. SPSS has a Text Import Wizard that will help you import data in an ASCII file format:

1. Select File -> Open -> Data
2. Choose Text as the File Type if your ASCII file has the .txt extension. Otherwise you could choose the option All files
3. Select the file you want to import and click Open

Importing an ASCII file Open File

3 comments May 3rd, 2006 andris

Import data from an Excel file

1.5

First refer to Importing data into SPSS. If you have read it, than you can continue below.
Before you start the actual import process, please keep in mind that the Excel file should not be opened in Excel.

1. Select File -> Open -> Data
2. Choose Excel as the File Type
3. Select the file you want to import and click Open

Importing Excel file Open Excel Data Source 

3 comments May 3rd, 2006 andris

Import data from a tab delimited text file

1.5

First refer to Importing data into SPSS. If you have read it, than you can continue below.

1. Select File -> Open -> Data
2. Choose Text as the File Type
3. Select the file you want to import and click Open

Open tab delimited text file

4. The next thing that will pop up is the Import text wizard. First click Next if your file does not match a predefined format. It probably doesn’t, so click Next. :) 

Importing a tab delimited text file step 1

5. In step 2, you can set the first question to Delimited. In the second question you choose wether you have a header row or not (are variables names included in the top of the file). After setting the options right, choose Next.

2 comments May 3rd, 2006 andris

Importing Excel file into SPSS

This weekend we got a question from Zakya, who desperately needs information on how to import Excel data into SPSS.

Actually, importing from SPSS is not that hard at all. But before you import, there are some steps to take to make importing more easy:

- Close the Excel file (otherwise SPSS will give an error message)
- Make a header row in Excel with column names (keep them brief and descriptive)
- Do not mix up numbers and text in the same column

3 comments April 10th, 2006 andris


Calendar

July 2008
M T W T F S S
« Oct    
 123456
78910111213
14151617181920
21222324252627
28293031  

Posts by Month

Posts by Category