Bysort and egen code not carrying over correct data

[Alejandra Gomez]

Hello,

I have a long data set containing college enrollment data by term, multiple instances per student ID. If a student enrolled 10 terms in college, there will be 10 date rows per ID. The date data variables include high school graduate date, enrollment begin (college) enrollment (end) college and graduation date (college). Each date is in a separate column, my issue is occurring specifically in graduation_date.

The graduated variable is marked N or Y if a student graduated college. I created a variable (degree) to note N = 0 and Y = 1. Then ran code

by randomid, sort: egen college_grad = max(degree)

to create college_grad and carry over that 1 to each observation by student ID.

I want to now carry over graduation_date by each observation where college_grad is 1. I did this with code

bys randomid: egen degree_date=max(graduation_date)

graduation date carries over to degree_date variable, but not in all instances does graduation_date match degree_date. Graduation date will be June 08, 2020 and under degree_date it will be noted as May 20, 2022. It happens in multiple instances. I noticed the first one in row 221, which is more than dataex shows. Can someone help troubleshoot my coding?


I also formatted the dates using

 foreach var of varlist enrollment_begin enrollment_end graduation_date high_school_grad_date degree_date {
replace `var' = date(string(`var' ,"%08.0f"),"YMD")
format %td `var'
}

Essentially what I am trying to do is convert the different dates to terms in order to run length of time between each date, over time

* Example generated by -dataex-. For more info, type help dataex
clear
input double randomid long(high_school_grad_date enrollment_begin enrollment_end) str1 graduated long graduation_date float(degree college_grad degree_date)
2103300231 22804 22886 22997 "N"     . 0 0     .
2103300237 22804     .     . "N"     . 0 0     .
2103300243 22804     .     . "N"     . 0 0     .
2103300255 22069 22886 22997 "N"     . 0 0     .
2103300255 22069 22312 22408 "N"     . 0 0     .
2103300255 22069 22522 22633 "N"     . 0 0     .
2103300255 22069 22432 22497 "N"     . 0 0     .
2103300255 22069 22432 22505 "N"     . 0 0     .
2103300255 22069 22662 22773 "N"     . 0 0     .
2103300255 22069 22158 22262 "N"     . 0 0     .
2103300264 22069 22508 22631 "N"     . 0 0     .
2103300264 22069 22144 22267 "N"     . 0 0     .
2103300264 22069 22872 22995 "N"     . 0 0     .
2103300264 22069 22872 22996 "N"     . 0 0     .
2103300264 22069 22663 22789 "N"     . 0 0     .
2103300264 22069 22872 22995 "N"     . 0 0     .
2103300264 22069 22872 22996 "N"     . 0 0     .
2103300267 21705 22817 22836 "N"     . 0 0     .
2103300267 21705 22067 22074 "N"     . 0 0     .
2103300267 21705 22515 22630 "N"     . 0 0     .
2103300267 21705 21780 21903 "N"     . 0 0     .
2103300267 21705 22879 22996 "N"     . 0 0     .
2103300267 21705 22144 22210 "N"     . 0 0     .
2103300267 21705 21927 22056 "N"     . 0 0     .
2103300267 21705 22690 22806 "N"     . 0 0     .
2103300282 21341     .     . "N"     . 0 0     .
2103300291 20977     .     . "N"     . 0 0     .
2103300321 22804     .     . "N"     . 0 0     .
2103300336 21340 22676 22792 "N"     . 0 0     .
2103300336 21340 22883 22995 "N"     . 0 0     .
2103300426 22440     .     . "N"     . 0 0     .
2103300477 21341 21409 21532 "N"     . 0 0     .
2103300477 21341 21927 22056 "N"     . 0 0     .
2103300477 21341 21563 21692 "N"     . 0 0     .
2103300477 21341 22872 22995 "N"     . 0 0     .
2103300477 21341 22299 22425 "N"     . 0 0     .
2103300477 21341 22144 22267 "N"     . 0 0     .
2103300477 21341 21780 21903 "N"     . 0 0     .
2103300477 21341 22879 22995 "N"     . 0 0     .
2103300477 21341 22872 22996 "N"     . 0 0     .
2103300477 21341 22515 22631 "N"     . 0 0     .
2103300477 21341 22797 22873 "N"     . 0 0     .
2103300477 21341 22067 22141 "N"     . 0 0     .
2103300477 21341 22669 22785 "N"     . 0 0     .
2103300477 21341 22872 22996 "N"     . 0 0     .
2103300477 21341 22872 22995 "N"     . 0 0     .
2103300495 20977 21409 21431 "N"     . 0 0     .
2103300495 20977 21200 21328 "N"     . 0 0     .
2103300552 21705 22515 22626 "N"     . 0 0     .
2103300552 21705 21927 22056 "N"     . 0 0     .
2103300552 21705 22879 22990 "N"     . 0 0     .
2103300552 21705 22319 22437 "N"     . 0 0     .
2103300552 21705 21780 21903 "N"     . 0 0     .
2103300552 21705 22151 22262 "N"     . 0 0     .
2103300552 21705 22683 22801 "N"     . 0 0     .
2103300552 21705 22144 22267 "N"     . 0 0     .
2103300552 21705 22067 22141 "N"     . 0 0     .
2103300552 21705 22879 22994 "N"     . 0 0     .
2103300561 22069 22144 22267 "N"     . 0 0     .
2103300561 22069 22879 22995 "N"     . 0 0     .
2103300561 22069 22648 22778 "N"     . 0 0     .
2103300561 22069 22284 22407 "N"     . 0 0     .
2103300561 22069 22781 22868 "N"     . 0 0     .
2103300561 22069 22515 22631 "N"     . 0 0     .
2103300585 22440 22522 22632 "N"     . 0 0     .
2103300585 22440 22669 22784 "N"     . 0 0     .
2103300585 22440 22796 22861 "N"     . 0 0     .
2103300585 22440 22796 22869 "N"     . 0 0     .
2103300591 22440     .     . "N"     . 0 0     .
2103300594 22804     .     . "N"     . 0 0     .
2103300600 22804     .     . "N"     . 0 0     .
2103300603 22656     .     . "N"     . 0 0     .
2103300855 22804 22900 22991 "N"     . 0 0     .
2103300861 22440 22872 22996 "N"     . 0 0     .
2103300861 22440 22872 22995 "N"     . 0 0     .
2103300861 22440 22796 22861 "N"     . 0 0     .
2103300861 22440 22872 22995 "N"     . 0 0     .
2103300861 22440 22796 22869 "N"     . 0 0     .
2103300861 22440 22508 22631 "N"     . 0 0     .
2103300861 22440 22663 22789 "N"     . 0 0     .
2103300861 22440 22872 22996 "N"     . 0 0     .
3333004638 20248     .     . "N"     . 0 0     .
3333004845 20248 20472 20600 "N"     . 0 0     .
3333004845 20248 20318 20440 "N"     . 0 0     .
3333004845 20248 22524 22704 "N"     . 0 0     .
3333004845 20248 22705 22888 "N"     . 0 0     .
3333004845 20248 22889 23069 "N"     . 0 0     .
3333005328 20248 21409 21456 "N"     . 0 0     .
3333005328 20248 20682 20804 "N"     . 0 0     .
3333005340 20248 22515 22631 "N"     . 0 1 22078
3333005340 20248 21818 21889 "N"     . 0 1 22078
3333005340 20248     .     . "Y" 22078 1 1 22078
3333005340 20248 21556 21623 "N"     . 0 1 22078
3333005340 20248 21818 21896 "N"     . 0 1 22078
3333005340 20248 22305 22420 "N"     . 0 1 22078
3333005340 20248 22151 22267 "N"     . 0 1 22078
3333005340 20248 22879 22995 "N"     . 0 1 22078
3333005340 20248     .     . "Y" 22078 1 1 22078
3333005340 20248 21916 21994 "N"     . 0 1 22078
3333005340 20248 21999 22078 "N"     . 0 1 22078
end
format %td high_school_grad_date
format %td enrollment_begin
format %td enrollment_end
format %td graduation_date
format %td degree_date

Thank you.

[Andrew Musau]

You can use the -count()- option of dataex to present more observations or restrict the range of the data in some way. For example:

dataex in 200/300

will present observations starting at observation number 200 to observation number 300. Just make sure your problem is reproducible.

[Alejandra Gomez]

Andrew Musau thank you for the suggestion. I have changed the observation start for my data

* Example generated by -dataex-. For more info, type help dataex
clear
input double randomid long(high_school_grad_date enrollment_begin enrollment_end) str1 graduated long graduation_date float(degree college_grad degree_date)
3333005415 20248 22894 22928 "N"     . 0 0     .
3333005415 20248 22740 22774 "N"     . 0 0     .
3333005415 20248 22817 22851 "N"     . 0 0     .
3333005415 20248 22922 22932 "N"     . 0 0     .
3333005415 20248 20826 20898 "N"     . 0 0     .
3333005415 20248 21274 21346 "N"     . 0 0     .
3333005415 20248 20355 20429 "N"     . 0 0     .
3333005415 20248 21697 21727 "N"     . 0 0     .
3333005415 20248 21843 21872 "N"     . 0 0     .
3333005415 20248 22775 22809 "N"     . 0 0     .
3333005415 20248 22586 22620 "N"     . 0 0     .
3333005415 20248 22397 22431 "N"     . 0 0     .
3333005415 20248 20462 20534 "N"     . 0 0     .
3333005418 20248 21045 21168 "N"     . 0 0     .
3333005418 20248 21200 21328 "N"     . 0 0     .
3333005418 20248 20836 20964 "N"     . 0 0     .
3333005418 20248 21563 21692 "N"     . 0 0     .
3333005418 20248 21409 21532 "N"     . 0 0     .
3333005418 20248 20682 20804 "N"     . 0 0     .
3333005418 20248 20318 20440 "N"     . 0 0     .
3333005418 20248 20472 20600 "N"     . 0 0     .
3333005442 20248 21638 21710 "N"     . 0 1 22785
3333005442 20248 20682 20804 "N"     . 0 1 22785
3333005442 20248     .     . "Y" 22074 1 1 22785
3333005442 20248     .     . "Y" 21328 1 1 22785
3333005442 20248 20472 20600 "N"     . 0 1 22785
3333005442 20248 22907 22988 "N"     . 0 1 22785
3333005442 20248 21045 21168 "N"     . 0 1 22785
3333005442 20248 21200 21328 "N"     . 0 1 22785
3333005442 20248 21447 21521 "N"     . 0 1 22785
3333005442 20248     .     . "Y" 22786 1 1 22785
3333005442 20248 21554 21626 "N"     . 0 1 22785
3333005442 20248 22513 22618 "N"     . 0 1 22785
3333005442 20248 22149 22254 "N"     . 0 1 22785
3333005442 20248 20318 20440 "N"     . 0 1 22785
3333005442 20248 21811 21885 "N"     . 0 1 22785
3333005442 20248 20836 20964 "N"     . 0 1 22785
3333005442 20248     .     . "Y" 21328 1 1 22785
3333005442 20248     .     . "Y" 21328 1 1 22785
3333005442 20248     .     . "Y" 22778 1 1 22785
3333005442 20248 22303 22414 "N"     . 0 1 22785
3333005442 20248 22667 22778 "N"     . 0 1 22785
3333005442 20248 21918 21990 "N"     . 0 1 22785
3333005442 20248 22002 22074 "N"     . 0 1 22785
3333005442 20248     .     . "Y" 22079 1 1 22785
3333005445 20248 21550 21669 "N"     . 0 1     .
3333005445 20248 21793 21914 "N"     . 0 1     .
3333005445 20248 20969 21042 "N"     . 0 1     .
3333005445 20248 22774 22870 "N"     . 0 1     .
3333005445 20248 21045 21168 "N"     . 0 1     .
3333005445 20248 20605 20678 "N"     . 0 1     .
3333005445 20248 20472 20600 "N"     . 0 1     .
3333005445 20248 22158 22269 "N"     . 0 1     .
3333005445 20248     .     . "Y" 22888 1 1     .
3333005445 20248 21194 21304 "N"     . 0 1     .
3333005445 20248     .     . "Y" 21168 1 1     .
3333005445 20248     .     . "Y" 21168 1 1     .
3333005445 20248 22284 22395 "N"     . 0 1     .
3333005445 20248 20836 20964 "N"     . 0 1     .
3333005445 20248 20682 20804 "N"     . 0 1     .
3333005445 20248 21431 21529 "N"     . 0 1     .
3333005445 20248     .     . "Y" 22870 1 1     .
3333005445 20248 22410 22506 "N"     . 0 1     .
3333005445 20248 20318 20440 "N"     . 0 1     .
3333005445 20248 22655 22766 "N"     . 0 1     .
3333005445 20248     .     . "Y" 21914 1 1     .
3333005445 20248 21194 21305 "N"     . 0 1     .
3333005445 20248 22522 22633 "N"     . 0 1     .
3333005445 20248     .     . "Y" 21168 1 1     .
3333005448 20248 21200 21328 "N"     . 0 0     .
3333005448 20248 21409 21532 "N"     . 0 0     .
3333005448 20248 20318 20440 "N"     . 0 0     .
3333005448 20248 21045 21168 "N"     . 0 0     .
3333005448 20248 20836 20964 "N"     . 0 0     .
3333005448 20248 20472 20600 "N"     . 0 0     .
3333005448 20248 21563 21692 "N"     . 0 0     .
3333005448 20248 20682 20804 "N"     . 0 0     .
3333005451 20248     .     . "N"     . 0 0     .
3333005460 20248     .     . "N"     . 0 0     .
3333005475 20248 21200 21328 "N"     . 0 0     .
3333005475 20248 20836 20964 "N"     . 0 0     .
3333005475 20248 20682 20804 "N"     . 0 0     .
3333005475 20248 20317 20440 "N"     . 0 0     .
3333005475 20248 20464 20592 "N"     . 0 0     .
3333005478 20248 20605 20678 "N"     . 0 1 22043
3333005478 20248 21423 21532 "N"     . 0 1 22043
3333005478 20248 20836 20964 "N"     . 0 1 22043
3333005478 20248 21927 22043 "N"     . 0 1 22043
3333005478 20248     .     . "Y" 22043 1 1 22043
3333005478 20248 21059 21168 "N"     . 0 1 22043
3333005478 20248     .     . "Y" 22043 1 1 22043
3333005478 20248 21199 21315 "N"     . 0 1 22043
3333005478 20248 21563 21679 "N"     . 0 1 22043
3333005478 20248 20331 20439 "N"     . 0 1 22043
3333005478 20248     .     . "Y" 20965 1 1 22043
3333005478 20248 21318 21403 "N"     . 0 1 22043
3333005478 20248 20500 20614 "N"     . 0 1 22043
3333005478 20248 21787 21896 "N"     . 0 1 22043
3333005478 20248 20682 20804 "N"     . 0 1 22043
3333005478 20248 20969 21042 "N"     . 0 1 22043
end
format %td high_school_grad_date
format %td enrollment_begin
format %td enrollment_end
format %td graduation_date
format %td degree_date

[Andrew Musau]

Code:
bys randomid: egen degree_date=max(graduation_date)

This code works as it should do. The mentioned identifier has 7 graduation dates attached to it and the max date for this subsample is 21 May 2022. Perhaps you intend the first reported graduation date in sequence?

. l randomid graduation_date degree_date2, sepby(rand)


. l randomid graduation_date degree_date2, sepby(rand)

     +------------------------------------+
     |   randomid   graduat~e   degree_~2 |
     |------------------------------------|
  1. | 3333005415           .           . |
  2. | 3333005415           .           . |
  3. | 3333005415           .           . |
  4. | 3333005415           .           . |
  5. | 3333005415           .           . |
  6. | 3333005415           .           . |
  7. | 3333005415           .           . |
  8. | 3333005415           .           . |
  9. | 3333005415           .           . |
 10. | 3333005415           .           . |
 11. | 3333005415           .           . |
 12. | 3333005415           .           . |
 13. | 3333005415           .           . |
     |------------------------------------|
 14. | 3333005418           .           . |
 15. | 3333005418           .           . |
 16. | 3333005418           .           . |
 17. | 3333005418           .           . |
 18. | 3333005418           .           . |
 19. | 3333005418           .           . |
 20. | 3333005418           .           . |
 21. | 3333005418           .           . |
     |------------------------------------|
 22. | 3333005442           .   21may2022 |
 23. | 3333005442           .   21may2022 |
 24. | 3333005442   08jun2020   21may2022 |
 25. | 3333005442   24may2018   21may2022 |
 26. | 3333005442           .   21may2022 |
 27. | 3333005442           .   21may2022 |
 28. | 3333005442           .   21may2022 |
 29. | 3333005442           .   21may2022 |
 30. | 3333005442           .   21may2022 |
 31. | 3333005442   21may2022   21may2022 |
 32. | 3333005442           .   21may2022 |
 33. | 3333005442           .   21may2022 |
 34. | 3333005442           .   21may2022 |
 35. | 3333005442           .   21may2022 |
 36. | 3333005442           .   21may2022 |
 37. | 3333005442           .   21may2022 |
 38. | 3333005442   24may2018   21may2022 |
 39. | 3333005442   24may2018   21may2022 |
 40. | 3333005442   13may2022   21may2022 |
 41. | 3333005442           .   21may2022 |
 42. | 3333005442           .   21may2022 |
 43. | 3333005442           .   21may2022 |
 44. | 3333005442           .   21may2022 |
 45. | 3333005442   13jun2020   21may2022 |
     |------------------------------------|
 46. | 3333005445           .   31aug2022 |
 47. | 3333005445           .   31aug2022 |
 48. | 3333005445           .   31aug2022 |
 49. | 3333005445           .   31aug2022 |
 50. | 3333005445           .   31aug2022 |
 51. | 3333005445           .   31aug2022 |
 52. | 3333005445           .   31aug2022 |
 53. | 3333005445           .   31aug2022 |
 54. | 3333005445   31aug2022   31aug2022 |
 55. | 3333005445           .   31aug2022 |
 56. | 3333005445   15dec2017   31aug2022 |
 57. | 3333005445   15dec2017   31aug2022 |
 58. | 3333005445           .   31aug2022 |
 59. | 3333005445           .   31aug2022 |
 60. | 3333005445           .   31aug2022 |
 61. | 3333005445           .   31aug2022 |
 62. | 3333005445   13aug2022   31aug2022 |
 63. | 3333005445           .   31aug2022 |
 64. | 3333005445           .   31aug2022 |
 65. | 3333005445           .   31aug2022 |
 66. | 3333005445   31dec2019   31aug2022 |
 67. | 3333005445           .   31aug2022 |
 68. | 3333005445           .   31aug2022 |
 69. | 3333005445   15dec2017   31aug2022 |
     |------------------------------------|
 70. | 3333005448           .           . |
 71. | 3333005448           .           . |
 72. | 3333005448           .           . |
 73. | 3333005448           .           . |
 74. | 3333005448           .           . |
 75. | 3333005448           .           . |
 76. | 3333005448           .           . |
 77. | 3333005448           .           . |
     |------------------------------------|
 78. | 3333005451           .           . |
     |------------------------------------|
 79. | 3333005460           .           . |
     |------------------------------------|
 80. | 3333005475           .           . |
 81. | 3333005475           .           . |
 82. | 3333005475           .           . |
 83. | 3333005475           .           . |
 84. | 3333005475           .           . |
     |------------------------------------|
 85. | 3333005478           .   08may2020 |
 86. | 3333005478           .   08may2020 |
 87. | 3333005478           .   08may2020 |
 88. | 3333005478           .   08may2020 |
 89. | 3333005478   08may2020   08may2020 |
 90. | 3333005478           .   08may2020 |
 91. | 3333005478   08may2020   08may2020 |
 92. | 3333005478           .   08may2020 |
 93. | 3333005478           .   08may2020 |
 94. | 3333005478           .   08may2020 |
 95. | 3333005478   26may2017   08may2020 |
 96. | 3333005478           .   08may2020 |
 97. | 3333005478           .   08may2020 |
 98. | 3333005478           .   08may2020 |
 99. | 3333005478           .   08may2020 |
100. | 3333005478           .   08may2020 |
     +------------------------------------+

.

[Alejandra Gomez]

Andrew Musau You are right, thank you for catching this. You made me realize that there are instances where a student graduated from multiple colleges with different degrees and thus why there are multiple graduation dates. My code is only pulling the latest graduation date. Is there a way to pull each different one into the variable degree_date or a different method I should be using? Or should I be posing my question in a new post? I am trying to figure out the length of time between high school graduation date and college graduation date, knowing that some students stop out, some return after years, have gaps and others never graduate

[Andrew Musau]

The first graduation date is unambiguous, so you may define the problem as the time between high school and first college graduation. It is possible to compile all dates into a string variable, but that will not be useful for analysis as you need numerical variables. I will nonetheless show you how you can do that.

* Example generated by -dataex-. For more info, type help dataex
clear
input double randomid long(high_school_grad_date enrollment_begin enrollment_end) str1 graduated long graduation_date float(degree college_grad degree_date)
3333005415 20248 22894 22928 "N"     . 0 0     .
3333005415 20248 22740 22774 "N"     . 0 0     .
3333005415 20248 22817 22851 "N"     . 0 0     .
3333005415 20248 22922 22932 "N"     . 0 0     .
3333005415 20248 20826 20898 "N"     . 0 0     .
3333005415 20248 21274 21346 "N"     . 0 0     .
3333005415 20248 20355 20429 "N"     . 0 0     .
3333005415 20248 21697 21727 "N"     . 0 0     .
3333005415 20248 21843 21872 "N"     . 0 0     .
3333005415 20248 22775 22809 "N"     . 0 0     .
3333005415 20248 22586 22620 "N"     . 0 0     .
3333005415 20248 22397 22431 "N"     . 0 0     .
3333005415 20248 20462 20534 "N"     . 0 0     .
3333005418 20248 21045 21168 "N"     . 0 0     .
3333005418 20248 21200 21328 "N"     . 0 0     .
3333005418 20248 20836 20964 "N"     . 0 0     .
3333005418 20248 21563 21692 "N"     . 0 0     .
3333005418 20248 21409 21532 "N"     . 0 0     .
3333005418 20248 20682 20804 "N"     . 0 0     .
3333005418 20248 20318 20440 "N"     . 0 0     .
3333005418 20248 20472 20600 "N"     . 0 0     .
3333005442 20248 21638 21710 "N"     . 0 1 22785
3333005442 20248 20682 20804 "N"     . 0 1 22785
3333005442 20248     .     . "Y" 22074 1 1 22785
3333005442 20248     .     . "Y" 21328 1 1 22785
3333005442 20248 20472 20600 "N"     . 0 1 22785
3333005442 20248 22907 22988 "N"     . 0 1 22785
3333005442 20248 21045 21168 "N"     . 0 1 22785
3333005442 20248 21200 21328 "N"     . 0 1 22785
3333005442 20248 21447 21521 "N"     . 0 1 22785
3333005442 20248     .     . "Y" 22786 1 1 22785
3333005442 20248 21554 21626 "N"     . 0 1 22785
3333005442 20248 22513 22618 "N"     . 0 1 22785
3333005442 20248 22149 22254 "N"     . 0 1 22785
3333005442 20248 20318 20440 "N"     . 0 1 22785
3333005442 20248 21811 21885 "N"     . 0 1 22785
3333005442 20248 20836 20964 "N"     . 0 1 22785
3333005442 20248     .     . "Y" 21328 1 1 22785
3333005442 20248     .     . "Y" 21328 1 1 22785
3333005442 20248     .     . "Y" 22778 1 1 22785
3333005442 20248 22303 22414 "N"     . 0 1 22785
3333005442 20248 22667 22778 "N"     . 0 1 22785
3333005442 20248 21918 21990 "N"     . 0 1 22785
3333005442 20248 22002 22074 "N"     . 0 1 22785
3333005442 20248     .     . "Y" 22079 1 1 22785
3333005445 20248 21550 21669 "N"     . 0 1     .
3333005445 20248 21793 21914 "N"     . 0 1     .
3333005445 20248 20969 21042 "N"     . 0 1     .
3333005445 20248 22774 22870 "N"     . 0 1     .
3333005445 20248 21045 21168 "N"     . 0 1     .
3333005445 20248 20605 20678 "N"     . 0 1     .
3333005445 20248 20472 20600 "N"     . 0 1     .
3333005445 20248 22158 22269 "N"     . 0 1     .
3333005445 20248     .     . "Y" 22888 1 1     .
3333005445 20248 21194 21304 "N"     . 0 1     .
3333005445 20248     .     . "Y" 21168 1 1     .
3333005445 20248     .     . "Y" 21168 1 1     .
3333005445 20248 22284 22395 "N"     . 0 1     .
3333005445 20248 20836 20964 "N"     . 0 1     .
3333005445 20248 20682 20804 "N"     . 0 1     .
3333005445 20248 21431 21529 "N"     . 0 1     .
3333005445 20248     .     . "Y" 22870 1 1     .
3333005445 20248 22410 22506 "N"     . 0 1     .
3333005445 20248 20318 20440 "N"     . 0 1     .
3333005445 20248 22655 22766 "N"     . 0 1     .
3333005445 20248     .     . "Y" 21914 1 1     .
3333005445 20248 21194 21305 "N"     . 0 1     .
3333005445 20248 22522 22633 "N"     . 0 1     .
3333005445 20248     .     . "Y" 21168 1 1     .
3333005448 20248 21200 21328 "N"     . 0 0     .
3333005448 20248 21409 21532 "N"     . 0 0     .
3333005448 20248 20318 20440 "N"     . 0 0     .
3333005448 20248 21045 21168 "N"     . 0 0     .
3333005448 20248 20836 20964 "N"     . 0 0     .
3333005448 20248 20472 20600 "N"     . 0 0     .
3333005448 20248 21563 21692 "N"     . 0 0     .
3333005448 20248 20682 20804 "N"     . 0 0     .
3333005451 20248     .     . "N"     . 0 0     .
3333005460 20248     .     . "N"     . 0 0     .
3333005475 20248 21200 21328 "N"     . 0 0     .
3333005475 20248 20836 20964 "N"     . 0 0     .
3333005475 20248 20682 20804 "N"     . 0 0     .
3333005475 20248 20317 20440 "N"     . 0 0     .
3333005475 20248 20464 20592 "N"     . 0 0     .
3333005478 20248 20605 20678 "N"     . 0 1 22043
3333005478 20248 21423 21532 "N"     . 0 1 22043
3333005478 20248 20836 20964 "N"     . 0 1 22043
3333005478 20248 21927 22043 "N"     . 0 1 22043
3333005478 20248     .     . "Y" 22043 1 1 22043
3333005478 20248 21059 21168 "N"     . 0 1 22043
3333005478 20248     .     . "Y" 22043 1 1 22043
3333005478 20248 21199 21315 "N"     . 0 1 22043
3333005478 20248 21563 21679 "N"     . 0 1 22043
3333005478 20248 20331 20439 "N"     . 0 1 22043
3333005478 20248     .     . "Y" 20965 1 1 22043
3333005478 20248 21318 21403 "N"     . 0 1 22043
3333005478 20248 20500 20614 "N"     . 0 1 22043
3333005478 20248 21787 21896 "N"     . 0 1 22043
3333005478 20248 20682 20804 "N"     . 0 1 22043
3333005478 20248 20969 21042 "N"     . 0 1 22043
end
format %td high_school_grad_date
format %td enrollment_begin
format %td enrollment_end
format %td graduation_date
format %td degree_date

format randomid %13.0f
bys randomid: egen first_grad=min(graduation_date)
format first_grad %td
bys randomid (graduation_date): gen wanted= string(graduation_date[1], "%td")
bys randomid: gen howmany=_N
qui sum howmany
forval i=2/`r(max)'{  
    quietly{
        by randomid: replace wanted = wanted+ "; "+ string(graduation_date[`i'], "%td") if !missing(graduation_date[`i']) & graduation_date[`i']!=graduation_date[`i'-1]
     }
}

Res.:

. l randomid graduation_date first_grad wanted, sepby(randomid)

     +--------------------------------------------------------------------------------------------+
     |   randomid   graduat~e   first_g~d                                                  wanted |
     |--------------------------------------------------------------------------------------------|
  1. | 3333005415           .           .                                                       . |
  2. | 3333005415           .           .                                                       . |
  3. | 3333005415           .           .                                                       . |
  4. | 3333005415           .           .                                                       . |
  5. | 3333005415           .           .                                                       . |
  6. | 3333005415           .           .                                                       . |
  7. | 3333005415           .           .                                                       . |
  8. | 3333005415           .           .                                                       . |
  9. | 3333005415           .           .                                                       . |
 10. | 3333005415           .           .                                                       . |
 11. | 3333005415           .           .                                                       . |
 12. | 3333005415           .           .                                                       . |
 13. | 3333005415           .           .                                                       . |
     |--------------------------------------------------------------------------------------------|
 14. | 3333005418           .           .                                                       . |
 15. | 3333005418           .           .                                                       . |
 16. | 3333005418           .           .                                                       . |
 17. | 3333005418           .           .                                                       . |
 18. | 3333005418           .           .                                                       . |
 19. | 3333005418           .           .                                                       . |
 20. | 3333005418           .           .                                                       . |
 21. | 3333005418           .           .                                                       . |
     |--------------------------------------------------------------------------------------------|
 22. | 3333005442   24may2018   24may2018   24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022 |
 23. | 3333005442   24may2018   24may2018   24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022 |
 24. | 3333005442   24may2018   24may2018   24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022 |
 25. | 3333005442   08jun2020   24may2018   24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022 |
 26. | 3333005442   13jun2020   24may2018   24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022 |
 27. | 3333005442   13may2022   24may2018   24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022 |
 28. | 3333005442   21may2022   24may2018   24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022 |
 29. | 3333005442           .   24may2018   24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022 |
 30. | 3333005442           .   24may2018   24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022 |
 31. | 3333005442           .   24may2018   24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022 |
 32. | 3333005442           .   24may2018   24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022 |
 33. | 3333005442           .   24may2018   24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022 |
 34. | 3333005442           .   24may2018   24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022 |
 35. | 3333005442           .   24may2018   24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022 |
 36. | 3333005442           .   24may2018   24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022 |
 37. | 3333005442           .   24may2018   24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022 |
 38. | 3333005442           .   24may2018   24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022 |
 39. | 3333005442           .   24may2018   24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022 |
 40. | 3333005442           .   24may2018   24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022 |
 41. | 3333005442           .   24may2018   24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022 |
 42. | 3333005442           .   24may2018   24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022 |
 43. | 3333005442           .   24may2018   24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022 |
 44. | 3333005442           .   24may2018   24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022 |
 45. | 3333005442           .   24may2018   24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022 |
     |--------------------------------------------------------------------------------------------|
 46. | 3333005445   15dec2017   15dec2017              15dec2017; 31dec2019; 13aug2022; 31aug2022 |
 47. | 3333005445   15dec2017   15dec2017              15dec2017; 31dec2019; 13aug2022; 31aug2022 |
 48. | 3333005445   15dec2017   15dec2017              15dec2017; 31dec2019; 13aug2022; 31aug2022 |
 49. | 3333005445   31dec2019   15dec2017              15dec2017; 31dec2019; 13aug2022; 31aug2022 |
 50. | 3333005445   13aug2022   15dec2017              15dec2017; 31dec2019; 13aug2022; 31aug2022 |
 51. | 3333005445   31aug2022   15dec2017              15dec2017; 31dec2019; 13aug2022; 31aug2022 |
 52. | 3333005445           .   15dec2017              15dec2017; 31dec2019; 13aug2022; 31aug2022 |
 53. | 3333005445           .   15dec2017              15dec2017; 31dec2019; 13aug2022; 31aug2022 |
 54. | 3333005445           .   15dec2017              15dec2017; 31dec2019; 13aug2022; 31aug2022 |
 55. | 3333005445           .   15dec2017              15dec2017; 31dec2019; 13aug2022; 31aug2022 |
 56. | 3333005445           .   15dec2017              15dec2017; 31dec2019; 13aug2022; 31aug2022 |
 57. | 3333005445           .   15dec2017              15dec2017; 31dec2019; 13aug2022; 31aug2022 |
 58. | 3333005445           .   15dec2017              15dec2017; 31dec2019; 13aug2022; 31aug2022 |
 59. | 3333005445           .   15dec2017              15dec2017; 31dec2019; 13aug2022; 31aug2022 |
 60. | 3333005445           .   15dec2017              15dec2017; 31dec2019; 13aug2022; 31aug2022 |
 61. | 3333005445           .   15dec2017              15dec2017; 31dec2019; 13aug2022; 31aug2022 |
 62. | 3333005445           .   15dec2017              15dec2017; 31dec2019; 13aug2022; 31aug2022 |
 63. | 3333005445           .   15dec2017              15dec2017; 31dec2019; 13aug2022; 31aug2022 |
 64. | 3333005445           .   15dec2017              15dec2017; 31dec2019; 13aug2022; 31aug2022 |
 65. | 3333005445           .   15dec2017              15dec2017; 31dec2019; 13aug2022; 31aug2022 |
 66. | 3333005445           .   15dec2017              15dec2017; 31dec2019; 13aug2022; 31aug2022 |
 67. | 3333005445           .   15dec2017              15dec2017; 31dec2019; 13aug2022; 31aug2022 |
 68. | 3333005445           .   15dec2017              15dec2017; 31dec2019; 13aug2022; 31aug2022 |
 69. | 3333005445           .   15dec2017              15dec2017; 31dec2019; 13aug2022; 31aug2022 |
     |--------------------------------------------------------------------------------------------|
 70. | 3333005448           .           .                                                       . |
 71. | 3333005448           .           .                                                       . |
 72. | 3333005448           .           .                                                       . |
 73. | 3333005448           .           .                                                       . |
 74. | 3333005448           .           .                                                       . |
 75. | 3333005448           .           .                                                       . |
 76. | 3333005448           .           .                                                       . |
 77. | 3333005448           .           .                                                       . |
     |--------------------------------------------------------------------------------------------|
 78. | 3333005451           .           .                                                       . |
     |--------------------------------------------------------------------------------------------|
 79. | 3333005460           .           .                                                       . |
     |--------------------------------------------------------------------------------------------|
 80. | 3333005475           .           .                                                       . |
 81. | 3333005475           .           .                                                       . |
 82. | 3333005475           .           .                                                       . |
 83. | 3333005475           .           .                                                       . |
 84. | 3333005475           .           .                                                       . |
     |--------------------------------------------------------------------------------------------|
 85. | 3333005478   26may2017   26may2017                                    26may2017; 08may2020 |
 86. | 3333005478   08may2020   26may2017                                    26may2017; 08may2020 |
 87. | 3333005478   08may2020   26may2017                                    26may2017; 08may2020 |
 88. | 3333005478           .   26may2017                                    26may2017; 08may2020 |
 89. | 3333005478           .   26may2017                                    26may2017; 08may2020 |
 90. | 3333005478           .   26may2017                                    26may2017; 08may2020 |
 91. | 3333005478           .   26may2017                                    26may2017; 08may2020 |
 92. | 3333005478           .   26may2017                                    26may2017; 08may2020 |
 93. | 3333005478           .   26may2017                                    26may2017; 08may2020 |
 94. | 3333005478           .   26may2017                                    26may2017; 08may2020 |
 95. | 3333005478           .   26may2017                                    26may2017; 08may2020 |
 96. | 3333005478           .   26may2017                                    26may2017; 08may2020 |
 97. | 3333005478           .   26may2017                                    26may2017; 08may2020 |
 98. | 3333005478           .   26may2017                                    26may2017; 08may2020 |
 99. | 3333005478           .   26may2017                                    26may2017; 08may2020 |
100. | 3333005478           .   26may2017                                    26may2017; 08may2020 |
     +--------------------------------------------------------------------------------------------+

.

[Alejandra Gomez]

Andrew Musau Thanks for this. A follow up, is there a way to pull each graduation date separately into variables? Say grad_date1, grad_date2, etc? I am converting the dates into terms then replacing terms into numbers, for calculations. Would there be a way to have each graduation date in a separate column so I can then turn each into a term? There by using each one to calculate from high school graduation, since this one is the same for each student, no matter how many college graduations they have

[Nick Cox]

#7 is a problem for split.

[Alejandra Gomez]

Nick Cox Thank you for the suggestion, split worked great for my data

[Alejandra Gomez]

Andrew Musau Your code in #6 works great. I have a follow up to it regarding variable format. How can I get wanted to match the format for the others like this? I split wanted into different columns using

split wanted, gen (degree_date2) parse(;)

This is what my data looks like and I am trying to match up the formats so I can run this code

gen year = year(degree_date21) gen month = month(degree_date21) gen term = "Spring " if month <= 6 replace term = "Fall " if month >= 7 replace term = term + string(year)

* Example generated by -dataex-. For more info, type help dataex
clear
input str53 wanted str9 degree_date1 long graduation_date
"24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022" "24may2018" 21328
"24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022" "24may2018" 21328
"24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022" "24may2018" 21328
"24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022" "24may2018" 22074
"24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022" "24may2018" 22079
"24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022" "24may2018" 22778
"24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022" "24may2018" 22786
"24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022" "24may2018"     .
"24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022" "24may2018"     .
"24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022" "24may2018"     .
"24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022" "24may2018"     .
"24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022" "24may2018"     .
"24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022" "24may2018"     .
"24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022" "24may2018"     .
"24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022" "24may2018"     .
"24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022" "24may2018"     .
"24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022" "24may2018"     .
"24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022" "24may2018"     .
"24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022" "24may2018"     .
"24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022" "24may2018"     .
"24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022" "24may2018"     .
"24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022" "24may2018"     .
"24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022" "24may2018"     .
"24may2018; 08jun2020; 13jun2020; 13may2022; 21may2022" "24may2018"     .
"15dec2017; 31dec2019; 13aug2022; 31aug2022"            "15dec2017" 21168
"15dec2017; 31dec2019; 13aug2022; 31aug2022"            "15dec2017" 21168
"15dec2017; 31dec2019; 13aug2022; 31aug2022"            "15dec2017" 21168
"15dec2017; 31dec2019; 13aug2022; 31aug2022"            "15dec2017" 21914
"15dec2017; 31dec2019; 13aug2022; 31aug2022"            "15dec2017" 22870
"15dec2017; 31dec2019; 13aug2022; 31aug2022"            "15dec2017" 22888
"15dec2017; 31dec2019; 13aug2022; 31aug2022"            "15dec2017"     .
"15dec2017; 31dec2019; 13aug2022; 31aug2022"            "15dec2017"     .
"15dec2017; 31dec2019; 13aug2022; 31aug2022"            "15dec2017"     .
"15dec2017; 31dec2019; 13aug2022; 31aug2022"            "15dec2017"     .
"15dec2017; 31dec2019; 13aug2022; 31aug2022"            "15dec2017"     .
"15dec2017; 31dec2019; 13aug2022; 31aug2022"            "15dec2017"     .
"15dec2017; 31dec2019; 13aug2022; 31aug2022"            "15dec2017"     .
"15dec2017; 31dec2019; 13aug2022; 31aug2022"            "15dec2017"     .
"15dec2017; 31dec2019; 13aug2022; 31aug2022"            "15dec2017"     .
"15dec2017; 31dec2019; 13aug2022; 31aug2022"            "15dec2017"     .
"15dec2017; 31dec2019; 13aug2022; 31aug2022"            "15dec2017"     .
"15dec2017; 31dec2019; 13aug2022; 31aug2022"            "15dec2017"     .
"15dec2017; 31dec2019; 13aug2022; 31aug2022"            "15dec2017"     .
"15dec2017; 31dec2019; 13aug2022; 31aug2022"            "15dec2017"     .
"15dec2017; 31dec2019; 13aug2022; 31aug2022"            "15dec2017"     .
"15dec2017; 31dec2019; 13aug2022; 31aug2022"            "15dec2017"     .
"15dec2017; 31dec2019; 13aug2022; 31aug2022"            "15dec2017"     .
"15dec2017; 31dec2019; 13aug2022; 31aug2022"            "15dec2017"     .
end
format %td graduation_date

[Andrew Musau]

You need to keep the variables numeric.

* Example generated by -dataex-. For more info, type help dataex
clear
input double randomid long(high_school_grad_date enrollment_begin enrollment_end) str1 graduated long graduation_date float(degree college_grad degree_date)
3333005415 20248 22894 22928 "N"     . 0 0     .
3333005415 20248 22740 22774 "N"     . 0 0     .
3333005415 20248 22817 22851 "N"     . 0 0     .
3333005415 20248 22922 22932 "N"     . 0 0     .
3333005415 20248 20826 20898 "N"     . 0 0     .
3333005415 20248 21274 21346 "N"     . 0 0     .
3333005415 20248 20355 20429 "N"     . 0 0     .
3333005415 20248 21697 21727 "N"     . 0 0     .
3333005415 20248 21843 21872 "N"     . 0 0     .
3333005415 20248 22775 22809 "N"     . 0 0     .
3333005415 20248 22586 22620 "N"     . 0 0     .
3333005415 20248 22397 22431 "N"     . 0 0     .
3333005415 20248 20462 20534 "N"     . 0 0     .
3333005418 20248 21045 21168 "N"     . 0 0     .
3333005418 20248 21200 21328 "N"     . 0 0     .
3333005418 20248 20836 20964 "N"     . 0 0     .
3333005418 20248 21563 21692 "N"     . 0 0     .
3333005418 20248 21409 21532 "N"     . 0 0     .
3333005418 20248 20682 20804 "N"     . 0 0     .
3333005418 20248 20318 20440 "N"     . 0 0     .
3333005418 20248 20472 20600 "N"     . 0 0     .
3333005442 20248 21638 21710 "N"     . 0 1 22785
3333005442 20248 20682 20804 "N"     . 0 1 22785
3333005442 20248     .     . "Y" 22074 1 1 22785
3333005442 20248     .     . "Y" 21328 1 1 22785
3333005442 20248 20472 20600 "N"     . 0 1 22785
3333005442 20248 22907 22988 "N"     . 0 1 22785
3333005442 20248 21045 21168 "N"     . 0 1 22785
3333005442 20248 21200 21328 "N"     . 0 1 22785
3333005442 20248 21447 21521 "N"     . 0 1 22785
3333005442 20248     .     . "Y" 22786 1 1 22785
3333005442 20248 21554 21626 "N"     . 0 1 22785
3333005442 20248 22513 22618 "N"     . 0 1 22785
3333005442 20248 22149 22254 "N"     . 0 1 22785
3333005442 20248 20318 20440 "N"     . 0 1 22785
3333005442 20248 21811 21885 "N"     . 0 1 22785
3333005442 20248 20836 20964 "N"     . 0 1 22785
3333005442 20248     .     . "Y" 21328 1 1 22785
3333005442 20248     .     . "Y" 21328 1 1 22785
3333005442 20248     .     . "Y" 22778 1 1 22785
3333005442 20248 22303 22414 "N"     . 0 1 22785
3333005442 20248 22667 22778 "N"     . 0 1 22785
3333005442 20248 21918 21990 "N"     . 0 1 22785
3333005442 20248 22002 22074 "N"     . 0 1 22785
3333005442 20248     .     . "Y" 22079 1 1 22785
3333005445 20248 21550 21669 "N"     . 0 1     .
3333005445 20248 21793 21914 "N"     . 0 1     .
3333005445 20248 20969 21042 "N"     . 0 1     .
3333005445 20248 22774 22870 "N"     . 0 1     .
3333005445 20248 21045 21168 "N"     . 0 1     .
3333005445 20248 20605 20678 "N"     . 0 1     .
3333005445 20248 20472 20600 "N"     . 0 1     .
3333005445 20248 22158 22269 "N"     . 0 1     .
3333005445 20248     .     . "Y" 22888 1 1     .
3333005445 20248 21194 21304 "N"     . 0 1     .
3333005445 20248     .     . "Y" 21168 1 1     .
3333005445 20248     .     . "Y" 21168 1 1     .
3333005445 20248 22284 22395 "N"     . 0 1     .
3333005445 20248 20836 20964 "N"     . 0 1     .
3333005445 20248 20682 20804 "N"     . 0 1     .
3333005445 20248 21431 21529 "N"     . 0 1     .
3333005445 20248     .     . "Y" 22870 1 1     .
3333005445 20248 22410 22506 "N"     . 0 1     .
3333005445 20248 20318 20440 "N"     . 0 1     .
3333005445 20248 22655 22766 "N"     . 0 1     .
3333005445 20248     .     . "Y" 21914 1 1     .
3333005445 20248 21194 21305 "N"     . 0 1     .
3333005445 20248 22522 22633 "N"     . 0 1     .
3333005445 20248     .     . "Y" 21168 1 1     .
3333005448 20248 21200 21328 "N"     . 0 0     .
3333005448 20248 21409 21532 "N"     . 0 0     .
3333005448 20248 20318 20440 "N"     . 0 0     .
3333005448 20248 21045 21168 "N"     . 0 0     .
3333005448 20248 20836 20964 "N"     . 0 0     .
3333005448 20248 20472 20600 "N"     . 0 0     .
3333005448 20248 21563 21692 "N"     . 0 0     .
3333005448 20248 20682 20804 "N"     . 0 0     .
3333005451 20248     .     . "N"     . 0 0     .
3333005460 20248     .     . "N"     . 0 0     .
3333005475 20248 21200 21328 "N"     . 0 0     .
3333005475 20248 20836 20964 "N"     . 0 0     .
3333005475 20248 20682 20804 "N"     . 0 0     .
3333005475 20248 20317 20440 "N"     . 0 0     .
3333005475 20248 20464 20592 "N"     . 0 0     .
3333005478 20248 20605 20678 "N"     . 0 1 22043
3333005478 20248 21423 21532 "N"     . 0 1 22043
3333005478 20248 20836 20964 "N"     . 0 1 22043
3333005478 20248 21927 22043 "N"     . 0 1 22043
3333005478 20248     .     . "Y" 22043 1 1 22043
3333005478 20248 21059 21168 "N"     . 0 1 22043
3333005478 20248     .     . "Y" 22043 1 1 22043
3333005478 20248 21199 21315 "N"     . 0 1 22043
3333005478 20248 21563 21679 "N"     . 0 1 22043
3333005478 20248 20331 20439 "N"     . 0 1 22043
3333005478 20248     .     . "Y" 20965 1 1 22043
3333005478 20248 21318 21403 "N"     . 0 1 22043
3333005478 20248 20500 20614 "N"     . 0 1 22043
3333005478 20248 21787 21896 "N"     . 0 1 22043
3333005478 20248 20682 20804 "N"     . 0 1 22043
3333005478 20248 20969 21042 "N"     . 0 1 22043
end
format %td high_school_grad_date
format %td enrollment_begin
format %td enrollment_end
format %td graduation_date
format %td degree_date

format randomid %13.0f
bys randomid: egen first_grad=min(graduation_date)
format first_grad %td
bys randomid (graduation_date): gen wanted= string(graduation_date[1])
bys randomid: gen howmany=_N
qui sum howmany
forval i=2/`r(max)'{  
    quietly{
        by randomid: replace wanted = wanted+ "; "+ string(graduation_date[`i']) if !missing(graduation_date[`i']) & graduation_date[`i']!=graduation_date[`i'-1]
     }
}
split wanted, gen (degree_date2) parse(;) destring
format degree_date2* %td