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.
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
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
Can you provide additional information?
How detailed of info do you need. If I provide on example, do you think you could do the rest?
Art, CEO, AnalystFinder.com
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
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".
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.