I've generated a data set (call this percentile.dta) that connect test scores to percentiles depending on the year and test type. I'm left with 5 variables: score, test1_percentile, test2_percentile, test3_percentile, test4_percentile.
I then have a different data set (call this score.dta) that has variables like test1_score, test2_score, test3_score, and test4_score for 400+ individual IDs, and I want to generate test1_percentile, test2_percentile, test3_percentile, test4_percentile for each ID. Each ID doesn't necessarily have values for all 4 test scores.
Is there a way to match test scores from score.dta to their respective percentiles in percentile.dta without merging the data? In a way, percentile.dta acts as the code to generate percentile variables.
I then have a different data set (call this score.dta) that has variables like test1_score, test2_score, test3_score, and test4_score for 400+ individual IDs, and I want to generate test1_percentile, test2_percentile, test3_percentile, test4_percentile for each ID. Each ID doesn't necessarily have values for all 4 test scores.
Is there a way to match test scores from score.dta to their respective percentiles in percentile.dta without merging the data? In a way, percentile.dta acts as the code to generate percentile variables.