Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Referencing outside data set to generate new variables

    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.
Working...
X