I have a dataset with admission dates and diagnosis codes for hospital admission during the last 25 years. The coding system changed from ICD9 to ICD10 during the follow-up period. Some of the individuals, identified by an id variable (ID), have up to 200 admissions during this time period (admissiondate_1-200) and corresponding diagnosis codes (ICD9_1-200 and ICD10_1-200, one code per admission). I want to create a summary variable for the ICD codes, called ICD_sum, where the number of admissions is summarized. E.g.: individual X has been admitted 2 times coded with an ICD9 code, and 4 times with an ICD10 code, resulting in ICD_sum==6 for ID X.
I can't seem to figure out how to create such a variable. Would anybody be willing to help me?
My dataset is in wide format:
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input float ID double admissiondate_1 str18 ICD9_1 str21 ICD10_1 double admissiondate_2 str18 ICD9_2 str21 ICD10_2 1 . "" "" . "" "" 2 20130221 "." "M81.9" . " " " " 3 . "" "" . "" "" 4 20160311 "." "J44.0" 20170407 "." "M81.9" 5 . "" "" . "" "" 6 . "" "" . "" "" 7 19991115 "." "J45.9" . " " " " 8 19930223 "492" " " 19950515 "492" " " 9 . "" "" . "" "" 10 20141005 "." "J44.9" 20141018 "." "J22" 11 20120618 "." "J44.9" 19950530 "476" " " 12 20001031 "." "M81.0" 20160602 "." "M81.9" 13 20000404 "." "J44.9" . " " " " 14 20150413 "." "C34.9" 20150323 "." "C34.9" 15 19990914 "." "J44.8" 19980223 "491.2" " " 16 20050713 "." "J44.9" 20050902 "." "J44.9" 17 20180428 "." "J44.9" 20180428 "." "C34.1" 18 20100718 "." "J44.9" 19880317 "476" " " 19 . "" "" . "" "" 20 . "" "" . "" "" 21 20011217 "." "M81.0" 20160707 "." "J44.9" 22 19991006 "." "J44.9" 20070803 "." "J45.8" 23 20050415 "." "J44.9" 20070621 "." "J44.9" 24 20110928 "." "J45.0" . " " " " 25 20000327 "." "J44.9" 20040406 "." "J44.9" 26 19941019 "491" " " 20010905 "." "J44.9" 27 20120917 "." "J30.3" . " " " " 28 20030402 "." "J44.9" 20160303 "." "J44.9" 29 20081105 "." "C34.9" 20081118 "." "C34.9" 30 20070601 "." "J44.9" 20081231 "." "J44.1" 31 20060102 "." "J44.8" 20020103 "." "J44.9" 32 19911212 "471" " " 19901101 "471" " " 33 20110707 "." "C34.9" 20110911 "." "J44.0" 34 20060425 "." "J45.9" 20050725 "." "M81.0" 35 . "" "" . "" "" 36 19890116 "493" " " 19970912 "493.9" " " 37 20170411 "." "C34.9" 20160819 "." "C34.9" 38 20040625 "." "C34.9" 20041029 "." "C34.1" 39 20110303 "." "J44.9" 20120604 "." "J44.9" 40 20030712 "." "J44.1" 20031121 "." "J44.1" 41 19990928 "." "J44.1" 20010210 "." "J44.1" 42 20080506 "." "J45.9" 20010918 "." "J45.9" 43 . "" "" . "" "" 44 20190906 "." "J44.9" 20120703 "." "M81.0" 45 . "" "" . "" "" 46 20190704 "." "J44.9" 20010621 "." "J45.8" 47 20060508 "." "J44.9" 20060612 "." "J44.9" 48 . "" "" . "" "" 49 19951012 "477" " " 19951221 "477" " " 50 20120922 "." "J44.9" 20120708 "." "J44.9" 51 20130124 "." "J44.9" 20000519 "." "J30.4" 52 20030905 "." "J44.1" 20010914 "." "J44.9" 53 19890816 "493" " " . " " " " 54 . "" "" . "" "" 55 20090217 "." "J44.0" 20110304 "." "J44.9" 56 20190819 "." "J45.0" 20181112 "." "J45.0" 57 20130422 "." "J44.9" 20131115 "." "J44.9" 58 20151204 "." "M81.9" 20150714 "." "M81.9" 59 20160523 "." "C34.9" 20150317 "." "C34.9" 60 19950117 "162" " " 19970304 "162" " " 61 20140313 "." "J44.9" 20110706 "." "J44.9" 62 20111111 "." "J45.0" 19960812 "472" " " 63 20070914 "." "J45.9" 20100623 "." "J45.9" 64 20120321 "." "M81.0" 19971124 "493" " " 65 20020208 "." "J44.8" 20050118 "." "J44.9" 66 20050415 "." "J44.0" 20041215 "." "J44.0" 67 20060823 "." "J44.9" 20080222 "." "J44.9" 68 20150430 "." "M81.9" 20150522 "." "J44.9" 69 20120106 "." "J44.9" 20130117 "." "J44.0" 70 20060628 "." "J44.9" 20070815 "." "J44.9" 71 20040428 "." "M81.0" . " " " " 72 19931117 "491.2" " " 20020805 "." "J44.9" 73 20160427 "." "J44.9" 20160516 "." "J44.1" 74 20030522 "." "J44.9" 20001010 "." "J44.9" 75 20051114 "." "J45.9" 20060302 "." "J45.9" 76 20051206 "." "J31.0" . " " " " 77 . "" "" . "" "" 78 20070221 "." "J44.9" 20170505 "." "J44.1" 79 20120118 "." "C34.9" 20110826 "." "J44.9" 80 20160105 "." "J44.9" 20171227 "." "J44.0" 81 20030410 "." "J44.9" 20040224 "." "J20.9" 82 20070220 "." "J22" . " " " " 83 20021028 "." "J44.9" 19980814 "491.2" " " 84 20040610 "." "J44.9" 20021013 "." "J44.9" 85 20040526 "." "J44.9" 20050615 "." "J44.9" 86 20100929 "." "M81.5" 20190328 "." "J44.1" 87 20191204 "." "J45.9" 19920804 "493" " " 88 19930622 "493.9" " " 19980828 "491.2" " " 89 . "" "" . "" "" 90 . "" "" . "" "" 91 20101105 "." "J45.9" 20171201 "." "M81.9" 92 20110511 "." "C34.9" 20100927 "." "M81.5" 93 . "" "" . "" "" 94 20090416 "." "J42" 20070607 "." "J44.9" 95 20120918 "." "M81.99" 20111213 "." "J44.9" 96 20020122 "." "M81.0" 20030902 "." "M81.0" 97 20090619 "." "J44.0" 20010502 "." "J20.9" 98 20010514 "." "J44.0" 20030401 "." "J44.9" 99 19910822 "493" " " 19920221 "493" " " 100 20050511 "." "M81.0" 20060124 "." "M81.9" end
Sigrid
0 Response to Generating a summary variable from repeated data
Post a Comment