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