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

Linking NBER 2012 November Supplement to IPUMS CPS November 2012 Data Extract
is it possible to extract ipums-cps data with some cps original technical var...
documentation linking CPS variable names and IPUMS-CPS variable names
Merge IPUMS CPS and CEPR CPS
Login   |   Register

Recently Active Members

View More »

Share |