X hits on this document

163 views

0 shares

0 downloads

0 comments

48 / 57

Statistics Package for the Social Science (SPSS)

Importing tab-delimited data

In SPSSWIN click on FILE OPEN DATA. Look in the appropriate location for the text file. Then select “Text” from “Files of type”: Click on the file name and then click on “Open.” You will see the Text Import Wizard – step 1 of 6 dialog box.

You will now have an SPSS data file containing the former tab-delimited data. You simply need to add variable and value labels and define missing values.

Exporting Data to Excel

click on FILE SAVE AS. Click on the File Name for the file to be exported. For the “Save as Type” select from the pull-down menu Excel (*.xls). You will notice the checkbox for “write variable names to spreadsheet.” Leave this checked as you will want the variable names to be in the first row of each column in the Excel spreadsheet. Finally, click on Save.

Document info
Document views163
Page views163
Page last viewedFri Dec 09 06:16:24 UTC 2016
Pages57
Paragraphs509
Words3812

Comments