I am trying to figure out how many accounts this individual created to play games from 2013 to 2019. Also, I am trying to link all the scores that were played in the same account. The score array indicates the scores in the year 2013 to 2019. A score of (-1) indicates no scores were recorded in that year. Array score {4, 10} score_2013_1-score_2013_3 score_2015_1-score_2015_3 score_2017_1-score_2017_3 score_2019_1-score_2019_3; The rank array indicates the rank of the scores (lowest score is 1) in the year 2013 to 2019. A rank (-1) value also indicates no score and no ranking. Array rank{4, 3} rank_2013_1-rank_2013_3 rank_2015_1-rank_2015_3 rank_2017_1-rank_2017_3 rank_2019_1-rank_2019_3; The prevrank array is used to the link the rank of current year to the previous year. The prevrank rank greater than 0 indicates the rank of the player scored in the previous year on the same account. If the score and the rank are both greater than 0 and the prevrank is (-1), then this score was recorded on a new account that the individual created. In 2013, all the scores recorded on new accounts. prevrank_2013_1-prevrank_2013_3 are all going to (-1). Array prevrank{4, 3} prevrank_2013_1-prevrank_2013_3 prevrank_2015_1-prevrank_2015_3 prevrank_2017_1-prevrank_2017_3 prevrank_2019_1-prevrank_2019_3 ; data example; input score_2013_1-score_2013_3 score_2015_1-score_2015_3 score_2017_1-score_2017_3 score_2019_1-score_2019_3 rank_2013_1-rank_2013_3 rank_2015_1-rank_2015_3 rank_2017_1-rank_2017_3 rank_2019_1-rank_2019_3 prevrank_2013_1-prevrank_2013_3 prevrank_2015_1-prevrank_2015_3 prevrank_2017_1-prevrank_2017_3 prevrank_2019_1-prevrank_2019_3; datalines; 1 2 3 -1 -1 -1 11 3 12 17 18 19 1 2 3 -1 -1 -1 2 1 3 1 2 3 -1 -1 -1 -1 -1 -1 3 -1 1 -1 2 3 run; In the example, this individual recorded three scores in 2019 score_2019_1= 17 and ranked rank_2019_1=1 score_2019_2=18 and ranked rank_2019_2=2 score_2019_3=19 and ranked rank_2019_3=3. Linking: prevrank_2019_1=-1, which indicates the score was recorded on a new account that the individual created in 2019. prevrank_2019_2= 2, indicates that this was scored on an account which ranked 2nd in the previous year. prevrank_2019_3= 3, indicates that this was scored on an account which ranked 3rd in the previous year. If the score and rank are all -1 in a year, then the link would continue to the year before where all score and rank are non negatives. I would like to create an array which will display all the scores made on each account for this individual (the most recent score to the older score). In the example, the player created 5 accounts from 2013 to 2019 and the scores in each account are: Account1scores1-Account1scores3 (17) Account2scores1-Account2scores4 (18, 11, 2) Account3scores1-Account3scores2 (19, 12, 1) Account4scores1-Account4scores2 (3) Account5scores1-Account5scores1 (3) data want; input account1score1-account1score3 account2score1-account2score3 account3score1-account3score3 account4score1-account4score3 account5score1-account5score3; datalines; 17 . . . . 18 11 2 . . 19 12 1 . . 3 . . . . 3 . . . . run; Thank you for you feedbacks.
... View more