Instructions for Reading SAT9 Data with Microsoft Excel Macro

1. Copy the correct year file to your computer and open it.
   Import97.xls(1998 administration)
   Import98.xls(1999 administration)
   Import99.xls(2000 administration)
2. When prompted, choose ENABLE MACROS.
3. Go to File/Open and open the SAT9 data file.
4. The import wizard will come up. Choose "Delimited" and hit the NEXT button.
5. Uncheck "tab" and hit NEXT again.
6. Select TEXT and hit the FINISH button. This imports the data into one row of the spreadsheet.
7. Hold down the CTRL key and press "i". Then goto the "tools" dropdown menu, choose macro -> macros, click on NCEandPRparser and click run.
8. Delete any variables you do not want to import into QSP by RIGHT-clicking on the column letter above the variable name and selecting delete.
9. Choose SAVE AS from the file menu. Choose FILE TYPE: CSV (COMMA DELIMITED). You now have a file that can be imported into QSP.
10. When importing data please make sure that the data is in the correct year as regulated by your school.

    If your are getting and error message:
    Please see the importing questions page: Here

Back to main download section