I have a number of character dates and time variables that need to be formatted to numeric dates and times. Please see examples below: 1) Arrival date:  01/02/2018 (is in character and formatted as $11.) 2) Arrival time: .4215277777777778 (is in character and formatted as $21.) 3)Radiology date/time:  01/04/2018 08:30 (is in character and formatted as $19.) 4) Read date: 43102 (is in character and formatted as $10.)   I'd love all of the dates to be in mmddyy`10. and all of the times to be in 24hr time. Dates are so challenging. Please help! ... View more

hello,   I have patient registry data that is coded wide with ICD-10 diagnosis codes. It has one patient id per row. I'd like to create two dummy variables from all of the wide code, TBI_injury and Spinal_injury. The codes for TBI_injury all start with the prefix: S02.0, S02.1, S02.9, S06.0-S06.6, S06.8, S06.9, S06.A, S07.1 . The Spinal_cord injury start with the prefix: S14, S24, or S34.    Here is just an example of 3 fake patients (bold values represent code prefixs for TBI or spine) data have; Studynum:  ICD10code_1   ICD10code_2  ICD10code_3   1                      S02.028A    S00.03XA          S06.5X9A 2                      S14.5X9A     S00.83XA         S22.028A  3                       S06.5X9A     S61.412A        S34.5X9A             data want: Studynum:  ICD10code_1   ICD10code_2  ICD10code_3    TBI_injury   Spinal_injury 1                      S02.028A    S00.03XA          S06.5X9A               1                  0 2                      S14.5X9A     S00.83XA         S22.028A                0                   1     3                       S06.5X9A     S61.412A        S34.5X9A                1                  1 ... View more

hello,   I have patient registry data that is coded wide with ICD-10 diagnosis codes. It has one patient id per row. I'd like to get the data to be longways so that I can easily parse out the codes that I need.  The codes go all the way to 41 (ICD10code_41) and they might not always be filled in all the way to 41. (or am looking for another way to create two dummy variables, spinal injury and TBI injury, based on specific ICD_10 codes I have for this study from this wide data).   Here is just an example of 3 fake patients: data have; Studynum:  ICD10code_1   ICD10code_2  ICD10code_3  ICD10code_4 1                      S22.028A    S00.03XA          S06.5X9A 2                      S06.5X9A     S00.83XA         S22.028A  3                       S06.5X9A     S61.412A        S06.5X9A          S06.6X9A data want; Studynum     ICD_code 1                   S22.028A 1                   S00.03XA 1                   S06.5X9A 2                   S06.5X9A  2                   S00.83XA   2                    S22.028A 3                   S06.5X9A   3                  S61.412A 3                  S06.5X9A 3                  S06.6X9A ... View more

 My date of arrivals are in $11. Any ideas how to change it back to the original numeric date? Either mmddyy10 or ddmmyy10?  I've tried so many input functions and it says it's invalid. Data have; arrival_date 01/03/2018 02/03/2019 data want; arrival_date_ 01/03/2019 (numeric) 02/03/2019 (numeric) ... View more