NOTE: Copyright (c) 2002-2012 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) Proprietary Software 9.4 (TS1M3) Licensed to US CENTERS FOR DISEASE CONTROL & PRVNTN, Site 70024534. NOTE: This session is executing on the W32_8PRO platform. NOTE: Updated analytical products: SAS/STAT 14.1 SAS/ETS 14.1 SAS/OR 14.1 SAS/IML 14.1 SAS/QC 14.1 NOTE: Additional host information: W32_8PRO WIN 6.2.9200 Workstation NOTE: SAS initialization used: real time 2.63 seconds cpu time 2.23 seconds 1 proc options option=(Threads CPUcount); 2 run; SAS (r) Proprietary Software Release 9.4 TS1M3 THREADS Uses threaded processing for SAS applications that support it. CPUCOUNT=4 Specifies the number of processors that thread-enabled applications should assume are available for concurrent processing. NOTE: PROCEDURE OPTIONS used (Total process time): real time 0.09 seconds cpu time 0.01 seconds ... View more

Yes I agree, the data is not big at all, but all of SAS procedures used to create the dataset are causing me problem. There is a lot of proc sort procedures and I notices those procedures take a long time to run. I am trying my best to reduce the run time and yes it looks like I am having an inefficient process. Best, Le ... View more

Thanks again Jim, I did not use DISTINCTs but a lot of proc sort. Below is actual log of today. I can't pre-merge any child datasets, each child dataset been updated and inserted new records daily. I just use an insert to write data to SQL and it usually take around 15 minutes. The big chunk of time is to get that crazy comprehensive dataset. It usually take around 35 to 40 minutes. so the total time is more than 1 hours. I had to create two task schedules to reduce the workload for SAS, the first schedule is to create that dataset and the second schedule is to insert that dataset into SQL. Below is the atual SAS log of the first part (just to creat the dataset and sent out an email) NOTE: PROCEDURE PRINTTO used (Total process time): real time 0.59 seconds cpu time 0.20 seconds NOTE: There were 32592 observations read from the data set SQLIMPP.UDC2_FWP_JSON. NOTE: The data set WORK._JSO has 32592 observations and 241 variables. NOTE: DATA statement used (Total process time): real time 2.78 seconds cpu time 2.74 seconds NOTE: There were 37803 observations read from the data set SQLIMPP.UDC2_FWP_JSON_Health_Ins. NOTE: The data set WORK._INS has 37803 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.20 seconds cpu time 0.14 seconds NOTE: There were 18100 observations read from the data set SQLIMPP.UDC2_FWP_JSON_Seg_Doses. NOTE: The data set WORK._DOS has 18100 observations and 14 variables. NOTE: DATA statement used (Total process time): real time 0.18 seconds cpu time 0.11 seconds NOTE: There were 17564 observations read from the data set SQLIMPP.UDC2_FWP_JSON_Meds. NOTE: The data set WORK._MED has 17564 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.15 seconds cpu time 0.10 seconds NOTE: There were 101 observations read from the data set SQLIMPP.UDC2_FWP_JSON_ICH. NOTE: The data set WORK._ICH has 101 observations and 13 variables. NOTE: DATA statement used (Total process time): real time 0.12 seconds cpu time 0.06 seconds NOTE: There were 6239 observations read from the data set SQLIMPP.UDC2_FWP_JSON_Surgical_Pro. NOTE: The data set WORK._SUR has 6239 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.12 seconds cpu time 0.11 seconds NOTE: There were 698 observations read from the data set SQLIMPP.UDC2_FWP_JSON_Hep_Vacc. NOTE: The data set WORK._VAC has 698 observations and 8 variables. NOTE: DATA statement used (Total process time): real time 0.09 seconds cpu time 0.04 seconds NOTE: There were 32592 observations read from the data set WORK._JSO. NOTE: The data set WORK._JSO has 32592 observations and 241 variables. NOTE: DATA statement used (Total process time): real time 3.31 seconds cpu time 2.70 seconds NOTE: There were 37803 observations read from the data set WORK._INS. NOTE: The data set WORK._INS has 37803 observations and 4 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.15 seconds cpu time 0.15 seconds NOTE: There were 37803 observations read from the data set WORK._INS. NOTE: The data set WORK._INSALL has 32592 observations and 11 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.95 seconds cpu time 0.21 seconds NOTE: There were 32592 observations read from the data set WORK._INSALL. NOTE: The data set WORK._INSALL has 32592 observations and 13 variables. NOTE: DATA statement used (Total process time): real time 0.87 seconds cpu time 0.17 seconds NOTE: PROCEDURE SQL used (Total process time): real time 0.06 seconds cpu time 0.06 seconds NOTE: There were 18100 observations read from the data set WORK._DOS. NOTE: The data set WORK._JUNK_1 has 17558 observations and 15 variables. NOTE: DATA statement used (Total process time): real time 0.23 seconds cpu time 0.06 seconds NOTE: There were 17558 observations read from the data set WORK._JUNK_1. NOTE: The data set WORK._DOS_1 has 17026 observations and 15 variables. NOTE: The data set WORK._LOOP_1 has 532 observations and 15 variables. NOTE: DATA statement used (Total process time): real time 0.34 seconds cpu time 0.07 seconds NOTE: There were 532 observations read from the data set WORK._LOOP_1. NOTE: The data set WORK._DOS_1_2 has 529 observations and 16 variables. NOTE: DATA statement used (Total process time): real time 0.20 seconds cpu time 0.03 seconds NOTE: There were 532 observations read from the data set WORK._LOOP_1. NOTE: The data set WORK._DOS_1_3 has 3 observations and 16 variables. NOTE: DATA statement used (Total process time): real time 0.34 seconds cpu time 0.01 seconds NOTE: There were 18100 observations read from the data set WORK._DOS. NOTE: The data set WORK._JUNK_2 has 518 observations and 15 variables. NOTE: DATA statement used (Total process time): real time 0.06 seconds cpu time 0.06 seconds NOTE: There were 518 observations read from the data set WORK._JUNK_2. NOTE: The data set WORK._DOS_2 has 514 observations and 15 variables. NOTE: The data set WORK._LOOP_2 has 4 observations and 15 variables. NOTE: DATA statement used (Total process time): real time 0.31 seconds cpu time 0.03 seconds NOTE: There were 4 observations read from the data set WORK._LOOP_2. NOTE: The data set WORK._DOS_2_2 has 4 observations and 16 variables. NOTE: DATA statement used (Total process time): real time 0.37 seconds cpu time 0.03 seconds NOTE: There were 4 observations read from the data set WORK._LOOP_2. NOTE: The data set WORK._DOS_2_3 has 0 observations and 16 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds NOTE: There were 18100 observations read from the data set WORK._DOS. NOTE: The data set WORK._JUNK_3 has 19 observations and 15 variables. NOTE: DATA statement used (Total process time): real time 0.13 seconds cpu time 0.04 seconds NOTE: There were 19 observations read from the data set WORK._JUNK_3. NOTE: The data set WORK._DOS_3 has 19 observations and 15 variables. NOTE: The data set WORK._LOOP_3 has 0 observations and 15 variables. NOTE: DATA statement used (Total process time): real time 0.35 seconds cpu time 0.04 seconds NOTE: There were 0 observations read from the data set WORK._LOOP_3. NOTE: The data set WORK._DOS_3_2 has 0 observations and 16 variables. NOTE: DATA statement used (Total process time): real time 0.15 seconds cpu time 0.03 seconds NOTE: There were 0 observations read from the data set WORK._LOOP_3. NOTE: The data set WORK._DOS_3_3 has 0 observations and 16 variables. NOTE: DATA statement used (Total process time): real time 0.17 seconds cpu time 0.03 seconds NOTE: There were 18100 observations read from the data set WORK._DOS. NOTE: The data set WORK._JUNK_4 has 5 observations and 15 variables. NOTE: DATA statement used (Total process time): real time 0.07 seconds cpu time 0.04 seconds NOTE: There were 5 observations read from the data set WORK._JUNK_4. NOTE: The data set WORK._DOS_4 has 5 observations and 15 variables. NOTE: The data set WORK._LOOP_4 has 0 observations and 15 variables. NOTE: DATA statement used (Total process time): real time 0.20 seconds cpu time 0.04 seconds NOTE: There were 0 observations read from the data set WORK._LOOP_4. NOTE: The data set WORK._DOS_4_2 has 0 observations and 16 variables. NOTE: DATA statement used (Total process time): real time 0.18 seconds cpu time 0.03 seconds NOTE: There were 0 observations read from the data set WORK._LOOP_4. NOTE: The data set WORK._DOS_4_3 has 0 observations and 16 variables. NOTE: DATA statement used (Total process time): real time 0.04 seconds cpu time 0.03 seconds NOTE: Table WORK._DOS_2_3 has been dropped. NOTE: Table WORK._DOS_3_2 has been dropped. NOTE: Table WORK._DOS_3_3 has been dropped. NOTE: Table WORK._DOS_4_2 has been dropped. NOTE: Table WORK._DOS_4_3 has been dropped. NOTE: Table WORK._LOOP_3 has been dropped. NOTE: Table WORK._LOOP_4 has been dropped. NOTE: PROCEDURE SQL used (Total process time): real time 0.13 seconds cpu time 0.09 seconds NOTE: There were 17026 observations read from the data set WORK._DOS_1. NOTE: There were 529 observations read from the data set WORK._DOS_1_2. NOTE: There were 3 observations read from the data set WORK._DOS_1_3. NOTE: There were 514 observations read from the data set WORK._DOS_2. NOTE: There were 4 observations read from the data set WORK._DOS_2_2. NOTE: There were 19 observations read from the data set WORK._DOS_3. NOTE: There were 5 observations read from the data set WORK._DOS_4. NOTE: The data set WORK._DOSALL has 17026 observations and 86 variables. NOTE: DATA statement used (Total process time): real time 0.26 seconds cpu time 0.23 seconds NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds NOTE: There were 17564 observations read from the data set WORK._MED. NOTE: The data set WORK._MED_1 has 17026 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.10 seconds cpu time 0.04 seconds NOTE: There were 17564 observations read from the data set WORK._MED. NOTE: The data set WORK._MED_2 has 514 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.25 seconds cpu time 0.01 seconds NOTE: There were 17564 observations read from the data set WORK._MED. NOTE: The data set WORK._MED_3 has 19 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.57 seconds cpu time 0.04 seconds NOTE: There were 17564 observations read from the data set WORK._MED. NOTE: The data set WORK._MED_4 has 5 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.56 seconds cpu time 0.04 seconds NOTE: There were 17026 observations read from the data set WORK._MED_1. NOTE: There were 514 observations read from the data set WORK._MED_2. NOTE: There were 19 observations read from the data set WORK._MED_3. NOTE: There were 5 observations read from the data set WORK._MED_4. NOTE: The data set WORK._MEDALL has 17026 observations and 10 variables. NOTE: DATA statement used (Total process time): real time 0.20 seconds cpu time 0.07 seconds NOTE: There were 101 observations read from the data set WORK._ICH. NOTE: The data set WORK._ICH has 101 observations and 13 variables. NOTE: DATA statement used (Total process time): real time 0.73 seconds cpu time 0.06 seconds NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Variable ich_infu_ft_reason_no_value_1 is uninitialized. NOTE: There were 101 observations read from the data set WORK._ICH. NOTE: The data set WORK._ICH_1 has 91 observations and 11 variables. NOTE: DATA statement used (Total process time): real time 0.23 seconds cpu time 0.03 seconds NOTE: Variable ich_infu_ft_reason_no_value_2 is uninitialized. NOTE: There were 101 observations read from the data set WORK._ICH. NOTE: The data set WORK._ICH_2 has 8 observations and 11 variables. NOTE: DATA statement used (Total process time): real time 0.34 seconds cpu time 0.03 seconds NOTE: Variable ich_infu_ft_reason_no_value_3 is uninitialized. NOTE: There were 101 observations read from the data set WORK._ICH. NOTE: The data set WORK._ICH_3 has 2 observations and 11 variables. NOTE: DATA statement used (Total process time): real time 0.18 seconds cpu time 0.03 seconds NOTE: There were 91 observations read from the data set WORK._ICH_1. NOTE: There were 8 observations read from the data set WORK._ICH_2. NOTE: There were 2 observations read from the data set WORK._ICH_3. NOTE: The data set WORK._ICHALL has 91 observations and 29 variables. NOTE: DATA statement used (Total process time): real time 0.12 seconds cpu time 0.03 seconds NOTE: PROCEDURE SQL used (Total process time): real time 0.04 seconds cpu time 0.04 seconds NOTE: There were 6239 observations read from the data set WORK._SUR. NOTE: The data set WORK._SUR_1 has 4499 observations and 7 variables. NOTE: DATA statement used (Total process time): real time 0.21 seconds cpu time 0.06 seconds NOTE: There were 6239 observations read from the data set WORK._SUR. NOTE: The data set WORK._SUR_2 has 1078 observations and 7 variables. NOTE: DATA statement used (Total process time): real time 0.40 seconds cpu time 0.06 seconds NOTE: There were 6239 observations read from the data set WORK._SUR. NOTE: The data set WORK._SUR_3 has 353 observations and 7 variables. NOTE: DATA statement used (Total process time): real time 0.39 seconds cpu time 0.06 seconds NOTE: There were 6239 observations read from the data set WORK._SUR. NOTE: The data set WORK._SUR_4 has 145 observations and 7 variables. NOTE: DATA statement used (Total process time): real time 0.60 seconds cpu time 0.04 seconds NOTE: There were 6239 observations read from the data set WORK._SUR. NOTE: The data set WORK._SUR_5 has 70 observations and 7 variables. NOTE: DATA statement used (Total process time): real time 0.17 seconds cpu time 0.04 seconds NOTE: There were 6239 observations read from the data set WORK._SUR. NOTE: The data set WORK._SUR_6 has 40 observations and 7 variables. NOTE: DATA statement used (Total process time): real time 0.28 seconds cpu time 0.06 seconds NOTE: There were 6239 observations read from the data set WORK._SUR. NOTE: The data set WORK._SUR_7 has 23 observations and 7 variables. NOTE: DATA statement used (Total process time): real time 0.21 seconds cpu time 0.04 seconds NOTE: There were 6239 observations read from the data set WORK._SUR. NOTE: The data set WORK._SUR_8 has 17 observations and 7 variables. NOTE: DATA statement used (Total process time): real time 0.26 seconds cpu time 0.04 seconds NOTE: There were 6239 observations read from the data set WORK._SUR. NOTE: The data set WORK._SUR_9 has 9 observations and 7 variables. NOTE: DATA statement used (Total process time): real time 0.56 seconds cpu time 0.04 seconds NOTE: There were 6239 observations read from the data set WORK._SUR. NOTE: The data set WORK._SUR_10 has 5 observations and 7 variables. NOTE: DATA statement used (Total process time): real time 0.35 seconds cpu time 0.06 seconds NOTE: There were 4499 observations read from the data set WORK._SUR_1. NOTE: There were 5 observations read from the data set WORK._SUR_10. NOTE: There were 1078 observations read from the data set WORK._SUR_2. NOTE: There were 353 observations read from the data set WORK._SUR_3. NOTE: There were 145 observations read from the data set WORK._SUR_4. NOTE: There were 70 observations read from the data set WORK._SUR_5. NOTE: There were 40 observations read from the data set WORK._SUR_6. NOTE: There were 23 observations read from the data set WORK._SUR_7. NOTE: There were 17 observations read from the data set WORK._SUR_8. NOTE: There were 9 observations read from the data set WORK._SUR_9. NOTE: The data set WORK._SURALL has 4499 observations and 52 variables. NOTE: DATA statement used (Total process time): real time 0.07 seconds cpu time 0.07 seconds NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 261:53 261:109 261:156 NOTE: There were 698 observations read from the data set WORK._VAC. NOTE: The data set WORK._VACAA has 413 observations and 6 variables. NOTE: The data set WORK._VACBB has 285 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.04 seconds cpu time 0.04 seconds NOTE: There were 413 observations read from the data set WORK._VACAA. NOTE: The data set WORK._VACA has 413 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds NOTE: There were 285 observations read from the data set WORK._VACBB. NOTE: The data set WORK._VACB has 285 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds NOTE: There were 413 observations read from the data set WORK._VACA. NOTE: The data set WORK._VAC_A_1 has 409 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds NOTE: There were 413 observations read from the data set WORK._VACA. NOTE: The data set WORK._VAC_A_2 has 4 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds NOTE: There were 285 observations read from the data set WORK._VACB. NOTE: The data set WORK._VAC_B_1 has 279 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds NOTE: There were 285 observations read from the data set WORK._VACB. NOTE: The data set WORK._VAC_B_2 has 5 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds NOTE: There were 285 observations read from the data set WORK._VACB. NOTE: The data set WORK._VAC_B_3 has 1 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds NOTE: There were 409 observations read from the data set WORK._VAC_A_1. NOTE: There were 4 observations read from the data set WORK._VAC_A_2. NOTE: There were 279 observations read from the data set WORK._VAC_B_1. NOTE: There were 5 observations read from the data set WORK._VAC_B_2. NOTE: There were 1 observations read from the data set WORK._VAC_B_3. NOTE: The data set WORK._VACALL has 539 observations and 18 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds NOTE: There were 32592 observations read from the data set WORK._JSO. NOTE: There were 32592 observations read from the data set WORK._INSALL. NOTE: There were 17026 observations read from the data set WORK._MEDALL. NOTE: There were 17026 observations read from the data set WORK._DOSALL. NOTE: There were 91 observations read from the data set WORK._ICHALL. NOTE: There were 4499 observations read from the data set WORK._SURALL. NOTE: There were 539 observations read from the data set WORK._VACALL. NOTE: The data set WORK.JSONALL has 32592 observations and 417 variables. NOTE: DATA statement used (Total process time): real time 4.43 seconds cpu time 4.12 seconds Directory Libref WORK Engine V9 Physical Name C:\Users\bil7\AppData\Local\Temp\SAS Temporary Files\_TD14916_D347430_ Filename C:\Users\bil7\AppData\Local\Temp\SAS Temporary Files\_TD14916_D347430_ Member # Name Type File Size Last Modified 1 JSONALL DATA 3GB 08/12/2021 06:30:39 2 _DOS DATA 29MB 08/12/2021 06:30:07 3 _DOSALL DATA 180MB 08/12/2021 06:30:21 4 _DOS_1 DATA 27MB 08/12/2021 06:30:15 5 _DOS_1_2 DATA 1MB 08/12/2021 06:30:16 6 _DOS_1_3 DATA 264KB 08/12/2021 06:30:16 7 _DOS_2 DATA 1MB 08/12/2021 06:30:17 8 _DOS_2_2 DATA 264KB 08/12/2021 06:30:18 9 _DOS_3 DATA 264KB 08/12/2021 06:30:18 10 _DOS_4 DATA 264KB 08/12/2021 06:30:20 11 _ICH DATA 756KB 08/12/2021 06:30:27 12 _ICHALL DATA 288KB 08/12/2021 06:30:29 13 _ICH_1 DATA 128KB 08/12/2021 06:30:28 14 _ICH_2 DATA 128KB 08/12/2021 06:30:29 15 _ICH_3 DATA 128KB 08/12/2021 06:30:29 16 _INS DATA 21MB 08/12/2021 06:30:11 17 _INSALL DATA 29MB 08/12/2021 06:30:13 18 _JSO DATA 2GB 08/12/2021 06:30:10 19 _JUNK_1 DATA 28MB 08/12/2021 06:30:14 20 _JUNK_2 DATA 1MB 08/12/2021 06:30:17 21 _JUNK_3 DATA 264KB 08/12/2021 06:30:18 22 _JUNK_4 DATA 264KB 08/12/2021 06:30:19 23 _LOOP_1 DATA 1MB 08/12/2021 06:30:15 24 _LOOP_2 DATA 264KB 08/12/2021 06:30:17 25 _MED DATA 10MB 08/12/2021 06:30:07 26 _MEDALL DATA 5MB 08/12/2021 06:30:25 27 _MED_1 DATA 2MB 08/12/2021 06:30:22 28 _MED_2 DATA 192KB 08/12/2021 06:30:22 29 _MED_3 DATA 128KB 08/12/2021 06:30:23 30 _MED_4 DATA 128KB 08/12/2021 06:30:24 31 _SUR DATA 19MB 08/12/2021 06:30:07 32 _SURALL DATA 11MB 08/12/2021 06:30:35 33 _SUR_1 DATA 1MB 08/12/2021 06:30:30 34 _SUR_10 DATA 128KB 08/12/2021 06:30:35 35 _SUR_2 DATA 448KB 08/12/2021 06:30:30 36 _SUR_3 DATA 192KB 08/12/2021 06:30:31 37 _SUR_4 DATA 128KB 08/12/2021 06:30:32 38 _SUR_5 DATA 128KB 08/12/2021 06:30:32 39 _SUR_6 DATA 128KB 08/12/2021 06:30:33 40 _SUR_7 DATA 128KB 08/12/2021 06:30:33 41 _SUR_8 DATA 128KB 08/12/2021 06:30:33 42 _SUR_9 DATA 128KB 08/12/2021 06:30:34 43 _VAC DATA 576KB 08/12/2021 06:30:07 44 _VACA DATA 384KB 08/12/2021 06:30:35 45 _VACAA DATA 384KB 08/12/2021 06:30:35 46 _VACALL DATA 384KB 08/12/2021 06:30:35 47 _VACB DATA 320KB 08/12/2021 06:30:35 48 _VACBB DATA 320KB 08/12/2021 06:30:35 49 _VAC_A_1 DATA 192KB 08/12/2021 06:30:35 50 _VAC_A_2 DATA 128KB 08/12/2021 06:30:35 51 _VAC_B_1 DATA 128KB 08/12/2021 06:30:35 52 _VAC_B_2 DATA 128KB 08/12/2021 06:30:35 53 _VAC_B_3 DATA 128KB 08/12/2021 06:30:35 NOTE: MODIFY was successful for WORK.JSONALL.DATA. NOTE: PROCEDURE DATASETS used (Total process time): real time 1.35 seconds cpu time 0.07 seconds NOTE: Deleting WORK._DOS (memtype=DATA). NOTE: Deleting WORK._DOSALL (memtype=DATA). NOTE: Deleting WORK._DOS_1 (memtype=DATA). NOTE: Deleting WORK._DOS_1_2 (memtype=DATA). NOTE: Deleting WORK._DOS_1_3 (memtype=DATA). NOTE: Deleting WORK._DOS_2 (memtype=DATA). NOTE: Deleting WORK._DOS_2_2 (memtype=DATA). NOTE: Deleting WORK._DOS_3 (memtype=DATA). NOTE: Deleting WORK._DOS_4 (memtype=DATA). NOTE: Deleting WORK._ICH (memtype=DATA). NOTE: Deleting WORK._ICHALL (memtype=DATA). NOTE: Deleting WORK._ICH_1 (memtype=DATA). NOTE: Deleting WORK._ICH_2 (memtype=DATA). NOTE: Deleting WORK._ICH_3 (memtype=DATA). NOTE: Deleting WORK._INS (memtype=DATA). NOTE: Deleting WORK._INSALL (memtype=DATA). NOTE: Deleting WORK._JSO (memtype=DATA). NOTE: Deleting WORK._JUNK_1 (memtype=DATA). NOTE: Deleting WORK._JUNK_2 (memtype=DATA). NOTE: Deleting WORK._JUNK_3 (memtype=DATA). NOTE: Deleting WORK._JUNK_4 (memtype=DATA). NOTE: Deleting WORK._LOOP_1 (memtype=DATA). NOTE: Deleting WORK._LOOP_2 (memtype=DATA). NOTE: Deleting WORK._MED (memtype=DATA). NOTE: Deleting WORK._MEDALL (memtype=DATA). NOTE: Deleting WORK._MED_1 (memtype=DATA). NOTE: Deleting WORK._MED_2 (memtype=DATA). NOTE: Deleting WORK._MED_3 (memtype=DATA). NOTE: Deleting WORK._MED_4 (memtype=DATA). NOTE: Deleting WORK._SUR (memtype=DATA). NOTE: Deleting WORK._SURALL (memtype=DATA). NOTE: Deleting WORK._SUR_1 (memtype=DATA). NOTE: Deleting WORK._SUR_10 (memtype=DATA). NOTE: Deleting WORK._SUR_2 (memtype=DATA). NOTE: Deleting WORK._SUR_3 (memtype=DATA). NOTE: Deleting WORK._SUR_4 (memtype=DATA). NOTE: Deleting WORK._SUR_5 (memtype=DATA). NOTE: Deleting WORK._SUR_6 (memtype=DATA). NOTE: Deleting WORK._SUR_7 (memtype=DATA). NOTE: Deleting WORK._SUR_8 (memtype=DATA). NOTE: Deleting WORK._SUR_9 (memtype=DATA). NOTE: Deleting WORK._VAC (memtype=DATA). NOTE: Deleting WORK._VACA (memtype=DATA). NOTE: Deleting WORK._VACAA (memtype=DATA). NOTE: Deleting WORK._VACALL (memtype=DATA). NOTE: Deleting WORK._VACB (memtype=DATA). NOTE: Deleting WORK._VACBB (memtype=DATA). NOTE: Deleting WORK._VAC_A_1 (memtype=DATA). NOTE: Deleting WORK._VAC_A_2 (memtype=DATA). NOTE: Deleting WORK._VAC_B_1 (memtype=DATA). NOTE: Deleting WORK._VAC_B_2 (memtype=DATA). NOTE: Deleting WORK._VAC_B_3 (memtype=DATA). NOTE: PROCEDURE DATASETS used (Total process time): real time 1.09 seconds cpu time 0.50 seconds NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 367:54 367:110 367:157 368:53 368:109 368:156 369:53 369:109 369:156 371:54 371:110 371:157 372:53 372:109 372:156 373:53 373:109 373:156 375:54 375:110 375:157 376:53 376:109 376:156 378:23 379:25 380:24 381:53 381:109 381:156 398:14 399:14 400:14 401:14 450:52 NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 32458 at 378:43 32434 at 379:47 32425 at 380:45 NOTE: There were 32592 observations read from the data set WORK.JSONALL. NOTE: The data set WORK._JSONALL_PREFINAL has 32592 observations and 830 variables. NOTE: DATA statement used (Total process time): real time 9.09 seconds cpu time 8.10 seconds NOTE: WORK._MAP data set was successfully created. NOTE: The data set WORK._MAP has 613 observations and 1 variables. NOTE: PROCEDURE IMPORT used (Total process time): real time 1.62 seconds cpu time 0.70 seconds  The SAS System 06:30 Thursday, August 12, 2021 1 var_name ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ id subject_id _date_of_visit SubjectId_Latest htc_id is_update _date_submitted date_submitted DateEntered submitted_by LastUpdated UpdatedBy Version _udc_last_visit_date weight_date height height_unknown height_date weight weight_unknown most_rece_inhi_draw_date zipcode patient_highest_edu_level patient_grade_level patient_employment_status congenital_bleed_disor_his specific_genetic_mutation _combine_htc_service inhi_hemlibra_use inhi_cba_date _inhi_cba_date_qual _inhi_cba_titr_combine inhi_cba_titr_neg inhi_nba_date _inhi_nba_date_qual _inhi_nba_titr_combine inhi_nba_titr_neg most_rece_inhi_date_type _combine_inhi_mostrcnt most_rece_inhi_result_not_avai most_rece_inhi_below_value _combine_highest_historic_inh pat_iti_his _combine_day_miss_school pat_iti_his_high_his_inhi pat_iti_his_high_his_inhi_unk his_immune_modulation_therapy _combine_bleeding_tx_product current_treatment_regimen clot_fact_con clot_fact_con_date_age_unk  The SAS System 06:30 Thursday, August 12, 2021 2 var_name ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ clot_fact_con_date_qualifier clot_fact_con_date joint_bleed_history percent_of_doses _combine_tx_used_ludc tma_ludc _tma_ludc allergic_reaction _combine_algic_med_name cvad cvad_last_udc_visit cvad_compl_last_udc _combine_cvad_compl ich_history history_of_joint_bleeds age_date_unknown date_first_joint_bleed_qual date_first_joint_bleed number_ble_ankle_left number_ble_ankle_right _combine_joint_ble_ankle_cat number_ble_elbow_left number_ble_elbow_right _combine_joint_ble_elbow_cat number_ble_hip_left number_ble_hip_right _combine_joint_ble_hip_cat number_ble_knee_left number_ble_knee_right _combine_joint_ble_knee_cat number_ble_shoulder_left number_ble_shoulder_right _combine_joint_ble_shoulder_cat _joint_ble_left_ankle_ludc _joint_ble_right_ankle_ludc _joint_ble_ankle_ludc_sum _joint_ble_left_elbow_ludc _joint_ble_right_elbow_ludc _joint_ble_elbow_ludc_sum _joint_ble_left_hip_ludc _joint_ble_right_hip_ludc _joint_ble_hip_ludc_sum _joint_ble_left_knee_ludc _joint_ble_right_knee_ludc _joint_ble_knee_ludc_sum _joint_ble_left_shoulder_ludc _joint_ble_right_shoulder_ludc _joint_ble_shoulder_ludc_sum number_treat_ble_event other_bleeds gastr  The SAS System 06:30 Thursday, August 12, 2021 3 var_name ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ _combine_gastro_methd geni_hema _combine_genit_hemat_methd geni_oth _combine_genit_othr_methd head_extr _combine_head_extrcl muscle _combine_muscl_methd nasal_muco _combine_nas_mucsa_methd oral _combine_oral_methd other _combine_oth_methd soft_tiss _combine_sft_tisue_methd spine _combine_spine_methd his_invasive_joint_proc _combine_synove_arthr_joi _combine_synove_open_joi _combine_synove_radio_joi _combine_synove_unkn_joi _combine_rplcm_arthr_joi _combine_surgcl_arthr_joi _combine_othr_inva_proc_joi pain_loss_motion_weakness ble_dis_chro_pain_12_mon ble_dis_chro_pain_12_mon_freq opioids_12_mon opioids_12_mon_freq er_visit_12_mon er_visit_12_mon_freq inpat_adm inpat_adm_occur inpat_adm_night hep_a_vaccination hep_b_vaccination circum circum_clot_factor_concent circum_exce_bleed iron_replacement menstrual_bleeding hysterectomy hysterectomy_date hysterectomy_date_qualifier hcc leukemia other_cancer fracture  The SAS System 06:30 Thursday, August 12, 2021 4 var_name ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ ostopenia osteoporosis acute_ischemic_stroke atrial_fibrilation coronary_artery_disease congestive_heart_failure myocardial_infarction transient_ischemic_attach chronic_kidney_disease kidney_stones nephrotic_syndrome ascites cirrhosis hepatic_fibrosis splenoomegaly varices deep_vein_thrombosis pulmonary_embolisim anxiety depression diabetes_melitus hypertension iron_deficiency_anemia pseudotumor coronary_artery_angioplasty coronary_artery_stent_place coronary_artery_bypass_graft dialysis_peritoneal dialysis_hemodialysis heart_valve_replacement heart_valve_repair kidney_transplant liver_transplant peripheral_revascularization surg_12_mon FileName DateImp Deleted DeletedComments ins_commercial_ins ins_military_health ins_medicaid ins_medicare ins_state_programs ins_indian_health ins_other ins_uninsured ins_unknown ins_support_programs _combine_insur_primary _combine_insur_type  The SAS System 06:30 Thursday, August 12, 2021 5 var_name ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ cur_clot_ft_med_1 cur_clot_ft_med_2 cur_clot_ft_med_3 cur_clot_ft_med_4 cur_clot_ft_med_5 cur_clot_ft_med_6 cur_clot_ft_med_7 cur_clot_ft_med_8 cur_clot_ft_med_9 cur_clot_ft_med_10 cur_clot_ft_med_1_ds_1_inst cur_clot_ft_med_1_ds_1_int_val cur_clot_ft_med_1_ds_1_int_ter cur_clot_ft_med_1_ds_1_repet cur_clot_ft_med_1_ds_1_pri_reg cur_clot_ft_med_1_ds_1_range cur_clot_ft_med_1_ds_1_max cur_clot_ft_med_1_ds_1_min cur_clot_ft_med_1_ds_1_type cur_clot_ft_med_1_ds_1_units cur_clot_ft_med_1_ds_1_value cur_clot_ft_med_1_ds_2_inst cur_clot_ft_med_1_ds_2_int_val cur_clot_ft_med_1_ds_2_int_ter cur_clot_ft_med_1_ds_2_repet cur_clot_ft_med_1_ds_2_pri_reg cur_clot_ft_med_1_ds_2_range cur_clot_ft_med_1_ds_2_max cur_clot_ft_med_1_ds_2_min cur_clot_ft_med_1_ds_2_type cur_clot_ft_med_1_ds_2_units cur_clot_ft_med_1_ds_2_value cur_clot_ft_med_2_ds_1_inst cur_clot_ft_med_2_ds_1_int_val cur_clot_ft_med_2_ds_1_int_ter cur_clot_ft_med_2_ds_1_repet cur_clot_ft_med_2_ds_1_pri_reg cur_clot_ft_med_2_ds_1_range cur_clot_ft_med_2_ds_1_max cur_clot_ft_med_2_ds_1_min cur_clot_ft_med_2_ds_1_type cur_clot_ft_med_2_ds_1_units cur_clot_ft_med_2_ds_1_value cur_clot_ft_med_2_ds_2_inst cur_clot_ft_med_2_ds_2_int_val cur_clot_ft_med_2_ds_2_int_ter cur_clot_ft_med_2_ds_2_repet cur_clot_ft_med_2_ds_2_pri_reg cur_clot_ft_med_2_ds_2_range cur_clot_ft_med_2_ds_2_max cur_clot_ft_med_2_ds_2_min  The SAS System 06:30 Thursday, August 12, 2021 6 var_name ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ cur_clot_ft_med_2_ds_2_type cur_clot_ft_med_2_ds_2_units cur_clot_ft_med_2_ds_2_value cur_clot_ft_med_3_ds_1_inst cur_clot_ft_med_3_ds_1_int_val cur_clot_ft_med_3_ds_1_int_ter cur_clot_ft_med_3_ds_1_repet cur_clot_ft_med_3_ds_1_pri_reg cur_clot_ft_med_3_ds_1_range cur_clot_ft_med_3_ds_1_max cur_clot_ft_med_3_ds_1_min cur_clot_ft_med_3_ds_1_type cur_clot_ft_med_3_ds_1_units cur_clot_ft_med_3_ds_1_value cur_clot_ft_med_3_ds_2_inst cur_clot_ft_med_3_ds_2_int_val cur_clot_ft_med_3_ds_2_int_ter cur_clot_ft_med_3_ds_2_repet cur_clot_ft_med_3_ds_2_pri_reg cur_clot_ft_med_3_ds_2_range cur_clot_ft_med_3_ds_2_max cur_clot_ft_med_3_ds_2_min cur_clot_ft_med_3_ds_2_type cur_clot_ft_med_3_ds_2_units cur_clot_ft_med_3_ds_2_value cur_clot_ft_med_4_ds_1_inst cur_clot_ft_med_4_ds_1_int_val cur_clot_ft_med_4_ds_1_int_ter cur_clot_ft_med_4_ds_1_repet cur_clot_ft_med_4_ds_1_pri_reg cur_clot_ft_med_4_ds_1_range cur_clot_ft_med_4_ds_1_max cur_clot_ft_med_4_ds_1_min cur_clot_ft_med_4_ds_1_type cur_clot_ft_med_4_ds_1_units cur_clot_ft_med_4_ds_1_value cur_clot_ft_med_4_ds_2_inst cur_clot_ft_med_4_ds_2_int_val cur_clot_ft_med_4_ds_2_int_ter cur_clot_ft_med_4_ds_2_repet cur_clot_ft_med_4_ds_2_pri_reg cur_clot_ft_med_4_ds_2_range cur_clot_ft_med_4_ds_2_max cur_clot_ft_med_4_ds_2_min cur_clot_ft_med_4_ds_2_type cur_clot_ft_med_4_ds_2_units cur_clot_ft_med_4_ds_2_value cur_clot_ft_med_5_ds_1_inst cur_clot_ft_med_5_ds_1_int_val cur_clot_ft_med_5_ds_1_int_ter cur_clot_ft_med_5_ds_1_repet  The SAS System 06:30 Thursday, August 12, 2021 7 var_name ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ cur_clot_ft_med_5_ds_1_pri_reg cur_clot_ft_med_5_ds_1_range cur_clot_ft_med_5_ds_1_max cur_clot_ft_med_5_ds_1_min cur_clot_ft_med_5_ds_1_type cur_clot_ft_med_5_ds_1_units cur_clot_ft_med_5_ds_1_value cur_clot_ft_med_5_ds_2_inst cur_clot_ft_med_5_ds_2_int_val cur_clot_ft_med_5_ds_2_int_ter cur_clot_ft_med_5_ds_2_repet cur_clot_ft_med_5_ds_2_pri_reg cur_clot_ft_med_5_ds_2_range cur_clot_ft_med_5_ds_2_max cur_clot_ft_med_5_ds_2_min cur_clot_ft_med_5_ds_2_type cur_clot_ft_med_5_ds_2_units cur_clot_ft_med_5_ds_2_value cur_clot_ft_med_6_ds_1_inst cur_clot_ft_med_6_ds_1_int_val cur_clot_ft_med_6_ds_1_int_ter cur_clot_ft_med_6_ds_1_repet cur_clot_ft_med_6_ds_1_pri_reg cur_clot_ft_med_6_ds_1_range cur_clot_ft_med_6_ds_1_max cur_clot_ft_med_6_ds_1_min cur_clot_ft_med_6_ds_1_type cur_clot_ft_med_6_ds_1_units cur_clot_ft_med_6_ds_1_value cur_clot_ft_med_6_ds_2_inst cur_clot_ft_med_6_ds_2_int_val cur_clot_ft_med_6_ds_2_int_ter cur_clot_ft_med_6_ds_2_repet cur_clot_ft_med_6_ds_2_pri_reg cur_clot_ft_med_6_ds_2_range cur_clot_ft_med_6_ds_2_max cur_clot_ft_med_6_ds_2_min cur_clot_ft_med_6_ds_2_type cur_clot_ft_med_6_ds_2_units cur_clot_ft_med_6_ds_2_value cur_clot_ft_med_7_ds_1_inst cur_clot_ft_med_7_ds_1_int_val cur_clot_ft_med_7_ds_1_int_ter cur_clot_ft_med_7_ds_1_repet cur_clot_ft_med_7_ds_1_pri_reg cur_clot_ft_med_7_ds_1_range cur_clot_ft_med_7_ds_1_max cur_clot_ft_med_7_ds_1_min cur_clot_ft_med_7_ds_1_type cur_clot_ft_med_7_ds_1_units cur_clot_ft_med_7_ds_1_value  The SAS System 06:30 Thursday, August 12, 2021 8 var_name ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ cur_clot_ft_med_7_ds_2_inst cur_clot_ft_med_7_ds_2_int_val cur_clot_ft_med_7_ds_2_int_ter cur_clot_ft_med_7_ds_2_repet cur_clot_ft_med_7_ds_2_pri_reg cur_clot_ft_med_7_ds_2_range cur_clot_ft_med_7_ds_2_max cur_clot_ft_med_7_ds_2_min cur_clot_ft_med_7_ds_2_type cur_clot_ft_med_7_ds_2_units cur_clot_ft_med_7_ds_2_value cur_clot_ft_med_8_ds_1_inst cur_clot_ft_med_8_ds_1_int_val cur_clot_ft_med_8_ds_1_int_ter cur_clot_ft_med_8_ds_1_repet cur_clot_ft_med_8_ds_1_pri_reg cur_clot_ft_med_8_ds_1_range cur_clot_ft_med_8_ds_1_max cur_clot_ft_med_8_ds_1_min cur_clot_ft_med_8_ds_1_type cur_clot_ft_med_8_ds_1_units cur_clot_ft_med_8_ds_1_value cur_clot_ft_med_8_ds_2_inst cur_clot_ft_med_8_ds_2_int_val cur_clot_ft_med_8_ds_2_int_ter cur_clot_ft_med_8_ds_2_repet cur_clot_ft_med_8_ds_2_pri_reg cur_clot_ft_med_8_ds_2_range cur_clot_ft_med_8_ds_2_max cur_clot_ft_med_8_ds_2_min cur_clot_ft_med_8_ds_2_type cur_clot_ft_med_8_ds_2_units cur_clot_ft_med_8_ds_2_value cur_clot_ft_med_9_ds_1_inst cur_clot_ft_med_9_ds_1_int_val cur_clot_ft_med_9_ds_1_int_ter cur_clot_ft_med_9_ds_1_repet cur_clot_ft_med_9_ds_1_pri_reg cur_clot_ft_med_9_ds_1_range cur_clot_ft_med_9_ds_1_max cur_clot_ft_med_9_ds_1_min cur_clot_ft_med_9_ds_1_type cur_clot_ft_med_9_ds_1_units cur_clot_ft_med_9_ds_1_value cur_clot_ft_med_9_ds_2_inst cur_clot_ft_med_9_ds_2_int_val cur_clot_ft_med_9_ds_2_int_ter cur_clot_ft_med_9_ds_2_repet cur_clot_ft_med_9_ds_2_pri_reg cur_clot_ft_med_9_ds_2_range cur_clot_ft_med_9_ds_2_max  The SAS System 06:30 Thursday, August 12, 2021 9 var_name ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ cur_clot_ft_med_9_ds_2_min cur_clot_ft_med_9_ds_2_type cur_clot_ft_med_9_ds_2_units cur_clot_ft_med_9_ds_2_value cur_clot_ft_med_10_ds_1_inst cur_clot_ft_med_10_ds_1_int_val cur_clot_ft_med_10_ds_1_int_ter cur_clot_ft_med_10_ds_1_repet cur_clot_ft_med_10_ds_1_pri_reg cur_clot_ft_med_10_ds_1_range cur_clot_ft_med_10_ds_1_max cur_clot_ft_med_10_ds_1_min cur_clot_ft_med_10_ds_1_type cur_clot_ft_med_10_ds_1_units cur_clot_ft_med_10_ds_1_value cur_clot_ft_med_10_ds_2_inst cur_clot_ft_med_10_ds_2_int_val cur_clot_ft_med_10_ds_2_int_ter cur_clot_ft_med_10_ds_2_repet cur_clot_ft_med_10_ds_2_pri_reg cur_clot_ft_med_10_ds_2_range cur_clot_ft_med_10_ds_2_max cur_clot_ft_med_10_ds_2_min cur_clot_ft_med_10_ds_2_type cur_clot_ft_med_10_ds_2_units cur_clot_ft_med_10_ds_2_value _combine_cur_clot_fac_med _combine_cur_clot_fac_med_fi1 _combine_cur_clot_fac_med_fiv1 _combine_cur_clot_fac_med_fit1 _combine_cur_clot_fac_med_fr1 _combine_cur_clot_pri_reg1 _combine_cur_clot_fac_med_r1 _combine_cur_clot_fac_med_dmx1 _combine_cur_clot_fac_med_dm1 _combine_cur_clot_fac_med_type1 _combine_cur_clot_fac_med_du1 _combine_cur_clot_fac_med_da1 _combine_cur_clot_fac_med_fi2 _combine_cur_clot_fac_med_fiv2 _combine_cur_clot_fac_med_fit2 _combine_cur_clot_fac_med_fr2 _combine_cur_clot_pri_reg2 _combine_cur_clot_fac_med_r2 _combine_cur_clot_fac_med_dmx2 _combine_cur_clot_fac_med_dm2 _combine_cur_clot_fac_med_type2 _combine_cur_clot_fac_med_du2 _combine_cur_clot_fac_med_da2 _combine_cur_clot_fac_med_fi _combine_cur_clot_fac_med_fiv  The SAS System 06:30 Thursday, August 12, 2021 10 var_name ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ _combine_cur_clot_fac_med_fit _combine_cur_clot_fac_med_fr _combine_cur_clot_pri_reg _combine_cur_clot_fac_med_r _combine_cur_clot_fac_med_dmx _combine_cur_clot_fac_med_dm _combine_cur_clot_fac_med_type _combine_cur_clot_fac_med_du _combine_cur_clot_fac_med_da ich_date_1 ich_anatomical_loca_1 ich_date_qualifier_1 ich_prec_head_trauma_1 ich_conti_prophy_1 ich_infu_ft_giv_1 ich_infu_ft_giv_period_1 ich_date_2 ich_anatomical_loca_2 ich_date_qualifier_2 ich_prec_head_trauma_2 ich_conti_prophy_2 ich_infu_ft_giv_2 ich_infu_ft_giv_period_2 ich_date_3 ich_anatomical_loca_3 ich_date_qualifier_3 ich_prec_head_trauma_3 ich_conti_prophy_3 ich_infu_ft_giv_3 ich_infu_ft_giv_period_3 ich_date_4 ich_anatomical_loca_4 ich_date_qualifier_4 ich_prec_head_trauma_4 ich_conti_prophy_4 ich_infu_ft_giv_4 ich_infu_ft_giv_period_4 ich_date_5 ich_anatomical_loca_5 ich_date_qualifier_5 ich_prec_head_trauma_5 ich_conti_prophy_5 ich_infu_ft_giv_5 ich_infu_ft_giv_period_5 ich_date_6 ich_anatomical_loca_6 ich_date_qualifier_6 ich_prec_head_trauma_6 ich_conti_prophy_6 ich_infu_ft_giv_6 ich_infu_ft_giv_period_6  The SAS System 06:30 Thursday, August 12, 2021 11 var_name ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ ich_date_7 ich_anatomical_loca_7 ich_date_qualifier_7 ich_prec_head_trauma_7 ich_conti_prophy_7 ich_infu_ft_giv_7 ich_infu_ft_giv_period_7 ich_date_8 ich_anatomical_loca_8 ich_date_qualifier_8 ich_prec_head_trauma_8 ich_conti_prophy_8 ich_infu_ft_giv_8 ich_infu_ft_giv_period_8 ich_date_9 ich_anatomical_loca_9 ich_date_qualifier_9 ich_prec_head_trauma_9 ich_conti_prophy_9 ich_infu_ft_giv_9 ich_infu_ft_giv_period_9 ich_date_10 ich_anatomical_loca_10 ich_date_qualifier_10 ich_prec_head_trauma_10 ich_conti_prophy_10 ich_infu_ft_giv_10 ich_infu_ft_giv_period_10 _combine_anato_locat _combine_ich_DiagDate _combine_ich_DiagDateDetail _combine_Head_Trauma _combine_ICH_Prophy _combine_Infusion_Factor _combine_Infusion_Factor_Detail surg_12_mon_date_1 surg_12_mon_date_qual_1 surg_12_mon_proc_1 surg_12_mon_anato_loca_1 surg_12_mon_date_2 surg_12_mon_date_qual_2 surg_12_mon_proc_2 surg_12_mon_anato_loca_2 surg_12_mon_date_3 surg_12_mon_date_qual_3 surg_12_mon_proc_3 surg_12_mon_anato_loca_3 surg_12_mon_date_4 surg_12_mon_date_qual_4 surg_12_mon_proc_4 surg_12_mon_anato_loca_4  The SAS System 06:30 Thursday, August 12, 2021 12 var_name ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ surg_12_mon_date_5 surg_12_mon_date_qual_5 surg_12_mon_proc_5 surg_12_mon_anato_loca_5 surg_12_mon_date_6 surg_12_mon_date_qual_6 surg_12_mon_proc_6 surg_12_mon_anato_loca_6 surg_12_mon_date_7 surg_12_mon_date_qual_7 surg_12_mon_proc_7 surg_12_mon_anato_loca_7 surg_12_mon_date_8 surg_12_mon_date_qual_8 surg_12_mon_proc_8 surg_12_mon_anato_loca_8 surg_12_mon_date_9 surg_12_mon_date_qual_9 surg_12_mon_proc_9 surg_12_mon_anato_loca_9 surg_12_mon_date_10 surg_12_mon_date_qual_10 surg_12_mon_proc_10 surg_12_mon_anato_loca_10 surg_12_mon_date_11 surg_12_mon_date_qual_11 surg_12_mon_proc_11 surg_12_mon_anato_loca_11 surg_12_mon_date_12 surg_12_mon_date_qual_12 surg_12_mon_proc_12 surg_12_mon_anato_loca_12 surg_12_mon_date_13 surg_12_mon_date_qual_13 surg_12_mon_proc_13 surg_12_mon_anato_loca_13 surg_12_mon_date_14 surg_12_mon_date_qual_14 surg_12_mon_proc_14 surg_12_mon_anato_loca_14 surg_12_mon_date_15 surg_12_mon_date_qual_15 surg_12_mon_proc_15 surg_12_mon_anato_loca_15 _combine_surgical_prolist _combine_surgical_prolist_date _combine_sur_prolist_date_qual _combine_sur_anato_loca hep_a_vaccinationa hep_a_vaccination_status hep_b_vaccinationa  The SAS System 06:30 Thursday, August 12, 2021 13 var_name ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ hep_b_vaccination_status NOTE: PROCEDURE SQL used (Total process time): real time 1.17 seconds cpu time 0.06 seconds NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 676:53 676:109 676:156 NOTE: There were 32592 observations read from the data set WORK._JSONALL_PREFINAL. NOTE: The data set WORK.SE has 32592 observations and 614 variables. NOTE: DATA statement used (Total process time): real time 33.33 seconds cpu time 9.46 seconds NOTE: There were 32592 observations read from the data set WORK.SE. NOTE: The data set WORK.SE has 32592 observations and 614 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1:46.18 cpu time 17.03 seconds NOTE: Deleting WORK._JSONALL_PREFINAL (memtype=DATA). NOTE: Deleting WORK._MAP (memtype=DATA). NOTE: Deleting WORK.JSONALL (memtype=DATA). NOTE: PROCEDURE DATASETS used (Total process time): real time 1.62 seconds cpu time 1.14 seconds NOTE: There were 16649 observations read from the data set SQLIMPP.registry_initial. NOTE: There were 16649 observations read from the data set SQLIMPP.registry_initial1. NOTE: The data set WORK._EF has 16649 observations and 1389 variables. NOTE: DATA statement used (Total process time): real time 3.81 seconds cpu time 3.28 seconds Directory Libref WORK Engine V9 Physical Name C:\Users\bil7\AppData\Local\Temp\SAS Temporary Files\_TD14916_D347430_ Filename C:\Users\bil7\AppData\Local\Temp\SAS Temporary Files\_TD14916_D347430_ Member # Name Type File Size Last Modified 1 SE DATA 3GB 08/12/2021 06:33:18 2 _EF DATA 441MB 08/12/2021 06:33:25 NOTE: MODIFY was successful for WORK._EF.DATA. NOTE: PROCEDURE DATASETS used (Total process time): real time 1.23 seconds cpu time 0.06 seconds NOTE: The data set WORK._VAR_EF has 1389 observations and 2 variables. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.56 seconds cpu time 0.03 seconds NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 765:32 766:22 NOTE: There were 1389 observations read from the data set WORK._VAR_EF. NOTE: The data set WORK._VAR_EF has 1389 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.54 seconds cpu time 0.03 seconds NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds NOTE: There were 16649 observations read from the data set WORK._EF. NOTE: The data set WORK._EF2 has 16649 observations and 1389 variables. NOTE: DATA statement used (Total process time): real time 1.17 seconds cpu time 0.78 seconds NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 1117:1 1117:1 1117:1 1118:1 1118:1 1118:1 1119:1 1119:1 1119:1 1184:1 1188:89 1188:119 1197:1 1201:89 1201:119 1211:1 1215:89 1215:119 1247:52 1255:1 1255:1 1255:1 1401:4 1473:4 1473:48 NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 15192 at 1255:120 7451 at 1401:49 NOTE: There were 16649 observations read from the data set WORK._EF2. NOTE: The data set WORK._EF_C has 16649 observations and 1531 variables. NOTE: DATA statement used (Total process time): real time 3.95 seconds cpu time 2.54 seconds NOTE: There were 16649 observations read from the data set WORK._EF_C. NOTE: The data set WORK._EF_MAP has 16649 observations and 1532 variables. NOTE: DATA statement used (Total process time): real time 2.15 seconds cpu time 1.32 seconds NOTE: There were 16649 observations read from the data set WORK._EF_MAP. NOTE: The data set WORK._EF_MAP has 16649 observations and 1532 variables. NOTE: PROCEDURE SORT used (Total process time): real time 4.40 seconds cpu time 2.45 seconds WARNING: Multiple lengths were specified for the variable _combine_htc_service by input data set(s). This can cause truncation of data. WARNING: Multiple lengths were specified for the variable inhi_cba_date by input data set(s). This can cause truncation of data. WARNING: Multiple lengths were specified for the variable inhi_nba_date by input data set(s). This can cause truncation of data. WARNING: Multiple lengths were specified for the variable _combine_algic_med_name by input data set(s). This can cause truncation of data. WARNING: Multiple lengths were specified for the variable _combine_cvad_compl by input data set(s). This can cause truncation of data. WARNING: Multiple lengths were specified for the variable other_bleeds by input data set(s). This can cause truncation of data. WARNING: Multiple lengths were specified for the variable gastr by input data set(s). This can cause truncation of data. WARNING: Multiple lengths were specified for the variable geni_hema by input data set(s). This can cause truncation of data. WARNING: Multiple lengths were specified for the variable geni_oth by input data set(s). This can cause truncation of data. WARNING: Multiple lengths were specified for the variable head_extr by input data set(s). This can cause truncation of data. WARNING: Multiple lengths were specified for the variable muscle by input data set(s). This can cause truncation of data. WARNING: Multiple lengths were specified for the variable nasal_muco by input data set(s). This can cause truncation of data. WARNING: Multiple lengths were specified for the variable oral by input data set(s). This can cause truncation of data. WARNING: Multiple lengths were specified for the variable other by input data set(s). This can cause truncation of data. WARNING: Multiple lengths were specified for the variable soft_tiss by input data set(s). This can cause truncation of data. WARNING: Multiple lengths were specified for the variable spine by input data set(s). This can cause truncation of data. NOTE: There were 32592 observations read from the data set WORK.SE. NOTE: There were 16649 observations read from the data set WORK._EF_MAP. NOTE: The data set WORK.IE_SE_COMBINED has 49241 observations and 1595 variables. NOTE: DATA statement used (Total process time): real time 43.10 seconds cpu time 8.78 seconds NOTE: Deleting WORK._EF (memtype=DATA). NOTE: Deleting WORK._EF2 (memtype=DATA). NOTE: Deleting WORK._EF_C (memtype=DATA). NOTE: Deleting WORK._EF_MAP (memtype=DATA). NOTE: Deleting WORK._VAR_EF (memtype=DATA). NOTE: Deleting WORK.SE (memtype=DATA). NOTE: PROCEDURE DATASETS used (Total process time): real time 2.62 seconds cpu time 0.95 seconds NOTE: There were 1476 observations read from the data set SQLIMPP.UDC2_FWP_DOSES. NOTE: The data set WORK._DOSES has 1476 observations and 7 variables. NOTE: DATA statement used (Total process time): real time 0.32 seconds cpu time 0.06 seconds NOTE: There were 11 observations read from the data set SQLIMPP.UDC2_FWP_ICH_LastUDC. NOTE: The data set WORK._LUDC has 11 observations and 11 variables. NOTE: DATA statement used (Total process time): real time 0.18 seconds cpu time 0.06 seconds NOTE: There were 380 observations read from the data set SQLIMPP.UDC2_FWP_SurgicalPro. NOTE: The data set WORK._SPRO has 380 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.18 seconds cpu time 0.04 seconds NOTE: There were 2605 observations read from the data set SQLIMPP.UDC2_FWP. NOTE: The data set WORK._FWP has 2605 observations and 184 variables. NOTE: DATA statement used (Total process time): real time 0.43 seconds cpu time 0.15 seconds NOTE: There were 1476 observations read from the data set WORK._DOSES. NOTE: The data set WORK._DOSES has 1476 observations and 7 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.09 seconds cpu time 0.01 seconds NOTE: There were 11 observations read from the data set WORK._LUDC. NOTE: The data set WORK._LUDC has 11 observations and 11 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds NOTE: There were 380 observations read from the data set WORK._SPRO. NOTE: The data set WORK._SPRO has 380 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.14 seconds cpu time 0.01 seconds NOTE: There were 2605 observations read from the data set WORK._FWP. NOTE: The data set WORK._FWP has 2605 observations and 184 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.18 seconds cpu time 0.06 seconds Directory Libref WORK Engine V9 Physical Name C:\Users\bil7\AppData\Local\Temp\SAS Temporary Files\_TD14916_D347430_ Filename C:\Users\bil7\AppData\Local\Temp\SAS Temporary Files\_TD14916_D347430_ Member # Name Type File Size Last Modified 1 IE_SE_COMBINED DATA 6GB 08/12/2021 06:34:27 2 _DOSES DATA 256KB 08/12/2021 06:34:32 3 _FWP DATA 11MB 08/12/2021 06:34:33 4 _LUDC DATA 128KB 08/12/2021 06:34:32 5 _SPRO DATA 320KB 08/12/2021 06:34:33 NOTE: MODIFY was successful for WORK._FWP.DATA. NOTE: PROCEDURE DATASETS used (Total process time): real time 0.65 seconds cpu time 0.04 seconds NOTE: There were 2605 observations read from the data set WORK._FWP. NOTE: The data set WORK._FWP has 2605 observations and 184 variables. NOTE: DATA statement used (Total process time): real time 0.53 seconds cpu time 0.06 seconds Directory Libref WORK Engine V9 Physical Name C:\Users\bil7\AppData\Local\Temp\SAS Temporary Files\_TD14916_D347430_ Filename C:\Users\bil7\AppData\Local\Temp\SAS Temporary Files\_TD14916_D347430_ Member # Name Type File Size Last Modified 1 IE_SE_COMBINED DATA 6GB 08/12/2021 06:34:27 2 _DOSES DATA 256KB 08/12/2021 06:34:32 3 _FWP DATA 11MB 08/12/2021 06:34:35 4 _LUDC DATA 128KB 08/12/2021 06:34:32 5 _SPRO DATA 320KB 08/12/2021 06:34:33 NOTE: MODIFY was successful for WORK._DOSES.DATA. NOTE: PROCEDURE DATASETS used (Total process time): real time 0.45 seconds cpu time 0.01 seconds NOTE: There were 1476 observations read from the data set WORK._DOSES. NOTE: The data set WORK._DOSES1 has 1323 observations and 6 variables. NOTE: The data set WORK._DOSES2 has 153 observations and 6 variables. NOTE: The data set WORK._DOSES3 has 0 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 1.57 seconds cpu time 0.04 seconds NOTE: There were 1323 observations read from the data set WORK._DOSES1. NOTE: There were 153 observations read from the data set WORK._DOSES2. NOTE: There were 0 observations read from the data set WORK._DOSES3. NOTE: The data set WORK._DOSESALL has 1323 observations and 14 variables. NOTE: DATA statement used (Total process time): real time 0.10 seconds cpu time 0.04 seconds NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 1757:1 1757:1 NOTE: There were 11 observations read from the data set WORK._LUDC. NOTE: The data set WORK._LUDC has 11 observations and 13 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.01 seconds NOTE: There were 11 observations read from the data set WORK._LUDC. NOTE: The data set WORK._LUDC1 has 10 observations and 9 variables. NOTE: DATA statement used (Total process time): real time 0.32 seconds cpu time 0.03 seconds NOTE: There were 11 observations read from the data set WORK._LUDC. NOTE: The data set WORK._LUDC2 has 1 observations and 9 variables. NOTE: DATA statement used (Total process time): real time 0.12 seconds cpu time 0.03 seconds NOTE: There were 10 observations read from the data set WORK._LUDC1. NOTE: There were 1 observations read from the data set WORK._LUDC2. NOTE: The data set WORK._LUDCALL has 10 observations and 16 variables. NOTE: DATA statement used (Total process time): real time 0.15 seconds cpu time 0.03 seconds NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 1774:1 1774:1 NOTE: There were 380 observations read from the data set WORK._SPRO. NOTE: The data set WORK._SPRO has 380 observations and 9 variables. NOTE: DATA statement used (Total process time): real time 0.12 seconds cpu time 0.03 seconds NOTE: There were 380 observations read from the data set WORK._SPRO. NOTE: The data set WORK._SPRO1 has 312 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.18 seconds cpu time 0.03 seconds NOTE: There were 380 observations read from the data set WORK._SPRO. NOTE: The data set WORK._SPRO2 has 48 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.10 seconds cpu time 0.03 seconds NOTE: There were 380 observations read from the data set WORK._SPRO. NOTE: The data set WORK._SPRO3 has 16 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.07 seconds cpu time 0.03 seconds NOTE: There were 380 observations read from the data set WORK._SPRO. NOTE: The data set WORK._SPRO4 has 3 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.04 seconds cpu time 0.03 seconds NOTE: There were 380 observations read from the data set WORK._SPRO. NOTE: The data set WORK._SPRO5 has 1 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.07 seconds cpu time 0.03 seconds NOTE: There were 312 observations read from the data set WORK._SPRO1. NOTE: There were 48 observations read from the data set WORK._SPRO2. NOTE: There were 16 observations read from the data set WORK._SPRO3. NOTE: There were 3 observations read from the data set WORK._SPRO4. NOTE: There were 1 observations read from the data set WORK._SPRO5. NOTE: The data set WORK._SPROALL has 312 observations and 17 variables. NOTE: DATA statement used (Total process time): real time 0.25 seconds cpu time 0.03 seconds NOTE: There were 1323 observations read from the data set WORK._DOSESALL. NOTE: There were 10 observations read from the data set WORK._LUDCALL. NOTE: There were 312 observations read from the data set WORK._SPROALL. NOTE: There were 2605 observations read from the data set WORK._FWP. NOTE: The data set WORK._FWP_ALL has 2605 observations and 225 variables. NOTE: DATA statement used (Total process time): real time 0.12 seconds cpu time 0.07 seconds NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 1814:16 1814:34 NOTE: There were 120910 observations read from the data set SQLIMPP.udc2_codes_selected. NOTE: The data set WORK._UCS has 18658 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.53 seconds cpu time 0.32 seconds NOTE: There were 18658 observations read from the data set WORK._UCS. NOTE: The data set WORK._UCS has 18658 observations and 5 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.53 seconds cpu time 0.06 seconds NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 1828:29 NOTE: There were 18658 observations read from the data set WORK._UCS. NOTE: The data set WORK._UCS2 has 18658 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.31 seconds cpu time 0.07 seconds NOTE: There were 18658 observations read from the data set WORK._UCS2. NOTE: The data set WORK._JUNK has 2583 observations and 79 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 1.06 seconds cpu time 0.18 seconds NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 1842:49 1842:74 1843:49 1843:74 NOTE: There were 1909 observations read from the data set SQLIMPP.codes_master. NOTE: The data set WORK.REC has 353 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.17 seconds cpu time 0.07 seconds NOTE: The data set WORK._JUNK2 has 79 observations and 2 variables. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.13 seconds cpu time 0.01 seconds NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds NOTE: There were 2583 observations read from the data set WORK._JUNK. NOTE: The data set WORK._JUNK has 2583 observations and 79 variables. NOTE: DATA statement used (Total process time): real time 20.05 seconds cpu time 18.46 seconds NOTE: There were 2583 observations read from the data set WORK._JUNK. NOTE: The data set WORK._JUNK has 2583 observations and 79 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.26 seconds cpu time 0.14 seconds NOTE: There were 2605 observations read from the data set WORK._FWP_ALL. NOTE: There were 2583 observations read from the data set WORK._JUNK. NOTE: The data set WORK._PPF_FWP_COMBINE has 2605 observations and 303 variables. NOTE: DATA statement used (Total process time): real time 0.67 seconds cpu time 0.15 seconds NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 1872:1 1872:1 1873:1 1873:1 1874:1 1874:1 1875:1 1875:1 1876:1 1876:1 1877:1 1877:1 NOTE: There were 2605 observations read from the data set WORK._PPF_FWP_COMBINE. NOTE: The data set WORK._PPF_FWP_COMBINE2 has 2605 observations and 312 variables. NOTE: DATA statement used (Total process time): real time 0.87 seconds cpu time 0.18 seconds NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 46 at 1887:17 NOTE: There were 2605 observations read from the data set WORK._PPF_FWP_COMBINE2. NOTE: The data set WORK.PPF_FWP_COMBINE3 has 2605 observations and 302 variables. NOTE: DATA statement used (Total process time): real time 0.31 seconds cpu time 0.18 seconds NOTE: There were 2605 observations read from the data set WORK.PPF_FWP_COMBINE3. NOTE: The data set WORK.PPF_FWP_COMBINE3 has 2605 observations and 302 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.98 seconds cpu time 0.26 seconds NOTE: Deleting WORK._DOSES (memtype=DATA). NOTE: Deleting WORK._DOSES1 (memtype=DATA). NOTE: Deleting WORK._DOSES2 (memtype=DATA). NOTE: Deleting WORK._DOSES3 (memtype=DATA). NOTE: Deleting WORK._DOSESALL (memtype=DATA). NOTE: Deleting WORK._FWP (memtype=DATA). NOTE: Deleting WORK._FWP_ALL (memtype=DATA). NOTE: Deleting WORK._JUNK (memtype=DATA). NOTE: Deleting WORK._JUNK2 (memtype=DATA). NOTE: Deleting WORK._LUDC (memtype=DATA). NOTE: Deleting WORK._LUDC1 (memtype=DATA). NOTE: Deleting WORK._LUDC2 (memtype=DATA). NOTE: Deleting WORK._LUDCALL (memtype=DATA). NOTE: Deleting WORK._PPF_FWP_COMBINE (memtype=DATA). NOTE: Deleting WORK._PPF_FWP_COMBINE2 (memtype=DATA). NOTE: Deleting WORK._SPRO (memtype=DATA). NOTE: Deleting WORK._SPRO1 (memtype=DATA). NOTE: Deleting WORK._SPRO2 (memtype=DATA). NOTE: Deleting WORK._SPRO3 (memtype=DATA). NOTE: Deleting WORK._SPRO4 (memtype=DATA). NOTE: Deleting WORK._SPRO5 (memtype=DATA). NOTE: Deleting WORK._SPROALL (memtype=DATA). NOTE: Deleting WORK._UCS (memtype=DATA). NOTE: Deleting WORK._UCS2 (memtype=DATA). NOTE: PROCEDURE DATASETS used (Total process time): real time 0.07 seconds cpu time 0.07 seconds NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 8735:110 8735:179 8735:239 1941:18 1941:1 1941:1 NOTE: There were 4204 observations read from the data set SQLIMPP.UDC2_REG_DIAGNOSIS_CFD. NOTE: The data set WORK._DX1 has 4204 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.29 seconds cpu time 0.10 seconds NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 8782:110 8782:179 8782:239 1942:18 1942:1 1942:1 NOTE: Variable BasePercentage is uninitialized. NOTE: Variable BasePercentage_unk is uninitialized. NOTE: Variable BasePercentage_dk is uninitialized. NOTE: There were 1000 observations read from the data set SQLIMPP.UDC2_REG_DIAGNOSIS_VWD. NOTE: The data set WORK._DX2 has 1000 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 1.64 seconds cpu time 0.09 seconds NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 8829:110 8829:179 8829:239 1943:18 1943:1 1943:1 NOTE: Variable BasePercentage is uninitialized. NOTE: Variable BasePercentage_unk is uninitialized. NOTE: Variable BasePercentage_dk is uninitialized. NOTE: There were 171 observations read from the data set SQLIMPP.UDC2_REG_DIAGNOSIS_FPD. NOTE: The data set WORK._DX3 has 171 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.32 seconds cpu time 0.07 seconds NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 8876:110 8876:179 8876:239 1944:18 1944:1 1944:1 NOTE: Variable BasePercentage is uninitialized. NOTE: Variable BasePercentage_unk is uninitialized. NOTE: Variable BasePercentage_dk is uninitialized. NOTE: There were 18 observations read from the data set SQLIMPP.UDC2_REG_DIAGNOSIS_NLD. NOTE: The data set WORK._DX4 has 18 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.20 seconds cpu time 0.01 seconds NOTE: There were 4204 observations read from the data set WORK._DX1. NOTE: The data set WORK._DX1 has 4204 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.20 seconds cpu time 0.03 seconds NOTE: There were 1000 observations read from the data set WORK._DX2. NOTE: The data set WORK._DX2 has 1000 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.04 seconds cpu time 0.01 seconds NOTE: There were 171 observations read from the data set WORK._DX3. NOTE: The data set WORK._DX3 has 171 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.26 seconds cpu time 0.01 seconds NOTE: There were 18 observations read from the data set WORK._DX4. NOTE: The data set WORK._DX4 has 18 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.04 seconds cpu time 0.01 seconds NOTE: There were 4204 observations read from the data set WORK._DX1. NOTE: There were 1000 observations read from the data set WORK._DX2. NOTE: There were 171 observations read from the data set WORK._DX3. NOTE: There were 18 observations read from the data set WORK._DX4. NOTE: The data set WORK._DX has 5393 observations and 7 variables. NOTE: DATA statement used (Total process time): real time 0.81 seconds cpu time 0.06 seconds NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 8949:169 NOTE: There were 5393 observations read from the data set WORK._DX. NOTE: The data set WORK._DX1 has 5284 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.29 seconds cpu time 0.04 seconds NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 8963:170 NOTE: There were 5393 observations read from the data set WORK._DX. NOTE: The data set WORK._DX2 has 104 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.07 seconds cpu time 0.03 seconds NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 8977:170 NOTE: There were 5393 observations read from the data set WORK._DX. NOTE: The data set WORK._DX3 has 4 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.31 seconds cpu time 0.03 seconds NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 8991:170 NOTE: There were 5393 observations read from the data set WORK._DX. NOTE: The data set WORK._DX4 has 1 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.09 seconds cpu time 0.03 seconds NOTE: There were 5284 observations read from the data set WORK._DX1. NOTE: There were 104 observations read from the data set WORK._DX2. NOTE: There were 4 observations read from the data set WORK._DX3. NOTE: There were 1 observations read from the data set WORK._DX4. NOTE: The data set WORK._DXC has 5284 observations and 18 variables. NOTE: DATA statement used (Total process time): real time 0.11 seconds cpu time 0.04 seconds NOTE: There were 2281 observations read from the data set SQLIMPP.UDC2_REG_DOSES. NOTE: The data set WORK._DOSES has 2281 observations and 7 variables. NOTE: DATA statement used (Total process time): real time 0.23 seconds cpu time 0.07 seconds NOTE: There were 435 observations read from the data set SQLIMPP.UDC2_REG_ICH. NOTE: The data set WORK._ICH has 435 observations and 7 variables. NOTE: DATA statement used (Total process time): real time 0.15 seconds cpu time 0.03 seconds NOTE: There were 36 observations read from the data set SQLIMPP.UDC2_REG_ICH_LastUDC. NOTE: The data set WORK._LUDC has 36 observations and 11 variables. NOTE: DATA statement used (Total process time): real time 0.15 seconds cpu time 0.06 seconds NOTE: There were 837 observations read from the data set SQLIMPP.UDC2_REG_SurgicalPro. NOTE: The data set WORK._SPRO has 837 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.32 seconds cpu time 0.07 seconds NOTE: There were 5294 observations read from the data set SQLIMPP.UDC2_REG. NOTE: The data set WORK._REG has 5294 observations and 221 variables. NOTE: DATA statement used (Total process time): real time 0.53 seconds cpu time 0.28 seconds NOTE: There were 2281 observations read from the data set WORK._DOSES. NOTE: The data set WORK._DOSES has 2281 observations and 7 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.17 seconds cpu time 0.03 seconds NOTE: There were 435 observations read from the data set WORK._ICH. NOTE: The data set WORK._ICH has 435 observations and 7 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.37 seconds cpu time 0.01 seconds NOTE: There were 36 observations read from the data set WORK._LUDC. NOTE: The data set WORK._LUDC has 36 observations and 11 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.04 seconds cpu time 0.00 seconds NOTE: There were 837 observations read from the data set WORK._SPRO. NOTE: The data set WORK._SPRO has 837 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.18 seconds cpu time 0.00 seconds NOTE: There were 5294 observations read from the data set WORK._REG. NOTE: The data set WORK._REG has 5294 observations and 221 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.17 seconds cpu time 0.07 seconds Directory Libref WORK Engine V9 Physical Name C:\Users\bil7\AppData\Local\Temp\SAS Temporary Files\_TD14916_D347430_ Filename C:\Users\bil7\AppData\Local\Temp\SAS Temporary Files\_TD14916_D347430_ Member # Name Type File Size Last Modified 1 IE_SE_COMBINED DATA 6GB 08/12/2021 06:34:27 2 PPF_FWP_COMBINE3 DATA 57MB 08/12/2021 06:35:10 3 REC DATA 256KB 08/12/2021 06:34:45 4 _DOSES DATA 320KB 08/12/2021 06:35:21 5 _DX DATA 2MB 08/12/2021 06:35:16 6 _DX1 DATA 3MB 08/12/2021 06:35:17 7 _DX2 DATA 128KB 08/12/2021 06:35:17 8 _DX3 DATA 128KB 08/12/2021 06:35:18 9 _DX4 DATA 128KB 08/12/2021 06:35:18 10 _DXC DATA 9MB 08/12/2021 06:35:18 11 _ICH DATA 128KB 08/12/2021 06:35:22 12 _LUDC DATA 128KB 08/12/2021 06:35:22 13 _REG DATA 24MB 08/12/2021 06:35:23 14 _SPRO DATA 576KB 08/12/2021 06:35:22 NOTE: MODIFY was successful for WORK._DOSES.DATA. NOTE: PROCEDURE DATASETS used (Total process time): real time 0.04 seconds cpu time 0.03 seconds NOTE: There were 2281 observations read from the data set WORK._DOSES. NOTE: The data set WORK._DOSES1 has 2025 observations and 6 variables. NOTE: The data set WORK._DOSES2 has 254 observations and 6 variables. NOTE: The data set WORK._DOSES3 has 2 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.37 seconds cpu time 0.04 seconds NOTE: There were 2025 observations read from the data set WORK._DOSES1. NOTE: There were 254 observations read from the data set WORK._DOSES2. NOTE: There were 2 observations read from the data set WORK._DOSES3. NOTE: The data set WORK._DOSESALL has 2025 observations and 14 variables. NOTE: DATA statement used (Total process time): real time 0.07 seconds cpu time 0.03 seconds NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 2008:1 2008:1 NOTE: There were 435 observations read from the data set WORK._ICH. NOTE: The data set WORK._ICH has 435 observations and 9 variables. NOTE: DATA statement used (Total process time): real time 1.21 seconds cpu time 0.03 seconds NOTE: There were 435 observations read from the data set WORK._ICH. NOTE: The data set WORK._ICH1 has 354 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.06 seconds cpu time 0.03 seconds NOTE: There were 435 observations read from the data set WORK._ICH. NOTE: The data set WORK._ICH2 has 60 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.18 seconds cpu time 0.03 seconds NOTE: There were 435 observations read from the data set WORK._ICH. NOTE: The data set WORK._ICH3 has 20 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.18 seconds cpu time 0.03 seconds NOTE: There were 435 observations read from the data set WORK._ICH. NOTE: The data set WORK._ICH4 has 1 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.10 seconds cpu time 0.03 seconds NOTE: There were 354 observations read from the data set WORK._ICH1. NOTE: There were 60 observations read from the data set WORK._ICH2. NOTE: There were 20 observations read from the data set WORK._ICH3. NOTE: There were 1 observations read from the data set WORK._ICH4. NOTE: The data set WORK._ICHALL has 354 observations and 14 variables. NOTE: DATA statement used (Total process time): real time 0.09 seconds cpu time 0.03 seconds NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 2022:1 2022:1 NOTE: There were 36 observations read from the data set WORK._LUDC. NOTE: The data set WORK._LUDC has 36 observations and 13 variables. NOTE: DATA statement used (Total process time): real time 0.17 seconds cpu time 0.03 seconds NOTE: There were 36 observations read from the data set WORK._LUDC. NOTE: The data set WORK._LUDC1 has 33 observations and 10 variables. NOTE: DATA statement used (Total process time): real time 0.14 seconds cpu time 0.03 seconds NOTE: There were 36 observations read from the data set WORK._LUDC. NOTE: The data set WORK._LUDC2 has 3 observations and 10 variables. NOTE: DATA statement used (Total process time): real time 0.15 seconds cpu time 0.03 seconds NOTE: There were 33 observations read from the data set WORK._LUDC1. NOTE: There were 3 observations read from the data set WORK._LUDC2. NOTE: The data set WORK._LUDCALL has 33 observations and 17 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 2039:1 2039:1 NOTE: There were 837 observations read from the data set WORK._SPRO. NOTE: The data set WORK._SPRO has 837 observations and 9 variables. NOTE: DATA statement used (Total process time): real time 0.25 seconds cpu time 0.03 seconds NOTE: There were 837 observations read from the data set WORK._SPRO. NOTE: The data set WORK._SPRO1 has 665 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.57 seconds cpu time 0.04 seconds NOTE: There were 837 observations read from the data set WORK._SPRO. NOTE: The data set WORK._SPRO2 has 124 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.12 seconds cpu time 0.03 seconds NOTE: There were 837 observations read from the data set WORK._SPRO. NOTE: The data set WORK._SPRO3 has 32 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.23 seconds cpu time 0.03 seconds NOTE: There were 837 observations read from the data set WORK._SPRO. NOTE: The data set WORK._SPRO4 has 11 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.10 seconds cpu time 0.03 seconds NOTE: There were 837 observations read from the data set WORK._SPRO. NOTE: The data set WORK._SPRO5 has 5 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.13 seconds cpu time 0.03 seconds NOTE: There were 665 observations read from the data set WORK._SPRO1. NOTE: There were 124 observations read from the data set WORK._SPRO2. NOTE: There were 32 observations read from the data set WORK._SPRO3. NOTE: There were 11 observations read from the data set WORK._SPRO4. NOTE: There were 5 observations read from the data set WORK._SPRO5. NOTE: The data set WORK._SPROALL has 665 observations and 17 variables. NOTE: DATA statement used (Total process time): real time 0.04 seconds cpu time 0.04 seconds NOTE: There were 5284 observations read from the data set WORK._DXC. NOTE: There were 2025 observations read from the data set WORK._DOSESALL. NOTE: There were 354 observations read from the data set WORK._ICHALL. NOTE: There were 33 observations read from the data set WORK._LUDCALL. NOTE: There were 665 observations read from the data set WORK._SPROALL. NOTE: There were 5294 observations read from the data set WORK._REG. NOTE: The data set WORK._REG_ALL has 5294 observations and 291 variables. NOTE: DATA statement used (Total process time): real time 0.10 seconds cpu time 0.10 seconds NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 2078:16 2078:34 NOTE: There were 120910 observations read from the data set SQLIMPP.udc2_codes_selected. NOTE: The data set WORK._UCS has 58145 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.43 seconds cpu time 0.37 seconds NOTE: There were 58145 observations read from the data set WORK._UCS. NOTE: The data set WORK._UCS has 58145 observations and 5 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.46 seconds cpu time 0.12 seconds NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 2091:29 NOTE: There were 58145 observations read from the data set WORK._UCS. NOTE: The data set WORK._UCS2 has 58145 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.09 seconds cpu time 0.09 seconds NOTE: There were 58145 observations read from the data set WORK._UCS2. NOTE: The data set WORK._JUNK has 5289 observations and 281 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.43 seconds cpu time 0.40 seconds NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 2105:51 2105:76 2106:51 2106:76 2107:79 2107:104 NOTE: There were 1909 observations read from the data set SQLIMPP.codes_master. NOTE: The data set WORK.REC has 387 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.29 seconds cpu time 0.09 seconds NOTE: The data set WORK._JUNK2 has 281 observations and 2 variables. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.15 seconds cpu time 0.01 seconds  The SAS System 06:30 Thursday, August 12, 2021 14 recode ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ RECODE2(I) = TRANWRD(RECODE2(I),"83,1 " ,"White"); RECODE2(I) = TRANWRD(RECODE2(I),"83,2 " ,"Black or African American"); RECODE2(I) = TRANWRD(RECODE2(I),"83,3 " ,"Asian"); RECODE2(I) = TRANWRD(RECODE2(I),"83,4 " ,"Native Hawaiian or Other Pacific Islander"); RECODE2(I) = TRANWRD(RECODE2(I),"83,5 " ,"American Indian or Alaska Native"); RECODE2(I) = TRANWRD(RECODE2(I),"83,888","Unknown"); RECODE2(I) = TRANWRD(RECODE2(I),"83,999","Other (specify)"); RECODE2(I) = TRANWRD(RECODE2(I),"206,1 " ,"VIII (8)"); RECODE2(I) = TRANWRD(RECODE2(I),"206,2 " ,"IX (9)"); RECODE2(I) = TRANWRD(RECODE2(I),"206,3 " ,"I (afibrinogenemia) (1)"); RECODE2(I) = TRANWRD(RECODE2(I),"206,4 " ,"I (dysfibrinogenemia) (1)"); RECODE2(I) = TRANWRD(RECODE2(I),"206,5 " ,"I (hypofibrinogenemia) (1)"); RECODE2(I) = TRANWRD(RECODE2(I),"206,6 " ,"I (Factor 1, hereditary, unspecified)"); RECODE2(I) = TRANWRD(RECODE2(I),"206,7 " ,"II (prothrombin) (2)"); RECODE2(I) = TRANWRD(RECODE2(I),"206,8 " ,"V (5)"); RECODE2(I) = TRANWRD(RECODE2(I),"206,9 " ,"VII (7)"); RECODE2(I) = TRANWRD(RECODE2(I),"206,10","X (10)"); RECODE2(I) = TRANWRD(RECODE2(I),"206,11","XI (11)"); RECODE2(I) = TRANWRD(RECODE2(I),"206,12","XIII (13)"); RECODE2(I) = TRANWRD(RECODE2(I),"206,13","V-VIII (5/8)"); RECODE2(I) = TRANWRD(RECODE2(I),"206,14","PAI-1 deficiency (plasminogen activator inhibitor-1 deficiency)"); RECODE2(I) = TRANWRD(RECODE2(I),"206,15","a2anti-plasmin deficiency (a2-AP)"); RECODE2(I) = TRANWRD(RECODE2(I),"206,16","VWD Type 1"); RECODE2(I) = TRANWRD(RECODE2(I),"206,17","VWD Type 1C"); RECODE2(I) = TRANWRD(RECODE2(I),"206,18","VWD Type 2A"); RECODE2(I) = TRANWRD(RECODE2(I),"206,19","VWD Type 2B"); RECODE2(I) = TRANWRD(RECODE2(I),"206,20","VWD Type 2M"); RECODE2(I) = TRANWRD(RECODE2(I),"206,21","VWD Type 2N"); RECODE2(I) = TRANWRD(RECODE2(I),"206,22","VWD Type 2, type unknown"); RECODE2(I) = TRANWRD(RECODE2(I),"206,23","VWD Type 3"); RECODE2(I) = TRANWRD(RECODE2(I),"206,24","VWD type unknown"); RECODE2(I) = TRANWRD(RECODE2(I),"206,25","VWD Other"); RECODE2(I) = TRANWRD(RECODE2(I),"206,26","Bernard Soulier"); RECODE2(I) = TRANWRD(RECODE2(I),"206,27","Glanzmann’s thrombasthenia"); RECODE2(I) = TRANWRD(RECODE2(I),"206,28","Grey platelet syndrome"); RECODE2(I) = TRANWRD(RECODE2(I),"206,29","Hermansky-Pudlak syndrome"); RECODE2(I) = TRANWRD(RECODE2(I),"206,30","Inherited thrombocytopenia"); RECODE2(I) = TRANWRD(RECODE2(I),"206,31","Release defect"); RECODE2(I) = TRANWRD(RECODE2(I),"206,32","Storage pool defect"); RECODE2(I) = TRANWRD(RECODE2(I),"206,33","Hereditary platelet function disorder"); RECODE2(I) = TRANWRD(RECODE2(I),"206,34","Ehlers-Danlos syndrome"); RECODE2(I) = TRANWRD(RECODE2(I),"206,35","Blood coagulation disorder with prolonged coagulation time"); RECODE2(I) = TRANWRD(RECODE2(I),"206,36","Blood coagulation disorder with prolonged bleeding time"); RECODE2(I) = TRANWRD(RECODE2(I),"206,37","Blood coagulation disorder with impaired clot retraction time"); RECODE2(I) = TRANWRD(RECODE2(I),"207,1 " ,"Type 1"); RECODE2(I) = TRANWRD(RECODE2(I),"207,2 " ,"Type 2a"); RECODE2(I) = TRANWRD(RECODE2(I),"207,3 " ,"Type 2b");  The SAS System 06:30 Thursday, August 12, 2021 15 recode ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ RECODE2(I) = TRANWRD(RECODE2(I),"207,4 " ,"Type 3"); RECODE2(I) = TRANWRD(RECODE2(I),"207,888","Unknown"); RECODE2(I) = TRANWRD(RECODE2(I),"207,999","Other"); RECODE2(I) = TRANWRD(RECODE2(I),"208,1 " ,"Recombinant"); RECODE2(I) = TRANWRD(RECODE2(I),"208,2 " ,"Blood bank or plasma-derived"); RECODE2(I) = TRANWRD(RECODE2(I),"208,3 " ,"No applicable treatment products used"); RECODE2(I) = TRANWRD(RECODE2(I),"208,888","Unknown product use"); RECODE2(I) = TRANWRD(RECODE2(I),"209,1 " ,"Venipuncture without heparin flush"); RECODE2(I) = TRANWRD(RECODE2(I),"209,2 " ,"Venous access device utilizing heparin flush (ex. peripheral line, central line, port)"); RECODE2(I) = TRANWRD(RECODE2(I),"210,1 " ,"Final"); RECODE2(I) = TRANWRD(RECODE2(I),"210,2 " ,"Preliminary"); RECODE2(I) = TRANWRD(RECODE2(I),"211,1 " ,"Discard"); RECODE2(I) = TRANWRD(RECODE2(I),"211,2 " ,"Replace"); RECODE2(I) = TRANWRD(RECODE2(I),"211,3 " ,"Insert"); RECODE2(I) = TRANWRD(RECODE2(I),"211,4 " ,"Re-import"); RECODE2(I) = TRANWRD(RECODE2(I),"212,1 " ,"Insured"); RECODE2(I) = TRANWRD(RECODE2(I),"212,2 " ,"Uninsured"); RECODE2(I) = TRANWRD(RECODE2(I),"212,888","Unknown"); RECODE2(I) = TRANWRD(RECODE2(I),"213,1 " ,"Clotting Factor Deficiency"); RECODE2(I) = TRANWRD(RECODE2(I),"213,2 " ,"Von Willebrand disease (VWD)"); RECODE2(I) = TRANWRD(RECODE2(I),"213,3 " ,"Inherited or Functional Platelet Disorder"); RECODE2(I) = TRANWRD(RECODE2(I),"213,4 " ,"Connective Tissue Disorder"); RECODE2(I) = TRANWRD(RECODE2(I),"213,5 " ,"Bleeding Disorder, no laboratory diagnosis"); RECODE2(I) = TRANWRD(RECODE2(I),"213,6 " ,"Venous Thromboembolism (VTE)"); RECODE2(I) = TRANWRD(RECODE2(I),"214,1 " ,"VIII (8)"); RECODE2(I) = TRANWRD(RECODE2(I),"214,2 " ,"IX (9)"); RECODE2(I) = TRANWRD(RECODE2(I),"214,3 " ,"I (fibrinogen)"); RECODE2(I) = TRANWRD(RECODE2(I),"214,4 " ,"II (prothrombin)"); RECODE2(I) = TRANWRD(RECODE2(I),"214,5 " ,"V (5)"); RECODE2(I) = TRANWRD(RECODE2(I),"214,6 " ,"VII (7)"); RECODE2(I) = TRANWRD(RECODE2(I),"214,7 " ,"X (10)"); RECODE2(I) = TRANWRD(RECODE2(I),"214,8 " ,"XI (11)"); RECODE2(I) = TRANWRD(RECODE2(I),"214,9 " ,"XIII (13)"); RECODE2(I) = TRANWRD(RECODE2(I),"214,10","V-VIII (5/8)"); RECODE2(I) = TRANWRD(RECODE2(I),"214,11","PAI-1 deficiency (plasminogen activator inhibitor-1"); RECODE2(I) = TRANWRD(RECODE2(I),"214,12","a2anti-plasmin deficiency (a2-AP)"); RECODE2(I) = TRANWRD(RECODE2(I),"214,888","Unknown"); RECODE2(I) = TRANWRD(RECODE2(I),"215,1 " ,"VWD Type 1"); RECODE2(I) = TRANWRD(RECODE2(I),"215,2 " ,"VWD Type 1C"); RECODE2(I) = TRANWRD(RECODE2(I),"215,3 " ,"VWD Type 2A"); RECODE2(I) = TRANWRD(RECODE2(I),"215,4 " ,"VWD Type 2B"); RECODE2(I) = TRANWRD(RECODE2(I),"215,5 " ,"VWD Type 2M"); RECODE2(I) = TRANWRD(RECODE2(I),"215,6 " ,"VWD Type 2N"); RECODE2(I) = TRANWRD(RECODE2(I),"215,7 " ,"VWD Type 2, type unknown"); RECODE2(I) = TRANWRD(RECODE2(I),"215,8 " ,"VWD Type 3"); RECODE2(I) = TRANWRD(RECODE2(I),"215,9 " ,"VWD type unknown"); RECODE2(I) = TRANWRD(RECODE2(I),"215,10","VWD Other"); RECODE2(I) = TRANWRD(RECODE2(I),"216,1 " ,"Bernard Soulier"); RECODE2(I) = TRANWRD(RECODE2(I),"216,2 " ,"Glanzmann’s thrombasthenia"); RECODE2(I) = TRANWRD(RECODE2(I),"216,3 " ,"Grey platelet syndrome");  The SAS System 06:30 Thursday, August 12, 2021 16 recode ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ RECODE2(I) = TRANWRD(RECODE2(I),"216,4 " ,"Hermansky-Pudlak syndrome"); RECODE2(I) = TRANWRD(RECODE2(I),"216,5 " ,"Inherited thrombocytopenia"); RECODE2(I) = TRANWRD(RECODE2(I),"216,6 " ,"Release defect"); RECODE2(I) = TRANWRD(RECODE2(I),"216,7 " ,"Storage pool defect"); RECODE2(I) = TRANWRD(RECODE2(I),"216,8 " ,"Hereditary platelet function disorder"); RECODE2(I) = TRANWRD(RECODE2(I),"216,555","N/A"); RECODE2(I) = TRANWRD(RECODE2(I),"217,1 " ,"Ehlers-Danlos syndrome"); RECODE2(I) = TRANWRD(RECODE2(I),"217,555","N/A"); RECODE2(I) = TRANWRD(RECODE2(I),"218,1 " ,"Blood coagulation disorder with prolonged coagulation time"); RECODE2(I) = TRANWRD(RECODE2(I),"218,2 " ,"Blood coagulation disorder with prolonged bleeding time"); RECODE2(I) = TRANWRD(RECODE2(I),"218,3 " ,"Blood coagulation disorder with impaired clot retraction time"); RECODE2(I) = TRANWRD(RECODE2(I),"218,555","N/A"); RECODE2(I) = TRANWRD(RECODE2(I),"219,1 " ,"Pulmonary Embolism"); RECODE2(I) = TRANWRD(RECODE2(I),"219,2 " ,"Thrombosis Abdominal Vein Mesenteric Portal Or Renal"); RECODE2(I) = TRANWRD(RECODE2(I),"219,3 " ,"Thrombosis Deep Venous"); RECODE2(I) = TRANWRD(RECODE2(I),"219,4 " ,"Thrombosis Deep Venous of Lower Extremity or Pelvis"); RECODE2(I) = TRANWRD(RECODE2(I),"219,5 " ,"Thrombosis Deep Venous Of Upper Extremity or Upper Thorax"); RECODE2(I) = TRANWRD(RECODE2(I),"219,555","N/A"); RECODE2(I) = TRANWRD(RECODE2(I),"220,1 " ,"Initial Surveillance Inhibitor Titer"); RECODE2(I) = TRANWRD(RECODE2(I),"220,2 " ,"Subsequent Surveillance Inhibitor Titer"); RECODE2(I) = TRANWRD(RECODE2(I),"220,3 " ,"Clinical Indication of an Inhibitor"); RECODE2(I) = TRANWRD(RECODE2(I),"220,4 " ,"Follow-up to Locally Identified Elevated Inhibitor Titer"); RECODE2(I) = TRANWRD(RECODE2(I),"220,5 " ,"Follow-up to Elevated CDC Surveillance Inhibitor Titer"); RECODE2(I) = TRANWRD(RECODE2(I),"221,1 " ,"Accident"); RECODE2(I) = TRANWRD(RECODE2(I),"221,2 " ,"Cancer"); RECODE2(I) = TRANWRD(RECODE2(I),"221,3 " ,"Cardiovascular"); RECODE2(I) = TRANWRD(RECODE2(I),"221,4 " ,"Dementia"); RECODE2(I) = TRANWRD(RECODE2(I),"221,5 " ,"Diabetes mellitus"); RECODE2(I) = TRANWRD(RECODE2(I),"221,6 " ,"Hemophilia/ Bleeding disorder-related"); RECODE2(I) = TRANWRD(RECODE2(I),"221,7 " ,"HIV-related"); RECODE2(I) = TRANWRD(RECODE2(I),"221,8 " ,"Kidney Disease"); RECODE2(I) = TRANWRD(RECODE2(I),"221,9 " ,"Liver Disease"); RECODE2(I) = TRANWRD(RECODE2(I),"221,10","Suicide"); RECODE2(I) = TRANWRD(RECODE2(I),"221,888","Unknown"); RECODE2(I) = TRANWRD(RECODE2(I),"221,999","Other"); RECODE2(I) = TRANWRD(RECODE2(I),"222,1 " ,"Commercial Insurance"); RECODE2(I) = TRANWRD(RECODE2(I),"222,2 " ,"Military Health Care (TRICARE/VA/Champ-VA)"); RECODE2(I) = TRANWRD(RECODE2(I),"222,3 " ,"Medicaid"); RECODE2(I) = TRANWRD(RECODE2(I),"222,4 " ,"Medicare"); RECODE2(I) = TRANWRD(RECODE2(I),"222,5 " ,"State Programs"); RECODE2(I) = TRANWRD(RECODE2(I),"222,6 " ,"Indian Health Service"); RECODE2(I) = TRANWRD(RECODE2(I),"222,7 " ,"Uninsured"); RECODE2(I) = TRANWRD(RECODE2(I),"222,888","Unknown");  The SAS System 06:30 Thursday, August 12, 2021 17 recode ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ RECODE2(I) = TRANWRD(RECODE2(I),"222,999","Other"); RECODE2(I) = TRANWRD(RECODE2(I),"223,1 " ,"None"); RECODE2(I) = TRANWRD(RECODE2(I),"223,2 " ,"Pre-elementary"); RECODE2(I) = TRANWRD(RECODE2(I),"223,3 " ,"Primary / Secondary"); RECODE2(I) = TRANWRD(RECODE2(I),"223,4 " ,"GED or equivalent"); RECODE2(I) = TRANWRD(RECODE2(I),"223,5 " ,"Technical school"); RECODE2(I) = TRANWRD(RECODE2(I),"223,6 " ,"Some college"); RECODE2(I) = TRANWRD(RECODE2(I),"223,7 " ,"2-year college degree (Associates)"); RECODE2(I) = TRANWRD(RECODE2(I),"223,8 " ,"4-year college degree (Bachelors)"); RECODE2(I) = TRANWRD(RECODE2(I),"223,9 " ,"Advanced degree (Masters, Doctorate or professional)"); RECODE2(I) = TRANWRD(RECODE2(I),"223,888","Unknown"); RECODE2(I) = TRANWRD(RECODE2(I),"223,999","Other"); RECODE2(I) = TRANWRD(RECODE2(I),"224,1 " ,"Employed full-time"); RECODE2(I) = TRANWRD(RECODE2(I),"224,2 " ,"Employed part-time"); RECODE2(I) = TRANWRD(RECODE2(I),"224,3 " ,"Not employed"); RECODE2(I) = TRANWRD(RECODE2(I),"224,888","Unknown employment status"); RECODE2(I) = TRANWRD(RECODE2(I),"225,1 " ,"Child or student"); RECODE2(I) = TRANWRD(RECODE2(I),"225,2 " ,"Homemaker"); RECODE2(I) = TRANWRD(RECODE2(I),"225,3 " ,"Able, but not currently working"); RECODE2(I) = TRANWRD(RECODE2(I),"225,4 " ,"Disabled"); RECODE2(I) = TRANWRD(RECODE2(I),"225,5 " ,"Retired"); RECODE2(I) = TRANWRD(RECODE2(I),"225,888","Unknown"); RECODE2(I) = TRANWRD(RECODE2(I),"225,999","Other"); RECODE2(I) = TRANWRD(RECODE2(I),"226,1 " ,"Actual"); RECODE2(I) = TRANWRD(RECODE2(I),"226,2 " ,"Estimated"); RECODE2(I) = TRANWRD(RECODE2(I),"226,3 " ,"No Results Available"); RECODE2(I) = TRANWRD(RECODE2(I),"226,555","N/A"); RECODE2(I) = TRANWRD(RECODE2(I),"226,888","Date Unknown"); RECODE2(I) = TRANWRD(RECODE2(I),"227,1 " ,"Vaginal, unassisted"); RECODE2(I) = TRANWRD(RECODE2(I),"227,2 " ,"Vaginal with forceps"); RECODE2(I) = TRANWRD(RECODE2(I),"227,3 " ,"Vaginal with vacuum"); RECODE2(I) = TRANWRD(RECODE2(I),"227,4 " ,"Vaginal, assistance unknown"); RECODE2(I) = TRANWRD(RECODE2(I),"227,5 " ,"C-Section, Elective"); RECODE2(I) = TRANWRD(RECODE2(I),"227,6 " ,"C-Section, Emergent/Non-elective"); RECODE2(I) = TRANWRD(RECODE2(I),"227,7 " ,"C-Section, type unknown"); RECODE2(I) = TRANWRD(RECODE2(I),"227,888","Unknown"); RECODE2(I) = TRANWRD(RECODE2(I),"228,1 " ,"HTC’s primary location"); RECODE2(I) = TRANWRD(RECODE2(I),"228,2 " ,"HTC outreach clinic"); RECODE2(I) = TRANWRD(RECODE2(I),"228,3 " ,"HTC telemedicine session or telemedicine clinic"); RECODE2(I) = TRANWRD(RECODE2(I),"229,1 " ,"FVIII (8)"); RECODE2(I) = TRANWRD(RECODE2(I),"229,2 " ,"FIX (9)"); RECODE2(I) = TRANWRD(RECODE2(I),"229,3 " ,"FI (fibrinogen)"); RECODE2(I) = TRANWRD(RECODE2(I),"229,4 " ,"FII (2)"); RECODE2(I) = TRANWRD(RECODE2(I),"229,5 " ,"FV (5)"); RECODE2(I) = TRANWRD(RECODE2(I),"229,6 " ,"FVII (7)"); RECODE2(I) = TRANWRD(RECODE2(I),"229,7 " ,"FX (10)"); RECODE2(I) = TRANWRD(RECODE2(I),"229,8 " ,"FXI (11)"); RECODE2(I) = TRANWRD(RECODE2(I),"229,9 " ,"FXIII (13)"); RECODE2(I) = TRANWRD(RECODE2(I),"229,10","VWF"); RECODE2(I) = TRANWRD(RECODE2(I),"229,11","PAI-1 deficiency");  The SAS System 06:30 Thursday, August 12, 2021 18 recode ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ RECODE2(I) = TRANWRD(RECODE2(I),"229,12","a2anti-plasmin deficiency"); RECODE2(I) = TRANWRD(RECODE2(I),"229,888","Unknown"); RECODE2(I) = TRANWRD(RECODE2(I),"230,1 " ,"FVIII or FIX concentrates"); RECODE2(I) = TRANWRD(RECODE2(I),"230,2 " ,"Bypassing agents"); RECODE2(I) = TRANWRD(RECODE2(I),"230,3 " ,"Antifibrinolytics"); RECODE2(I) = TRANWRD(RECODE2(I),"230,4 " ,"Corticosteroids"); RECODE2(I) = TRANWRD(RECODE2(I),"230,888","Unknown"); RECODE2(I) = TRANWRD(RECODE2(I),"230,999","Other"); RECODE2(I) = TRANWRD(RECODE2(I),"231,1 " ,"Routine doses and frequency"); RECODE2(I) = TRANWRD(RECODE2(I),"231,2 " ,"Increased doses or frequency or both"); RECODE2(I) = TRANWRD(RECODE2(I),"231,888","Unknown whether dose or frequency is routine or increased"); RECODE2(I) = TRANWRD(RECODE2(I),"232,1 " ,"Prophylaxis- Continuous"); RECODE2(I) = TRANWRD(RECODE2(I),"232,2 " ,"Prophylaxis- Continuous with by-passing agents plus ITI"); RECODE2(I) = TRANWRD(RECODE2(I),"232,3 " ,"Prophylaxis- Menstrual bleeding"); RECODE2(I) = TRANWRD(RECODE2(I),"232,4 " ,"Prophylaxis- Event-based, short-term or intermittent"); RECODE2(I) = TRANWRD(RECODE2(I),"232,5 " ,"Immune tolerance induction without continuous prophylaxis with a by-passing agent"); RECODE2(I) = TRANWRD(RECODE2(I),"232,6 " ,"Episodic (on-demand)"); RECODE2(I) = TRANWRD(RECODE2(I),"233,1 " ,"Date"); RECODE2(I) = TRANWRD(RECODE2(I),"233,2 " ,"Age"); RECODE2(I) = TRANWRD(RECODE2(I),"233,888","Date or Age Unknown"); RECODE2(I) = TRANWRD(RECODE2(I),"234,1 " ,"Days"); RECODE2(I) = TRANWRD(RECODE2(I),"234,2 " ,"Months"); RECODE2(I) = TRANWRD(RECODE2(I),"234,3 " ,"Years"); RECODE2(I) = TRANWRD(RECODE2(I),"235,1 " ,"<3 years of age"); RECODE2(I) = TRANWRD(RECODE2(I),"235,2 " ,"3-6 years of age"); RECODE2(I) = TRANWRD(RECODE2(I),"235,3 " ,">6 years of age"); RECODE2(I) = TRANWRD(RECODE2(I),"236,1 " ,"Fewer than 2 bleeds total (that is, 0 or 1 bleed total) into the large joints (ankle, knee, hip, elbow or shoulder)"); RECODE2(I) = TRANWRD(RECODE2(I),"236,2 " ,"2 or more bleeds total into the large joints (ankle, knee, hip, elbow or shoulder)"); RECODE2(I) = TRANWRD(RECODE2(I),"236,888","Unknown"); RECODE2(I) = TRANWRD(RECODE2(I),"237,1 " ,"Advate"); RECODE2(I) = TRANWRD(RECODE2(I),"237,2 " ,"Alphanate"); RECODE2(I) = TRANWRD(RECODE2(I),"237,3 " ,"AlphaNine SD"); RECODE2(I) = TRANWRD(RECODE2(I),"237,4 " ,"Amicar Syrup (Aminocaproic acid)"); RECODE2(I) = TRANWRD(RECODE2(I),"237,5 " ,"Amicar Tablet (Aminocaproic acid)"); RECODE2(I) = TRANWRD(RECODE2(I),"237,6 " ,"Autoplex T"); RECODE2(I) = TRANWRD(RECODE2(I),"237,7 " ,"Bebulin VH"); RECODE2(I) = TRANWRD(RECODE2(I),"237,8 " ,"BeneFIX"); RECODE2(I) = TRANWRD(RECODE2(I),"237,9 " ,"Bioclate"); RECODE2(I) = TRANWRD(RECODE2(I),"237,10","Corifact (FXIII)"); RECODE2(I) = TRANWRD(RECODE2(I),"237,11","Cryoprecipiteted AHF (Cryoprecipitate)"); RECODE2(I) = TRANWRD(RECODE2(I),"237,12","DDVAP (desmorpressin IV or SQ)"); RECODE2(I) = TRANWRD(RECODE2(I),"237,13","FEIBA NF"); RECODE2(I) = TRANWRD(RECODE2(I),"237,14","FEIBA VH Immuno"); RECODE2(I) = TRANWRD(RECODE2(I),"237,15","Fibrin glue (Tissell, Artiss)"); RECODE2(I) = TRANWRD(RECODE2(I),"237,16","Fibrogammin P (FXIII)");  The SAS System 06:30 Thursday, August 12, 2021 19 recode ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ RECODE2(I) = TRANWRD(RECODE2(I),"237,17","Fresh-frozen plasma"); RECODE2(I) = TRANWRD(RECODE2(I),"237,18","Helixate"); RECODE2(I) = TRANWRD(RECODE2(I),"237,19","Helixate FS"); RECODE2(I) = TRANWRD(RECODE2(I),"237,20","Hemofil M"); RECODE2(I) = TRANWRD(RECODE2(I),"237,21","Humate-P"); RECODE2(I) = TRANWRD(RECODE2(I),"237,22","Hyate:C"); RECODE2(I) = TRANWRD(RECODE2(I),"237,23","Koate-DVI"); RECODE2(I) = TRANWRD(RECODE2(I),"237,24","Kogenate"); RECODE2(I) = TRANWRD(RECODE2(I),"237,25","Kogenate FS"); RECODE2(I) = TRANWRD(RECODE2(I),"237,26","Konyne 80"); RECODE2(I) = TRANWRD(RECODE2(I),"237,27","Monarc-M"); RECODE2(I) = TRANWRD(RECODE2(I),"237,28","Monoclate-P"); RECODE2(I) = TRANWRD(RECODE2(I),"237,29","Mononine"); RECODE2(I) = TRANWRD(RECODE2(I),"237,30","NovoSeven (FVIIa)"); RECODE2(I) = TRANWRD(RECODE2(I),"237,31","Novoseven RT (FVIIa)"); RECODE2(I) = TRANWRD(RECODE2(I),"237,32","Novo13 (rXIII-A2)"); RECODE2(I) = TRANWRD(RECODE2(I),"237,33","Packed RBCs"); RECODE2(I) = TRANWRD(RECODE2(I),"237,34","Platelets"); RECODE2(I) = TRANWRD(RECODE2(I),"237,35","Profilnine SD"); RECODE2(I) = TRANWRD(RECODE2(I),"237,36","Proplex T"); RECODE2(I) = TRANWRD(RECODE2(I),"237,37","Recombinate"); RECODE2(I) = TRANWRD(RECODE2(I),"237,38","ReFacto"); RECODE2(I) = TRANWRD(RECODE2(I),"237,39","RiaSTAP (fibrinogen, FI)"); RECODE2(I) = TRANWRD(RECODE2(I),"237,40","Stimate (Nasal desmopressin)"); RECODE2(I) = TRANWRD(RECODE2(I),"237,41","Topical thrombin (Evithrom, Thrombin-JMI)"); RECODE2(I) = TRANWRD(RECODE2(I),"237,42","Tranexamic acid (Cyclokapron, Lysteda)"); RECODE2(I) = TRANWRD(RECODE2(I),"237,43","Whole blood"); RECODE2(I) = TRANWRD(RECODE2(I),"237,44","Wilate"); RECODE2(I) = TRANWRD(RECODE2(I),"237,45","Xyntha"); RECODE2(I) = TRANWRD(RECODE2(I),"237,46","None"); RECODE2(I) = TRANWRD(RECODE2(I),"237,888","Unknown"); RECODE2(I) = TRANWRD(RECODE2(I),"237,999","Other, specify"); RECODE2(I) = TRANWRD(RECODE2(I),"238,1 " ,"time(s)/week"); RECODE2(I) = TRANWRD(RECODE2(I),"238,2 " ,"time(s)/month"); RECODE2(I) = TRANWRD(RECODE2(I),"238,888","Unknown"); RECODE2(I) = TRANWRD(RECODE2(I),"239,1 " ,"Days"); RECODE2(I) = TRANWRD(RECODE2(I),"239,2 " ,"Hours"); RECODE2(I) = TRANWRD(RECODE2(I),"239,3 " ,"Minutes"); RECODE2(I) = TRANWRD(RECODE2(I),"239,4 " ,"More than 7 days"); RECODE2(I) = TRANWRD(RECODE2(I),"239,888","Unknown"); RECODE2(I) = TRANWRD(RECODE2(I),"240,1 " ,"Left"); RECODE2(I) = TRANWRD(RECODE2(I),"240,2 " ,"Right"); RECODE2(I) = TRANWRD(RECODE2(I),"241,1 " ,"Unrestricted school or work and unrestricted recreational activities"); RECODE2(I) = TRANWRD(RECODE2(I),"241,2 " ,"Unrestricted school or work with limited recreational activity levels"); RECODE2(I) = TRANWRD(RECODE2(I),"241,3 " ,"Limited school or work and limited recreational activity levels"); RECODE2(I) = TRANWRD(RECODE2(I),"241,4 " ,"Limited school or work, limited recreational activity levels, and limited self-care activity levels");  The SAS System 06:30 Thursday, August 12, 2021 20 recode ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ RECODE2(I) = TRANWRD(RECODE2(I),"241,5 " ,"Requires assistance from another person for school or work or self-care, and unable to participate in recreation"); RECODE2(I) = TRANWRD(RECODE2(I),"241,888","Unknown"); RECODE2(I) = TRANWRD(RECODE2(I),"242,1 " ,"Every day"); RECODE2(I) = TRANWRD(RECODE2(I),"242,2 " ,"Most days"); RECODE2(I) = TRANWRD(RECODE2(I),"242,3 " ,"Some days"); RECODE2(I) = TRANWRD(RECODE2(I),"242,4 " ,"Never"); RECODE2(I) = TRANWRD(RECODE2(I),"242,888","Unknown"); RECODE2(I) = TRANWRD(RECODE2(I),"243,1 " ,"Completed basic vaccine series"); RECODE2(I) = TRANWRD(RECODE2(I),"243,2 " ,"Incompletely vaccinated"); RECODE2(I) = TRANWRD(RECODE2(I),"243,888","Unknown"); RECODE2(I) = TRANWRD(RECODE2(I),"244,1 " ,"Hepatocellular carcinoma (HCC)"); RECODE2(I) = TRANWRD(RECODE2(I),"244,2 " ,"Leukemia (any type)"); RECODE2(I) = TRANWRD(RECODE2(I),"244,3 " ,"Cancer other than HCC and leukemia"); RECODE2(I) = TRANWRD(RECODE2(I),"245,1 " ,"Fracture of a bone"); RECODE2(I) = TRANWRD(RECODE2(I),"245,2 " ,"Osteopenia"); RECODE2(I) = TRANWRD(RECODE2(I),"245,3 " ,"Osteopenia"); RECODE2(I) = TRANWRD(RECODE2(I),"246,1 " ,"Acute ischemic stroke (AIS)"); RECODE2(I) = TRANWRD(RECODE2(I),"246,2 " ,"Atrial fibrillation"); RECODE2(I) = TRANWRD(RECODE2(I),"246,3 " ,"Coronary artery disease"); RECODE2(I) = TRANWRD(RECODE2(I),"246,4 " ,"Congestive heart failure"); RECODE2(I) = TRANWRD(RECODE2(I),"246,5 " ,"Myocardial infarction"); RECODE2(I) = TRANWRD(RECODE2(I),"246,6 " ,"Transient ischemic attack (TIA)"); RECODE2(I) = TRANWRD(RECODE2(I),"247,1 " ,"Chronic kidney disease/CKD"); RECODE2(I) = TRANWRD(RECODE2(I),"247,2 " ,"Kidney stones (renal urolith, nephrolith, nephrolithiasis)"); RECODE2(I) = TRANWRD(RECODE2(I),"247,3 " ,"Nephrotic syndrome"); RECODE2(I) = TRANWRD(RECODE2(I),"248,1 " ,"Ascites"); RECODE2(I) = TRANWRD(RECODE2(I),"248,2 " ,"Cirrhosis"); RECODE2(I) = TRANWRD(RECODE2(I),"248,3 " ,"Hepatic fibrosis"); RECODE2(I) = TRANWRD(RECODE2(I),"248,4 " ,"Splenomegaly"); RECODE2(I) = TRANWRD(RECODE2(I),"248,5 " ,"Varices (esophageal or gastric)"); RECODE2(I) = TRANWRD(RECODE2(I),"249,1 " ,"Deep vein thrombosis (DVT)"); RECODE2(I) = TRANWRD(RECODE2(I),"249,2 " ,"Pulmonary embolism (PE)"); RECODE2(I) = TRANWRD(RECODE2(I),"250,1 " ,"Anxiety"); RECODE2(I) = TRANWRD(RECODE2(I),"250,2 " ,"Depression"); RECODE2(I) = TRANWRD(RECODE2(I),"250,3 " ,"Diabetes mellitus (other than gestational diabetes)"); RECODE2(I) = TRANWRD(RECODE2(I),"250,4 " ,"Hypertension"); RECODE2(I) = TRANWRD(RECODE2(I),"250,5 " ,"Iron deficiency anemia"); RECODE2(I) = TRANWRD(RECODE2(I),"250,6 " ,"Pseudotumor"); RECODE2(I) = TRANWRD(RECODE2(I),"251,1 " ,"<10%"); RECODE2(I) = TRANWRD(RECODE2(I),"251,2 " ,"10-20%"); RECODE2(I) = TRANWRD(RECODE2(I),"251,3 " ,"21-50%"); RECODE2(I) = TRANWRD(RECODE2(I),"251,4 " ,">50%"); RECODE2(I) = TRANWRD(RECODE2(I),"251,888","Unknown"); RECODE2(I) = TRANWRD(RECODE2(I),"252,1 " ,"Bleeding"); RECODE2(I) = TRANWRD(RECODE2(I),"252,2 " ,"Infection"); RECODE2(I) = TRANWRD(RECODE2(I),"252,3 " ,"Mechanical"); RECODE2(I) = TRANWRD(RECODE2(I),"252,4 " ,"Thrombosis"); RECODE2(I) = TRANWRD(RECODE2(I),"252,888","Unknown");  The SAS System 06:30 Thursday, August 12, 2021 21 recode ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ RECODE2(I) = TRANWRD(RECODE2(I),"252,999","Other"); RECODE2(I) = TRANWRD(RECODE2(I),"253,1 " ,"CT (computed tomography)"); RECODE2(I) = TRANWRD(RECODE2(I),"253,2 " ,"MRI (magnetic resonance imaging)"); RECODE2(I) = TRANWRD(RECODE2(I),"253,3 " ,"US (ultrasound)"); RECODE2(I) = TRANWRD(RECODE2(I),"253,888","Imaging type unknown"); RECODE2(I) = TRANWRD(RECODE2(I),"253,999","Other"); RECODE2(I) = TRANWRD(RECODE2(I),"254,0","No"); RECODE2(I) = TRANWRD(RECODE2(I),"254,1 " ,"Yes"); RECODE2(I) = TRANWRD(RECODE2(I),"254,2 " ,"None used"); RECODE2(I) = TRANWRD(RECODE2(I),"254,888","Unknown"); RECODE2(I) = TRANWRD(RECODE2(I),"255,1 " ,"Gastrointestinal"); RECODE2(I) = TRANWRD(RECODE2(I),"255,2 " ,"Genitourinary, Hematuria"); RECODE2(I) = TRANWRD(RECODE2(I),"255,3 " ,"Genitourinary, Other"); RECODE2(I) = TRANWRD(RECODE2(I),"255,4 " ,"Head- Extracranial"); RECODE2(I) = TRANWRD(RECODE2(I),"255,5 " ,"Joint"); RECODE2(I) = TRANWRD(RECODE2(I),"255,6 " ,"Muscle"); RECODE2(I) = TRANWRD(RECODE2(I),"255,7 " ,"Nasal Mucosa (including Epistaxis)"); RECODE2(I) = TRANWRD(RECODE2(I),"255,8 " ,"Oral"); RECODE2(I) = TRANWRD(RECODE2(I),"255,9 " ,"Soft tissue"); RECODE2(I) = TRANWRD(RECODE2(I),"255,10","Spine"); RECODE2(I) = TRANWRD(RECODE2(I),"255,11","Umbilicus"); RECODE2(I) = TRANWRD(RECODE2(I),"255,999","Other"); RECODE2(I) = TRANWRD(RECODE2(I),"256,1 " ,"Circumcision"); RECODE2(I) = TRANWRD(RECODE2(I),"256,2 " ,"Delivery"); RECODE2(I) = TRANWRD(RECODE2(I),"256,3 " ,"Dental procedure"); RECODE2(I) = TRANWRD(RECODE2(I),"256,4 " ,"Iatrogenic"); RECODE2(I) = TRANWRD(RECODE2(I),"256,5 " ,"Injection site"); RECODE2(I) = TRANWRD(RECODE2(I),"256,6 " ,"Lancet stick"); RECODE2(I) = TRANWRD(RECODE2(I),"256,7 " ,"Spontaneous"); RECODE2(I) = TRANWRD(RECODE2(I),"256,8 " ,"Surgery"); RECODE2(I) = TRANWRD(RECODE2(I),"256,9 " ,"Thrombocytopenia"); RECODE2(I) = TRANWRD(RECODE2(I),"256,10","Trauma"); RECODE2(I) = TRANWRD(RECODE2(I),"256,11","Venipuncture"); RECODE2(I) = TRANWRD(RECODE2(I),"256,12","Other medical procedure"); RECODE2(I) = TRANWRD(RECODE2(I),"256,13","Menses"); RECODE2(I) = TRANWRD(RECODE2(I),"256,14","Post-partum"); RECODE2(I) = TRANWRD(RECODE2(I),"256,999","Other"); RECODE2(I) = TRANWRD(RECODE2(I),"257,1 " ,"Ankle, Left"); RECODE2(I) = TRANWRD(RECODE2(I),"257,2 " ,"Ankle, Right"); RECODE2(I) = TRANWRD(RECODE2(I),"257,3 " ,"Elbow, Left"); RECODE2(I) = TRANWRD(RECODE2(I),"257,4 " ,"Elbow, Right"); RECODE2(I) = TRANWRD(RECODE2(I),"257,5 " ,"Hip, Left"); RECODE2(I) = TRANWRD(RECODE2(I),"257,6 " ,"Hip, Right"); RECODE2(I) = TRANWRD(RECODE2(I),"257,7 " ,"Knee, Left"); RECODE2(I) = TRANWRD(RECODE2(I),"257,8 " ,"Knee, Right"); RECODE2(I) = TRANWRD(RECODE2(I),"257,9 " ,"Shoulder, Left"); RECODE2(I) = TRANWRD(RECODE2(I),"257,10","Shoulder, Right"); RECODE2(I) = TRANWRD(RECODE2(I),"258,1 " ,"1-3"); RECODE2(I) = TRANWRD(RECODE2(I),"258,2 " ,"4-19"); RECODE2(I) = TRANWRD(RECODE2(I),"258,3 " ,">/=20"); RECODE2(I) = TRANWRD(RECODE2(I),"258,888","Unknown");  The SAS System 06:30 Thursday, August 12, 2021 22 recode ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ RECODE2(I) = TRANWRD(RECODE2(I),"259,1 " ,"Paper Logs"); RECODE2(I) = TRANWRD(RECODE2(I),"259,2 " ,"Electronic Logs"); RECODE2(I) = TRANWRD(RECODE2(I),"259,3 " ,"Factor Dispensing Records"); RECODE2(I) = TRANWRD(RECODE2(I),"259,4 " ,"Medical Chart"); RECODE2(I) = TRANWRD(RECODE2(I),"259,5 " ,"Routine Patient contact (non-contemporaneous patient verbal report)"); RECODE2(I) = TRANWRD(RECODE2(I),"259,888","Unknown"); RECODE2(I) = TRANWRD(RECODE2(I),"259,999","Other");  The SAS System 06:30 Thursday, August 12, 2021 23 rec_dx ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ RECODE3(I) = TRANWRD(RECODE3(I),"206,1 ", "VIII (8)"); RECODE3(I) = TRANWRD(RECODE3(I),"206,2 ", "IX (9)"); RECODE3(I) = TRANWRD(RECODE3(I),"206,3 ", "I (afibrinogenemia) (1)"); RECODE3(I) = TRANWRD(RECODE3(I),"206,4 ", "I (dysfibrinogenemia) (1)"); RECODE3(I) = TRANWRD(RECODE3(I),"206,5 ", "I (hypofibrinogenemia) (1)"); RECODE3(I) = TRANWRD(RECODE3(I),"206,6 ", "I (Factor 1, hereditary, unspecified)"); RECODE3(I) = TRANWRD(RECODE3(I),"206,7 ", "II (prothrombin) (2)"); RECODE3(I) = TRANWRD(RECODE3(I),"206,8 ", "V (5)"); RECODE3(I) = TRANWRD(RECODE3(I),"206,9 ", "VII (7)"); RECODE3(I) = TRANWRD(RECODE3(I),"206,10 ", "X (10)"); RECODE3(I) = TRANWRD(RECODE3(I),"206,11 ", "XI (11)"); RECODE3(I) = TRANWRD(RECODE3(I),"206,12 ", "XIII (13)"); RECODE3(I) = TRANWRD(RECODE3(I),"206,13 ", "V-VIII (5/8)"); RECODE3(I) = TRANWRD(RECODE3(I),"206,14 ", "PAI-1 deficiency (plasminogen activator inhibitor-1 deficiency)"); RECODE3(I) = TRANWRD(RECODE3(I),"206,15 ", "a2anti-plasmin deficiency (a2-AP)"); RECODE3(I) = TRANWRD(RECODE3(I),"206,16 ", "VWD Type 1"); RECODE3(I) = TRANWRD(RECODE3(I),"206,17 ", "VWD Type 1C"); RECODE3(I) = TRANWRD(RECODE3(I),"206,18 ", "VWD Type 2A"); RECODE3(I) = TRANWRD(RECODE3(I),"206,19 ", "VWD Type 2B"); RECODE3(I) = TRANWRD(RECODE3(I),"206,20 ", "VWD Type 2M"); RECODE3(I) = TRANWRD(RECODE3(I),"206,21 ", "VWD Type 2N"); RECODE3(I) = TRANWRD(RECODE3(I),"206,22 ", "VWD Type 2, type unknown"); RECODE3(I) = TRANWRD(RECODE3(I),"206,23 ", "VWD Type 3"); RECODE3(I) = TRANWRD(RECODE3(I),"206,24 ", "VWD type unknown"); RECODE3(I) = TRANWRD(RECODE3(I),"206,25 ", "VWD Other"); RECODE3(I) = TRANWRD(RECODE3(I),"206,26 ", "Bernard Soulier"); RECODE3(I) = TRANWRD(RECODE3(I),"206,27 ", "Glanzmann’s thrombasthenia"); RECODE3(I) = TRANWRD(RECODE3(I),"206,28 ", "Grey platelet syndrome"); RECODE3(I) = TRANWRD(RECODE3(I),"206,29 ", "Hermansky-Pudlak syndrome"); RECODE3(I) = TRANWRD(RECODE3(I),"206,30 ", "Inherited thrombocytopenia"); RECODE3(I) = TRANWRD(RECODE3(I),"206,31 ", "Release defect"); RECODE3(I) = TRANWRD(RECODE3(I),"206,32 ", "Storage pool defect"); RECODE3(I) = TRANWRD(RECODE3(I),"206,33 ", "Hereditary platelet function disorder"); RECODE3(I) = TRANWRD(RECODE3(I),"206,34 ", "Ehlers-Danlos syndrome"); RECODE3(I) = TRANWRD(RECODE3(I),"206,35 ", "Blood coagulation disorder with prolonged coagulation time"); RECODE3(I) = TRANWRD(RECODE3(I),"206,36 ", "Blood coagulation disorder with prolonged bleeding time"); RECODE3(I) = TRANWRD(RECODE3(I),"206,37 ", "Blood coagulation disorder with impaired clot retraction time");  The SAS System 06:30 Thursday, August 12, 2021 24 Variable Name ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ AllReactionProd_1 AllReactionProd_2 AllReactionProd_3 AllReactionProd_4 AllReactionProd_5 AllReactionProd_6 AllReactionProd_7 AllReactionProd_8 AllReactionProd_9 AllReactionProd_10 AllReactionProd_11 AllReactionProd_12 AllReactionProd_13 AllReactionProd_14 AllReactionProd_15 AllReactionProd_16 AllReactionProd_17 AllReactionProd_18 AllReactionProd_19 AllReactionProd_20 AllReactionProd_21 AllReactionProd_22 AllReactionProd_23 AllReactionProd_24 AllReactionProd_25 AllReactionProd_26 AllReactionProd_27 AllReactionProd_28 AllReactionProd_29 AllReactionProd_30 AllReactionProd_31 AllReactionProd_32 AllReactionProd_33 AllReactionProd_34 All_Dx_Type_1 All_Dx_Type_2 All_Dx_Type_3 All_Dx_Type_4 AscertainMethodTreatEvents_1 AscertainMethodTreatEvents_2 AscertainMethodTreatEvents_3 AscertainMethodTreatEvents_4 AscertainMethodTreatEvents_5 AscertainMethodTreatEvents_6 AscertainMethod_1 AscertainMethod_2 AscertainMethod_3 AscertainMethod_4 AscertainMethod_5 AscertainMethod_6 CVADComplications_1  The SAS System 06:30 Thursday, August 12, 2021 25 Variable Name ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ CVADComplications_2 CVADComplications_3 CVADComplications_4 CVADComplications_5 CurrentBleedTreat_1 CurrentBleedTreat_2 CurrentBleedTreat_3 CurrentBleedTreat_4 CurrentClotFactorProduct_1 CurrentClotFactorProduct_2 CurrentClotFactorProduct_3 CurrentClotFactorProduct_4 CurrentClotFactorProduct_5 CurrentClotFactorProduct_6 CurrentClotFactorProduct_7 CurrentClotFactorProduct_8 CurrentClotFactorProduct_9 CurrentClotFactorProduct_10 CurrentClotFactorProduct_11 CurrentClotFactorProduct_12 CurrentClotFactorProduct_13 CurrentClotFactorProduct_14 CurrentClotFactorProduct_15 CurrentClotFactorProduct_16 CurrentClotFactorProduct_17 CurrentClotFactorProduct_18 CurrentClotFactorProduct_19 CurrentClotFactorProduct_20 CurrentClotFactorProduct_21 CurrentClotFactorProduct_22 CurrentClotFactorProduct_23 CurrentClotFactorProduct_24 CurrentClotFactorProduct_25 CurrentClotFactorProduct_26 CurrentClotFactorProduct_27 CurrentClotFactorProduct_28 CurrentClotFactorProduct_29 CurrentClotFactorProduct_30 CurrentClotFactorProduct_31 CurrentClotFactorProduct_32 CurrentClotFactorProduct_33 CurrentClotFactorProduct_34 Dx_TypeFPD_1 Dx_TypeFPD_2 Dx_TypeNLD_1 Dx_TypeNLD_2 Dx_TypeVWD_1 Dx_TypeVWD_2 Dx_Type_1 Dx_Type_2 HIO_1  The SAS System 06:30 Thursday, August 12, 2021 26 Variable Name ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ HIO_2 HIO_3 HTCService_1 HTCService_2 HTCService_3 InhibFactorDetect_1 InhibFactorDetect_2 Method_1 Method_2 OtherBleed2_Gastrointestinal_1 OtherBleed2_Gastrointestinal_2 OtherBleed2_Gastrointestinal_3 OtherBleed2_Geni_Hema_1 OtherBleed2_Geni_Hema_2 OtherBleed2_Geni_Oth_1 OtherBleed2_Geni_Oth_2 OtherBleed2_Geni_Oth_3 OtherBleed2_Hea_Extr_1 OtherBleed2_Hea_Extr_2 OtherBleed2_Muscle_1 OtherBleed2_Muscle_2 OtherBleed2_Muscle_3 OtherBleed2_Nasal_Mucosa_1 OtherBleed2_Nasal_Mucosa_2 OtherBleed2_Nasal_Mucosa_3 OtherBleed2_Oral_1 OtherBleed2_Oral_2 OtherBleed2_Oral_3 OtherBleed2_Other_Site_1 OtherBleed2_Other_Site_2 OtherBleed2_Other_Site_3 OtherBleed2_Soft_tissue_1 OtherBleed2_Soft_tissue_2 OtherBleed2_Soft_tissue_3 OtherBleed2_Soft_tissue_4 OtherBleed2_Soft_tissue_5 OtherBleed2_Soft_tissue_6 OtherBleed2_Spine_1 OtherBleed2_Spine_2 OtherBleed_Geni_Hema_1 OtherBleed_Geni_Hema_2 OtherBleed_Genito_Oth_1 OtherBleed_Genito_Oth_2 OtherBleed_Head_Extracranial_1 OtherBleed_Head_Extracranial_2 OtherBleed_Head_Extracranial_3 OtherBleed_Muscle_1 OtherBleed_Nasal_Mucosa_1 OtherBleed_Oral_1 OtherBleed_Other_Site_1 OtherBleed_Other_Site_2  The SAS System 06:30 Thursday, August 12, 2021 27 Variable Name ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ OtherBleed_Soft_tissue_1 OtherBleed_Soft_tissue_2 OtherBleed_Soft_tissue_3 OtherBleed_Umbilicus_1 ProPerf_Arthrodesis_Ankle_1 ProPerf_Arthrodesis_Ankle_2 ProPerf_Arthrodesis_Elbow_1 ProPerf_Arthrodesis_Elbow_2 ProPerf_Arthrodesis_Hip_1 ProPerf_Arthrodesis_Hip_2 ProPerf_Arthrodesis_Knee_1 ProPerf_Arthrodesis_Knee_2 ProPerf_Arthrodesis_Shoulder_1 ProPerf_Arthrodesis_Shoulder_2 ProPerf_Arthrop_Shou_1 ProPerf_Arthrop_Shou_2 ProPerf_Arthroplasty_Ankle_1 ProPerf_Arthroplasty_Ankle_2 ProPerf_Arthroplasty_Elbow_1 ProPerf_Arthroplasty_Elbow_2 ProPerf_Arthroplasty_Hip_1 ProPerf_Arthroplasty_Hip_2 ProPerf_Arthroplasty_Knee_1 ProPerf_Arthroplasty_Knee_2 ProPerf_Arthros_Shou_1 ProPerf_Arthros_Shou_2 ProPerf_Arthroscopic_Ankle_1 ProPerf_Arthroscopic_Ankle_2 ProPerf_Arthroscopic_Elbow_1 ProPerf_Arthroscopic_Elbow_2 ProPerf_Arthroscopic_Hip_1 ProPerf_Arthroscopic_Hip_2 ProPerf_Arthroscopic_Knee_1 ProPerf_Arthroscopic_Knee_2 ProPerf_Joint_Pro_Sho_1 ProPerf_Joint_Pro_Sho_2 ProPerf_Joint_Proc_Ankle_1 ProPerf_Joint_Proc_Ankle_2 ProPerf_Joint_Proc_Elbow_1 ProPerf_Joint_Proc_Elbow_2 ProPerf_Joint_Procedure_Hip_1 ProPerf_Joint_Procedure_Hip_2 ProPerf_Joint_Procedure_Knee_1 ProPerf_Joint_Procedure_Knee_2 ProPerf_Open_Ankle_1 ProPerf_Open_Ankle_2 ProPerf_Open_Elbow_1 ProPerf_Open_Elbow_2 ProPerf_Open_Hip_1 ProPerf_Open_Hip_2 ProPerf_Open_Knee_1  The SAS System 06:30 Thursday, August 12, 2021 28 Variable Name ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ ProPerf_Open_Knee_2 ProPerf_Open_Shoulder_1 ProPerf_Open_Shoulder_2 ProPerf_Radioi_Shou_1 ProPerf_Radioi_Shou_2 ProPerf_Radioisotopic_Ankle_1 ProPerf_Radioisotopic_Ankle_2 ProPerf_Radioisotopic_Elbow_1 ProPerf_Radioisotopic_Elbow_2 ProPerf_Radioisotopic_Hip_1 ProPerf_Radioisotopic_Hip_2 ProPerf_Radioisotopic_Knee_1 ProPerf_Radioisotopic_Knee_2 ProPerf_Type_Unk_Shou_1 ProPerf_Type_Unk_Shou_2 ProPerf_Type_Unknown_Ankle_1 ProPerf_Type_Unknown_Ankle_2 ProPerf_Type_Unknown_Elbow_1 ProPerf_Type_Unknown_Elbow_2 ProPerf_Type_Unknown_Hip_1 ProPerf_Type_Unknown_Hip_2 ProPerf_Type_Unknown_Knee_1 ProPerf_Type_Unknown_Knee_2 Race_1 Race_2 Race_3 Race_4 TreatProd_1 TreatProd_2 TreatProd_3 TreatProd_4 TreatProd_5 TreatProd_6 TreatProd_7 TreatProd_8 TreatProd_9 TreatProd_10 TreatProd_11 TreatProd_12 TreatProd_13 TreatProd_14 TreatProd_15 TreatProd_16 TreatProd_17 TreatProd_18 TreatProd_19 TreatProd_20 TreatProd_21 TreatProd_22 TreatProd_23 TreatProd_24  The SAS System 06:30 Thursday, August 12, 2021 29 Variable Name ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ TreatProd_25 TreatProd_26 TreatProd_27 TreatProd_28 TreatProd_29 TreatProd_30 TreatProd_31 TreatProd_32 TreatProd_33 TreatProd_34 TreatProd_35 TreatProd_36 TreatProd_37 TreatProd_38 TreatProd_39 TreatProd_40 TreatProd_41 TreatProd_42 TreatProd_43 TreatProd_44 TreatProd_45 TreatProd_46 TypeHeadImage_1 TypeHeadImage_2 TypeHeadImage_3 NOTE: PROCEDURE SQL used (Total process time): real time 0.28 seconds cpu time 0.07 seconds NOTE: There were 5289 observations read from the data set WORK._JUNK. NOTE: The data set WORK._JUNK has 5289 observations and 281 variables. NOTE: DATA statement used (Total process time): real time 2:08.27 cpu time 2:08.20 NOTE: There were 5289 observations read from the data set WORK._JUNK. NOTE: The data set WORK._JUNK has 5289 observations and 281 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.56 seconds cpu time 0.56 seconds NOTE: There were 5294 observations read from the data set WORK._REG_ALL. NOTE: There were 5289 observations read from the data set WORK._JUNK. NOTE: The data set WORK._PPF_COMBINE has 5294 observations and 571 variables. NOTE: DATA statement used (Total process time): real time 0.35 seconds cpu time 0.36 seconds NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 2139:1 2139:1 2140:1 2140:1 2145:1 2145:1 2146:1 2146:1 2147:1 2147:1 2148:1 2148:1 2149:1 2149:1 2150:1 2150:1 2151:1 2151:1 2152:1 2152:1 2153:1 2153:1 2154:1 2154:1 NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 10 at 2141:16 117 at 2143:17 NOTE: There were 5294 observations read from the data set WORK._PPF_COMBINE. NOTE: The data set WORK._PPF_COMBINE has 5294 observations and 587 variables. NOTE: DATA statement used (Total process time): real time 0.68 seconds cpu time 0.68 seconds WARNING: The variable i in the DROP, KEEP, or RENAME list has never been referenced. NOTE: There were 5294 observations read from the data set WORK._PPF_COMBINE. NOTE: The data set WORK._PPF_COMBINE2 has 5294 observations and 588 variables. NOTE: DATA statement used (Total process time): real time 0.42 seconds cpu time 0.34 seconds NOTE: There were 5294 observations read from the data set WORK._PPF_COMBINE2. NOTE: The data set WORK._PPF_COMBINE2 has 5294 observations and 588 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.68 seconds cpu time 0.68 seconds NOTE: The data set WORK._JUNK has 588 observations and 2 variables. NOTE: PROCEDURE CONTENTS used (Total process time): real time 1.18 seconds cpu time 0.09 seconds NOTE: There were 588 observations read from the data set WORK._JUNK. NOTE: The data set WORK._JUNK has 588 observations and 2 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.03 seconds cpu time 0.03 seconds NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds WARNING: Multiple lengths were specified for the variable SubjectID by input data set(s). This can cause truncation of data. NOTE: There were 2605 observations read from the data set WORK.PPF_FWP_COMBINE3. NOTE: There were 5294 observations read from the data set WORK._PPF_COMBINE2. NOTE: The data set WORK.IP_SP_COMBINED has 7899 observations and 588 variables. NOTE: DATA statement used (Total process time): real time 0.46 seconds cpu time 0.46 seconds NOTE: Deleting WORK._DOSES (memtype=DATA). NOTE: Deleting WORK._DOSES1 (memtype=DATA). NOTE: Deleting WORK._DOSES2 (memtype=DATA). NOTE: Deleting WORK._DOSES3 (memtype=DATA). NOTE: Deleting WORK._DOSESALL (memtype=DATA). NOTE: Deleting WORK._DX (memtype=DATA). NOTE: Deleting WORK._DX1 (memtype=DATA). NOTE: Deleting WORK._DX2 (memtype=DATA). NOTE: Deleting WORK._DX3 (memtype=DATA). NOTE: Deleting WORK._DX4 (memtype=DATA). NOTE: Deleting WORK._DXC (memtype=DATA). NOTE: Deleting WORK._ICH (memtype=DATA). NOTE: Deleting WORK._ICH1 (memtype=DATA). NOTE: Deleting WORK._ICH2 (memtype=DATA). NOTE: Deleting WORK._ICH3 (memtype=DATA). NOTE: Deleting WORK._ICH4 (memtype=DATA). NOTE: Deleting WORK._ICHALL (memtype=DATA). NOTE: Deleting WORK._JUNK (memtype=DATA). NOTE: Deleting WORK._JUNK2 (memtype=DATA). NOTE: Deleting WORK._LUDC (memtype=DATA). NOTE: Deleting WORK._LUDC1 (memtype=DATA). NOTE: Deleting WORK._LUDC2 (memtype=DATA). NOTE: Deleting WORK._LUDCALL (memtype=DATA). NOTE: Deleting WORK._PPF_COMBINE (memtype=DATA). NOTE: Deleting WORK._PPF_COMBINE2 (memtype=DATA). NOTE: Deleting WORK._REG (memtype=DATA). NOTE: Deleting WORK._REG_ALL (memtype=DATA). NOTE: Deleting WORK._SPRO (memtype=DATA). NOTE: Deleting WORK._SPRO1 (memtype=DATA). NOTE: Deleting WORK._SPRO2 (memtype=DATA). NOTE: Deleting WORK._SPRO3 (memtype=DATA). NOTE: Deleting WORK._SPRO4 (memtype=DATA). NOTE: Deleting WORK._SPRO5 (memtype=DATA). NOTE: Deleting WORK._SPROALL (memtype=DATA). NOTE: Deleting WORK._UCS (memtype=DATA). NOTE: Deleting WORK._UCS2 (memtype=DATA). NOTE: Deleting WORK.PPF_FWP_COMBINE3 (memtype=DATA). NOTE: PROCEDURE DATASETS used (Total process time): real time 0.18 seconds cpu time 0.18 seconds NOTE: There were 7899 observations read from the data set WORK.IP_SP_COMBINED. NOTE: The data set WORK._ISP has 7899 observations and 589 variables. NOTE: DATA statement used (Total process time): real time 0.46 seconds cpu time 0.46 seconds Directory Libref WORK Engine V9 Physical Name C:\Users\bil7\AppData\Local\Temp\SAS Temporary Files\_TD14916_D347430_ Filename C:\Users\bil7\AppData\Local\Temp\SAS Temporary Files\_TD14916_D347430_ Member # Name Type File Size Last Modified 1 IE_SE_COMBINED DATA 6GB 08/12/2021 06:34:27 2 IP_SP_COMBINED DATA 494MB 08/12/2021 06:37:46 3 REC DATA 384KB 08/12/2021 06:35:32 4 _ISP DATA 494MB 08/12/2021 06:37:47 NOTE: MODIFY was successful for WORK._ISP.DATA. NOTE: PROCEDURE DATASETS used (Total process time): real time 0.03 seconds cpu time 0.03 seconds NOTE: The data set WORK._VAR_ISP has 589 observations and 2 variables. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.01 seconds cpu time 0.01 seconds NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 2863:32 2864:22 NOTE: There were 589 observations read from the data set WORK._VAR_ISP. NOTE: The data set WORK._VAR_ISP has 589 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds NOTE: There were 7899 observations read from the data set WORK._ISP. NOTE: The data set WORK._ISP2 has 7899 observations and 589 variables. NOTE: DATA statement used (Total process time): real time 0.48 seconds cpu time 0.48 seconds NOTE: WORK.CLOT data set was successfully created. NOTE: The data set WORK.CLOT has 1101 observations and 2 variables. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.88 seconds cpu time 0.56 seconds NOTE: There were 1101 observations read from the data set WORK.CLOT. NOTE: The data set WORK.CLOT2 has 1101 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 2970:34 2975:32 2980:35 3031:1 3034:1 3076:1 NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 3031:92 3034:91 3076:89 3271:90 3282:90 NOTE: There were 7899 observations read from the data set WORK._ISP2. NOTE: The data set WORK._ISP_C has 7892 observations and 648 variables. NOTE: DATA statement used (Total process time): real time 3.12 seconds cpu time 3.12 seconds NOTE: There were 7892 observations read from the data set WORK._ISP_C. NOTE: The data set WORK._ISP_C2 has 7892 observations and 653 variables. NOTE: DATA statement used (Total process time): real time 0.68 seconds cpu time 0.67 seconds NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 3317:63 3318:62 NOTE: There were 7892 observations read from the data set WORK._ISP_C2. NOTE: The data set WORK._ISP_C3 has 7892 observations and 653 variables. NOTE: DATA statement used (Total process time): real time 1.37 seconds cpu time 0.76 seconds NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 3437:9 3441:9 3456:21 3470:22 3541:27 3556:19 3595:21 3596:21 3616:23 3671:24 3699:22 3705:17 3706:17 NOTE: There were 7892 observations read from the data set WORK._ISP_C3. NOTE: The data set WORK._ISP_C4 has 7892 observations and 807 variables. NOTE: DATA statement used (Total process time): real time 1.45 seconds cpu time 0.89 seconds NOTE: There were 7892 observations read from the data set WORK._ISP_C4. NOTE: The data set WORK.IP_SP_COMBINED3 has 7892 observations and 807 variables. NOTE: DATA statement used (Total process time): real time 1.40 seconds cpu time 0.76 seconds NOTE: The file WORK.IP_SP_COMBINED1 (memtype=DATA) was not found, but appears on a DELETE statement. NOTE: Deleting WORK._ISP (memtype=DATA). NOTE: Deleting WORK._ISP2 (memtype=DATA). NOTE: Deleting WORK._ISP_C (memtype=DATA). NOTE: Deleting WORK._ISP_C2 (memtype=DATA). NOTE: Deleting WORK._ISP_C3 (memtype=DATA). NOTE: Deleting WORK._ISP_C4 (memtype=DATA). NOTE: Deleting WORK._VAR_ISP (memtype=DATA). NOTE: PROCEDURE DATASETS used (Total process time): real time 1.40 seconds cpu time 0.57 seconds Directory Libref WORK Engine V9 Physical Name C:\Users\bil7\AppData\Local\Temp\SAS Temporary Files\_TD14916_D347430_ Filename C:\Users\bil7\AppData\Local\Temp\SAS Temporary Files\_TD14916_D347430_ Member # Name Type File Size Last Modified 1 CLOT DATA 192KB 08/12/2021 06:37:48 2 CLOT2 DATA 256KB 08/12/2021 06:37:48 3 IE_SE_COMBINED DATA 6GB 08/12/2021 06:34:27 4 IP_SP_COMBINED DATA 494MB 08/12/2021 06:37:46 5 IP_SP_COMBINED3 DATA 709MB 08/12/2021 06:37:58 6 REC DATA 384KB 08/12/2021 06:35:32 NOTE: MODIFY was successful for WORK.IE_SE_COMBINED.DATA. NOTE: PROCEDURE DATASETS used (Total process time): real time 0.03 seconds cpu time 0.03 seconds NOTE: There were 7892 observations read from the data set WORK.IP_SP_COMBINED3. NOTE: The data set WORK._IP_SP_COMBINED4 has 7892 observations and 806 variables. NOTE: DATA statement used (Total process time): real time 0.73 seconds cpu time 0.73 seconds NOTE: Data source is connected in READ ONLY mode. NOTE: WORK.KEEP data set was successfully created. NOTE: The data set WORK.KEEP has 829 observations and 3 variables. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.70 seconds cpu time 0.31 seconds NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 4525:35 NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 4525:26 WARNING: The variable _inhi_hemlibra_use in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable _inhi_mostrcnt_titr_assay in the DROP, KEEP, or RENAME list has never been referenced. NOTE: There were 49241 observations read from the data set WORK.IE_SE_COMBINED. NOTE: There were 7892 observations read from the data set WORK._IP_SP_COMBINED4. NOTE: The data set WORK._UDC2_MAP has 57133 observations and 488 variables. NOTE: DATA statement used (Total process time): real time 8.34 seconds cpu time 8.23 seconds NOTE: There were 57133 observations read from the data set WORK._UDC2_MAP. NOTE: The data set WORK._UDC2_MAP has 57133 observations and 488 variables. NOTE: PROCEDURE SORT used (Total process time): real time 49.42 seconds cpu time 13.23 seconds NOTE: There were 57133 observations read from the data set WORK._UDC2_MAP. NOTE: The data set WORK._UDC2_MAP2 has 57133 observations and 488 variables. NOTE: DATA statement used (Total process time): real time 5.96 seconds cpu time 4.95 seconds NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 4833:6 4833:30 4833:55 4833:192 4833:1 4833:1 4833:1 4836:7 4836:31 4836:56 4836:193 4836:1 4836:1 4836:1 NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 4833:201 4836:202 NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 54319 at 4833:23 53567 at 4833:47 53025 at 4833:72 55255 at 4836:24 54765 at 4836:48 54173 at 4836:73 1 at 4836:244 1 at 4836:23 NOTE: There were 57133 observations read from the data set WORK._UDC2_MAP2. NOTE: The data set WORK._UDC2_MAP3 has 57133 observations and 490 variables. NOTE: DATA statement used (Total process time): real time 12.32 seconds cpu time 5.87 seconds NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 4955:1 4955:1 4955:1 4955:1 NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 41395 at 4955:43 56930 at 4955:43 57125 at 4955:43 57130 at 4955:43 NOTE: There were 57133 observations read from the data set WORK._UDC2_MAP3. NOTE: The data set WORK._UDC2_FINAL has 57133 observations and 496 variables. NOTE: DATA statement used (Total process time): real time 43.91 seconds cpu time 39.17 seconds NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 5003:2 5003:2 5003:2 5003:2 5003:2 5003:1 5003:1 5003:1 5004:2 5004:2 5004:2 5004:2 5004:2 5004:1 5004:1 5004:1 5005:2 5005:2 5005:2 5005:2 5005:2 5005:1 5005:1 5005:1 5006:2 5006:2 5006:2 5006:2 5006:2 5006:1 5006:1 5006:1 5007:2 5007:2 5007:2 5007:2 5007:2 5007:1 5007:1 5007:1 5008:2 5008:2 5008:2 5008:2 5008:2 5008:1 5008:1 5008:1 5009:2 5009:2 5009:2 5009:2 5009:2 5009:1 5009:1 5009:1 5013:2 5013:2 5013:2 5013:2 5013:2 5013:1 5013:1 5013:1 5014:2 5014:2 5014:2 5014:2 5014:2 5014:1 5014:1 5014:1 5015:2 5015:2 5015:2 5015:2 5015:2 5015:1 5015:1 5015:1 5016:2 5016:2 5016:2 5016:2 5016:2 5016:1 5016:1 5016:1 5017:2 5017:2 5017:2 5017:2 5017:2 5017:1 5017:1 5017:1 5018:2 5018:2 5018:2 5018:2 5018:2 5018:1 5018:1 5018:1 5019:2 5019:2 5019:2 5019:2 5019:2 5019:1 5019:1 5019:1 5020:2 5020:2 5020:2 5020:2 5020:2 5020:1 5020:1 5020:1 5021:2 5021:2 5021:2 5021:2 5021:2 5021:1 5021:1 5021:1 5022:2 5022:2 5022:2 5022:2 5022:2 5022:1 5022:1 5022:1 5023:2 5023:2 5023:2 5023:2 5023:2 5023:1 5023:1 5023:1 5024:2 5024:2 5024:2 5024:2 5024:2 5024:1 5024:1 5024:1 5025:2 5025:2 5025:2 5025:2 5025:2 5025:1 5025:1 5025:1 5026:2 5026:2 5026:2 5026:2 5026:2 5026:1 5026:1 5026:1 5027:2 5027:2 5027:2 5027:2 5027:2 5027:1 5027:1 5027:1 5028:2 5028:2 5028:2 5028:2 5028:2 5028:1 5028:1 5028:1 5083:130 5083:1 5093:130 5093:1 5117:1 5117:17 5165:23 NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 5003:111 5003:155 5003:163 5004:111 5004:155 5004:163 5005:111 5005:155 5005:163 5006:111 5006:155 5006:163 5007:111 5007:155 5007:163 5008:111 5008:155 5008:163 5009:111 5009:155 5009:163 5013:111 5013:155 5013:163 5014:111 5014:155 5014:163 5015:111 5015:155 5015:163 5016:111 5016:155 5016:163 5017:111 5017:155 5017:163 5018:111 5018:155 5018:163 5019:111 5019:155 5019:163 5020:111 5020:155 5020:163 5021:111 5021:155 5021:163 5022:111 5022:155 5022:163 5023:111 5023:155 5023:163 5024:111 5024:155 5024:163 5025:111 5025:155 5025:163 5026:111 5026:155 5026:163 5027:111 5027:155 5027:163 5028:111 5028:155 5028:163 5117:22 NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 55669 at 5003:177 56913 at 5004:177 57076 at 5005:177 57113 at 5006:177 57125 at 5007:177 57128 at 5008:177 57130 at 5009:177 18624 at 5013:177 1169 at 5014:177 2564 at 5015:177 39349 at 5016:177 56480 at 5017:177 57107 at 5018:177 57131 at 5019:177 42533 at 5020:177 44311 at 5021:177 21730 at 5022:177 55443 at 5023:177 53025 at 5024:177 54173 at 5025:177 56588 at 5026:177 56202 at 5027:177 56824 at 5028:177 46 at 5035:16 18624 at 5037:25 1169 at 5038:22 2564 at 5039:22 39349 at 5040:21 56480 at 5041:21 57107 at 5042:21 57131 at 5043:21 42533 at 5044:22 44311 at 5045:27 21730 at 5046:30 55443 at 5047:26 54173 at 5048:27 56588 at 5049:23 53025 at 5050:22 46 at 5070:17 46 at 5070:38 46 at 5070:54 46 at 5071:17 46 at 5071:38 46 at 5071:54 39350 at 5073:13 39350 at 5073:35 39350 at 5073:51 56480 at 5074:13 56480 at 5074:35 56480 at 5074:51 57107 at 5075:13 57107 at 5075:35 57107 at 5075:51 57131 at 5076:13 57131 at 5076:35 57131 at 5076:51 55670 at 5085:14 55670 at 5085:35 55670 at 5085:51 56914 at 5086:14 56914 at 5086:35 56914 at 5086:51 57076 at 5087:14 57076 at 5087:35 57076 at 5087:51 57113 at 5088:14 57113 at 5088:35 57113 at 5088:51 57125 at 5089:14 57125 at 5089:35 57125 at 5089:51 57128 at 5090:14 57128 at 5090:35 57128 at 5090:51 57130 at 5091:14 57130 at 5091:35 57130 at 5091:51 410462 at 5117:22 46199 at 5165:53 NOTE: There were 57133 observations read from the data set WORK._UDC2_FINAL. NOTE: The data set WORK.UDC2_FINAL2 has 57133 observations and 745 variables. NOTE: DATA statement used (Total process time): real time 46.75 seconds cpu time 15.93 seconds NOTE: Deleting WORK._IP_SP_COMBINED4 (memtype=DATA). NOTE: Deleting WORK._UDC2_FINAL (memtype=DATA). NOTE: Deleting WORK._UDC2_MAP (memtype=DATA). NOTE: Deleting WORK._UDC2_MAP2 (memtype=DATA). NOTE: Deleting WORK._UDC2_MAP3 (memtype=DATA). NOTE: Deleting WORK.IE_SE_COMBINED (memtype=DATA). NOTE: Deleting WORK.IP_SP_COMBINED3 (memtype=DATA). NOTE: PROCEDURE DATASETS used (Total process time): real time 4.79 seconds cpu time 2.54 seconds NOTE: There were 57133 observations read from the data set WORK.UDC2_FINAL2. NOTE: The data set WORK.UDC2_FINAL3 has 57133 observations and 746 variables. NOTE: DATA statement used (Total process time): real time 3.71 seconds cpu time 3.00 seconds NOTE: Libref REFDIR was successfully assigned as follows: Engine: V9 Physical Name: \\cdc\project\CCHP_NCBDDD_DBD\SHARE\Binh Le\DUKE\BINH\SAS program\cdc NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 46 at 5240:9 46 at 5240:51 46 at 5240:73 NOTE: There were 57133 observations read from the data set WORK.UDC2_FINAL3. NOTE: The data set WORK.MYDATA has 27908 observations and 10 variables. NOTE: DATA statement used (Total process time): real time 1.95 seconds cpu time 1.34 seconds NOTE: There were 27908 observations read from the data set WORK.MYDATA. NOTE: The data set WORK._ORIG has 27908 observations and 13 variables. NOTE: The data set WORK._MYDATA has 27908 observations and 13 variables. NOTE: The data set WORK._OLD has 0 observations and 13 variables. NOTE: DATA statement used (Total process time): real time 1.54 seconds cpu time 0.04 seconds NOTE: There were 27908 observations read from the data set WORK._MYDATA. NOTE: The data set WORK._CINAGE has 27908 observations and 16 variables. NOTE: The data set WORK._CINLEN has 0 observations and 16 variables. NOTE: The data set WORK._CINHT has 27162 observations and 16 variables. NOTE: DATA statement used (Total process time): real time 1.53 seconds cpu time 0.11 seconds NOTE: There were 482 observations read from the data set REFDIR.CDCREF_D. WHERE denom='age'; NOTE: The data set WORK.CREFAGE has 482 observations and 52 variables. NOTE: DATA statement used (Total process time): real time 0.71 seconds cpu time 0.04 seconds NOTE: There were 482 observations read from the data set WORK.CREFAGE. NOTE: The data set WORK.CREFAGE has 482 observations and 52 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.60 seconds cpu time 0.01 seconds NOTE: There were 27908 observations read from the data set WORK._CINAGE. NOTE: The data set WORK._CINAGE has 27908 observations and 16 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.48 seconds cpu time 0.06 seconds NOTE: Variable headcir is uninitialized. NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 161286 at 5336:20 161286 at 5336:28 161286 at 5336:34 161286 at 5336:41 760 at 5353:21 NOTE: There were 27908 observations read from the data set WORK._CINAGE. NOTE: There were 482 observations read from the data set WORK.CREFAGE. NOTE: The data set WORK.FINFAGE has 27908 observations and 66 variables. NOTE: DATA statement used (Total process time): real time 1.13 seconds cpu time 0.17 seconds NOTE: Input data set is empty. NOTE: The data set WORK._CINLEN has 0 observations and 16 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.46 seconds cpu time 0.00 seconds NOTE: There were 118 observations read from the data set REFDIR.CDCREF_D. WHERE denom='length'; NOTE: The data set WORK.CREFLG has 118 observations and 11 variables. NOTE: DATA statement used (Total process time): real time 0.57 seconds cpu time 0.04 seconds NOTE: There were 118 observations read from the data set WORK.CREFLG. NOTE: The data set WORK.CREFLG has 118 observations and 11 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.53 seconds cpu time 0.01 seconds NOTE: There were 0 observations read from the data set WORK._CINLEN. NOTE: There were 118 observations read from the data set WORK.CREFLG. NOTE: The data set WORK.FINFLG has 0 observations and 9 variables. NOTE: DATA statement used (Total process time): real time 0.56 seconds cpu time 0.04 seconds NOTE: There were 27162 observations read from the data set WORK._CINHT. NOTE: The data set WORK._CINHT has 27162 observations and 16 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.21 seconds cpu time 0.06 seconds NOTE: There were 90 observations read from the data set REFDIR.CDCREF_D. WHERE denom='height'; NOTE: The data set WORK.CREFHT has 90 observations and 11 variables. NOTE: DATA statement used (Total process time): real time 0.70 seconds cpu time 0.01 seconds NOTE: There were 90 observations read from the data set WORK.CREFHT. NOTE: The data set WORK.CREFHT has 90 observations and 11 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.59 seconds cpu time 0.01 seconds NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 51 at 5395:17 51 at 5395:36 153 at 5399:19 153 at 5399:26 153 at 5399:32 153 at 5399:39 51 at 5401:30 51 at 5401:102 51 at 5401:152 51 at 5401:164 51 at 5401:195 51 at 5401:244 51 at 5401:85 NOTE: There were 27162 observations read from the data set WORK._CINHT. NOTE: There were 90 observations read from the data set WORK.CREFHT. NOTE: The data set WORK.FINFHT has 5596 observations and 9 variables. NOTE: DATA statement used (Total process time): real time 0.06 seconds cpu time 0.03 seconds NOTE: Input data set is empty. NOTE: The data set WORK.FINFLG has 0 observations and 9 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.64 seconds cpu time 0.01 seconds NOTE: There were 5596 observations read from the data set WORK.FINFHT. NOTE: The data set WORK.FINFHT has 5596 observations and 9 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.48 seconds cpu time 0.03 seconds NOTE: There were 0 observations read from the data set WORK.FINFLG. NOTE: There were 5596 observations read from the data set WORK.FINFHT. NOTE: The data set WORK.LENHT has 5596 observations and 13 variables. NOTE: DATA statement used (Total process time): real time 0.54 seconds cpu time 0.03 seconds NOTE: There were 27908 observations read from the data set WORK.FINFAGE. NOTE: The data set WORK.FINFAGE has 27908 observations and 66 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.60 seconds cpu time 0.09 seconds NOTE: Variable _bivac is uninitialized. NOTE: Variable _bivssf is uninitialized. NOTE: Variable _bivtsf is uninitialized. NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 391 at 5422:7 391 at 5424:7 NOTE: There were 27908 observations read from the data set WORK.FINFAGE. NOTE: There were 5596 observations read from the data set WORK.LENHT. NOTE: The data set WORK._OUTDATA has 27908 observations and 89 variables. NOTE: DATA statement used (Total process time): real time 0.70 seconds cpu time 0.11 seconds NOTE: There were 27908 observations read from the data set WORK._OUTDATA. NOTE: The data set WORK._OUTDATA has 27908 observations and 44 variables. NOTE: DATA statement used (Total process time): real time 0.62 seconds cpu time 0.07 seconds NOTE: There were 27908 observations read from the data set WORK._OUTDATA. NOTE: There were 0 observations read from the data set WORK._OLD. NOTE: The data set WORK._OUTDATA has 27908 observations and 53 variables. NOTE: DATA statement used (Total process time): real time 0.95 seconds cpu time 0.07 seconds NOTE: There were 27908 observations read from the data set WORK._OUTDATA. NOTE: The data set WORK._OUTDATA has 27908 observations and 53 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.01 seconds cpu time 0.09 seconds NOTE: There were 27908 observations read from the data set WORK._ORIG. NOTE: The data set WORK._ORIG has 27908 observations and 13 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.59 seconds cpu time 0.04 seconds NOTE: There were 27908 observations read from the data set WORK._OUTDATA. NOTE: There were 27908 observations read from the data set WORK._ORIG. NOTE: The data set WORK._CDCDATA has 27908 observations and 36 variables. NOTE: DATA statement used (Total process time): real time 0.62 seconds cpu time 0.07 seconds NOTE: There were 27908 observations read from the data set WORK._CDCDATA. NOTE: The data set WORK._PART1 has 27908 observations and 25 variables. NOTE: DATA statement used (Total process time): real time 0.59 seconds cpu time 0.09 seconds NOTE: Libref REFDIR was successfully assigned as follows: Engine: V9 Physical Name: \\cdc.gov\project\CCHP_NCBDDD_DBD\SHARE\Binh Le\Community Count\whodata NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 46 at 5466:9 46 at 5466:51 46 at 5466:73 NOTE: There were 57133 observations read from the data set WORK.UDC2_FINAL3. NOTE: The data set WORK.MYDATA has 1261 observations and 10 variables. NOTE: DATA statement used (Total process time): real time 1.85 seconds cpu time 1.34 seconds NOTE: There were 1261 observations read from the data set WORK.MYDATA. NOTE: The data set WORK._MYDATA has 1261 observations and 14 variables. NOTE: The data set WORK._WINDATA has 1261 observations and 14 variables. NOTE: The data set WORK._WOLD has 0 observations and 14 variables. NOTE: DATA statement used (Total process time): real time 1.65 seconds cpu time 0.07 seconds NOTE: There were 16716 observations read from the data set REFDIR.WHOREF_D. NOTE: The data set WORK._WREF1 has 1462 observations and 29 variables. NOTE: DATA statement used (Total process time): real time 1.10 seconds cpu time 0.10 seconds NOTE: There were 1462 observations read from the data set WORK._WREF1. NOTE: The data set WORK._WREF1 has 1462 observations and 29 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.85 seconds cpu time 0.03 seconds NOTE: There were 1261 observations read from the data set WORK._WINDATA. NOTE: The data set WORK._WINDATA has 1261 observations and 14 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.43 seconds cpu time 0.01 seconds NOTE: There were 1462 observations read from the data set WORK._WREF1. NOTE: There were 1261 observations read from the data set WORK._WINDATA. NOTE: The data set WORK._WT1 has 1261 observations and 40 variables. NOTE: DATA statement used (Total process time): real time 0.29 seconds cpu time 0.06 seconds NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 76 at 5504:15 76 at 5504:63 76 at 5504:64 1261 at 5505:20 1261 at 5505:79 1261 at 5505:80 3880 at 5518:6 3880 at 5525:10 3880 at 5525:11 NOTE: There were 1261 observations read from the data set WORK._WT1. NOTE: The data set WORK._WT1 has 1261 observations and 64 variables. NOTE: DATA statement used (Total process time): real time 0.40 seconds cpu time 0.06 seconds NOTE: There were 1261 observations read from the data set WORK._WINDATA. NOTE: The data set WORK._WINDATA2 has 1186 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.35 seconds cpu time 0.04 seconds NOTE: There were 13002 observations read from the data set REFDIR.WHOREF_D. WHERE _denom='forlen'; NOTE: The data set WORK._WREF2 has 13002 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 1.25 seconds cpu time 0.07 seconds NOTE: There were 13002 observations read from the data set WORK._WREF2. NOTE: The data set WORK._WREF2 has 13002 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.03 seconds cpu time 0.03 seconds NOTE: There were 1186 observations read from the data set WORK._WINDATA2. NOTE: The data set WORK._WINDATA2 has 1186 observations and 5 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.48 seconds cpu time 0.03 seconds NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 15 at 5539:37 15 at 5541:5 15 at 5548:14 15 at 5548:15 NOTE: There were 1186 observations read from the data set WORK._WINDATA2. NOTE: There were 13002 observations read from the data set WORK._WREF2. NOTE: The data set WORK._WT2 has 1186 observations and 17 variables. NOTE: DATA statement used (Total process time): real time 0.26 seconds cpu time 0.04 seconds NOTE: There were 1261 observations read from the data set WORK._WT1. NOTE: The data set WORK._WT1 has 1261 observations and 64 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.28 seconds cpu time 0.01 seconds NOTE: There were 1186 observations read from the data set WORK._WT2. NOTE: The data set WORK._WT2 has 1186 observations and 17 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.32 seconds cpu time 0.01 seconds NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 21 at 5565:7 21 at 5567:7 NOTE: There were 1261 observations read from the data set WORK._WT1. NOTE: There were 1186 observations read from the data set WORK._WT2. NOTE: The data set WORK._WD1 has 1261 observations and 78 variables. NOTE: DATA statement used (Total process time): real time 0.31 seconds cpu time 0.04 seconds NOTE: There were 1261 observations read from the data set WORK._WD1. NOTE: There were 0 observations read from the data set WORK._WOLD. NOTE: The data set WORK._WOUTDATA has 1261 observations and 30 variables. NOTE: DATA statement used (Total process time): real time 0.28 seconds cpu time 0.01 seconds NOTE: There were 1261 observations read from the data set WORK._WOUTDATA. NOTE: The data set WORK._WOUTDATA has 1261 observations and 30 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.28 seconds cpu time 0.01 seconds NOTE: There were 1261 observations read from the data set WORK._MYDATA. NOTE: The data set WORK._MYDATA has 1261 observations and 14 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.23 seconds cpu time 0.03 seconds NOTE: There were 1261 observations read from the data set WORK._WOUTDATA. NOTE: There were 1261 observations read from the data set WORK._MYDATA. NOTE: The data set WORK._WHODATA has 1261 observations and 40 variables. NOTE: DATA statement used (Total process time): real time 0.10 seconds cpu time 0.03 seconds NOTE: There were 1261 observations read from the data set WORK._WHODATA. NOTE: The data set WORK._WHODATA has 1261 observations and 37 variables. NOTE: DATA statement used (Total process time): real time 0.37 seconds cpu time 0.01 seconds NOTE: There were 1261 observations read from the data set WORK._WHODATA. NOTE: The data set WORK._WHODATA2 has 1261 observations and 36 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds NOTE: There were 27908 observations read from the data set WORK._PART1. NOTE: The data set WORK._CDCDATA2 has 27908 observations and 24 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds WARNING: The variable _bmi in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable _bmi_cat in the DROP, KEEP, or RENAME list has never been referenced. NOTE: There were 1261 observations read from the data set WORK._WHODATA2. NOTE: There were 27908 observations read from the data set WORK._CDCDATA2. NOTE: The data set WORK._CALL has 29169 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds NOTE: There were 29169 observations read from the data set WORK._CALL. NOTE: The data set WORK._CALL has 29169 observations and 4 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.04 seconds cpu time 0.03 seconds NOTE: There were 29169 observations read from the data set WORK._CALL. NOTE: There were 57133 observations read from the data set WORK.UDC2_FINAL3. NOTE: The data set WORK._CALL2 has 57133 observations and 749 variables. NOTE: DATA statement used (Total process time): real time 3.63 seconds cpu time 3.21 seconds NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 74 at 5610:39 2649 at 5610:68 668983 at 5646:8 56588 at 5666:19 56588 at 5666:44 56588 at 5666:60 NOTE: There were 57133 observations read from the data set WORK._CALL2. NOTE: The data set WORK._FINAL has 57133 observations and 775 variables. NOTE: DATA statement used (Total process time): real time 4.28 seconds cpu time 3.42 seconds NOTE: There were 57133 observations read from the data set WORK._FINAL. NOTE: The data set WORK._A has 57133 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 2.04 seconds cpu time 1.40 seconds NOTE: There were 57133 observations read from the data set WORK._A. NOTE: The data set WORK._B has 57133 observations and 37 variables. NOTE: DATA statement used (Total process time): real time 1.90 seconds cpu time 0.84 seconds NOTE: IML Ready NOTE: Closing WORK._B NOTE: Exiting IML. NOTE: PROCEDURE IML used (Total process time): real time 4.43 seconds cpu time 1.73 seconds NOTE: PROCEDURE SQL used (Total process time): real time 0.06 seconds cpu time 0.06 seconds NOTE: There were 57133 observations read from the data set WORK._B1. NOTE: The data set WORK._SET1 has 57133 observations and 34 variables. NOTE: DATA statement used (Total process time): real time 1.21 seconds cpu time 0.18 seconds NOTE: There were 57133 observations read from the data set WORK._SET1. NOTE: The data set WORK._SET1 has 57133 observations and 34 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.73 seconds cpu time 0.34 seconds NOTE: There were 57133 observations read from the data set WORK._B1. NOTE: The data set WORK._SET2 has 57133 observations and 34 variables. NOTE: DATA statement used (Total process time): real time 0.70 seconds cpu time 0.15 seconds NOTE: There were 57133 observations read from the data set WORK._SET2. NOTE: The data set WORK._SET2 has 57133 observations and 34 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.53 seconds cpu time 0.36 seconds NOTE: There were 57133 observations read from the data set WORK._B1. NOTE: The data set WORK._SET3 has 57133 observations and 34 variables. NOTE: DATA statement used (Total process time): real time 0.63 seconds cpu time 0.17 seconds NOTE: There were 57133 observations read from the data set WORK._SET3. NOTE: The data set WORK._SET3 has 57133 observations and 34 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.07 seconds cpu time 0.40 seconds NOTE: There were 57133 observations read from the data set WORK._B1. NOTE: The data set WORK._SET4 has 57133 observations and 34 variables. NOTE: DATA statement used (Total process time): real time 0.70 seconds cpu time 0.17 seconds NOTE: There were 57133 observations read from the data set WORK._SET4. NOTE: The data set WORK._SET4 has 57133 observations and 34 variables. NOTE: PROCEDURE SORT used (Total process time): real time 2.09 seconds cpu time 0.35 seconds NOTE: There were 57133 observations read from the data set WORK._B1. NOTE: The data set WORK._SET5 has 57133 observations and 34 variables. NOTE: DATA statement used (Total process time): real time 1.15 seconds cpu time 0.17 seconds NOTE: There were 57133 observations read from the data set WORK._SET5. NOTE: The data set WORK._SET5 has 57133 observations and 34 variables. NOTE: PROCEDURE SORT used (Total process time): real time 2.04 seconds cpu time 0.39 seconds NOTE: There were 57133 observations read from the data set WORK._B1. NOTE: The data set WORK._SET6 has 57133 observations and 34 variables. NOTE: DATA statement used (Total process time): real time 0.71 seconds cpu time 0.17 seconds NOTE: There were 57133 observations read from the data set WORK._SET6. NOTE: The data set WORK._SET6 has 57133 observations and 34 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.32 seconds cpu time 0.37 seconds NOTE: There were 57133 observations read from the data set WORK._B1. NOTE: The data set WORK._SET7 has 57133 observations and 34 variables. NOTE: DATA statement used (Total process time): real time 0.76 seconds cpu time 0.17 seconds NOTE: There were 57133 observations read from the data set WORK._SET7. NOTE: The data set WORK._SET7 has 57133 observations and 34 variables. NOTE: PROCEDURE SORT used (Total process time): real time 2.09 seconds cpu time 0.39 seconds NOTE: MERGE statement has more than one data set with repeats of BY values. NOTE: There were 57133 observations read from the data set WORK._SET1. NOTE: There were 57133 observations read from the data set WORK._SET2. NOTE: There were 57133 observations read from the data set WORK._SET3. NOTE: There were 57133 observations read from the data set WORK._SET4. NOTE: There were 57133 observations read from the data set WORK._SET5. NOTE: There were 57133 observations read from the data set WORK._SET6. NOTE: There were 57133 observations read from the data set WORK._SET7. NOTE: The data set WORK._ALL has 57133 observations and 98 variables. NOTE: DATA statement used (Total process time): real time 1.98 seconds cpu time 1.14 seconds NOTE: There were 57133 observations read from the data set WORK._ALL. NOTE: The data set WORK._JUNK has 57133 observations and 16 variables. NOTE: DATA statement used (Total process time): real time 1.42 seconds cpu time 0.76 seconds NOTE: There were 57133 observations read from the data set WORK._JUNK. NOTE: The data set WORK._JUNK has 57133 observations and 16 variables. NOTE: PROCEDURE SORT used (Total process time): real time 2.21 seconds cpu time 0.62 seconds NOTE: There were 57133 observations read from the data set WORK._FINAL. NOTE: The data set WORK._FINAL has 57133 observations and 775 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1:23.20 cpu time 15.26 seconds NOTE: MERGE statement has more than one data set with repeats of BY values. NOTE: There were 57133 observations read from the data set WORK._JUNK. NOTE: There were 57133 observations read from the data set WORK._FINAL. NOTE: The data set WORK._FINAL2 has 57133 observations and 788 variables. NOTE: DATA statement used (Total process time): real time 4.77 seconds cpu time 3.84 seconds NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 9 at 5916:5 NOTE: There were 57133 observations read from the data set WORK._FINAL2. NOTE: The data set WORK._CC_IV_SV_JUNK has 57133 observations and 794 variables. NOTE: DATA statement used (Total process time): real time 41.94 seconds cpu time 14.15 seconds NOTE: There were 57133 observations read from the data set WORK._CC_IV_SV_JUNK. NOTE: The data set WORK._CC_IV_SV_JUNK has 57133 observations and 794 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1:49.30 cpu time 19.62 seconds NOTE: There were 57133 observations read from the data set WORK._CC_IV_SV_JUNK. NOTE: The data set WORK.CC_IV_SV has 57133 observations and 794 variables. NOTE: DATA statement used (Total process time): real time 6.34 seconds cpu time 5.51 seconds NOTE: Deleting WORK._A (memtype=DATA). NOTE: Deleting WORK._ALL (memtype=DATA). NOTE: Deleting WORK._B (memtype=DATA). NOTE: Deleting WORK._B1 (memtype=DATA). NOTE: Deleting WORK._CALL (memtype=DATA). NOTE: Deleting WORK._CALL2 (memtype=DATA). NOTE: Deleting WORK._CC_IV_SV_JUNK (memtype=DATA). NOTE: Deleting WORK._CDCDATA (memtype=DATA). NOTE: Deleting WORK._CDCDATA2 (memtype=DATA). NOTE: Deleting WORK._CINAGE (memtype=DATA). NOTE: Deleting WORK._CINHT (memtype=DATA). NOTE: Deleting WORK._CINLEN (memtype=DATA). NOTE: Deleting WORK._FINAL (memtype=DATA). NOTE: Deleting WORK._FINAL2 (memtype=DATA). NOTE: Deleting WORK._JUNK (memtype=DATA). NOTE: Deleting WORK._MYDATA (memtype=DATA). NOTE: Deleting WORK._OLD (memtype=DATA). NOTE: Deleting WORK._ORIG (memtype=DATA). NOTE: Deleting WORK._OUTDATA (memtype=DATA). NOTE: Deleting WORK._PART1 (memtype=DATA). NOTE: Deleting WORK._SET1 (memtype=DATA). NOTE: Deleting WORK._SET2 (memtype=DATA). NOTE: Deleting WORK._SET3 (memtype=DATA). NOTE: Deleting WORK._SET4 (memtype=DATA). NOTE: Deleting WORK._SET5 (memtype=DATA). NOTE: Deleting WORK._SET6 (memtype=DATA). NOTE: Deleting WORK._SET7 (memtype=DATA). NOTE: Deleting WORK._WD1 (memtype=DATA). NOTE: Deleting WORK._WHODATA (memtype=DATA). NOTE: Deleting WORK._WHODATA2 (memtype=DATA). NOTE: Deleting WORK._WINDATA (memtype=DATA). NOTE: Deleting WORK._WINDATA2 (memtype=DATA). NOTE: Deleting WORK._WOLD (memtype=DATA). NOTE: Deleting WORK._WOUTDATA (memtype=DATA). NOTE: Deleting WORK._WREF1 (memtype=DATA). NOTE: Deleting WORK._WREF2 (memtype=DATA). NOTE: Deleting WORK._WT1 (memtype=DATA). NOTE: Deleting WORK._WT2 (memtype=DATA). NOTE: Deleting WORK.UDC2_FINAL3 (memtype=DATA). NOTE: Deleting WORK.MYDATA (memtype=DATA). NOTE: Deleting WORK.CREFAGE (memtype=DATA). NOTE: Deleting WORK.CREFHT (memtype=DATA). NOTE: Deleting WORK.CREFLG (memtype=DATA). NOTE: Deleting WORK.FINFAGE (memtype=DATA). NOTE: Deleting WORK.FINFHT (memtype=DATA). NOTE: Deleting WORK.FINFLG (memtype=DATA). NOTE: Deleting WORK.LENHT (memtype=DATA). NOTE: PROCEDURE DATASETS used (Total process time): real time 11.34 seconds cpu time 2.64 seconds NOTE: There were 57133 observations read from the data set WORK.CC_IV_SV. NOTE: The data set WORK.CC_IV_SV has 57133 observations and 794 variables. NOTE: PROCEDURE SORT used (Total process time): real time 39.66 seconds cpu time 13.06 seconds NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 22689 at 6018:4 46 at 6044:5 156 at 6044:37 NOTE: There were 57133 observations read from the data set WORK.CC_IV_SV. NOTE: The data set WORK._AAA has 57133 observations and 812 variables. NOTE: DATA statement used (Total process time): real time 7.06 seconds cpu time 6.00 seconds NOTE: WORK._VARNAME data set was successfully created. NOTE: The data set WORK._VARNAME has 456 observations and 12 variables. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.71 seconds cpu time 0.34 seconds NOTE: There were 456 observations read from the data set WORK._VARNAME. NOTE: The data set WORK._VARNAME has 456 observations and 13 variables. NOTE: DATA statement used (Total process time): real time 0.35 seconds cpu time 0.03 seconds NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds WARNING: Variable SubjectID already exists on file WORK._OUT1. WARNING: Variable first_treat_ble_date already exists on file WORK._OUT1. WARNING: Variable _first_treat_ble_date already exists on file WORK._OUT1. WARNING: Variable circum_exce_ble already exists on file WORK._OUT1. WARNING: Variable _circum_exce_ble already exists on file WORK._OUT1. NOTE: There were 57133 observations read from the data set WORK._AAA. NOTE: The data set WORK._OUT1 has 57133 observations and 807 variables. NOTE: DATA statement used (Total process time): real time 34.80 seconds cpu time 10.15 seconds NOTE: There were 57133 observations read from the data set WORK._OUT1. NOTE: The data set WORK._TEMP has 57133 observations and 808 variables. NOTE: DATA statement used (Total process time): real time 50.74 seconds cpu time 13.95 seconds NOTE: There were 176 observations read from the data set SQLUDC.T_HTCADDRESS. NOTE: The data set WORK.ZIP_HTC has 174 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.60 seconds cpu time 0.03 seconds NOTE: There were 174 observations read from the data set WORK.ZIP_HTC. NOTE: The data set WORK.ZIP_HTC has 174 observations and 4 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.65 seconds cpu time 0.01 seconds NOTE: There were 57133 observations read from the data set WORK._TEMP. NOTE: The data set WORK._TEMP has 57133 observations and 808 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1:58.78 cpu time 19.29 seconds NOTE: There were 57133 observations read from the data set WORK._TEMP. NOTE: There were 174 observations read from the data set WORK.ZIP_HTC. NOTE: The data set WORK._GIS1 has 57133 observations and 811 variables. NOTE: DATA statement used (Total process time): real time 6.34 seconds cpu time 5.61 seconds NOTE: Libref BINH was successfully assigned as follows: Engine: V9 Physical Name: \\cdc.gov\project\CCHP_NCBDDD_DBD\SHARE\Binh Le\SAS\ZIPCODE NOTE: There were 41262 observations read from the data set BINH.ZIPCODE_FINAL. NOTE: The data set WORK.ZIP_PT has 41262 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 2.32 seconds cpu time 0.21 seconds NOTE: There were 41262 observations read from the data set WORK.ZIP_PT. NOTE: The data set WORK.ZIP_PT has 41262 observations and 2 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.46 seconds cpu time 0.04 seconds NOTE: There were 57133 observations read from the data set WORK._GIS1. NOTE: The data set WORK._GIS1 has 57133 observations and 811 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1:30.28 cpu time 17.40 seconds NOTE: There were 41262 observations read from the data set WORK.ZIP_PT. NOTE: There were 57133 observations read from the data set WORK._GIS1. NOTE: The data set WORK._GIS2 has 57133 observations and 812 variables. NOTE: DATA statement used (Total process time): real time 6.57 seconds cpu time 5.76 seconds NOTE: There were 57133 observations read from the data set WORK._GIS2. NOTE: The data set WORK.PTWO1 has 57133 observations and 813 variables. NOTE: DATA statement used (Total process time): real time 39.57 seconds cpu time 12.90 seconds NOTE: WORK.CLOT data set was successfully created. NOTE: The data set WORK.CLOT has 1101 observations and 3 variables. NOTE: PROCEDURE IMPORT used (Total process time): real time 1.92 seconds cpu time 0.59 seconds NOTE: There were 1101 observations read from the data set WORK.CLOT. NOTE: The data set WORK.LIST2 has 1101 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 0.60 seconds cpu time 0.04 seconds NOTE: There were 1101 observations read from the data set WORK.LIST2. NOTE: 80 observations with duplicate key values were deleted. NOTE: The data set WORK.LIST2 has 1021 observations and 2 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.93 seconds cpu time 0.01 seconds NOTE: There were 1021 observations read from the data set WORK.LIST2. NOTE: The data set WORK.LIST3 has 1021 observations and 7 variables. NOTE: DATA statement used (Total process time): real time 0.81 seconds cpu time 0.04 seconds NOTE: There were 1101 observations read from the data set WORK.CLOT. NOTE: The data set WORK.CLOT2 has 464 observations and 8 variables. NOTE: DATA statement used (Total process time): real time 1.92 seconds cpu time 0.03 seconds NOTE: PROCEDURE SQL used (Total process time): real time 0.04 seconds cpu time 0.04 seconds NOTE: There were 57133 observations read from the data set WORK.PTWO1. NOTE: The data set WORK.A has 57133 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 4.18 seconds cpu time 3.51 seconds  The SAS System 06:30 Thursday, August 12, 2021 30 ƒƒƒƒƒƒƒƒ 13  The SAS System 06:30 Thursday, August 12, 2021 31 ƒƒƒƒƒƒƒƒ 4  The SAS System 06:30 Thursday, August 12, 2021 32 ƒƒƒƒƒƒƒƒ 5 NOTE: PROCEDURE SQL used (Total process time): real time 2.40 seconds cpu time 0.09 seconds 13+0 is 13 4+0 is 4 5+0 is 5 NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 42533 at 6516:9 44311 at 6517:11 46 at 6518:10 1 at 6521:36 1 at 6521:63 1 at 6521:77 1 at 6523:45 1 at 6523:74 1 at 6523:90 NOTE: There were 57133 observations read from the data set WORK.PTWO1. NOTE: The data set WORK._TEMP1 has 57133 observations and 926 variables. NOTE: DATA statement used (Total process time): real time 43.00 seconds cpu time 31.18 seconds NOTE: There were 57133 observations read from the data set WORK._TEMP1. NOTE: The data set WORK.INSERT has 57133 observations and 456 variables. NOTE: DATA statement used (Total process time): real time 49.55 seconds cpu time 9.09 seconds NOTE: Libref CC was successfully assigned as follows: Engine: V9 Physical Name: \\cdc.gov\project\CCHP_NCBDDD_DBD\SHARE\Binh Le\CC DATA NOTE: There were 57133 observations read from the data set WORK.INSERT. NOTE: The data set CC.CC_IV_SV_RAW_COMBINE has 57133 observations and 456 variables. NOTE: DATA statement used (Total process time): real time 42.97 seconds cpu time 21.65 seconds NOTE: There were 57133 observations read from the data set WORK.INSERT. NOTE: The data set WORK._DM has 56633 observations and 456 variables. NOTE: DATA statement used (Total process time): real time 3.99 seconds cpu time 3.07 seconds NOTE: There were 16382 observations read from the data set WORK._DM. WHERE _source='IE'; NOTE: 15517 observations with unique key values were deleted. NOTE: The data set WORK._UNIQUE_IE has 15517 observations and 456 variables. NOTE: The data set WORK._DUP_IE has 865 observations and 456 variables. NOTE: PROCEDURE SORT used (Total process time): real time 11.49 seconds cpu time 3.06 seconds NOTE: There were 865 observations read from the data set WORK._DUP_IE. NOTE: The data set WORK._DUP_IE has 865 observations and 456 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.71 seconds cpu time 0.17 seconds NOTE: There were 865 observations read from the data set WORK._DUP_IE. NOTE: 444 observations with duplicate key values were deleted. NOTE: The data set WORK._DE_DUP_IE has 421 observations and 456 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.59 seconds cpu time 0.12 seconds NOTE: There were 15517 observations read from the data set WORK._UNIQUE_IE. NOTE: There were 421 observations read from the data set WORK._DE_DUP_IE. NOTE: The data set WORK._ALL_IE has 15938 observations and 456 variables. NOTE: DATA statement used (Total process time): real time 9.85 seconds cpu time 1.73 seconds NOTE: There were 5275 observations read from the data set WORK._DM. WHERE _source='IP'; NOTE: The data set WORK._ALL_IP has 5275 observations and 456 variables. NOTE: DATA statement used (Total process time): real time 3.18 seconds cpu time 1.71 seconds NOTE: There were 5275 observations read from the data set WORK._ALL_IP. NOTE: There were 15938 observations read from the data set WORK._ALL_IE. NOTE: The data set WORK._JUNK_IV has 21213 observations and 456 variables. NOTE: DATA statement used (Total process time): real time 17.96 seconds cpu time 2.73 seconds NOTE: There were 21213 observations read from the data set WORK._JUNK_IV. NOTE: 20099 observations with unique key values were deleted. NOTE: The data set WORK._UNIQUE_IV has 20099 observations and 456 variables. NOTE: The data set WORK._DUP_IV has 1114 observations and 456 variables. NOTE: PROCEDURE SORT used (Total process time): real time 18.55 seconds cpu time 3.26 seconds NOTE: There were 1114 observations read from the data set WORK._DUP_IV. NOTE: The data set WORK._DUP_IV has 1114 observations and 456 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.78 seconds cpu time 0.18 seconds NOTE: There were 1114 observations read from the data set WORK._DUP_IV. NOTE: 262 observations with duplicate key values were deleted. NOTE: The data set WORK._DE_DUP_IV1 has 852 observations and 456 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.74 seconds cpu time 0.15 seconds NOTE: There were 852 observations read from the data set WORK._DE_DUP_IV1. NOTE: The data set WORK._DE_DUP_IV1 has 852 observations and 456 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.70 seconds cpu time 0.14 seconds NOTE: There were 852 observations read from the data set WORK._DE_DUP_IV1. NOTE: 295 observations with duplicate key values were deleted. NOTE: The data set WORK._DE_DUP_IV2 has 557 observations and 456 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.73 seconds cpu time 0.15 seconds NOTE: There were 20099 observations read from the data set WORK._UNIQUE_IV. NOTE: There were 557 observations read from the data set WORK._DE_DUP_IV2. NOTE: The data set WORK._ALL_IV has 20656 observations and 456 variables. NOTE: DATA statement used (Total process time): real time 13.52 seconds cpu time 2.36 seconds NOTE: There were 32381 observations read from the data set WORK._DM. WHERE _source='SE'; NOTE: 31552 observations with unique key values were deleted. NOTE: The data set WORK._UNIQUE_SE has 31552 observations and 456 variables. NOTE: The data set WORK._DUP_SE has 829 observations and 456 variables. NOTE: PROCEDURE SORT used (Total process time): real time 30.69 seconds cpu time 5.60 seconds NOTE: There were 829 observations read from the data set WORK._DUP_SE. NOTE: The data set WORK._DUP_SE has 829 observations and 456 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.06 seconds cpu time 0.15 seconds NOTE: There were 829 observations read from the data set WORK._DUP_SE. NOTE: 425 observations with duplicate key values were deleted. NOTE: The data set WORK._DE_DUP_SE has 404 observations and 456 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.54 seconds cpu time 0.11 seconds NOTE: There were 31552 observations read from the data set WORK._UNIQUE_SE. NOTE: There were 404 observations read from the data set WORK._DE_DUP_SE. NOTE: The data set WORK._ALL_SE has 31956 observations and 456 variables. NOTE: DATA statement used (Total process time): real time 22.12 seconds cpu time 4.04 seconds NOTE: There were 2595 observations read from the data set WORK._DM. WHERE _source='SP'; NOTE: The data set WORK._ALL_SP has 2595 observations and 456 variables. NOTE: DATA statement used (Total process time): real time 3.34 seconds cpu time 1.23 seconds NOTE: There were 2595 observations read from the data set WORK._ALL_SP. NOTE: There were 31956 observations read from the data set WORK._ALL_SE. NOTE: The data set WORK._ALL_SV has 34551 observations and 456 variables. NOTE: DATA statement used (Total process time): real time 28.33 seconds cpu time 4.57 seconds NOTE: There were 34551 observations read from the data set WORK._ALL_SV. NOTE: There were 20656 observations read from the data set WORK._ALL_IV. NOTE: The data set CC.CC_IV_SV_ANALYSIS_COMBINE has 55207 observations and 456 variables. NOTE: DATA statement used (Total process time): real time 59.81 seconds cpu time 25.57 seconds 12 MPRINT(OPT): options emailhost=smtpgw.cdc.gov emailsys=SMTP nocenter nodate; MPRINT(OPT): title; MPRINT(OPT): options EMAILID ="bil7@cdc.gov"; SYMBOLGEN: Macro variable DAY resolves to 12 SYMBOLGEN: Macro variable DAY resolves to 12 SYMBOLGEN: Macro variable DAY resolves to 12 SYMBOLGEN: Macro variable DAY resolves to 12 MLOGIC(OPT): %IF condition &day=1|&day=7|&day=15|&day=22 is FALSE MPRINT(OPT): FILENAME ERRREPT EMAIL EMAILSYS=SMTP to=("bil7@cdc.gov" ) subject="Combined Community Counts Dataset Creation." content_type="text/html" ; MLOGIC(OPT): Ending execution. MLOGIC(AUTORUN): Beginning execution. MPRINT(AUTORUN): data _null_; MPRINT(AUTORUN): file ERRREPT; MPRINT(AUTORUN): put "<p>Hello,</p>"/; MPRINT(AUTORUN): put "<p> </p>"/; WARNING: Apparent symbolic reference SERVER not resolved. MPRINT(AUTORUN): put "<p>The program to create the TWO combine community counts datasets on &server. has run.</p>"; MPRINT(AUTORUN): put "<p>Thank you </p>"; MPRINT(AUTORUN): put "<p>Binh & Fred</p>"; MPRINT(AUTORUN): run; NOTE: The file ERRREPT is: E-Mail Access Device Message sent To: "bil7@cdc.gov" Cc: Bcc: Subject: Combined Community Counts Dataset Creation. Attachments: NOTE: 7 records were written to the file ERRREPT. The minimum record length was 0. The maximum record length was 91. NOTE: DATA statement used (Total process time): real time 0.17 seconds cpu time 0.04 seconds MLOGIC(AUTORUN): Ending execution. NOTE: AUTOEXEC processing completed. NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 30:58.18 cpu time 10:49.60 ... View more

Thanks. The problem is every record in the dataset has a possibility to be updated so I could not simply track for new records and append 😞 Le ... View more