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

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 8
Accepted Solution

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

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.


Accepted Solutions
Solution
‎04-28-2017 12:40 PM
PROC Star
Posts: 7,433

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

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

 

View solution in original post


All Replies
PROC Star
Posts: 7,433

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

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

Occasional Contributor
Posts: 8

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

Can you provide additional information?  

 

PROC Star
Posts: 7,433

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

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

 

Art, CEO, AnalystFinder.com

 

Solution
‎04-28-2017 12:40 PM
PROC Star
Posts: 7,433

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

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

 

Occasional Contributor
Posts: 8

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

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 137 views
  • 0 likes
  • 2 in conversation