Question

Status:Closed    Asked:Jun 11, 2014 - 10:52 AM

I received my IPUMS CPS extract but cannot move it into SPSS. Is theresomeone I can call who can guide me?

 
Do you have the same question? Follow this Question
 

Staff Answer

avatar

Joe_Grover

Staff

IPUMS-CPS provides an excellent tutorial video series including a video that walks through the process of opening a data extract in SPSS step-by-step. There is also a basic set of instructions if you prefer text based instruction.

I hope this helps.

 

Jun 11, 2014 - 11:27 AM

0
1
Report it
avatar

Joe_Grover

Staff

To insure that there was no error in the creation of your data extract, I downloaded it myself and was able to open the file in SPSS. Here are the steps I followed:

1) From your Download and Revise Extracts page, download the SPSS syntax file by right-clicking on the link and selecting "Save Target As..." (if you are using Chrome as you web browser you would select "Save Link As...") and saving the file to a specific directory (I saved the file in a folder on my desktop).

2) Download the Data file to the same folder you saved your SPSS syntax file. The data file will be named cps_00001.dat.gz

3) Use a program like 7-zip to unzip the file (if you are using a Mac you can simply double-click the zipped file).

4) Open SPSS and select File -> Open -> Syntax and navigate to your SPSS syntax file (called cps_00001.sps)

5) Edit the line near the top of the Syntax file that reads: cd ".". replacing the "." with the path to your data file. You can find the path to your data file by right clicking on the data file and selecting Properties, there should be a field called Location: which gives the path to your data file. Since I save my file in a New Folder on my Desktop the cd line reads cd "C:\Users\Joe_Grover\Desktop\New folder". (if you are using a Mac this will look something "/Users/Joe_Grover/Desktop/New folder").

6) Save your change to the Syntax file.

7) In the Syntax Editor window you have been working in, select Run -> All

If you are still having issues opening the data file in SPSS, respond to this answer with which step is giving you issues.

 

Jun 11, 2014 - 12:31 PM

0
0
Report it

Answers

Your answer does not help. I already tried the instructions and cannot make them work.

 

Jun 11, 2014 - 11:32 AM

0
0
Report it
avatar

Joe_Grover

Staff

To insure that there was no error in the creation of your data extract, I downloaded it myself and was able to open the file in SPSS. Here are the steps I followed:

1) From your Download and Revise Extracts page, download the SPSS syntax file by right-clicking on the link and selecting "Save Target As..." (if you are using Chrome as you web browser you would select "Save Link As...") and saving the file to a specific directory (I saved the file in a folder on my desktop).

2) Download the Data file to the same folder you saved your SPSS syntax file. The data file will be named cps_00001.dat.gz

3) Use a program like 7-zip to unzip the file (if you are using a Mac you can simply double-click the zipped file).

4) Open SPSS and select File -> Open -> Syntax and navigate to your SPSS syntax file (called cps_00001.sps)

5) Edit the line near the top of the Syntax file that reads: cd ".". replacing the "." with the path to your data file. You can find the path to your data file by right clicking on the data file and selecting Properties, there should be a field called Location: which gives the path to your data file. Since I save my file in a New Folder on my Desktop the cd line reads cd "C:\Users\Joe_Grover\Desktop\New folder". (if you are using a Mac this will look something "/Users/Joe_Grover/Desktop/New folder").

6) Save your change to the Syntax file.

7) In the Syntax Editor window you have been working in, select Run -> All

If you are still having issues opening the data file in SPSS, respond to this answer with which step is giving you issues.

 

Jun 11, 2014 - 12:31 PM

0
0
Report it

OTHER QUESTIONS NEEDING ANSWERS

Change in CPS EMPSTAT (A-LFSR Labor force status recode) in 2001?
I have an extract 2001 to 2015. Total number of people: 4 million, but in bir...
Why are there fewer counties in the 1950 1% sample compared to the 1940 1% sa...
Is the value of INCWKCOM included in the value of INCDISAB?
Trying to access CPS online analysis tool
ACS METRO variable construction
Login   |   Register

Recently Active Members

View More »

Share |