topic Re: Convert the new SAT scores to the old SAT scores for the Common Data Set in SAS Programming

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

kfwright23 — Thu, 27 Apr 2017 19:15:05 GMT

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.

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

art297 — Thu, 27 Apr 2017 19:25:55 GMT

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

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

kfwright23 — Thu, 27 Apr 2017 21:34:07 GMT

Can you provide additional information?

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

art297 — Thu, 27 Apr 2017 21:36:52 GMT

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

Art, CEO, AnalystFinder.com

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

art297 — Thu, 27 Apr 2017 22:04:59 GMT

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

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

kfwright23 — Fri, 28 Apr 2017 16:44:47 GMT

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".