Convert the new SAT scores to the old SAT scores for the Common Data Set

[kfwright23]

Has anyone developed SAS code to convert the new SAT scores to the old SAT scores to complete the Common Data Set?  I am specifically looking for code for total or composite scores and subscores. My university’s Student Information System captures the old test/subtests and the new test/subtests in different fields. As an analyst in Institutional Research, the table found on www.sat.org/concordance does not meet my needs.

[art297]

Can't you just download and import the workbook at: https://collegereadiness.collegeboard.org/xls/concordance-tables-new-sat-scores-old-sat-scores.xls

and then use those tables to create formats (using proc format cntlin=) for converting each set of scores?

Art, CEO, AnalystFinder.com

[kfwright23]

Can you provide additional information?  

[art297]

How detailed of info do you need. If I provide on example, do you think you could do the rest?

Art, CEO, AnalystFinder.com

[art297 · Accepted solution]

Here is an example, converting the total2400 scores.

Depending upon which engine you can use to import the xlsx file, the resulting variable names might be different:

proc import datafile="c:\art\concordance-tables-new-sat-scores-to-old-sat-scores.xlsx" 
    out=forfmt replace dbms=excel;
  getnames=no;
  datarow=3;
  sheet='Table 1 (Total 2400)';
run;

data forfmt;
  set forfmt (rename=(f1=start f2=label));
  retain fmtname 'sat2400t' type 'N';
run;

proc format cntlin = forfmt;
run;

data want;
  input newsat;
  oldsat=put(newsat,sat2400t.);
  cards;
450
510
1110
;

Art, CEO, AnalystFinder.com

[kfwright23]

Thank you for the code! It worked.  I also thank you for drawing my attention to the Concordance Tables that I initially overlooked because I was only focused on the "tools".