Skip to content

Instantly share code, notes, and snippets.

@Btibert3
Last active October 13, 2015 00:28
ACT to SAT Concordance
## act to sat concordance chart
## http://www.act.org/aap/concordance/pdf/reference.pdf
act <- (36:11)
sat <- c(1600, 1560, 1510, 1460, 1420, 1380, 1340, 1300, 1260, 1220, 1190,
1150, 1110, 1070, 1030, 990, 950, 910, 870, 830, 790, 740, 690, 640,
590, 530)
act2sat <- data.frame(act, sat)
// Concordance chart is found http://www.act.org/aap/concordance/pdf/reference.pdf
IF [ZAVUADM_SACT_SCORE] = 36 THEN 1600
ELSEIF [ZAVUADM_SACT_SCORE] = 35 THEN 1560
ELSEIF [ZAVUADM_SACT_SCORE] = 34 THEN 1510
ELSEIF [ZAVUADM_SACT_SCORE] = 33 THEN 1460
ELSEIF [ZAVUADM_SACT_SCORE] = 32 THEN 1420
ELSEIF [ZAVUADM_SACT_SCORE] = 31 THEN 1380
ELSEIF [ZAVUADM_SACT_SCORE] = 30 THEN 1340
ELSEIF [ZAVUADM_SACT_SCORE] = 29 THEN 1300
ELSEIF [ZAVUADM_SACT_SCORE] = 28 THEN 1260
ELSEIF [ZAVUADM_SACT_SCORE] = 27 THEN 1220
ELSEIF [ZAVUADM_SACT_SCORE] = 26 THEN 1190
ELSEIF [ZAVUADM_SACT_SCORE] = 25 THEN 1150
ELSEIF [ZAVUADM_SACT_SCORE] = 24 THEN 1110
ELSEIF [ZAVUADM_SACT_SCORE] = 23 THEN 1070
ELSEIF [ZAVUADM_SACT_SCORE] = 22 THEN 1030
ELSEIF [ZAVUADM_SACT_SCORE] = 21 THEN 990
ELSEIF [ZAVUADM_SACT_SCORE] = 20 THEN 950
ELSEIF [ZAVUADM_SACT_SCORE] = 19 THEN 910
ELSEIF [ZAVUADM_SACT_SCORE] = 18 THEN 870
ELSEIF [ZAVUADM_SACT_SCORE] = 17 THEN 830
ELSEIF [ZAVUADM_SACT_SCORE] = 16 THEN 790
ELSEIF [ZAVUADM_SACT_SCORE] = 15 THEN 740
ELSEIF [ZAVUADM_SACT_SCORE] = 14 THEN 690
ELSEIF [ZAVUADM_SACT_SCORE] = 13 THEN 640
ELSEIF [ZAVUADM_SACT_SCORE] = 12 THEN 590
ELSEIF [ZAVUADM_SACT_SCORE] = 11 THEN 530
END
//the calc above is saved as [ACT 2 SAT]
IIF(MAX([ACT 2 SAT], ZN([ZAVUADM_HIGH_SATC])) = 0, NULL, MAX([ACT 2 SAT], ZN([ZAVUADM_HIGH_SATC])))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment