topic Re: Updating big dataset in SAS Programming

Updating big dataset

binhle50 — Thu, 12 Aug 2021 19:00:30 GMT

Hi all,

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.

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.

I would be highly appreciate if any one have any suggestion for me!

Best,

Re: Updating big dataset

Tom — Thu, 12 Aug 2021 19:10:03 GMT

There are probably a lot of different ways to optimize. It would help to know which of the steps are the biggest bottle neck a start there.

So you might get some improvements (perhaps even major ones) by just making improvements on the individual steps.

Most likely the place where you could make the biggest improvement is limiting the updates to just the things that have changed. But that depends on being able to know what has changed.

For example if part of the change is re-structuring 5 tables into a single set of observations to be appended to the target database in the server you could skip that whole step if none of those 5 input tables have changed.

Or perhaps you don't have to search for updates on older records so you can drop them from the process early and speed up all of the later steps by having reduced volume.

If the bottle neck is the loading into the SQL server then you might just speed up that process. Look into bulk load options. Loading into a temporary table and then use pass thru code to move the uploaded data into the primary table. Running stats/cleaning on the database table. etc.

Try to find a step that is taking a long time now and ask about ways to improve that.

Re: Updating big dataset

Reeza — Thu, 12 Aug 2021 19:26:28 GMT

600 variables is a lot but 60,000 observations is not. Even put together that's 36,000,000 values which I've processed on a desktop - this isn't big data by any means even if you're working with many small files. I would typically process these sized files in under 20 minutes on a desktop (and that was ten years ago).

Anyways, it seems like you have a very inefficient process, so you should map out your steps in detail, time them and see which ones are leading to the bottleneck and then optimize from there.

Here's some tips and techniques you can employ

https://www.lexjansen.com/scsug/2017/Top-Ten-SAS-Performance-Tuning-Techniques-SCSUG-2017.pdf

Re: Updating big dataset

jimbarbour — Thu, 12 Aug 2021 19:19:10 GMT

Hello, Le,

The first thing I would need is to see the run times for each step in the process. I would need this information for each step:

NOTE: DATA statement used (Total process time):
      real time           0:00:00.21
      cpu time            0:00:00.02
      Timestamp           August 12, 2021 13:50:25

The format might be a little different, but basically I need to know how long each step runs. I would want the log from a successful run. If a given run had problems, the log might be misleading.

The second thing are some design questions:

Can any of the "child" datasets be combined? If you are doing multiple merges, one merge per child data set, then every record in the main dataset must be read multiple times. If there is a way to pre-merge or pre-process the child data sets such that they can be combined and processed as one, that should decrease the run time. Even if only 5 out 27 child datasets were suitable for combination, that would still be worthwhile.
Are there any Select DISTINCTs in your code? Select DISTINCT is typically very costly in terms of time. If we can remove the DISTINCT -- or at least move it to where the majority of the records have been filtered out, then we should be able to realize some performance gains.
How many Sort steps are there?
Are there any Sorts that can be combined or eliminated? Sorting typically takes a long time.
Can you run a PROC OPTIONS OPTION=(Threads CPUcount); RUN; for me? I'd like to see what your settings are.
When you write to the SQL server, how long does that operation normally take? Are you doing a BULKLOAD or are you doing an insert or ?

There are other things that we might want to look at, but those should give us a good start.

Jim

Re: Updating big dataset

ballardw — Thu, 12 Aug 2021 19:35:57 GMT

And show the code for how you "insert dataset into our SQL server".

If your existing records aren't having values changed then you might consider identifying the new records only and appending just those to the SQL.

Re: Updating big dataset

binhle50 — Thu, 12 Aug 2021 19:44:43 GMT

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

Re: Updating big dataset

binhle50 — Thu, 12 Aug 2021 19:54:51 GMT

Thanks again Jim,
I did not use DISTINCTs but a lot of proc sort. Below is actual log of today.
I can't pre-merge any child datasets, each child dataset been updated and inserted new records daily.
I just use an insert to write data to SQL and it usually take around 15 minutes. The big chunk of time is to get that crazy comprehensive dataset. It usually take around 35 to 40 minutes. so the total time is more than 1 hours. I had to create two task schedules to reduce the workload for SAS, the first schedule is to create that dataset and the second schedule is to insert that dataset into SQL.
Below is the atual SAS log of the first part (just to creat the dataset and sent out an email)

NOTE: PROCEDURE PRINTTO used (Total process time):
real time 0.59 seconds
cpu time 0.20 seconds

NOTE: There were 32592 observations read from the data set SQLIMPP.UDC2_FWP_JSON.
NOTE: The data set WORK._JSO has 32592 observations and 241 variables.
NOTE: DATA statement used (Total process time):
real time 2.78 seconds
cpu time 2.74 seconds

NOTE: There were 37803 observations read from the data set SQLIMPP.UDC2_FWP_JSON_Health_Ins.
NOTE: The data set WORK._INS has 37803 observations and 4 variables.
NOTE: DATA statement used (Total process time):
real time 0.20 seconds
cpu time 0.14 seconds

NOTE: There were 18100 observations read from the data set SQLIMPP.UDC2_FWP_JSON_Seg_Doses.
NOTE: The data set WORK._DOS has 18100 observations and 14 variables.
NOTE: DATA statement used (Total process time):
real time 0.18 seconds
cpu time 0.11 seconds

NOTE: There were 17564 observations read from the data set SQLIMPP.UDC2_FWP_JSON_Meds.
NOTE: The data set WORK._MED has 17564 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.15 seconds
cpu time 0.10 seconds

NOTE: There were 101 observations read from the data set SQLIMPP.UDC2_FWP_JSON_ICH.
NOTE: The data set WORK._ICH has 101 observations and 13 variables.
NOTE: DATA statement used (Total process time):
real time 0.12 seconds
cpu time 0.06 seconds

NOTE: There were 6239 observations read from the data set SQLIMPP.UDC2_FWP_JSON_Surgical_Pro.
NOTE: The data set WORK._SUR has 6239 observations and 6 variables.
NOTE: DATA statement used (Total process time):
real time 0.12 seconds
cpu time 0.11 seconds

NOTE: There were 698 observations read from the data set SQLIMPP.UDC2_FWP_JSON_Hep_Vacc.
NOTE: The data set WORK._VAC has 698 observations and 8 variables.
NOTE: DATA statement used (Total process time):
real time 0.09 seconds
cpu time 0.04 seconds

NOTE: There were 32592 observations read from the data set WORK._JSO.
NOTE: The data set WORK._JSO has 32592 observations and 241 variables.
NOTE: DATA statement used (Total process time):
real time 3.31 seconds
cpu time 2.70 seconds

NOTE: There were 37803 observations read from the data set WORK._INS.
NOTE: The data set WORK._INS has 37803 observations and 4 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.15 seconds
cpu time 0.15 seconds

NOTE: There were 37803 observations read from the data set WORK._INS.
NOTE: The data set WORK._INSALL has 32592 observations and 11 variables.
NOTE: PROCEDURE TRANSPOSE used (Total process time):
real time 0.95 seconds
cpu time 0.21 seconds

NOTE: There were 32592 observations read from the data set WORK._INSALL.
NOTE: The data set WORK._INSALL has 32592 observations and 13 variables.
NOTE: DATA statement used (Total process time):
real time 0.87 seconds
cpu time 0.17 seconds

NOTE: PROCEDURE SQL used (Total process time):
real time 0.06 seconds
cpu time 0.06 seconds

NOTE: There were 18100 observations read from the data set WORK._DOS.
NOTE: The data set WORK._JUNK_1 has 17558 observations and 15 variables.
NOTE: DATA statement used (Total process time):
real time 0.23 seconds
cpu time 0.06 seconds

NOTE: There were 17558 observations read from the data set WORK._JUNK_1.
NOTE: The data set WORK._DOS_1 has 17026 observations and 15 variables.
NOTE: The data set WORK._LOOP_1 has 532 observations and 15 variables.
NOTE: DATA statement used (Total process time):
real time 0.34 seconds
cpu time 0.07 seconds

NOTE: There were 532 observations read from the data set WORK._LOOP_1.
NOTE: The data set WORK._DOS_1_2 has 529 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 0.20 seconds
cpu time 0.03 seconds

NOTE: There were 532 observations read from the data set WORK._LOOP_1.
NOTE: The data set WORK._DOS_1_3 has 3 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 0.34 seconds
cpu time 0.01 seconds

NOTE: There were 18100 observations read from the data set WORK._DOS.
NOTE: The data set WORK._JUNK_2 has 518 observations and 15 variables.
NOTE: DATA statement used (Total process time):
real time 0.06 seconds
cpu time 0.06 seconds

NOTE: There were 518 observations read from the data set WORK._JUNK_2.
NOTE: The data set WORK._DOS_2 has 514 observations and 15 variables.
NOTE: The data set WORK._LOOP_2 has 4 observations and 15 variables.
NOTE: DATA statement used (Total process time):
real time 0.31 seconds
cpu time 0.03 seconds

NOTE: There were 4 observations read from the data set WORK._LOOP_2.
NOTE: The data set WORK._DOS_2_2 has 4 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 0.37 seconds
cpu time 0.03 seconds

NOTE: There were 4 observations read from the data set WORK._LOOP_2.
NOTE: The data set WORK._DOS_2_3 has 0 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds

NOTE: There were 18100 observations read from the data set WORK._DOS.
NOTE: The data set WORK._JUNK_3 has 19 observations and 15 variables.
NOTE: DATA statement used (Total process time):
real time 0.13 seconds
cpu time 0.04 seconds

NOTE: There were 19 observations read from the data set WORK._JUNK_3.
NOTE: The data set WORK._DOS_3 has 19 observations and 15 variables.
NOTE: The data set WORK._LOOP_3 has 0 observations and 15 variables.
NOTE: DATA statement used (Total process time):
real time 0.35 seconds
cpu time 0.04 seconds

NOTE: There were 0 observations read from the data set WORK._LOOP_3.
NOTE: The data set WORK._DOS_3_2 has 0 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 0.15 seconds
cpu time 0.03 seconds

NOTE: There were 0 observations read from the data set WORK._LOOP_3.
NOTE: The data set WORK._DOS_3_3 has 0 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 0.17 seconds
cpu time 0.03 seconds

NOTE: There were 18100 observations read from the data set WORK._DOS.
NOTE: The data set WORK._JUNK_4 has 5 observations and 15 variables.
NOTE: DATA statement used (Total process time):
real time 0.07 seconds
cpu time 0.04 seconds

NOTE: There were 5 observations read from the data set WORK._JUNK_4.
NOTE: The data set WORK._DOS_4 has 5 observations and 15 variables.
NOTE: The data set WORK._LOOP_4 has 0 observations and 15 variables.
NOTE: DATA statement used (Total process time):
real time 0.20 seconds
cpu time 0.04 seconds

NOTE: There were 0 observations read from the data set WORK._LOOP_4.
NOTE: The data set WORK._DOS_4_2 has 0 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 0.18 seconds
cpu time 0.03 seconds

NOTE: There were 0 observations read from the data set WORK._LOOP_4.
NOTE: The data set WORK._DOS_4_3 has 0 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 0.04 seconds
cpu time 0.03 seconds

NOTE: Table WORK._DOS_2_3 has been dropped.
NOTE: Table WORK._DOS_3_2 has been dropped.
NOTE: Table WORK._DOS_3_3 has been dropped.
NOTE: Table WORK._DOS_4_2 has been dropped.
NOTE: Table WORK._DOS_4_3 has been dropped.
NOTE: Table WORK._LOOP_3 has been dropped.
NOTE: Table WORK._LOOP_4 has been dropped.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.13 seconds
cpu time 0.09 seconds

NOTE: There were 17026 observations read from the data set WORK._DOS_1.
NOTE: There were 529 observations read from the data set WORK._DOS_1_2.
NOTE: There were 3 observations read from the data set WORK._DOS_1_3.
NOTE: There were 514 observations read from the data set WORK._DOS_2.
NOTE: There were 4 observations read from the data set WORK._DOS_2_2.
NOTE: There were 19 observations read from the data set WORK._DOS_3.
NOTE: There were 5 observations read from the data set WORK._DOS_4.
NOTE: The data set WORK._DOSALL has 17026 observations and 86 variables.
NOTE: DATA statement used (Total process time):
real time 0.26 seconds
cpu time 0.23 seconds

NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

NOTE: There were 17564 observations read from the data set WORK._MED.
NOTE: The data set WORK._MED_1 has 17026 observations and 4 variables.
NOTE: DATA statement used (Total process time):
real time 0.10 seconds
cpu time 0.04 seconds

NOTE: There were 17564 observations read from the data set WORK._MED.
NOTE: The data set WORK._MED_2 has 514 observations and 4 variables.
NOTE: DATA statement used (Total process time):
real time 0.25 seconds
cpu time 0.01 seconds

NOTE: There were 17564 observations read from the data set WORK._MED.
NOTE: The data set WORK._MED_3 has 19 observations and 4 variables.
NOTE: DATA statement used (Total process time):
real time 0.57 seconds
cpu time 0.04 seconds

NOTE: There were 17564 observations read from the data set WORK._MED.
NOTE: The data set WORK._MED_4 has 5 observations and 4 variables.
NOTE: DATA statement used (Total process time):
real time 0.56 seconds
cpu time 0.04 seconds

NOTE: There were 17026 observations read from the data set WORK._MED_1.
NOTE: There were 514 observations read from the data set WORK._MED_2.
NOTE: There were 19 observations read from the data set WORK._MED_3.
NOTE: There were 5 observations read from the data set WORK._MED_4.
NOTE: The data set WORK._MEDALL has 17026 observations and 10 variables.
NOTE: DATA statement used (Total process time):
real time 0.20 seconds
cpu time 0.07 seconds

NOTE: There were 101 observations read from the data set WORK._ICH.
NOTE: The data set WORK._ICH has 101 observations and 13 variables.
NOTE: DATA statement used (Total process time):
real time 0.73 seconds
cpu time 0.06 seconds

NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

NOTE: Variable ich_infu_ft_reason_no_value_1 is uninitialized.
NOTE: There were 101 observations read from the data set WORK._ICH.
NOTE: The data set WORK._ICH_1 has 91 observations and 11 variables.
NOTE: DATA statement used (Total process time):
real time 0.23 seconds
cpu time 0.03 seconds

NOTE: Variable ich_infu_ft_reason_no_value_2 is uninitialized.
NOTE: There were 101 observations read from the data set WORK._ICH.
NOTE: The data set WORK._ICH_2 has 8 observations and 11 variables.
NOTE: DATA statement used (Total process time):
real time 0.34 seconds
cpu time 0.03 seconds

NOTE: Variable ich_infu_ft_reason_no_value_3 is uninitialized.
NOTE: There were 101 observations read from the data set WORK._ICH.
NOTE: The data set WORK._ICH_3 has 2 observations and 11 variables.
NOTE: DATA statement used (Total process time):
real time 0.18 seconds
cpu time 0.03 seconds

NOTE: There were 91 observations read from the data set WORK._ICH_1.
NOTE: There were 8 observations read from the data set WORK._ICH_2.
NOTE: There were 2 observations read from the data set WORK._ICH_3.
NOTE: The data set WORK._ICHALL has 91 observations and 29 variables.
NOTE: DATA statement used (Total process time):
real time 0.12 seconds
cpu time 0.03 seconds

NOTE: PROCEDURE SQL used (Total process time):
real time 0.04 seconds
cpu time 0.04 seconds

NOTE: There were 6239 observations read from the data set WORK._SUR.
NOTE: The data set WORK._SUR_1 has 4499 observations and 7 variables.
NOTE: DATA statement used (Total process time):
real time 0.21 seconds
cpu time 0.06 seconds

NOTE: There were 6239 observations read from the data set WORK._SUR.
NOTE: The data set WORK._SUR_2 has 1078 observations and 7 variables.
NOTE: DATA statement used (Total process time):
real time 0.40 seconds
cpu time 0.06 seconds

NOTE: There were 6239 observations read from the data set WORK._SUR.
NOTE: The data set WORK._SUR_3 has 353 observations and 7 variables.
NOTE: DATA statement used (Total process time):
real time 0.39 seconds
cpu time 0.06 seconds

NOTE: There were 6239 observations read from the data set WORK._SUR.
NOTE: The data set WORK._SUR_4 has 145 observations and 7 variables.
NOTE: DATA statement used (Total process time):
real time 0.60 seconds
cpu time 0.04 seconds

NOTE: There were 6239 observations read from the data set WORK._SUR.
NOTE: The data set WORK._SUR_5 has 70 observations and 7 variables.
NOTE: DATA statement used (Total process time):
real time 0.17 seconds
cpu time 0.04 seconds

NOTE: There were 6239 observations read from the data set WORK._SUR.
NOTE: The data set WORK._SUR_6 has 40 observations and 7 variables.
NOTE: DATA statement used (Total process time):
real time 0.28 seconds
cpu time 0.06 seconds

NOTE: There were 6239 observations read from the data set WORK._SUR.
NOTE: The data set WORK._SUR_7 has 23 observations and 7 variables.
NOTE: DATA statement used (Total process time):
real time 0.21 seconds
cpu time 0.04 seconds

NOTE: There were 6239 observations read from the data set WORK._SUR.
NOTE: The data set WORK._SUR_8 has 17 observations and 7 variables.
NOTE: DATA statement used (Total process time):
real time 0.26 seconds
cpu time 0.04 seconds

NOTE: There were 6239 observations read from the data set WORK._SUR.
NOTE: The data set WORK._SUR_9 has 9 observations and 7 variables.
NOTE: DATA statement used (Total process time):
real time 0.56 seconds
cpu time 0.04 seconds

NOTE: There were 6239 observations read from the data set WORK._SUR.
NOTE: The data set WORK._SUR_10 has 5 observations and 7 variables.
NOTE: DATA statement used (Total process time):
real time 0.35 seconds
cpu time 0.06 seconds

NOTE: There were 4499 observations read from the data set WORK._SUR_1.
NOTE: There were 5 observations read from the data set WORK._SUR_10.
NOTE: There were 1078 observations read from the data set WORK._SUR_2.
NOTE: There were 353 observations read from the data set WORK._SUR_3.
NOTE: There were 145 observations read from the data set WORK._SUR_4.
NOTE: There were 70 observations read from the data set WORK._SUR_5.
NOTE: There were 40 observations read from the data set WORK._SUR_6.
NOTE: There were 23 observations read from the data set WORK._SUR_7.
NOTE: There were 17 observations read from the data set WORK._SUR_8.
NOTE: There were 9 observations read from the data set WORK._SUR_9.
NOTE: The data set WORK._SURALL has 4499 observations and 52 variables.
NOTE: DATA statement used (Total process time):
real time 0.07 seconds
cpu time 0.07 seconds

NOTE: Character values have been converted to numeric values at the places given by:
(Line):(Column).
261:53 261:109 261:156
NOTE: There were 698 observations read from the data set WORK._VAC.
NOTE: The data set WORK._VACAA has 413 observations and 6 variables.
NOTE: The data set WORK._VACBB has 285 observations and 6 variables.
NOTE: DATA statement used (Total process time):
real time 0.04 seconds
cpu time 0.04 seconds

NOTE: There were 413 observations read from the data set WORK._VACAA.
NOTE: The data set WORK._VACA has 413 observations and 6 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds

NOTE: There were 285 observations read from the data set WORK._VACBB.
NOTE: The data set WORK._VACB has 285 observations and 6 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds

NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

NOTE: There were 413 observations read from the data set WORK._VACA.
NOTE: The data set WORK._VAC_A_1 has 409 observations and 6 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds

NOTE: There were 413 observations read from the data set WORK._VACA.
NOTE: The data set WORK._VAC_A_2 has 4 observations and 6 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds

NOTE: There were 285 observations read from the data set WORK._VACB.
NOTE: The data set WORK._VAC_B_1 has 279 observations and 6 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds

NOTE: There were 285 observations read from the data set WORK._VACB.
NOTE: The data set WORK._VAC_B_2 has 5 observations and 6 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds

NOTE: There were 285 observations read from the data set WORK._VACB.
NOTE: The data set WORK._VAC_B_3 has 1 observations and 6 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds

NOTE: There were 409 observations read from the data set WORK._VAC_A_1.
NOTE: There were 4 observations read from the data set WORK._VAC_A_2.
NOTE: There were 279 observations read from the data set WORK._VAC_B_1.
NOTE: There were 5 observations read from the data set WORK._VAC_B_2.
NOTE: There were 1 observations read from the data set WORK._VAC_B_3.
NOTE: The data set WORK._VACALL has 539 observations and 18 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds

NOTE: There were 32592 observations read from the data set WORK._JSO.
NOTE: There were 32592 observations read from the data set WORK._INSALL.
NOTE: There were 17026 observations read from the data set WORK._MEDALL.
NOTE: There were 17026 observations read from the data set WORK._DOSALL.
NOTE: There were 91 observations read from the data set WORK._ICHALL.
NOTE: There were 4499 observations read from the data set WORK._SURALL.
NOTE: There were 539 observations read from the data set WORK._VACALL.
NOTE: The data set WORK.JSONALL has 32592 observations and 417 variables.
NOTE: DATA statement used (Total process time):
real time 4.43 seconds
cpu time 4.12 seconds

Directory

Libref WORK
Engine V9
Physical Name C:\Users\bil7\AppData\Local\Temp\SAS Temporary Files\_TD14916_D347430_
Filename C:\Users\bil7\AppData\Local\Temp\SAS Temporary Files\_TD14916_D347430_

Member
# Name Type File Size Last Modified

1 JSONALL DATA 3GB 08/12/2021 06:30:39
2 _DOS DATA 29MB 08/12/2021 06:30:07
3 _DOSALL DATA 180MB 08/12/2021 06:30:21
4 _DOS_1 DATA 27MB 08/12/2021 06:30:15
5 _DOS_1_2 DATA 1MB 08/12/2021 06:30:16
6 _DOS_1_3 DATA 264KB 08/12/2021 06:30:16
7 _DOS_2 DATA 1MB 08/12/2021 06:30:17
8 _DOS_2_2 DATA 264KB 08/12/2021 06:30:18
9 _DOS_3 DATA 264KB 08/12/2021 06:30:18
10 _DOS_4 DATA 264KB 08/12/2021 06:30:20
11 _ICH DATA 756KB 08/12/2021 06:30:27
12 _ICHALL DATA 288KB 08/12/2021 06:30:29
13 _ICH_1 DATA 128KB 08/12/2021 06:30:28
14 _ICH_2 DATA 128KB 08/12/2021 06:30:29
15 _ICH_3 DATA 128KB 08/12/2021 06:30:29
16 _INS DATA 21MB 08/12/2021 06:30:11
17 _INSALL DATA 29MB 08/12/2021 06:30:13
18 _JSO DATA 2GB 08/12/2021 06:30:10
19 _JUNK_1 DATA 28MB 08/12/2021 06:30:14
20 _JUNK_2 DATA 1MB 08/12/2021 06:30:17
21 _JUNK_3 DATA 264KB 08/12/2021 06:30:18
22 _JUNK_4 DATA 264KB 08/12/2021 06:30:19
23 _LOOP_1 DATA 1MB 08/12/2021 06:30:15
24 _LOOP_2 DATA 264KB 08/12/2021 06:30:17
25 _MED DATA 10MB 08/12/2021 06:30:07
26 _MEDALL DATA 5MB 08/12/2021 06:30:25
27 _MED_1 DATA 2MB 08/12/2021 06:30:22
28 _MED_2 DATA 192KB 08/12/2021 06:30:22
29 _MED_3 DATA 128KB 08/12/2021 06:30:23
30 _MED_4 DATA 128KB 08/12/2021 06:30:24
31 _SUR DATA 19MB 08/12/2021 06:30:07
32 _SURALL DATA 11MB 08/12/2021 06:30:35
33 _SUR_1 DATA 1MB 08/12/2021 06:30:30
34 _SUR_10 DATA 128KB 08/12/2021 06:30:35
35 _SUR_2 DATA 448KB 08/12/2021 06:30:30
36 _SUR_3 DATA 192KB 08/12/2021 06:30:31
37 _SUR_4 DATA 128KB 08/12/2021 06:30:32
38 _SUR_5 DATA 128KB 08/12/2021 06:30:32
39 _SUR_6 DATA 128KB 08/12/2021 06:30:33
40 _SUR_7 DATA 128KB 08/12/2021 06:30:33
41 _SUR_8 DATA 128KB 08/12/2021 06:30:33
42 _SUR_9 DATA 128KB 08/12/2021 06:30:34
43 _VAC DATA 576KB 08/12/2021 06:30:07
44 _VACA DATA 384KB 08/12/2021 06:30:35
45 _VACAA DATA 384KB 08/12/2021 06:30:35
46 _VACALL DATA 384KB 08/12/2021 06:30:35
47 _VACB DATA 320KB 08/12/2021 06:30:35
48 _VACBB DATA 320KB 08/12/2021 06:30:35
49 _VAC_A_1 DATA 192KB 08/12/2021 06:30:35
50 _VAC_A_2 DATA 128KB 08/12/2021 06:30:35
51 _VAC_B_1 DATA 128KB 08/12/2021 06:30:35
52 _VAC_B_2 DATA 128KB 08/12/2021 06:30:35
53 _VAC_B_3 DATA 128KB 08/12/2021 06:30:35

NOTE: MODIFY was successful for WORK.JSONALL.DATA.

NOTE: PROCEDURE DATASETS used (Total process time):
real time 1.35 seconds
cpu time 0.07 seconds

NOTE: Deleting WORK._DOS (memtype=DATA).
NOTE: Deleting WORK._DOSALL (memtype=DATA).
NOTE: Deleting WORK._DOS_1 (memtype=DATA).
NOTE: Deleting WORK._DOS_1_2 (memtype=DATA).
NOTE: Deleting WORK._DOS_1_3 (memtype=DATA).
NOTE: Deleting WORK._DOS_2 (memtype=DATA).
NOTE: Deleting WORK._DOS_2_2 (memtype=DATA).
NOTE: Deleting WORK._DOS_3 (memtype=DATA).
NOTE: Deleting WORK._DOS_4 (memtype=DATA).
NOTE: Deleting WORK._ICH (memtype=DATA).
NOTE: Deleting WORK._ICHALL (memtype=DATA).
NOTE: Deleting WORK._ICH_1 (memtype=DATA).
NOTE: Deleting WORK._ICH_2 (memtype=DATA).
NOTE: Deleting WORK._ICH_3 (memtype=DATA).
NOTE: Deleting WORK._INS (memtype=DATA).
NOTE: Deleting WORK._INSALL (memtype=DATA).
NOTE: Deleting WORK._JSO (memtype=DATA).
NOTE: Deleting WORK._JUNK_1 (memtype=DATA).
NOTE: Deleting WORK._JUNK_2 (memtype=DATA).
NOTE: Deleting WORK._JUNK_3 (memtype=DATA).
NOTE: Deleting WORK._JUNK_4 (memtype=DATA).
NOTE: Deleting WORK._LOOP_1 (memtype=DATA).
NOTE: Deleting WORK._LOOP_2 (memtype=DATA).
NOTE: Deleting WORK._MED (memtype=DATA).
NOTE: Deleting WORK._MEDALL (memtype=DATA).
NOTE: Deleting WORK._MED_1 (memtype=DATA).
NOTE: Deleting WORK._MED_2 (memtype=DATA).
NOTE: Deleting WORK._MED_3 (memtype=DATA).
NOTE: Deleting WORK._MED_4 (memtype=DATA).
NOTE: Deleting WORK._SUR (memtype=DATA).
NOTE: Deleting WORK._SURALL (memtype=DATA).
NOTE: Deleting WORK._SUR_1 (memtype=DATA).
NOTE: Deleting WORK._SUR_10 (memtype=DATA).
NOTE: Deleting WORK._SUR_2 (memtype=DATA).
NOTE: Deleting WORK._SUR_3 (memtype=DATA).
NOTE: Deleting WORK._SUR_4 (memtype=DATA).
NOTE: Deleting WORK._SUR_5 (memtype=DATA).
NOTE: Deleting WORK._SUR_6 (memtype=DATA).
NOTE: Deleting WORK._SUR_7 (memtype=DATA).
NOTE: Deleting WORK._SUR_8 (memtype=DATA).
NOTE: Deleting WORK._SUR_9 (memtype=DATA).
NOTE: Deleting WORK._VAC (memtype=DATA).
NOTE: Deleting WORK._VACA (memtype=DATA).
NOTE: Deleting WORK._VACAA (memtype=DATA).
NOTE: Deleting WORK._VACALL (memtype=DATA).
NOTE: Deleting WORK._VACB (memtype=DATA).
NOTE: Deleting WORK._VACBB (memtype=DATA).
NOTE: Deleting WORK._VAC_A_1 (memtype=DATA).
NOTE: Deleting WORK._VAC_A_2 (memtype=DATA).
NOTE: Deleting WORK._VAC_B_1 (memtype=DATA).
NOTE: Deleting WORK._VAC_B_2 (memtype=DATA).
NOTE: Deleting WORK._VAC_B_3 (memtype=DATA).
NOTE: PROCEDURE DATASETS used (Total process time):
real time 1.09 seconds
cpu time 0.50 seconds

NOTE: Character values have been converted to numeric values at the places given by:
(Line):(Column).
367:54 367:110 367:157 368:53 368:109 368:156 369:53 369:109 369:156
371:54 371:110 371:157 372:53 372:109 372:156 373:53 373:109 373:156
375:54 375:110 375:157 376:53 376:109 376:156 378:23 379:25 380:24
381:53 381:109 381:156 398:14 399:14 400:14 401:14 450:52
NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
32458 at 378:43 32434 at 379:47 32425 at 380:45
NOTE: There were 32592 observations read from the data set WORK.JSONALL.
NOTE: The data set WORK._JSONALL_PREFINAL has 32592 observations and 830 variables.
NOTE: DATA statement used (Total process time):
real time 9.09 seconds
cpu time 8.10 seconds

NOTE: WORK._MAP data set was successfully created.
NOTE: The data set WORK._MAP has 613 observations and 1 variables.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 1.62 seconds
cpu time 0.70 seconds

The SAS System 06:30 Thursday, August 12, 2021 1

var_name
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
id
subject_id
_date_of_visit
SubjectId_Latest
htc_id
is_update
_date_submitted
date_submitted
DateEntered
submitted_by
LastUpdated
UpdatedBy
Version
_udc_last_visit_date
weight_date
height
height_unknown
height_date
weight
weight_unknown
most_rece_inhi_draw_date
zipcode
patient_highest_edu_level
patient_grade_level
patient_employment_status
congenital_bleed_disor_his
specific_genetic_mutation
_combine_htc_service
inhi_hemlibra_use
inhi_cba_date
_inhi_cba_date_qual
_inhi_cba_titr_combine
inhi_cba_titr_neg
inhi_nba_date
_inhi_nba_date_qual
_inhi_nba_titr_combine
inhi_nba_titr_neg
most_rece_inhi_date_type
_combine_inhi_mostrcnt
most_rece_inhi_result_not_avai
most_rece_inhi_below_value
_combine_highest_historic_inh
pat_iti_his
_combine_day_miss_school
pat_iti_his_high_his_inhi
pat_iti_his_high_his_inhi_unk
his_immune_modulation_therapy
_combine_bleeding_tx_product
current_treatment_regimen
clot_fact_con
clot_fact_con_date_age_unk
The SAS System 06:30 Thursday, August 12, 2021 2

var_name
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
clot_fact_con_date_qualifier
clot_fact_con_date
joint_bleed_history
percent_of_doses
_combine_tx_used_ludc
tma_ludc
_tma_ludc
allergic_reaction
_combine_algic_med_name
cvad
cvad_last_udc_visit
cvad_compl_last_udc
_combine_cvad_compl
ich_history
history_of_joint_bleeds
age_date_unknown
date_first_joint_bleed_qual
date_first_joint_bleed
number_ble_ankle_left
number_ble_ankle_right
_combine_joint_ble_ankle_cat
number_ble_elbow_left
number_ble_elbow_right
_combine_joint_ble_elbow_cat
number_ble_hip_left
number_ble_hip_right
_combine_joint_ble_hip_cat
number_ble_knee_left
number_ble_knee_right
_combine_joint_ble_knee_cat
number_ble_shoulder_left
number_ble_shoulder_right
_combine_joint_ble_shoulder_cat
_joint_ble_left_ankle_ludc
_joint_ble_right_ankle_ludc
_joint_ble_ankle_ludc_sum
_joint_ble_left_elbow_ludc
_joint_ble_right_elbow_ludc
_joint_ble_elbow_ludc_sum
_joint_ble_left_hip_ludc
_joint_ble_right_hip_ludc
_joint_ble_hip_ludc_sum
_joint_ble_left_knee_ludc
_joint_ble_right_knee_ludc
_joint_ble_knee_ludc_sum
_joint_ble_left_shoulder_ludc
_joint_ble_right_shoulder_ludc
_joint_ble_shoulder_ludc_sum
number_treat_ble_event
other_bleeds
gastr
The SAS System 06:30 Thursday, August 12, 2021 3

var_name
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
_combine_gastro_methd
geni_hema
_combine_genit_hemat_methd
geni_oth
_combine_genit_othr_methd
head_extr
_combine_head_extrcl
muscle
_combine_muscl_methd
nasal_muco
_combine_nas_mucsa_methd
oral
_combine_oral_methd
other
_combine_oth_methd
soft_tiss
_combine_sft_tisue_methd
spine
_combine_spine_methd
his_invasive_joint_proc
_combine_synove_arthr_joi
_combine_synove_open_joi
_combine_synove_radio_joi
_combine_synove_unkn_joi
_combine_rplcm_arthr_joi
_combine_surgcl_arthr_joi
_combine_othr_inva_proc_joi
pain_loss_motion_weakness
ble_dis_chro_pain_12_mon
ble_dis_chro_pain_12_mon_freq
opioids_12_mon
opioids_12_mon_freq
er_visit_12_mon
er_visit_12_mon_freq
inpat_adm
inpat_adm_occur
inpat_adm_night
hep_a_vaccination
hep_b_vaccination
circum
circum_clot_factor_concent
circum_exce_bleed
iron_replacement
menstrual_bleeding
hysterectomy
hysterectomy_date
hysterectomy_date_qualifier
hcc
leukemia
other_cancer
fracture
The SAS System 06:30 Thursday, August 12, 2021 4

var_name
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
ostopenia
osteoporosis
acute_ischemic_stroke
atrial_fibrilation
coronary_artery_disease
congestive_heart_failure
myocardial_infarction
transient_ischemic_attach
chronic_kidney_disease
kidney_stones
nephrotic_syndrome
ascites
cirrhosis
hepatic_fibrosis
splenoomegaly
varices
deep_vein_thrombosis
pulmonary_embolisim
anxiety
depression
diabetes_melitus
hypertension
iron_deficiency_anemia
pseudotumor
coronary_artery_angioplasty
coronary_artery_stent_place
coronary_artery_bypass_graft
dialysis_peritoneal
dialysis_hemodialysis
heart_valve_replacement
heart_valve_repair
kidney_transplant
liver_transplant
peripheral_revascularization
surg_12_mon
FileName
DateImp
Deleted
DeletedComments
ins_commercial_ins
ins_military_health
ins_medicaid
ins_medicare
ins_state_programs
ins_indian_health
ins_other
ins_uninsured
ins_unknown
ins_support_programs
_combine_insur_primary
_combine_insur_type
The SAS System 06:30 Thursday, August 12, 2021 5

var_name
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
cur_clot_ft_med_1
cur_clot_ft_med_2
cur_clot_ft_med_3
cur_clot_ft_med_4
cur_clot_ft_med_5
cur_clot_ft_med_6
cur_clot_ft_med_7
cur_clot_ft_med_8
cur_clot_ft_med_9
cur_clot_ft_med_10
cur_clot_ft_med_1_ds_1_inst
cur_clot_ft_med_1_ds_1_int_val
cur_clot_ft_med_1_ds_1_int_ter
cur_clot_ft_med_1_ds_1_repet
cur_clot_ft_med_1_ds_1_pri_reg
cur_clot_ft_med_1_ds_1_range
cur_clot_ft_med_1_ds_1_max
cur_clot_ft_med_1_ds_1_min
cur_clot_ft_med_1_ds_1_type
cur_clot_ft_med_1_ds_1_units
cur_clot_ft_med_1_ds_1_value
cur_clot_ft_med_1_ds_2_inst
cur_clot_ft_med_1_ds_2_int_val
cur_clot_ft_med_1_ds_2_int_ter
cur_clot_ft_med_1_ds_2_repet
cur_clot_ft_med_1_ds_2_pri_reg
cur_clot_ft_med_1_ds_2_range
cur_clot_ft_med_1_ds_2_max
cur_clot_ft_med_1_ds_2_min
cur_clot_ft_med_1_ds_2_type
cur_clot_ft_med_1_ds_2_units
cur_clot_ft_med_1_ds_2_value
cur_clot_ft_med_2_ds_1_inst
cur_clot_ft_med_2_ds_1_int_val
cur_clot_ft_med_2_ds_1_int_ter
cur_clot_ft_med_2_ds_1_repet
cur_clot_ft_med_2_ds_1_pri_reg
cur_clot_ft_med_2_ds_1_range
cur_clot_ft_med_2_ds_1_max
cur_clot_ft_med_2_ds_1_min
cur_clot_ft_med_2_ds_1_type
cur_clot_ft_med_2_ds_1_units
cur_clot_ft_med_2_ds_1_value
cur_clot_ft_med_2_ds_2_inst
cur_clot_ft_med_2_ds_2_int_val
cur_clot_ft_med_2_ds_2_int_ter
cur_clot_ft_med_2_ds_2_repet
cur_clot_ft_med_2_ds_2_pri_reg
cur_clot_ft_med_2_ds_2_range
cur_clot_ft_med_2_ds_2_max
cur_clot_ft_med_2_ds_2_min
The SAS System 06:30 Thursday, August 12, 2021 6

var_name
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
cur_clot_ft_med_2_ds_2_type
cur_clot_ft_med_2_ds_2_units
cur_clot_ft_med_2_ds_2_value
cur_clot_ft_med_3_ds_1_inst
cur_clot_ft_med_3_ds_1_int_val
cur_clot_ft_med_3_ds_1_int_ter
cur_clot_ft_med_3_ds_1_repet
cur_clot_ft_med_3_ds_1_pri_reg
cur_clot_ft_med_3_ds_1_range
cur_clot_ft_med_3_ds_1_max
cur_clot_ft_med_3_ds_1_min
cur_clot_ft_med_3_ds_1_type
cur_clot_ft_med_3_ds_1_units
cur_clot_ft_med_3_ds_1_value
cur_clot_ft_med_3_ds_2_inst
cur_clot_ft_med_3_ds_2_int_val
cur_clot_ft_med_3_ds_2_int_ter
cur_clot_ft_med_3_ds_2_repet
cur_clot_ft_med_3_ds_2_pri_reg
cur_clot_ft_med_3_ds_2_range
cur_clot_ft_med_3_ds_2_max
cur_clot_ft_med_3_ds_2_min
cur_clot_ft_med_3_ds_2_type
cur_clot_ft_med_3_ds_2_units
cur_clot_ft_med_3_ds_2_value
cur_clot_ft_med_4_ds_1_inst
cur_clot_ft_med_4_ds_1_int_val
cur_clot_ft_med_4_ds_1_int_ter
cur_clot_ft_med_4_ds_1_repet
cur_clot_ft_med_4_ds_1_pri_reg
cur_clot_ft_med_4_ds_1_range
cur_clot_ft_med_4_ds_1_max
cur_clot_ft_med_4_ds_1_min
cur_clot_ft_med_4_ds_1_type
cur_clot_ft_med_4_ds_1_units
cur_clot_ft_med_4_ds_1_value
cur_clot_ft_med_4_ds_2_inst
cur_clot_ft_med_4_ds_2_int_val
cur_clot_ft_med_4_ds_2_int_ter
cur_clot_ft_med_4_ds_2_repet
cur_clot_ft_med_4_ds_2_pri_reg
cur_clot_ft_med_4_ds_2_range
cur_clot_ft_med_4_ds_2_max
cur_clot_ft_med_4_ds_2_min
cur_clot_ft_med_4_ds_2_type
cur_clot_ft_med_4_ds_2_units
cur_clot_ft_med_4_ds_2_value
cur_clot_ft_med_5_ds_1_inst
cur_clot_ft_med_5_ds_1_int_val
cur_clot_ft_med_5_ds_1_int_ter
cur_clot_ft_med_5_ds_1_repet
The SAS System 06:30 Thursday, August 12, 2021 7

var_name
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
cur_clot_ft_med_5_ds_1_pri_reg
cur_clot_ft_med_5_ds_1_range
cur_clot_ft_med_5_ds_1_max
cur_clot_ft_med_5_ds_1_min
cur_clot_ft_med_5_ds_1_type
cur_clot_ft_med_5_ds_1_units
cur_clot_ft_med_5_ds_1_value
cur_clot_ft_med_5_ds_2_inst
cur_clot_ft_med_5_ds_2_int_val
cur_clot_ft_med_5_ds_2_int_ter
cur_clot_ft_med_5_ds_2_repet
cur_clot_ft_med_5_ds_2_pri_reg
cur_clot_ft_med_5_ds_2_range
cur_clot_ft_med_5_ds_2_max
cur_clot_ft_med_5_ds_2_min
cur_clot_ft_med_5_ds_2_type
cur_clot_ft_med_5_ds_2_units
cur_clot_ft_med_5_ds_2_value
cur_clot_ft_med_6_ds_1_inst
cur_clot_ft_med_6_ds_1_int_val
cur_clot_ft_med_6_ds_1_int_ter
cur_clot_ft_med_6_ds_1_repet
cur_clot_ft_med_6_ds_1_pri_reg
cur_clot_ft_med_6_ds_1_range
cur_clot_ft_med_6_ds_1_max
cur_clot_ft_med_6_ds_1_min
cur_clot_ft_med_6_ds_1_type
cur_clot_ft_med_6_ds_1_units
cur_clot_ft_med_6_ds_1_value
cur_clot_ft_med_6_ds_2_inst
cur_clot_ft_med_6_ds_2_int_val
cur_clot_ft_med_6_ds_2_int_ter
cur_clot_ft_med_6_ds_2_repet
cur_clot_ft_med_6_ds_2_pri_reg
cur_clot_ft_med_6_ds_2_range
cur_clot_ft_med_6_ds_2_max
cur_clot_ft_med_6_ds_2_min
cur_clot_ft_med_6_ds_2_type
cur_clot_ft_med_6_ds_2_units
cur_clot_ft_med_6_ds_2_value
cur_clot_ft_med_7_ds_1_inst
cur_clot_ft_med_7_ds_1_int_val
cur_clot_ft_med_7_ds_1_int_ter
cur_clot_ft_med_7_ds_1_repet
cur_clot_ft_med_7_ds_1_pri_reg
cur_clot_ft_med_7_ds_1_range
cur_clot_ft_med_7_ds_1_max
cur_clot_ft_med_7_ds_1_min
cur_clot_ft_med_7_ds_1_type
cur_clot_ft_med_7_ds_1_units
cur_clot_ft_med_7_ds_1_value
The SAS System 06:30 Thursday, August 12, 2021 8

var_name
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
cur_clot_ft_med_7_ds_2_inst
cur_clot_ft_med_7_ds_2_int_val
cur_clot_ft_med_7_ds_2_int_ter
cur_clot_ft_med_7_ds_2_repet
cur_clot_ft_med_7_ds_2_pri_reg
cur_clot_ft_med_7_ds_2_range
cur_clot_ft_med_7_ds_2_max
cur_clot_ft_med_7_ds_2_min
cur_clot_ft_med_7_ds_2_type
cur_clot_ft_med_7_ds_2_units
cur_clot_ft_med_7_ds_2_value
cur_clot_ft_med_8_ds_1_inst
cur_clot_ft_med_8_ds_1_int_val
cur_clot_ft_med_8_ds_1_int_ter
cur_clot_ft_med_8_ds_1_repet
cur_clot_ft_med_8_ds_1_pri_reg
cur_clot_ft_med_8_ds_1_range
cur_clot_ft_med_8_ds_1_max
cur_clot_ft_med_8_ds_1_min
cur_clot_ft_med_8_ds_1_type
cur_clot_ft_med_8_ds_1_units
cur_clot_ft_med_8_ds_1_value
cur_clot_ft_med_8_ds_2_inst
cur_clot_ft_med_8_ds_2_int_val
cur_clot_ft_med_8_ds_2_int_ter
cur_clot_ft_med_8_ds_2_repet
cur_clot_ft_med_8_ds_2_pri_reg
cur_clot_ft_med_8_ds_2_range
cur_clot_ft_med_8_ds_2_max
cur_clot_ft_med_8_ds_2_min
cur_clot_ft_med_8_ds_2_type
cur_clot_ft_med_8_ds_2_units
cur_clot_ft_med_8_ds_2_value
cur_clot_ft_med_9_ds_1_inst
cur_clot_ft_med_9_ds_1_int_val
cur_clot_ft_med_9_ds_1_int_ter
cur_clot_ft_med_9_ds_1_repet
cur_clot_ft_med_9_ds_1_pri_reg
cur_clot_ft_med_9_ds_1_range
cur_clot_ft_med_9_ds_1_max
cur_clot_ft_med_9_ds_1_min
cur_clot_ft_med_9_ds_1_type
cur_clot_ft_med_9_ds_1_units
cur_clot_ft_med_9_ds_1_value
cur_clot_ft_med_9_ds_2_inst
cur_clot_ft_med_9_ds_2_int_val
cur_clot_ft_med_9_ds_2_int_ter
cur_clot_ft_med_9_ds_2_repet
cur_clot_ft_med_9_ds_2_pri_reg
cur_clot_ft_med_9_ds_2_range
cur_clot_ft_med_9_ds_2_max
The SAS System 06:30 Thursday, August 12, 2021 9

var_name
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
cur_clot_ft_med_9_ds_2_min
cur_clot_ft_med_9_ds_2_type
cur_clot_ft_med_9_ds_2_units
cur_clot_ft_med_9_ds_2_value
cur_clot_ft_med_10_ds_1_inst
cur_clot_ft_med_10_ds_1_int_val
cur_clot_ft_med_10_ds_1_int_ter
cur_clot_ft_med_10_ds_1_repet
cur_clot_ft_med_10_ds_1_pri_reg
cur_clot_ft_med_10_ds_1_range
cur_clot_ft_med_10_ds_1_max
cur_clot_ft_med_10_ds_1_min
cur_clot_ft_med_10_ds_1_type
cur_clot_ft_med_10_ds_1_units
cur_clot_ft_med_10_ds_1_value
cur_clot_ft_med_10_ds_2_inst
cur_clot_ft_med_10_ds_2_int_val
cur_clot_ft_med_10_ds_2_int_ter
cur_clot_ft_med_10_ds_2_repet
cur_clot_ft_med_10_ds_2_pri_reg
cur_clot_ft_med_10_ds_2_range
cur_clot_ft_med_10_ds_2_max
cur_clot_ft_med_10_ds_2_min
cur_clot_ft_med_10_ds_2_type
cur_clot_ft_med_10_ds_2_units
cur_clot_ft_med_10_ds_2_value
_combine_cur_clot_fac_med
_combine_cur_clot_fac_med_fi1
_combine_cur_clot_fac_med_fiv1
_combine_cur_clot_fac_med_fit1
_combine_cur_clot_fac_med_fr1
_combine_cur_clot_pri_reg1
_combine_cur_clot_fac_med_r1
_combine_cur_clot_fac_med_dmx1
_combine_cur_clot_fac_med_dm1
_combine_cur_clot_fac_med_type1
_combine_cur_clot_fac_med_du1
_combine_cur_clot_fac_med_da1
_combine_cur_clot_fac_med_fi2
_combine_cur_clot_fac_med_fiv2
_combine_cur_clot_fac_med_fit2
_combine_cur_clot_fac_med_fr2
_combine_cur_clot_pri_reg2
_combine_cur_clot_fac_med_r2
_combine_cur_clot_fac_med_dmx2
_combine_cur_clot_fac_med_dm2
_combine_cur_clot_fac_med_type2
_combine_cur_clot_fac_med_du2
_combine_cur_clot_fac_med_da2
_combine_cur_clot_fac_med_fi
_combine_cur_clot_fac_med_fiv
The SAS System 06:30 Thursday, August 12, 2021 10

var_name
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
_combine_cur_clot_fac_med_fit
_combine_cur_clot_fac_med_fr
_combine_cur_clot_pri_reg
_combine_cur_clot_fac_med_r
_combine_cur_clot_fac_med_dmx
_combine_cur_clot_fac_med_dm
_combine_cur_clot_fac_med_type
_combine_cur_clot_fac_med_du
_combine_cur_clot_fac_med_da
ich_date_1
ich_anatomical_loca_1
ich_date_qualifier_1
ich_prec_head_trauma_1
ich_conti_prophy_1
ich_infu_ft_giv_1
ich_infu_ft_giv_period_1
ich_date_2
ich_anatomical_loca_2
ich_date_qualifier_2
ich_prec_head_trauma_2
ich_conti_prophy_2
ich_infu_ft_giv_2
ich_infu_ft_giv_period_2
ich_date_3
ich_anatomical_loca_3
ich_date_qualifier_3
ich_prec_head_trauma_3
ich_conti_prophy_3
ich_infu_ft_giv_3
ich_infu_ft_giv_period_3
ich_date_4
ich_anatomical_loca_4
ich_date_qualifier_4
ich_prec_head_trauma_4
ich_conti_prophy_4
ich_infu_ft_giv_4
ich_infu_ft_giv_period_4
ich_date_5
ich_anatomical_loca_5
ich_date_qualifier_5
ich_prec_head_trauma_5
ich_conti_prophy_5
ich_infu_ft_giv_5
ich_infu_ft_giv_period_5
ich_date_6
ich_anatomical_loca_6
ich_date_qualifier_6
ich_prec_head_trauma_6
ich_conti_prophy_6
ich_infu_ft_giv_6
ich_infu_ft_giv_period_6
The SAS System 06:30 Thursday, August 12, 2021 11

var_name
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
ich_date_7
ich_anatomical_loca_7
ich_date_qualifier_7
ich_prec_head_trauma_7
ich_conti_prophy_7
ich_infu_ft_giv_7
ich_infu_ft_giv_period_7
ich_date_8
ich_anatomical_loca_8
ich_date_qualifier_8
ich_prec_head_trauma_8
ich_conti_prophy_8
ich_infu_ft_giv_8
ich_infu_ft_giv_period_8
ich_date_9
ich_anatomical_loca_9
ich_date_qualifier_9
ich_prec_head_trauma_9
ich_conti_prophy_9
ich_infu_ft_giv_9
ich_infu_ft_giv_period_9
ich_date_10
ich_anatomical_loca_10
ich_date_qualifier_10
ich_prec_head_trauma_10
ich_conti_prophy_10
ich_infu_ft_giv_10
ich_infu_ft_giv_period_10
_combine_anato_locat
_combine_ich_DiagDate
_combine_ich_DiagDateDetail
_combine_Head_Trauma
_combine_ICH_Prophy
_combine_Infusion_Factor
_combine_Infusion_Factor_Detail
surg_12_mon_date_1
surg_12_mon_date_qual_1
surg_12_mon_proc_1
surg_12_mon_anato_loca_1
surg_12_mon_date_2
surg_12_mon_date_qual_2
surg_12_mon_proc_2
surg_12_mon_anato_loca_2
surg_12_mon_date_3
surg_12_mon_date_qual_3
surg_12_mon_proc_3
surg_12_mon_anato_loca_3
surg_12_mon_date_4
surg_12_mon_date_qual_4
surg_12_mon_proc_4
surg_12_mon_anato_loca_4
The SAS System 06:30 Thursday, August 12, 2021 12

var_name
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
surg_12_mon_date_5
surg_12_mon_date_qual_5
surg_12_mon_proc_5
surg_12_mon_anato_loca_5
surg_12_mon_date_6
surg_12_mon_date_qual_6
surg_12_mon_proc_6
surg_12_mon_anato_loca_6
surg_12_mon_date_7
surg_12_mon_date_qual_7
surg_12_mon_proc_7
surg_12_mon_anato_loca_7
surg_12_mon_date_8
surg_12_mon_date_qual_8
surg_12_mon_proc_8
surg_12_mon_anato_loca_8
surg_12_mon_date_9
surg_12_mon_date_qual_9
surg_12_mon_proc_9
surg_12_mon_anato_loca_9
surg_12_mon_date_10
surg_12_mon_date_qual_10
surg_12_mon_proc_10
surg_12_mon_anato_loca_10
surg_12_mon_date_11
surg_12_mon_date_qual_11
surg_12_mon_proc_11
surg_12_mon_anato_loca_11
surg_12_mon_date_12
surg_12_mon_date_qual_12
surg_12_mon_proc_12
surg_12_mon_anato_loca_12
surg_12_mon_date_13
surg_12_mon_date_qual_13
surg_12_mon_proc_13
surg_12_mon_anato_loca_13
surg_12_mon_date_14
surg_12_mon_date_qual_14
surg_12_mon_proc_14
surg_12_mon_anato_loca_14
surg_12_mon_date_15
surg_12_mon_date_qual_15
surg_12_mon_proc_15
surg_12_mon_anato_loca_15
_combine_surgical_prolist
_combine_surgical_prolist_date
_combine_sur_prolist_date_qual
_combine_sur_anato_loca
hep_a_vaccinationa
hep_a_vaccination_status
hep_b_vaccinationa
The SAS System 06:30 Thursday, August 12, 2021 13

var_name
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
hep_b_vaccination_status
NOTE: PROCEDURE SQL used (Total process time):
real time 1.17 seconds
cpu time 0.06 seconds

NOTE: Character values have been converted to numeric values at the places given by:
(Line):(Column).
676:53 676:109 676:156
NOTE: There were 32592 observations read from the data set WORK._JSONALL_PREFINAL.
NOTE: The data set WORK.SE has 32592 observations and 614 variables.
NOTE: DATA statement used (Total process time):
real time 33.33 seconds
cpu time 9.46 seconds

NOTE: There were 32592 observations read from the data set WORK.SE.
NOTE: The data set WORK.SE has 32592 observations and 614 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 1:46.18
cpu time 17.03 seconds

NOTE: Deleting WORK._JSONALL_PREFINAL (memtype=DATA).
NOTE: Deleting WORK._MAP (memtype=DATA).
NOTE: Deleting WORK.JSONALL (memtype=DATA).
NOTE: PROCEDURE DATASETS used (Total process time):
real time 1.62 seconds
cpu time 1.14 seconds

NOTE: There were 16649 observations read from the data set SQLIMPP.registry_initial.
NOTE: There were 16649 observations read from the data set SQLIMPP.registry_initial1.
NOTE: The data set WORK._EF has 16649 observations and 1389 variables.
NOTE: DATA statement used (Total process time):
real time 3.81 seconds
cpu time 3.28 seconds

Directory

Libref WORK
Engine V9
Physical Name C:\Users\bil7\AppData\Local\Temp\SAS Temporary Files\_TD14916_D347430_
Filename C:\Users\bil7\AppData\Local\Temp\SAS Temporary Files\_TD14916_D347430_

Member
# Name Type File Size Last Modified

1 SE DATA 3GB 08/12/2021 06:33:18
2 _EF DATA 441MB 08/12/2021 06:33:25

NOTE: MODIFY was successful for WORK._EF.DATA.

NOTE: PROCEDURE DATASETS used (Total process time):
real time 1.23 seconds
cpu time 0.06 seconds

NOTE: The data set WORK._VAR_EF has 1389 observations and 2 variables.
NOTE: PROCEDURE CONTENTS used (Total process time):
real time 0.56 seconds
cpu time 0.03 seconds

NOTE: Numeric values have been converted to character values at the places given by:
(Line):(Column).
765:32 766:22
NOTE: There were 1389 observations read from the data set WORK._VAR_EF.
NOTE: The data set WORK._VAR_EF has 1389 observations and 4 variables.
NOTE: DATA statement used (Total process time):
real time 0.54 seconds
cpu time 0.03 seconds

NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

NOTE: There were 16649 observations read from the data set WORK._EF.
NOTE: The data set WORK._EF2 has 16649 observations and 1389 variables.
NOTE: DATA statement used (Total process time):
real time 1.17 seconds
cpu time 0.78 seconds

NOTE: Character values have been converted to numeric values at the places given by:
(Line):(Column).
1117:1 1117:1 1117:1 1118:1 1118:1 1118:1 1119:1 1119:1
1119:1 1184:1 1188:89 1188:119 1197:1 1201:89 1201:119 1211:1
1215:89 1215:119 1247:52 1255:1 1255:1 1255:1 1401:4 1473:4
1473:48
NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
15192 at 1255:120 7451 at 1401:49
NOTE: There were 16649 observations read from the data set WORK._EF2.
NOTE: The data set WORK._EF_C has 16649 observations and 1531 variables.
NOTE: DATA statement used (Total process time):
real time 3.95 seconds
cpu time 2.54 seconds

NOTE: There were 16649 observations read from the data set WORK._EF_C.
NOTE: The data set WORK._EF_MAP has 16649 observations and 1532 variables.
NOTE: DATA statement used (Total process time):
real time 2.15 seconds
cpu time 1.32 seconds

NOTE: There were 16649 observations read from the data set WORK._EF_MAP.
NOTE: The data set WORK._EF_MAP has 16649 observations and 1532 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 4.40 seconds
cpu time 2.45 seconds

WARNING: Multiple lengths were specified for the variable _combine_htc_service by input data
set(s). This can cause truncation of data.
WARNING: Multiple lengths were specified for the variable inhi_cba_date by input data set(s).
This can cause truncation of data.
WARNING: Multiple lengths were specified for the variable inhi_nba_date by input data set(s).
This can cause truncation of data.
WARNING: Multiple lengths were specified for the variable _combine_algic_med_name by input data
set(s). This can cause truncation of data.
WARNING: Multiple lengths were specified for the variable _combine_cvad_compl by input data
set(s). This can cause truncation of data.
WARNING: Multiple lengths were specified for the variable other_bleeds by input data set(s).
This can cause truncation of data.
WARNING: Multiple lengths were specified for the variable gastr by input data set(s). This can
cause truncation of data.
WARNING: Multiple lengths were specified for the variable geni_hema by input data set(s). This
can cause truncation of data.
WARNING: Multiple lengths were specified for the variable geni_oth by input data set(s). This
can cause truncation of data.
WARNING: Multiple lengths were specified for the variable head_extr by input data set(s). This
can cause truncation of data.
WARNING: Multiple lengths were specified for the variable muscle by input data set(s). This can
cause truncation of data.
WARNING: Multiple lengths were specified for the variable nasal_muco by input data set(s). This
can cause truncation of data.
WARNING: Multiple lengths were specified for the variable oral by input data set(s). This can
cause truncation of data.
WARNING: Multiple lengths were specified for the variable other by input data set(s). This can
cause truncation of data.
WARNING: Multiple lengths were specified for the variable soft_tiss by input data set(s). This
can cause truncation of data.
WARNING: Multiple lengths were specified for the variable spine by input data set(s). This can
cause truncation of data.
NOTE: There were 32592 observations read from the data set WORK.SE.
NOTE: There were 16649 observations read from the data set WORK._EF_MAP.
NOTE: The data set WORK.IE_SE_COMBINED has 49241 observations and 1595 variables.
NOTE: DATA statement used (Total process time):
real time 43.10 seconds
cpu time 8.78 seconds

NOTE: Deleting WORK._EF (memtype=DATA).
NOTE: Deleting WORK._EF2 (memtype=DATA).
NOTE: Deleting WORK._EF_C (memtype=DATA).
NOTE: Deleting WORK._EF_MAP (memtype=DATA).
NOTE: Deleting WORK._VAR_EF (memtype=DATA).
NOTE: Deleting WORK.SE (memtype=DATA).
NOTE: PROCEDURE DATASETS used (Total process time):
real time 2.62 seconds
cpu time 0.95 seconds

NOTE: There were 1476 observations read from the data set SQLIMPP.UDC2_FWP_DOSES.
NOTE: The data set WORK._DOSES has 1476 observations and 7 variables.
NOTE: DATA statement used (Total process time):
real time 0.32 seconds
cpu time 0.06 seconds

NOTE: There were 11 observations read from the data set SQLIMPP.UDC2_FWP_ICH_LastUDC.
NOTE: The data set WORK._LUDC has 11 observations and 11 variables.
NOTE: DATA statement used (Total process time):
real time 0.18 seconds
cpu time 0.06 seconds

NOTE: There were 380 observations read from the data set SQLIMPP.UDC2_FWP_SurgicalPro.
NOTE: The data set WORK._SPRO has 380 observations and 6 variables.
NOTE: DATA statement used (Total process time):
real time 0.18 seconds
cpu time 0.04 seconds

NOTE: There were 2605 observations read from the data set SQLIMPP.UDC2_FWP.
NOTE: The data set WORK._FWP has 2605 observations and 184 variables.
NOTE: DATA statement used (Total process time):
real time 0.43 seconds
cpu time 0.15 seconds

NOTE: There were 1476 observations read from the data set WORK._DOSES.
NOTE: The data set WORK._DOSES has 1476 observations and 7 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.09 seconds
cpu time 0.01 seconds

NOTE: There were 11 observations read from the data set WORK._LUDC.
NOTE: The data set WORK._LUDC has 11 observations and 11 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

NOTE: There were 380 observations read from the data set WORK._SPRO.
NOTE: The data set WORK._SPRO has 380 observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.14 seconds
cpu time 0.01 seconds

NOTE: There were 2605 observations read from the data set WORK._FWP.
NOTE: The data set WORK._FWP has 2605 observations and 184 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.18 seconds
cpu time 0.06 seconds

Directory

Libref WORK
Engine V9
Physical Name C:\Users\bil7\AppData\Local\Temp\SAS Temporary Files\_TD14916_D347430_
Filename C:\Users\bil7\AppData\Local\Temp\SAS Temporary Files\_TD14916_D347430_

Member
# Name Type File Size Last Modified

1 IE_SE_COMBINED DATA 6GB 08/12/2021 06:34:27
2 _DOSES DATA 256KB 08/12/2021 06:34:32
3 _FWP DATA 11MB 08/12/2021 06:34:33
4 _LUDC DATA 128KB 08/12/2021 06:34:32
5 _SPRO DATA 320KB 08/12/2021 06:34:33

NOTE: MODIFY was successful for WORK._FWP.DATA.

NOTE: PROCEDURE DATASETS used (Total process time):
real time 0.65 seconds
cpu time 0.04 seconds

NOTE: There were 2605 observations read from the data set WORK._FWP.
NOTE: The data set WORK._FWP has 2605 observations and 184 variables.
NOTE: DATA statement used (Total process time):
real time 0.53 seconds
cpu time 0.06 seconds

Directory

Libref WORK
Engine V9
Physical Name C:\Users\bil7\AppData\Local\Temp\SAS Temporary Files\_TD14916_D347430_
Filename C:\Users\bil7\AppData\Local\Temp\SAS Temporary Files\_TD14916_D347430_

Member
# Name Type File Size Last Modified

1 IE_SE_COMBINED DATA 6GB 08/12/2021 06:34:27
2 _DOSES DATA 256KB 08/12/2021 06:34:32
3 _FWP DATA 11MB 08/12/2021 06:34:35
4 _LUDC DATA 128KB 08/12/2021 06:34:32
5 _SPRO DATA 320KB 08/12/2021 06:34:33

NOTE: MODIFY was successful for WORK._DOSES.DATA.

NOTE: PROCEDURE DATASETS used (Total process time):
real time 0.45 seconds
cpu time 0.01 seconds

NOTE: There were 1476 observations read from the data set WORK._DOSES.
NOTE: The data set WORK._DOSES1 has 1323 observations and 6 variables.
NOTE: The data set WORK._DOSES2 has 153 observations and 6 variables.
NOTE: The data set WORK._DOSES3 has 0 observations and 6 variables.
NOTE: DATA statement used (Total process time):
real time 1.57 seconds
cpu time 0.04 seconds

NOTE: There were 1323 observations read from the data set WORK._DOSES1.
NOTE: There were 153 observations read from the data set WORK._DOSES2.
NOTE: There were 0 observations read from the data set WORK._DOSES3.
NOTE: The data set WORK._DOSESALL has 1323 observations and 14 variables.
NOTE: DATA statement used (Total process time):
real time 0.10 seconds
cpu time 0.04 seconds

NOTE: Numeric values have been converted to character values at the places given by:
(Line):(Column).
1757:1 1757:1
NOTE: There were 11 observations read from the data set WORK._LUDC.
NOTE: The data set WORK._LUDC has 11 observations and 13 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.01 seconds

NOTE: There were 11 observations read from the data set WORK._LUDC.
NOTE: The data set WORK._LUDC1 has 10 observations and 9 variables.
NOTE: DATA statement used (Total process time):
real time 0.32 seconds
cpu time 0.03 seconds

NOTE: There were 11 observations read from the data set WORK._LUDC.
NOTE: The data set WORK._LUDC2 has 1 observations and 9 variables.
NOTE: DATA statement used (Total process time):
real time 0.12 seconds
cpu time 0.03 seconds

NOTE: There were 10 observations read from the data set WORK._LUDC1.
NOTE: There were 1 observations read from the data set WORK._LUDC2.
NOTE: The data set WORK._LUDCALL has 10 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 0.15 seconds
cpu time 0.03 seconds

NOTE: Numeric values have been converted to character values at the places given by:
(Line):(Column).
1774:1 1774:1
NOTE: There were 380 observations read from the data set WORK._SPRO.
NOTE: The data set WORK._SPRO has 380 observations and 9 variables.
NOTE: DATA statement used (Total process time):
real time 0.12 seconds
cpu time 0.03 seconds

NOTE: There were 380 observations read from the data set WORK._SPRO.
NOTE: The data set WORK._SPRO1 has 312 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.18 seconds
cpu time 0.03 seconds

NOTE: There were 380 observations read from the data set WORK._SPRO.
NOTE: The data set WORK._SPRO2 has 48 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.10 seconds
cpu time 0.03 seconds

NOTE: There were 380 observations read from the data set WORK._SPRO.
NOTE: The data set WORK._SPRO3 has 16 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.07 seconds
cpu time 0.03 seconds

NOTE: There were 380 observations read from the data set WORK._SPRO.
NOTE: The data set WORK._SPRO4 has 3 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.04 seconds
cpu time 0.03 seconds

NOTE: There were 380 observations read from the data set WORK._SPRO.
NOTE: The data set WORK._SPRO5 has 1 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.07 seconds
cpu time 0.03 seconds

NOTE: There were 312 observations read from the data set WORK._SPRO1.
NOTE: There were 48 observations read from the data set WORK._SPRO2.
NOTE: There were 16 observations read from the data set WORK._SPRO3.
NOTE: There were 3 observations read from the data set WORK._SPRO4.
NOTE: There were 1 observations read from the data set WORK._SPRO5.
NOTE: The data set WORK._SPROALL has 312 observations and 17 variables.
NOTE: DATA statement used (Total process time):
real time 0.25 seconds
cpu time 0.03 seconds

NOTE: There were 1323 observations read from the data set WORK._DOSESALL.
NOTE: There were 10 observations read from the data set WORK._LUDCALL.
NOTE: There were 312 observations read from the data set WORK._SPROALL.
NOTE: There were 2605 observations read from the data set WORK._FWP.
NOTE: The data set WORK._FWP_ALL has 2605 observations and 225 variables.
NOTE: DATA statement used (Total process time):
real time 0.12 seconds
cpu time 0.07 seconds

NOTE: Numeric values have been converted to character values at the places given by:
(Line):(Column).
1814:16 1814:34
NOTE: There were 120910 observations read from the data set SQLIMPP.udc2_codes_selected.
NOTE: The data set WORK._UCS has 18658 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.53 seconds
cpu time 0.32 seconds

NOTE: There were 18658 observations read from the data set WORK._UCS.
NOTE: The data set WORK._UCS has 18658 observations and 5 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.53 seconds
cpu time 0.06 seconds

NOTE: Numeric values have been converted to character values at the places given by:
(Line):(Column).
1828:29
NOTE: There were 18658 observations read from the data set WORK._UCS.
NOTE: The data set WORK._UCS2 has 18658 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.31 seconds
cpu time 0.07 seconds

NOTE: There were 18658 observations read from the data set WORK._UCS2.
NOTE: The data set WORK._JUNK has 2583 observations and 79 variables.
NOTE: PROCEDURE TRANSPOSE used (Total process time):
real time 1.06 seconds
cpu time 0.18 seconds

NOTE: Numeric values have been converted to character values at the places given by:
(Line):(Column).
1842:49 1842:74 1843:49 1843:74
NOTE: There were 1909 observations read from the data set SQLIMPP.codes_master.
NOTE: The data set WORK.REC has 353 observations and 4 variables.
NOTE: DATA statement used (Total process time):
real time 0.17 seconds
cpu time 0.07 seconds

NOTE: The data set WORK._JUNK2 has 79 observations and 2 variables.
NOTE: PROCEDURE CONTENTS used (Total process time):
real time 0.13 seconds
cpu time 0.01 seconds

NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

NOTE: There were 2583 observations read from the data set WORK._JUNK.
NOTE: The data set WORK._JUNK has 2583 observations and 79 variables.
NOTE: DATA statement used (Total process time):
real time 20.05 seconds
cpu time 18.46 seconds

NOTE: There were 2583 observations read from the data set WORK._JUNK.
NOTE: The data set WORK._JUNK has 2583 observations and 79 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.26 seconds
cpu time 0.14 seconds

NOTE: There were 2605 observations read from the data set WORK._FWP_ALL.
NOTE: There were 2583 observations read from the data set WORK._JUNK.
NOTE: The data set WORK._PPF_FWP_COMBINE has 2605 observations and 303 variables.
NOTE: DATA statement used (Total process time):
real time 0.67 seconds
cpu time 0.15 seconds

NOTE: Numeric values have been converted to character values at the places given by:
(Line):(Column).
1872:1 1872:1 1873:1 1873:1 1874:1 1874:1 1875:1 1875:1 1876:1 1876:1
1877:1 1877:1
NOTE: There were 2605 observations read from the data set WORK._PPF_FWP_COMBINE.
NOTE: The data set WORK._PPF_FWP_COMBINE2 has 2605 observations and 312 variables.
NOTE: DATA statement used (Total process time):
real time 0.87 seconds
cpu time 0.18 seconds

NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
46 at 1887:17
NOTE: There were 2605 observations read from the data set WORK._PPF_FWP_COMBINE2.
NOTE: The data set WORK.PPF_FWP_COMBINE3 has 2605 observations and 302 variables.
NOTE: DATA statement used (Total process time):
real time 0.31 seconds
cpu time 0.18 seconds

NOTE: There were 2605 observations read from the data set WORK.PPF_FWP_COMBINE3.
NOTE: The data set WORK.PPF_FWP_COMBINE3 has 2605 observations and 302 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.98 seconds
cpu time 0.26 seconds

NOTE: Deleting WORK._DOSES (memtype=DATA).
NOTE: Deleting WORK._DOSES1 (memtype=DATA).
NOTE: Deleting WORK._DOSES2 (memtype=DATA).
NOTE: Deleting WORK._DOSES3 (memtype=DATA).
NOTE: Deleting WORK._DOSESALL (memtype=DATA).
NOTE: Deleting WORK._FWP (memtype=DATA).
NOTE: Deleting WORK._FWP_ALL (memtype=DATA).
NOTE: Deleting WORK._JUNK (memtype=DATA).
NOTE: Deleting WORK._JUNK2 (memtype=DATA).
NOTE: Deleting WORK._LUDC (memtype=DATA).
NOTE: Deleting WORK._LUDC1 (memtype=DATA).
NOTE: Deleting WORK._LUDC2 (memtype=DATA).
NOTE: Deleting WORK._LUDCALL (memtype=DATA).
NOTE: Deleting WORK._PPF_FWP_COMBINE (memtype=DATA).
NOTE: Deleting WORK._PPF_FWP_COMBINE2 (memtype=DATA).
NOTE: Deleting WORK._SPRO (memtype=DATA).
NOTE: Deleting WORK._SPRO1 (memtype=DATA).
NOTE: Deleting WORK._SPRO2 (memtype=DATA).
NOTE: Deleting WORK._SPRO3 (memtype=DATA).
NOTE: Deleting WORK._SPRO4 (memtype=DATA).
NOTE: Deleting WORK._SPRO5 (memtype=DATA).
NOTE: Deleting WORK._SPROALL (memtype=DATA).
NOTE: Deleting WORK._UCS (memtype=DATA).
NOTE: Deleting WORK._UCS2 (memtype=DATA).
NOTE: PROCEDURE DATASETS used (Total process time):
real time 0.07 seconds
cpu time 0.07 seconds

NOTE: Numeric values have been converted to character values at the places given by:
(Line):(Column).
8735:110 8735:179 8735:239 1941:18 1941:1 1941:1
NOTE: There were 4204 observations read from the data set SQLIMPP.UDC2_REG_DIAGNOSIS_CFD.
NOTE: The data set WORK._DX1 has 4204 observations and 6 variables.
NOTE: DATA statement used (Total process time):
real time 0.29 seconds
cpu time 0.10 seconds

NOTE: Numeric values have been converted to character values at the places given by:
(Line):(Column).
8782:110 8782:179 8782:239 1942:18 1942:1 1942:1
NOTE: Variable BasePercentage is uninitialized.
NOTE: Variable BasePercentage_unk is uninitialized.
NOTE: Variable BasePercentage_dk is uninitialized.
NOTE: There were 1000 observations read from the data set SQLIMPP.UDC2_REG_DIAGNOSIS_VWD.
NOTE: The data set WORK._DX2 has 1000 observations and 6 variables.
NOTE: DATA statement used (Total process time):
real time 1.64 seconds
cpu time 0.09 seconds

NOTE: Numeric values have been converted to character values at the places given by:
(Line):(Column).
8829:110 8829:179 8829:239 1943:18 1943:1 1943:1
NOTE: Variable BasePercentage is uninitialized.
NOTE: Variable BasePercentage_unk is uninitialized.
NOTE: Variable BasePercentage_dk is uninitialized.
NOTE: There were 171 observations read from the data set SQLIMPP.UDC2_REG_DIAGNOSIS_FPD.
NOTE: The data set WORK._DX3 has 171 observations and 6 variables.
NOTE: DATA statement used (Total process time):
real time 0.32 seconds
cpu time 0.07 seconds

NOTE: Numeric values have been converted to character values at the places given by:
(Line):(Column).
8876:110 8876:179 8876:239 1944:18 1944:1 1944:1
NOTE: Variable BasePercentage is uninitialized.
NOTE: Variable BasePercentage_unk is uninitialized.
NOTE: Variable BasePercentage_dk is uninitialized.
NOTE: There were 18 observations read from the data set SQLIMPP.UDC2_REG_DIAGNOSIS_NLD.
NOTE: The data set WORK._DX4 has 18 observations and 6 variables.
NOTE: DATA statement used (Total process time):
real time 0.20 seconds
cpu time 0.01 seconds

NOTE: There were 4204 observations read from the data set WORK._DX1.
NOTE: The data set WORK._DX1 has 4204 observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.20 seconds
cpu time 0.03 seconds

NOTE: There were 1000 observations read from the data set WORK._DX2.
NOTE: The data set WORK._DX2 has 1000 observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.04 seconds
cpu time 0.01 seconds

NOTE: There were 171 observations read from the data set WORK._DX3.
NOTE: The data set WORK._DX3 has 171 observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.26 seconds
cpu time 0.01 seconds

NOTE: There were 18 observations read from the data set WORK._DX4.
NOTE: The data set WORK._DX4 has 18 observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.04 seconds
cpu time 0.01 seconds

NOTE: There were 4204 observations read from the data set WORK._DX1.
NOTE: There were 1000 observations read from the data set WORK._DX2.
NOTE: There were 171 observations read from the data set WORK._DX3.
NOTE: There were 18 observations read from the data set WORK._DX4.
NOTE: The data set WORK._DX has 5393 observations and 7 variables.
NOTE: DATA statement used (Total process time):
real time 0.81 seconds
cpu time 0.06 seconds

NOTE: Numeric values have been converted to character values at the places given by:
(Line):(Column).
8949:169
NOTE: There were 5393 observations read from the data set WORK._DX.
NOTE: The data set WORK._DX1 has 5284 observations and 6 variables.
NOTE: DATA statement used (Total process time):
real time 0.29 seconds
cpu time 0.04 seconds

NOTE: Numeric values have been converted to character values at the places given by:
(Line):(Column).
8963:170
NOTE: There were 5393 observations read from the data set WORK._DX.
NOTE: The data set WORK._DX2 has 104 observations and 6 variables.
NOTE: DATA statement used (Total process time):
real time 0.07 seconds
cpu time 0.03 seconds

NOTE: Numeric values have been converted to character values at the places given by:
(Line):(Column).
8977:170
NOTE: There were 5393 observations read from the data set WORK._DX.
NOTE: The data set WORK._DX3 has 4 observations and 6 variables.
NOTE: DATA statement used (Total process time):
real time 0.31 seconds
cpu time 0.03 seconds

NOTE: Numeric values have been converted to character values at the places given by:
(Line):(Column).
8991:170
NOTE: There were 5393 observations read from the data set WORK._DX.
NOTE: The data set WORK._DX4 has 1 observations and 6 variables.
NOTE: DATA statement used (Total process time):
real time 0.09 seconds
cpu time 0.03 seconds

NOTE: There were 5284 observations read from the data set WORK._DX1.
NOTE: There were 104 observations read from the data set WORK._DX2.
NOTE: There were 4 observations read from the data set WORK._DX3.
NOTE: There were 1 observations read from the data set WORK._DX4.
NOTE: The data set WORK._DXC has 5284 observations and 18 variables.
NOTE: DATA statement used (Total process time):
real time 0.11 seconds
cpu time 0.04 seconds

NOTE: There were 2281 observations read from the data set SQLIMPP.UDC2_REG_DOSES.
NOTE: The data set WORK._DOSES has 2281 observations and 7 variables.
NOTE: DATA statement used (Total process time):
real time 0.23 seconds
cpu time 0.07 seconds

NOTE: There were 435 observations read from the data set SQLIMPP.UDC2_REG_ICH.
NOTE: The data set WORK._ICH has 435 observations and 7 variables.
NOTE: DATA statement used (Total process time):
real time 0.15 seconds
cpu time 0.03 seconds

NOTE: There were 36 observations read from the data set SQLIMPP.UDC2_REG_ICH_LastUDC.
NOTE: The data set WORK._LUDC has 36 observations and 11 variables.
NOTE: DATA statement used (Total process time):
real time 0.15 seconds
cpu time 0.06 seconds

NOTE: There were 837 observations read from the data set SQLIMPP.UDC2_REG_SurgicalPro.
NOTE: The data set WORK._SPRO has 837 observations and 6 variables.
NOTE: DATA statement used (Total process time):
real time 0.32 seconds
cpu time 0.07 seconds

NOTE: There were 5294 observations read from the data set SQLIMPP.UDC2_REG.
NOTE: The data set WORK._REG has 5294 observations and 221 variables.
NOTE: DATA statement used (Total process time):
real time 0.53 seconds
cpu time 0.28 seconds

NOTE: There were 2281 observations read from the data set WORK._DOSES.
NOTE: The data set WORK._DOSES has 2281 observations and 7 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.17 seconds
cpu time 0.03 seconds

NOTE: There were 435 observations read from the data set WORK._ICH.
NOTE: The data set WORK._ICH has 435 observations and 7 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.37 seconds
cpu time 0.01 seconds

NOTE: There were 36 observations read from the data set WORK._LUDC.
NOTE: The data set WORK._LUDC has 36 observations and 11 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.04 seconds
cpu time 0.00 seconds

NOTE: There were 837 observations read from the data set WORK._SPRO.
NOTE: The data set WORK._SPRO has 837 observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.18 seconds
cpu time 0.00 seconds

NOTE: There were 5294 observations read from the data set WORK._REG.
NOTE: The data set WORK._REG has 5294 observations and 221 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.17 seconds
cpu time 0.07 seconds

Directory

Libref WORK
Engine V9
Physical Name C:\Users\bil7\AppData\Local\Temp\SAS Temporary Files\_TD14916_D347430_
Filename C:\Users\bil7\AppData\Local\Temp\SAS Temporary Files\_TD14916_D347430_

Member
# Name Type File Size Last Modified

1 IE_SE_COMBINED DATA 6GB 08/12/2021 06:34:27
2 PPF_FWP_COMBINE3 DATA 57MB 08/12/2021 06:35:10
3 REC DATA 256KB 08/12/2021 06:34:45
4 _DOSES DATA 320KB 08/12/2021 06:35:21
5 _DX DATA 2MB 08/12/2021 06:35:16
6 _DX1 DATA 3MB 08/12/2021 06:35:17
7 _DX2 DATA 128KB 08/12/2021 06:35:17
8 _DX3 DATA 128KB 08/12/2021 06:35:18
9 _DX4 DATA 128KB 08/12/2021 06:35:18
10 _DXC DATA 9MB 08/12/2021 06:35:18
11 _ICH DATA 128KB 08/12/2021 06:35:22
12 _LUDC DATA 128KB 08/12/2021 06:35:22
13 _REG DATA 24MB 08/12/2021 06:35:23
14 _SPRO DATA 576KB 08/12/2021 06:35:22

NOTE: MODIFY was successful for WORK._DOSES.DATA.

NOTE: PROCEDURE DATASETS used (Total process time):
real time 0.04 seconds
cpu time 0.03 seconds

NOTE: There were 2281 observations read from the data set WORK._DOSES.
NOTE: The data set WORK._DOSES1 has 2025 observations and 6 variables.
NOTE: The data set WORK._DOSES2 has 254 observations and 6 variables.
NOTE: The data set WORK._DOSES3 has 2 observations and 6 variables.
NOTE: DATA statement used (Total process time):
real time 0.37 seconds
cpu time 0.04 seconds

NOTE: There were 2025 observations read from the data set WORK._DOSES1.
NOTE: There were 254 observations read from the data set WORK._DOSES2.
NOTE: There were 2 observations read from the data set WORK._DOSES3.
NOTE: The data set WORK._DOSESALL has 2025 observations and 14 variables.
NOTE: DATA statement used (Total process time):
real time 0.07 seconds
cpu time 0.03 seconds

NOTE: Numeric values have been converted to character values at the places given by:
(Line):(Column).
2008:1 2008:1
NOTE: There were 435 observations read from the data set WORK._ICH.
NOTE: The data set WORK._ICH has 435 observations and 9 variables.
NOTE: DATA statement used (Total process time):
real time 1.21 seconds
cpu time 0.03 seconds

NOTE: There were 435 observations read from the data set WORK._ICH.
NOTE: The data set WORK._ICH1 has 354 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.06 seconds
cpu time 0.03 seconds

NOTE: There were 435 observations read from the data set WORK._ICH.
NOTE: The data set WORK._ICH2 has 60 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.18 seconds
cpu time 0.03 seconds

NOTE: There were 435 observations read from the data set WORK._ICH.
NOTE: The data set WORK._ICH3 has 20 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.18 seconds
cpu time 0.03 seconds

NOTE: There were 435 observations read from the data set WORK._ICH.
NOTE: The data set WORK._ICH4 has 1 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.10 seconds
cpu time 0.03 seconds

NOTE: There were 354 observations read from the data set WORK._ICH1.
NOTE: There were 60 observations read from the data set WORK._ICH2.
NOTE: There were 20 observations read from the data set WORK._ICH3.
NOTE: There were 1 observations read from the data set WORK._ICH4.
NOTE: The data set WORK._ICHALL has 354 observations and 14 variables.
NOTE: DATA statement used (Total process time):
real time 0.09 seconds
cpu time 0.03 seconds

NOTE: Numeric values have been converted to character values at the places given by:
(Line):(Column).
2022:1 2022:1
NOTE: There were 36 observations read from the data set WORK._LUDC.
NOTE: The data set WORK._LUDC has 36 observations and 13 variables.
NOTE: DATA statement used (Total process time):
real time 0.17 seconds
cpu time 0.03 seconds

NOTE: There were 36 observations read from the data set WORK._LUDC.
NOTE: The data set WORK._LUDC1 has 33 observations and 10 variables.
NOTE: DATA statement used (Total process time):
real time 0.14 seconds
cpu time 0.03 seconds

NOTE: There were 36 observations read from the data set WORK._LUDC.
NOTE: The data set WORK._LUDC2 has 3 observations and 10 variables.
NOTE: DATA statement used (Total process time):
real time 0.15 seconds
cpu time 0.03 seconds

NOTE: There were 33 observations read from the data set WORK._LUDC1.
NOTE: There were 3 observations read from the data set WORK._LUDC2.
NOTE: The data set WORK._LUDCALL has 33 observations and 17 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds

NOTE: Numeric values have been converted to character values at the places given by:
(Line):(Column).
2039:1 2039:1
NOTE: There were 837 observations read from the data set WORK._SPRO.
NOTE: The data set WORK._SPRO has 837 observations and 9 variables.
NOTE: DATA statement used (Total process time):
real time 0.25 seconds
cpu time 0.03 seconds

NOTE: There were 837 observations read from the data set WORK._SPRO.
NOTE: The data set WORK._SPRO1 has 665 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.57 seconds
cpu time 0.04 seconds

NOTE: There were 837 observations read from the data set WORK._SPRO.
NOTE: The data set WORK._SPRO2 has 124 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.12 seconds
cpu time 0.03 seconds

NOTE: There were 837 observations read from the data set WORK._SPRO.
NOTE: The data set WORK._SPRO3 has 32 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.23 seconds
cpu time 0.03 seconds

NOTE: There were 837 observations read from the data set WORK._SPRO.
NOTE: The data set WORK._SPRO4 has 11 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.10 seconds
cpu time 0.03 seconds

NOTE: There were 837 observations read from the data set WORK._SPRO.
NOTE: The data set WORK._SPRO5 has 5 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.13 seconds
cpu time 0.03 seconds

NOTE: There were 665 observations read from the data set WORK._SPRO1.
NOTE: There were 124 observations read from the data set WORK._SPRO2.
NOTE: There were 32 observations read from the data set WORK._SPRO3.
NOTE: There were 11 observations read from the data set WORK._SPRO4.
NOTE: There were 5 observations read from the data set WORK._SPRO5.
NOTE: The data set WORK._SPROALL has 665 observations and 17 variables.
NOTE: DATA statement used (Total process time):
real time 0.04 seconds
cpu time 0.04 seconds

NOTE: There were 5284 observations read from the data set WORK._DXC.
NOTE: There were 2025 observations read from the data set WORK._DOSESALL.
NOTE: There were 354 observations read from the data set WORK._ICHALL.
NOTE: There were 33 observations read from the data set WORK._LUDCALL.
NOTE: There were 665 observations read from the data set WORK._SPROALL.
NOTE: There were 5294 observations read from the data set WORK._REG.
NOTE: The data set WORK._REG_ALL has 5294 observations and 291 variables.
NOTE: DATA statement used (Total process time):
real time 0.10 seconds
cpu time 0.10 seconds

NOTE: Numeric values have been converted to character values at the places given by:
(Line):(Column).
2078:16 2078:34
NOTE: There were 120910 observations read from the data set SQLIMPP.udc2_codes_selected.
NOTE: The data set WORK._UCS has 58145 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.43 seconds
cpu time 0.37 seconds

NOTE: There were 58145 observations read from the data set WORK._UCS.
NOTE: The data set WORK._UCS has 58145 observations and 5 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.46 seconds
cpu time 0.12 seconds

NOTE: Numeric values have been converted to character values at the places given by:
(Line):(Column).
2091:29
NOTE: There were 58145 observations read from the data set WORK._UCS.
NOTE: The data set WORK._UCS2 has 58145 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.09 seconds
cpu time 0.09 seconds

NOTE: There were 58145 observations read from the data set WORK._UCS2.
NOTE: The data set WORK._JUNK has 5289 observations and 281 variables.
NOTE: PROCEDURE TRANSPOSE used (Total process time):
real time 0.43 seconds
cpu time 0.40 seconds

NOTE: Numeric values have been converted to character values at the places given by:
(Line):(Column).
2105:51 2105:76 2106:51 2106:76 2107:79 2107:104
NOTE: There were 1909 observations read from the data set SQLIMPP.codes_master.
NOTE: The data set WORK.REC has 387 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.29 seconds
cpu time 0.09 seconds

NOTE: The data set WORK._JUNK2 has 281 observations and 2 variables.
NOTE: PROCEDURE CONTENTS used (Total process time):
real time 0.15 seconds
cpu time 0.01 seconds

The SAS System 06:30 Thursday, August 12, 2021 14

recode
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
RECODE2(I) = TRANWRD(RECODE2(I),"83,1 " ,"White");
RECODE2(I) = TRANWRD(RECODE2(I),"83,2 " ,"Black or African American");
RECODE2(I) = TRANWRD(RECODE2(I),"83,3 " ,"Asian");
RECODE2(I) = TRANWRD(RECODE2(I),"83,4 " ,"Native Hawaiian or Other Pacific Islander");
RECODE2(I) = TRANWRD(RECODE2(I),"83,5 " ,"American Indian or Alaska Native");
RECODE2(I) = TRANWRD(RECODE2(I),"83,888","Unknown");
RECODE2(I) = TRANWRD(RECODE2(I),"83,999","Other (specify)");
RECODE2(I) = TRANWRD(RECODE2(I),"206,1 " ,"VIII (8)");
RECODE2(I) = TRANWRD(RECODE2(I),"206,2 " ,"IX (9)");
RECODE2(I) = TRANWRD(RECODE2(I),"206,3 " ,"I (afibrinogenemia) (1)");
RECODE2(I) = TRANWRD(RECODE2(I),"206,4 " ,"I (dysfibrinogenemia) (1)");
RECODE2(I) = TRANWRD(RECODE2(I),"206,5 " ,"I (hypofibrinogenemia) (1)");
RECODE2(I) = TRANWRD(RECODE2(I),"206,6 " ,"I (Factor 1, hereditary, unspecified)");
RECODE2(I) = TRANWRD(RECODE2(I),"206,7 " ,"II (prothrombin) (2)");
RECODE2(I) = TRANWRD(RECODE2(I),"206,8 " ,"V (5)");
RECODE2(I) = TRANWRD(RECODE2(I),"206,9 " ,"VII (7)");
RECODE2(I) = TRANWRD(RECODE2(I),"206,10","X (10)");
RECODE2(I) = TRANWRD(RECODE2(I),"206,11","XI (11)");
RECODE2(I) = TRANWRD(RECODE2(I),"206,12","XIII (13)");
RECODE2(I) = TRANWRD(RECODE2(I),"206,13","V-VIII (5/8)");
RECODE2(I) = TRANWRD(RECODE2(I),"206,14","PAI-1 deficiency (plasminogen activator inhibitor-1
deficiency)");
RECODE2(I) = TRANWRD(RECODE2(I),"206,15","a2anti-plasmin deficiency (a2-AP)");
RECODE2(I) = TRANWRD(RECODE2(I),"206,16","VWD Type 1");
RECODE2(I) = TRANWRD(RECODE2(I),"206,17","VWD Type 1C");
RECODE2(I) = TRANWRD(RECODE2(I),"206,18","VWD Type 2A");
RECODE2(I) = TRANWRD(RECODE2(I),"206,19","VWD Type 2B");
RECODE2(I) = TRANWRD(RECODE2(I),"206,20","VWD Type 2M");
RECODE2(I) = TRANWRD(RECODE2(I),"206,21","VWD Type 2N");
RECODE2(I) = TRANWRD(RECODE2(I),"206,22","VWD Type 2, type unknown");
RECODE2(I) = TRANWRD(RECODE2(I),"206,23","VWD Type 3");
RECODE2(I) = TRANWRD(RECODE2(I),"206,24","VWD type unknown");
RECODE2(I) = TRANWRD(RECODE2(I),"206,25","VWD Other");
RECODE2(I) = TRANWRD(RECODE2(I),"206,26","Bernard Soulier");
RECODE2(I) = TRANWRD(RECODE2(I),"206,27","Glanzmann’s thrombasthenia");
RECODE2(I) = TRANWRD(RECODE2(I),"206,28","Grey platelet syndrome");
RECODE2(I) = TRANWRD(RECODE2(I),"206,29","Hermansky-Pudlak syndrome");
RECODE2(I) = TRANWRD(RECODE2(I),"206,30","Inherited thrombocytopenia");
RECODE2(I) = TRANWRD(RECODE2(I),"206,31","Release defect");
RECODE2(I) = TRANWRD(RECODE2(I),"206,32","Storage pool defect");
RECODE2(I) = TRANWRD(RECODE2(I),"206,33","Hereditary platelet function disorder");
RECODE2(I) = TRANWRD(RECODE2(I),"206,34","Ehlers-Danlos syndrome");
RECODE2(I) = TRANWRD(RECODE2(I),"206,35","Blood coagulation disorder with prolonged coagulation
time");
RECODE2(I) = TRANWRD(RECODE2(I),"206,36","Blood coagulation disorder with prolonged bleeding
time");
RECODE2(I) = TRANWRD(RECODE2(I),"206,37","Blood coagulation disorder with impaired clot
retraction time");
RECODE2(I) = TRANWRD(RECODE2(I),"207,1 " ,"Type 1");
RECODE2(I) = TRANWRD(RECODE2(I),"207,2 " ,"Type 2a");
RECODE2(I) = TRANWRD(RECODE2(I),"207,3 " ,"Type 2b");
The SAS System 06:30 Thursday, August 12, 2021 15

recode
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
RECODE2(I) = TRANWRD(RECODE2(I),"207,4 " ,"Type 3");
RECODE2(I) = TRANWRD(RECODE2(I),"207,888","Unknown");
RECODE2(I) = TRANWRD(RECODE2(I),"207,999","Other");
RECODE2(I) = TRANWRD(RECODE2(I),"208,1 " ,"Recombinant");
RECODE2(I) = TRANWRD(RECODE2(I),"208,2 " ,"Blood bank or plasma-derived");
RECODE2(I) = TRANWRD(RECODE2(I),"208,3 " ,"No applicable treatment products used");
RECODE2(I) = TRANWRD(RECODE2(I),"208,888","Unknown product use");
RECODE2(I) = TRANWRD(RECODE2(I),"209,1 " ,"Venipuncture without heparin flush");
RECODE2(I) = TRANWRD(RECODE2(I),"209,2 " ,"Venous access device utilizing heparin flush (ex.
peripheral line, central line, port)");
RECODE2(I) = TRANWRD(RECODE2(I),"210,1 " ,"Final");
RECODE2(I) = TRANWRD(RECODE2(I),"210,2 " ,"Preliminary");
RECODE2(I) = TRANWRD(RECODE2(I),"211,1 " ,"Discard");
RECODE2(I) = TRANWRD(RECODE2(I),"211,2 " ,"Replace");
RECODE2(I) = TRANWRD(RECODE2(I),"211,3 " ,"Insert");
RECODE2(I) = TRANWRD(RECODE2(I),"211,4 " ,"Re-import");
RECODE2(I) = TRANWRD(RECODE2(I),"212,1 " ,"Insured");
RECODE2(I) = TRANWRD(RECODE2(I),"212,2 " ,"Uninsured");
RECODE2(I) = TRANWRD(RECODE2(I),"212,888","Unknown");
RECODE2(I) = TRANWRD(RECODE2(I),"213,1 " ,"Clotting Factor Deficiency");
RECODE2(I) = TRANWRD(RECODE2(I),"213,2 " ,"Von Willebrand disease (VWD)");
RECODE2(I) = TRANWRD(RECODE2(I),"213,3 " ,"Inherited or Functional Platelet Disorder");
RECODE2(I) = TRANWRD(RECODE2(I),"213,4 " ,"Connective Tissue Disorder");
RECODE2(I) = TRANWRD(RECODE2(I),"213,5 " ,"Bleeding Disorder, no laboratory diagnosis");
RECODE2(I) = TRANWRD(RECODE2(I),"213,6 " ,"Venous Thromboembolism (VTE)");
RECODE2(I) = TRANWRD(RECODE2(I),"214,1 " ,"VIII (8)");
RECODE2(I) = TRANWRD(RECODE2(I),"214,2 " ,"IX (9)");
RECODE2(I) = TRANWRD(RECODE2(I),"214,3 " ,"I (fibrinogen)");
RECODE2(I) = TRANWRD(RECODE2(I),"214,4 " ,"II (prothrombin)");
RECODE2(I) = TRANWRD(RECODE2(I),"214,5 " ,"V (5)");
RECODE2(I) = TRANWRD(RECODE2(I),"214,6 " ,"VII (7)");
RECODE2(I) = TRANWRD(RECODE2(I),"214,7 " ,"X (10)");
RECODE2(I) = TRANWRD(RECODE2(I),"214,8 " ,"XI (11)");
RECODE2(I) = TRANWRD(RECODE2(I),"214,9 " ,"XIII (13)");
RECODE2(I) = TRANWRD(RECODE2(I),"214,10","V-VIII (5/8)");
RECODE2(I) = TRANWRD(RECODE2(I),"214,11","PAI-1 deficiency (plasminogen activator inhibitor-1");
RECODE2(I) = TRANWRD(RECODE2(I),"214,12","a2anti-plasmin deficiency (a2-AP)");
RECODE2(I) = TRANWRD(RECODE2(I),"214,888","Unknown");
RECODE2(I) = TRANWRD(RECODE2(I),"215,1 " ,"VWD Type 1");
RECODE2(I) = TRANWRD(RECODE2(I),"215,2 " ,"VWD Type 1C");
RECODE2(I) = TRANWRD(RECODE2(I),"215,3 " ,"VWD Type 2A");
RECODE2(I) = TRANWRD(RECODE2(I),"215,4 " ,"VWD Type 2B");
RECODE2(I) = TRANWRD(RECODE2(I),"215,5 " ,"VWD Type 2M");
RECODE2(I) = TRANWRD(RECODE2(I),"215,6 " ,"VWD Type 2N");
RECODE2(I) = TRANWRD(RECODE2(I),"215,7 " ,"VWD Type 2, type unknown");
RECODE2(I) = TRANWRD(RECODE2(I),"215,8 " ,"VWD Type 3");
RECODE2(I) = TRANWRD(RECODE2(I),"215,9 " ,"VWD type unknown");
RECODE2(I) = TRANWRD(RECODE2(I),"215,10","VWD Other");
RECODE2(I) = TRANWRD(RECODE2(I),"216,1 " ,"Bernard Soulier");
RECODE2(I) = TRANWRD(RECODE2(I),"216,2 " ,"Glanzmann’s thrombasthenia");
RECODE2(I) = TRANWRD(RECODE2(I),"216,3 " ,"Grey platelet syndrome");
The SAS System 06:30 Thursday, August 12, 2021 16

recode
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
RECODE2(I) = TRANWRD(RECODE2(I),"216,4 " ,"Hermansky-Pudlak syndrome");
RECODE2(I) = TRANWRD(RECODE2(I),"216,5 " ,"Inherited thrombocytopenia");
RECODE2(I) = TRANWRD(RECODE2(I),"216,6 " ,"Release defect");
RECODE2(I) = TRANWRD(RECODE2(I),"216,7 " ,"Storage pool defect");
RECODE2(I) = TRANWRD(RECODE2(I),"216,8 " ,"Hereditary platelet function disorder");
RECODE2(I) = TRANWRD(RECODE2(I),"216,555","N/A");
RECODE2(I) = TRANWRD(RECODE2(I),"217,1 " ,"Ehlers-Danlos syndrome");
RECODE2(I) = TRANWRD(RECODE2(I),"217,555","N/A");
RECODE2(I) = TRANWRD(RECODE2(I),"218,1 " ,"Blood coagulation disorder with prolonged coagulation
time");
RECODE2(I) = TRANWRD(RECODE2(I),"218,2 " ,"Blood coagulation disorder with prolonged bleeding
time");
RECODE2(I) = TRANWRD(RECODE2(I),"218,3 " ,"Blood coagulation disorder with impaired clot
retraction time");
RECODE2(I) = TRANWRD(RECODE2(I),"218,555","N/A");
RECODE2(I) = TRANWRD(RECODE2(I),"219,1 " ,"Pulmonary Embolism");
RECODE2(I) = TRANWRD(RECODE2(I),"219,2 " ,"Thrombosis Abdominal Vein Mesenteric Portal Or
Renal");
RECODE2(I) = TRANWRD(RECODE2(I),"219,3 " ,"Thrombosis Deep Venous");
RECODE2(I) = TRANWRD(RECODE2(I),"219,4 " ,"Thrombosis Deep Venous of Lower Extremity or
Pelvis");
RECODE2(I) = TRANWRD(RECODE2(I),"219,5 " ,"Thrombosis Deep Venous Of Upper Extremity or Upper
Thorax");
RECODE2(I) = TRANWRD(RECODE2(I),"219,555","N/A");
RECODE2(I) = TRANWRD(RECODE2(I),"220,1 " ,"Initial Surveillance Inhibitor Titer");
RECODE2(I) = TRANWRD(RECODE2(I),"220,2 " ,"Subsequent Surveillance Inhibitor Titer");
RECODE2(I) = TRANWRD(RECODE2(I),"220,3 " ,"Clinical Indication of an Inhibitor");
RECODE2(I) = TRANWRD(RECODE2(I),"220,4 " ,"Follow-up to Locally Identified Elevated Inhibitor
Titer");
RECODE2(I) = TRANWRD(RECODE2(I),"220,5 " ,"Follow-up to Elevated CDC Surveillance Inhibitor
Titer");
RECODE2(I) = TRANWRD(RECODE2(I),"221,1 " ,"Accident");
RECODE2(I) = TRANWRD(RECODE2(I),"221,2 " ,"Cancer");
RECODE2(I) = TRANWRD(RECODE2(I),"221,3 " ,"Cardiovascular");
RECODE2(I) = TRANWRD(RECODE2(I),"221,4 " ,"Dementia");
RECODE2(I) = TRANWRD(RECODE2(I),"221,5 " ,"Diabetes mellitus");
RECODE2(I) = TRANWRD(RECODE2(I),"221,6 " ,"Hemophilia/ Bleeding disorder-related");
RECODE2(I) = TRANWRD(RECODE2(I),"221,7 " ,"HIV-related");
RECODE2(I) = TRANWRD(RECODE2(I),"221,8 " ,"Kidney Disease");
RECODE2(I) = TRANWRD(RECODE2(I),"221,9 " ,"Liver Disease");
RECODE2(I) = TRANWRD(RECODE2(I),"221,10","Suicide");
RECODE2(I) = TRANWRD(RECODE2(I),"221,888","Unknown");
RECODE2(I) = TRANWRD(RECODE2(I),"221,999","Other");
RECODE2(I) = TRANWRD(RECODE2(I),"222,1 " ,"Commercial Insurance");
RECODE2(I) = TRANWRD(RECODE2(I),"222,2 " ,"Military Health Care (TRICARE/VA/Champ-VA)");
RECODE2(I) = TRANWRD(RECODE2(I),"222,3 " ,"Medicaid");
RECODE2(I) = TRANWRD(RECODE2(I),"222,4 " ,"Medicare");
RECODE2(I) = TRANWRD(RECODE2(I),"222,5 " ,"State Programs");
RECODE2(I) = TRANWRD(RECODE2(I),"222,6 " ,"Indian Health Service");
RECODE2(I) = TRANWRD(RECODE2(I),"222,7 " ,"Uninsured");
RECODE2(I) = TRANWRD(RECODE2(I),"222,888","Unknown");
The SAS System 06:30 Thursday, August 12, 2021 17

recode
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
RECODE2(I) = TRANWRD(RECODE2(I),"222,999","Other");
RECODE2(I) = TRANWRD(RECODE2(I),"223,1 " ,"None");
RECODE2(I) = TRANWRD(RECODE2(I),"223,2 " ,"Pre-elementary");
RECODE2(I) = TRANWRD(RECODE2(I),"223,3 " ,"Primary / Secondary");
RECODE2(I) = TRANWRD(RECODE2(I),"223,4 " ,"GED or equivalent");
RECODE2(I) = TRANWRD(RECODE2(I),"223,5 " ,"Technical school");
RECODE2(I) = TRANWRD(RECODE2(I),"223,6 " ,"Some college");
RECODE2(I) = TRANWRD(RECODE2(I),"223,7 " ,"2-year college degree (Associates)");
RECODE2(I) = TRANWRD(RECODE2(I),"223,8 " ,"4-year college degree (Bachelors)");
RECODE2(I) = TRANWRD(RECODE2(I),"223,9 " ,"Advanced degree (Masters, Doctorate or
professional)");
RECODE2(I) = TRANWRD(RECODE2(I),"223,888","Unknown");
RECODE2(I) = TRANWRD(RECODE2(I),"223,999","Other");
RECODE2(I) = TRANWRD(RECODE2(I),"224,1 " ,"Employed full-time");
RECODE2(I) = TRANWRD(RECODE2(I),"224,2 " ,"Employed part-time");
RECODE2(I) = TRANWRD(RECODE2(I),"224,3 " ,"Not employed");
RECODE2(I) = TRANWRD(RECODE2(I),"224,888","Unknown employment status");
RECODE2(I) = TRANWRD(RECODE2(I),"225,1 " ,"Child or student");
RECODE2(I) = TRANWRD(RECODE2(I),"225,2 " ,"Homemaker");
RECODE2(I) = TRANWRD(RECODE2(I),"225,3 " ,"Able, but not currently working");
RECODE2(I) = TRANWRD(RECODE2(I),"225,4 " ,"Disabled");
RECODE2(I) = TRANWRD(RECODE2(I),"225,5 " ,"Retired");
RECODE2(I) = TRANWRD(RECODE2(I),"225,888","Unknown");
RECODE2(I) = TRANWRD(RECODE2(I),"225,999","Other");
RECODE2(I) = TRANWRD(RECODE2(I),"226,1 " ,"Actual");
RECODE2(I) = TRANWRD(RECODE2(I),"226,2 " ,"Estimated");
RECODE2(I) = TRANWRD(RECODE2(I),"226,3 " ,"No Results Available");
RECODE2(I) = TRANWRD(RECODE2(I),"226,555","N/A");
RECODE2(I) = TRANWRD(RECODE2(I),"226,888","Date Unknown");
RECODE2(I) = TRANWRD(RECODE2(I),"227,1 " ,"Vaginal, unassisted");
RECODE2(I) = TRANWRD(RECODE2(I),"227,2 " ,"Vaginal with forceps");
RECODE2(I) = TRANWRD(RECODE2(I),"227,3 " ,"Vaginal with vacuum");
RECODE2(I) = TRANWRD(RECODE2(I),"227,4 " ,"Vaginal, assistance unknown");
RECODE2(I) = TRANWRD(RECODE2(I),"227,5 " ,"C-Section, Elective");
RECODE2(I) = TRANWRD(RECODE2(I),"227,6 " ,"C-Section, Emergent/Non-elective");
RECODE2(I) = TRANWRD(RECODE2(I),"227,7 " ,"C-Section, type unknown");
RECODE2(I) = TRANWRD(RECODE2(I),"227,888","Unknown");
RECODE2(I) = TRANWRD(RECODE2(I),"228,1 " ,"HTC’s primary location");
RECODE2(I) = TRANWRD(RECODE2(I),"228,2 " ,"HTC outreach clinic");
RECODE2(I) = TRANWRD(RECODE2(I),"228,3 " ,"HTC telemedicine session or telemedicine clinic");
RECODE2(I) = TRANWRD(RECODE2(I),"229,1 " ,"FVIII (8)");
RECODE2(I) = TRANWRD(RECODE2(I),"229,2 " ,"FIX (9)");
RECODE2(I) = TRANWRD(RECODE2(I),"229,3 " ,"FI (fibrinogen)");
RECODE2(I) = TRANWRD(RECODE2(I),"229,4 " ,"FII (2)");
RECODE2(I) = TRANWRD(RECODE2(I),"229,5 " ,"FV (5)");
RECODE2(I) = TRANWRD(RECODE2(I),"229,6 " ,"FVII (7)");
RECODE2(I) = TRANWRD(RECODE2(I),"229,7 " ,"FX (10)");
RECODE2(I) = TRANWRD(RECODE2(I),"229,8 " ,"FXI (11)");
RECODE2(I) = TRANWRD(RECODE2(I),"229,9 " ,"FXIII (13)");
RECODE2(I) = TRANWRD(RECODE2(I),"229,10","VWF");
RECODE2(I) = TRANWRD(RECODE2(I),"229,11","PAI-1 deficiency");
The SAS System 06:30 Thursday, August 12, 2021 18

recode
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
RECODE2(I) = TRANWRD(RECODE2(I),"229,12","a2anti-plasmin deficiency");
RECODE2(I) = TRANWRD(RECODE2(I),"229,888","Unknown");
RECODE2(I) = TRANWRD(RECODE2(I),"230,1 " ,"FVIII or FIX concentrates");
RECODE2(I) = TRANWRD(RECODE2(I),"230,2 " ,"Bypassing agents");
RECODE2(I) = TRANWRD(RECODE2(I),"230,3 " ,"Antifibrinolytics");
RECODE2(I) = TRANWRD(RECODE2(I),"230,4 " ,"Corticosteroids");
RECODE2(I) = TRANWRD(RECODE2(I),"230,888","Unknown");
RECODE2(I) = TRANWRD(RECODE2(I),"230,999","Other");
RECODE2(I) = TRANWRD(RECODE2(I),"231,1 " ,"Routine doses and frequency");
RECODE2(I) = TRANWRD(RECODE2(I),"231,2 " ,"Increased doses or frequency or both");
RECODE2(I) = TRANWRD(RECODE2(I),"231,888","Unknown whether dose or frequency is routine or
increased");
RECODE2(I) = TRANWRD(RECODE2(I),"232,1 " ,"Prophylaxis- Continuous");
RECODE2(I) = TRANWRD(RECODE2(I),"232,2 " ,"Prophylaxis- Continuous with by-passing agents plus
ITI");
RECODE2(I) = TRANWRD(RECODE2(I),"232,3 " ,"Prophylaxis- Menstrual bleeding");
RECODE2(I) = TRANWRD(RECODE2(I),"232,4 " ,"Prophylaxis- Event-based, short-term or
intermittent");
RECODE2(I) = TRANWRD(RECODE2(I),"232,5 " ,"Immune tolerance induction without continuous
prophylaxis with a by-passing agent");
RECODE2(I) = TRANWRD(RECODE2(I),"232,6 " ,"Episodic (on-demand)");
RECODE2(I) = TRANWRD(RECODE2(I),"233,1 " ,"Date");
RECODE2(I) = TRANWRD(RECODE2(I),"233,2 " ,"Age");
RECODE2(I) = TRANWRD(RECODE2(I),"233,888","Date or Age Unknown");
RECODE2(I) = TRANWRD(RECODE2(I),"234,1 " ,"Days");
RECODE2(I) = TRANWRD(RECODE2(I),"234,2 " ,"Months");
RECODE2(I) = TRANWRD(RECODE2(I),"234,3 " ,"Years");
RECODE2(I) = TRANWRD(RECODE2(I),"235,1 " ,"<3 years of age");
RECODE2(I) = TRANWRD(RECODE2(I),"235,2 " ,"3-6 years of age");
RECODE2(I) = TRANWRD(RECODE2(I),"235,3 " ,">6 years of age");
RECODE2(I) = TRANWRD(RECODE2(I),"236,1 " ,"Fewer than 2 bleeds total (that is, 0 or 1 bleed
total) into the large joints (ankle, knee, hip, elbow or shoulder)");
RECODE2(I) = TRANWRD(RECODE2(I),"236,2 " ,"2 or more bleeds total into the large joints (ankle,
knee, hip, elbow or shoulder)");
RECODE2(I) = TRANWRD(RECODE2(I),"236,888","Unknown");
RECODE2(I) = TRANWRD(RECODE2(I),"237,1 " ,"Advate");
RECODE2(I) = TRANWRD(RECODE2(I),"237,2 " ,"Alphanate");
RECODE2(I) = TRANWRD(RECODE2(I),"237,3 " ,"AlphaNine SD");
RECODE2(I) = TRANWRD(RECODE2(I),"237,4 " ,"Amicar Syrup (Aminocaproic acid)");
RECODE2(I) = TRANWRD(RECODE2(I),"237,5 " ,"Amicar Tablet (Aminocaproic acid)");
RECODE2(I) = TRANWRD(RECODE2(I),"237,6 " ,"Autoplex T");
RECODE2(I) = TRANWRD(RECODE2(I),"237,7 " ,"Bebulin VH");
RECODE2(I) = TRANWRD(RECODE2(I),"237,8 " ,"BeneFIX");
RECODE2(I) = TRANWRD(RECODE2(I),"237,9 " ,"Bioclate");
RECODE2(I) = TRANWRD(RECODE2(I),"237,10","Corifact (FXIII)");
RECODE2(I) = TRANWRD(RECODE2(I),"237,11","Cryoprecipiteted AHF (Cryoprecipitate)");
RECODE2(I) = TRANWRD(RECODE2(I),"237,12","DDVAP (desmorpressin IV or SQ)");
RECODE2(I) = TRANWRD(RECODE2(I),"237,13","FEIBA NF");
RECODE2(I) = TRANWRD(RECODE2(I),"237,14","FEIBA VH Immuno");
RECODE2(I) = TRANWRD(RECODE2(I),"237,15","Fibrin glue (Tissell, Artiss)");
RECODE2(I) = TRANWRD(RECODE2(I),"237,16","Fibrogammin P (FXIII)");
The SAS System 06:30 Thursday, August 12, 2021 19

recode
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
RECODE2(I) = TRANWRD(RECODE2(I),"237,17","Fresh-frozen plasma");
RECODE2(I) = TRANWRD(RECODE2(I),"237,18","Helixate");
RECODE2(I) = TRANWRD(RECODE2(I),"237,19","Helixate FS");
RECODE2(I) = TRANWRD(RECODE2(I),"237,20","Hemofil M");
RECODE2(I) = TRANWRD(RECODE2(I),"237,21","Humate-P");
RECODE2(I) = TRANWRD(RECODE2(I),"237,22","Hyate:C");
RECODE2(I) = TRANWRD(RECODE2(I),"237,23","Koate-DVI");
RECODE2(I) = TRANWRD(RECODE2(I),"237,24","Kogenate");
RECODE2(I) = TRANWRD(RECODE2(I),"237,25","Kogenate FS");
RECODE2(I) = TRANWRD(RECODE2(I),"237,26","Konyne 80");
RECODE2(I) = TRANWRD(RECODE2(I),"237,27","Monarc-M");
RECODE2(I) = TRANWRD(RECODE2(I),"237,28","Monoclate-P");
RECODE2(I) = TRANWRD(RECODE2(I),"237,29","Mononine");
RECODE2(I) = TRANWRD(RECODE2(I),"237,30","NovoSeven (FVIIa)");
RECODE2(I) = TRANWRD(RECODE2(I),"237,31","Novoseven RT (FVIIa)");
RECODE2(I) = TRANWRD(RECODE2(I),"237,32","Novo13 (rXIII-A2)");
RECODE2(I) = TRANWRD(RECODE2(I),"237,33","Packed RBCs");
RECODE2(I) = TRANWRD(RECODE2(I),"237,34","Platelets");
RECODE2(I) = TRANWRD(RECODE2(I),"237,35","Profilnine SD");
RECODE2(I) = TRANWRD(RECODE2(I),"237,36","Proplex T");
RECODE2(I) = TRANWRD(RECODE2(I),"237,37","Recombinate");
RECODE2(I) = TRANWRD(RECODE2(I),"237,38","ReFacto");
RECODE2(I) = TRANWRD(RECODE2(I),"237,39","RiaSTAP (fibrinogen, FI)");
RECODE2(I) = TRANWRD(RECODE2(I),"237,40","Stimate (Nasal desmopressin)");
RECODE2(I) = TRANWRD(RECODE2(I),"237,41","Topical thrombin (Evithrom, Thrombin-JMI)");
RECODE2(I) = TRANWRD(RECODE2(I),"237,42","Tranexamic acid (Cyclokapron, Lysteda)");
RECODE2(I) = TRANWRD(RECODE2(I),"237,43","Whole blood");
RECODE2(I) = TRANWRD(RECODE2(I),"237,44","Wilate");
RECODE2(I) = TRANWRD(RECODE2(I),"237,45","Xyntha");
RECODE2(I) = TRANWRD(RECODE2(I),"237,46","None");
RECODE2(I) = TRANWRD(RECODE2(I),"237,888","Unknown");
RECODE2(I) = TRANWRD(RECODE2(I),"237,999","Other, specify");
RECODE2(I) = TRANWRD(RECODE2(I),"238,1 " ,"time(s)/week");
RECODE2(I) = TRANWRD(RECODE2(I),"238,2 " ,"time(s)/month");
RECODE2(I) = TRANWRD(RECODE2(I),"238,888","Unknown");
RECODE2(I) = TRANWRD(RECODE2(I),"239,1 " ,"Days");
RECODE2(I) = TRANWRD(RECODE2(I),"239,2 " ,"Hours");
RECODE2(I) = TRANWRD(RECODE2(I),"239,3 " ,"Minutes");
RECODE2(I) = TRANWRD(RECODE2(I),"239,4 " ,"More than 7 days");
RECODE2(I) = TRANWRD(RECODE2(I),"239,888","Unknown");
RECODE2(I) = TRANWRD(RECODE2(I),"240,1 " ,"Left");
RECODE2(I) = TRANWRD(RECODE2(I),"240,2 " ,"Right");
RECODE2(I) = TRANWRD(RECODE2(I),"241,1 " ,"Unrestricted school or work and unrestricted
recreational activities");
RECODE2(I) = TRANWRD(RECODE2(I),"241,2 " ,"Unrestricted school or work with limited recreational
activity levels");
RECODE2(I) = TRANWRD(RECODE2(I),"241,3 " ,"Limited school or work and limited recreational
activity levels");
RECODE2(I) = TRANWRD(RECODE2(I),"241,4 " ,"Limited school or work, limited recreational activity
levels, and limited self-care activity levels");
The SAS System 06:30 Thursday, August 12, 2021 20

recode
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
RECODE2(I) = TRANWRD(RECODE2(I),"241,5 " ,"Requires assistance from another person for school or
work or self-care, and unable to participate in recreation");
RECODE2(I) = TRANWRD(RECODE2(I),"241,888","Unknown");
RECODE2(I) = TRANWRD(RECODE2(I),"242,1 " ,"Every day");
RECODE2(I) = TRANWRD(RECODE2(I),"242,2 " ,"Most days");
RECODE2(I) = TRANWRD(RECODE2(I),"242,3 " ,"Some days");
RECODE2(I) = TRANWRD(RECODE2(I),"242,4 " ,"Never");
RECODE2(I) = TRANWRD(RECODE2(I),"242,888","Unknown");
RECODE2(I) = TRANWRD(RECODE2(I),"243,1 " ,"Completed basic vaccine series");
RECODE2(I) = TRANWRD(RECODE2(I),"243,2 " ,"Incompletely vaccinated");
RECODE2(I) = TRANWRD(RECODE2(I),"243,888","Unknown");
RECODE2(I) = TRANWRD(RECODE2(I),"244,1 " ,"Hepatocellular carcinoma (HCC)");
RECODE2(I) = TRANWRD(RECODE2(I),"244,2 " ,"Leukemia (any type)");
RECODE2(I) = TRANWRD(RECODE2(I),"244,3 " ,"Cancer other than HCC and leukemia");
RECODE2(I) = TRANWRD(RECODE2(I),"245,1 " ,"Fracture of a bone");
RECODE2(I) = TRANWRD(RECODE2(I),"245,2 " ,"Osteopenia");
RECODE2(I) = TRANWRD(RECODE2(I),"245,3 " ,"Osteopenia");
RECODE2(I) = TRANWRD(RECODE2(I),"246,1 " ,"Acute ischemic stroke (AIS)");
RECODE2(I) = TRANWRD(RECODE2(I),"246,2 " ,"Atrial fibrillation");
RECODE2(I) = TRANWRD(RECODE2(I),"246,3 " ,"Coronary artery disease");
RECODE2(I) = TRANWRD(RECODE2(I),"246,4 " ,"Congestive heart failure");
RECODE2(I) = TRANWRD(RECODE2(I),"246,5 " ,"Myocardial infarction");
RECODE2(I) = TRANWRD(RECODE2(I),"246,6 " ,"Transient ischemic attack (TIA)");
RECODE2(I) = TRANWRD(RECODE2(I),"247,1 " ,"Chronic kidney disease/CKD");
RECODE2(I) = TRANWRD(RECODE2(I),"247,2 " ,"Kidney stones (renal urolith, nephrolith,
nephrolithiasis)");
RECODE2(I) = TRANWRD(RECODE2(I),"247,3 " ,"Nephrotic syndrome");
RECODE2(I) = TRANWRD(RECODE2(I),"248,1 " ,"Ascites");
RECODE2(I) = TRANWRD(RECODE2(I),"248,2 " ,"Cirrhosis");
RECODE2(I) = TRANWRD(RECODE2(I),"248,3 " ,"Hepatic fibrosis");
RECODE2(I) = TRANWRD(RECODE2(I),"248,4 " ,"Splenomegaly");
RECODE2(I) = TRANWRD(RECODE2(I),"248,5 " ,"Varices (esophageal or gastric)");
RECODE2(I) = TRANWRD(RECODE2(I),"249,1 " ,"Deep vein thrombosis (DVT)");
RECODE2(I) = TRANWRD(RECODE2(I),"249,2 " ,"Pulmonary embolism (PE)");
RECODE2(I) = TRANWRD(RECODE2(I),"250,1 " ,"Anxiety");
RECODE2(I) = TRANWRD(RECODE2(I),"250,2 " ,"Depression");
RECODE2(I) = TRANWRD(RECODE2(I),"250,3 " ,"Diabetes mellitus (other than gestational
diabetes)");
RECODE2(I) = TRANWRD(RECODE2(I),"250,4 " ,"Hypertension");
RECODE2(I) = TRANWRD(RECODE2(I),"250,5 " ,"Iron deficiency anemia");
RECODE2(I) = TRANWRD(RECODE2(I),"250,6 " ,"Pseudotumor");
RECODE2(I) = TRANWRD(RECODE2(I),"251,1 " ,"<10%");
RECODE2(I) = TRANWRD(RECODE2(I),"251,2 " ,"10-20%");
RECODE2(I) = TRANWRD(RECODE2(I),"251,3 " ,"21-50%");
RECODE2(I) = TRANWRD(RECODE2(I),"251,4 " ,">50%");
RECODE2(I) = TRANWRD(RECODE2(I),"251,888","Unknown");
RECODE2(I) = TRANWRD(RECODE2(I),"252,1 " ,"Bleeding");
RECODE2(I) = TRANWRD(RECODE2(I),"252,2 " ,"Infection");
RECODE2(I) = TRANWRD(RECODE2(I),"252,3 " ,"Mechanical");
RECODE2(I) = TRANWRD(RECODE2(I),"252,4 " ,"Thrombosis");
RECODE2(I) = TRANWRD(RECODE2(I),"252,888","Unknown");
The SAS System 06:30 Thursday, August 12, 2021 21

recode
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
RECODE2(I) = TRANWRD(RECODE2(I),"252,999","Other");
RECODE2(I) = TRANWRD(RECODE2(I),"253,1 " ,"CT (computed tomography)");
RECODE2(I) = TRANWRD(RECODE2(I),"253,2 " ,"MRI (magnetic resonance imaging)");
RECODE2(I) = TRANWRD(RECODE2(I),"253,3 " ,"US (ultrasound)");
RECODE2(I) = TRANWRD(RECODE2(I),"253,888","Imaging type unknown");
RECODE2(I) = TRANWRD(RECODE2(I),"253,999","Other");
RECODE2(I) = TRANWRD(RECODE2(I),"254,0","No");
RECODE2(I) = TRANWRD(RECODE2(I),"254,1 " ,"Yes");
RECODE2(I) = TRANWRD(RECODE2(I),"254,2 " ,"None used");
RECODE2(I) = TRANWRD(RECODE2(I),"254,888","Unknown");
RECODE2(I) = TRANWRD(RECODE2(I),"255,1 " ,"Gastrointestinal");
RECODE2(I) = TRANWRD(RECODE2(I),"255,2 " ,"Genitourinary, Hematuria");
RECODE2(I) = TRANWRD(RECODE2(I),"255,3 " ,"Genitourinary, Other");
RECODE2(I) = TRANWRD(RECODE2(I),"255,4 " ,"Head- Extracranial");
RECODE2(I) = TRANWRD(RECODE2(I),"255,5 " ,"Joint");
RECODE2(I) = TRANWRD(RECODE2(I),"255,6 " ,"Muscle");
RECODE2(I) = TRANWRD(RECODE2(I),"255,7 " ,"Nasal Mucosa (including Epistaxis)");
RECODE2(I) = TRANWRD(RECODE2(I),"255,8 " ,"Oral");
RECODE2(I) = TRANWRD(RECODE2(I),"255,9 " ,"Soft tissue");
RECODE2(I) = TRANWRD(RECODE2(I),"255,10","Spine");
RECODE2(I) = TRANWRD(RECODE2(I),"255,11","Umbilicus");
RECODE2(I) = TRANWRD(RECODE2(I),"255,999","Other");
RECODE2(I) = TRANWRD(RECODE2(I),"256,1 " ,"Circumcision");
RECODE2(I) = TRANWRD(RECODE2(I),"256,2 " ,"Delivery");
RECODE2(I) = TRANWRD(RECODE2(I),"256,3 " ,"Dental procedure");
RECODE2(I) = TRANWRD(RECODE2(I),"256,4 " ,"Iatrogenic");
RECODE2(I) = TRANWRD(RECODE2(I),"256,5 " ,"Injection site");
RECODE2(I) = TRANWRD(RECODE2(I),"256,6 " ,"Lancet stick");
RECODE2(I) = TRANWRD(RECODE2(I),"256,7 " ,"Spontaneous");
RECODE2(I) = TRANWRD(RECODE2(I),"256,8 " ,"Surgery");
RECODE2(I) = TRANWRD(RECODE2(I),"256,9 " ,"Thrombocytopenia");
RECODE2(I) = TRANWRD(RECODE2(I),"256,10","Trauma");
RECODE2(I) = TRANWRD(RECODE2(I),"256,11","Venipuncture");
RECODE2(I) = TRANWRD(RECODE2(I),"256,12","Other medical procedure");
RECODE2(I) = TRANWRD(RECODE2(I),"256,13","Menses");
RECODE2(I) = TRANWRD(RECODE2(I),"256,14","Post-partum");
RECODE2(I) = TRANWRD(RECODE2(I),"256,999","Other");
RECODE2(I) = TRANWRD(RECODE2(I),"257,1 " ,"Ankle, Left");
RECODE2(I) = TRANWRD(RECODE2(I),"257,2 " ,"Ankle, Right");
RECODE2(I) = TRANWRD(RECODE2(I),"257,3 " ,"Elbow, Left");
RECODE2(I) = TRANWRD(RECODE2(I),"257,4 " ,"Elbow, Right");
RECODE2(I) = TRANWRD(RECODE2(I),"257,5 " ,"Hip, Left");
RECODE2(I) = TRANWRD(RECODE2(I),"257,6 " ,"Hip, Right");
RECODE2(I) = TRANWRD(RECODE2(I),"257,7 " ,"Knee, Left");
RECODE2(I) = TRANWRD(RECODE2(I),"257,8 " ,"Knee, Right");
RECODE2(I) = TRANWRD(RECODE2(I),"257,9 " ,"Shoulder, Left");
RECODE2(I) = TRANWRD(RECODE2(I),"257,10","Shoulder, Right");
RECODE2(I) = TRANWRD(RECODE2(I),"258,1 " ,"1-3");
RECODE2(I) = TRANWRD(RECODE2(I),"258,2 " ,"4-19");
RECODE2(I) = TRANWRD(RECODE2(I),"258,3 " ,">/=20");
RECODE2(I) = TRANWRD(RECODE2(I),"258,888","Unknown");
The SAS System 06:30 Thursday, August 12, 2021 22

recode
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
RECODE2(I) = TRANWRD(RECODE2(I),"259,1 " ,"Paper Logs");
RECODE2(I) = TRANWRD(RECODE2(I),"259,2 " ,"Electronic Logs");
RECODE2(I) = TRANWRD(RECODE2(I),"259,3 " ,"Factor Dispensing Records");
RECODE2(I) = TRANWRD(RECODE2(I),"259,4 " ,"Medical Chart");
RECODE2(I) = TRANWRD(RECODE2(I),"259,5 " ,"Routine Patient contact (non-contemporaneous patient
verbal report)");
RECODE2(I) = TRANWRD(RECODE2(I),"259,888","Unknown");
RECODE2(I) = TRANWRD(RECODE2(I),"259,999","Other");
The SAS System 06:30 Thursday, August 12, 2021 23

rec_dx
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
RECODE3(I) = TRANWRD(RECODE3(I),"206,1 ", "VIII (8)");
RECODE3(I) = TRANWRD(RECODE3(I),"206,2 ", "IX (9)");
RECODE3(I) = TRANWRD(RECODE3(I),"206,3 ", "I (afibrinogenemia) (1)");
RECODE3(I) = TRANWRD(RECODE3(I),"206,4 ", "I (dysfibrinogenemia) (1)");
RECODE3(I) = TRANWRD(RECODE3(I),"206,5 ", "I (hypofibrinogenemia) (1)");
RECODE3(I) = TRANWRD(RECODE3(I),"206,6 ", "I (Factor 1, hereditary, unspecified)");
RECODE3(I) = TRANWRD(RECODE3(I),"206,7 ", "II (prothrombin) (2)");
RECODE3(I) = TRANWRD(RECODE3(I),"206,8 ", "V (5)");
RECODE3(I) = TRANWRD(RECODE3(I),"206,9 ", "VII (7)");
RECODE3(I) = TRANWRD(RECODE3(I),"206,10 ", "X (10)");
RECODE3(I) = TRANWRD(RECODE3(I),"206,11 ", "XI (11)");
RECODE3(I) = TRANWRD(RECODE3(I),"206,12 ", "XIII (13)");
RECODE3(I) = TRANWRD(RECODE3(I),"206,13 ", "V-VIII (5/8)");
RECODE3(I) = TRANWRD(RECODE3(I),"206,14 ", "PAI-1 deficiency (plasminogen activator inhibitor-1
deficiency)");
RECODE3(I) = TRANWRD(RECODE3(I),"206,15 ", "a2anti-plasmin deficiency (a2-AP)");
RECODE3(I) = TRANWRD(RECODE3(I),"206,16 ", "VWD Type 1");
RECODE3(I) = TRANWRD(RECODE3(I),"206,17 ", "VWD Type 1C");
RECODE3(I) = TRANWRD(RECODE3(I),"206,18 ", "VWD Type 2A");
RECODE3(I) = TRANWRD(RECODE3(I),"206,19 ", "VWD Type 2B");
RECODE3(I) = TRANWRD(RECODE3(I),"206,20 ", "VWD Type 2M");
RECODE3(I) = TRANWRD(RECODE3(I),"206,21 ", "VWD Type 2N");
RECODE3(I) = TRANWRD(RECODE3(I),"206,22 ", "VWD Type 2, type unknown");
RECODE3(I) = TRANWRD(RECODE3(I),"206,23 ", "VWD Type 3");
RECODE3(I) = TRANWRD(RECODE3(I),"206,24 ", "VWD type unknown");
RECODE3(I) = TRANWRD(RECODE3(I),"206,25 ", "VWD Other");
RECODE3(I) = TRANWRD(RECODE3(I),"206,26 ", "Bernard Soulier");
RECODE3(I) = TRANWRD(RECODE3(I),"206,27 ", "Glanzmann’s thrombasthenia");
RECODE3(I) = TRANWRD(RECODE3(I),"206,28 ", "Grey platelet syndrome");
RECODE3(I) = TRANWRD(RECODE3(I),"206,29 ", "Hermansky-Pudlak syndrome");
RECODE3(I) = TRANWRD(RECODE3(I),"206,30 ", "Inherited thrombocytopenia");
RECODE3(I) = TRANWRD(RECODE3(I),"206,31 ", "Release defect");
RECODE3(I) = TRANWRD(RECODE3(I),"206,32 ", "Storage pool defect");
RECODE3(I) = TRANWRD(RECODE3(I),"206,33 ", "Hereditary platelet function disorder");
RECODE3(I) = TRANWRD(RECODE3(I),"206,34 ", "Ehlers-Danlos syndrome");
RECODE3(I) = TRANWRD(RECODE3(I),"206,35 ", "Blood coagulation disorder with prolonged
coagulation time");
RECODE3(I) = TRANWRD(RECODE3(I),"206,36 ", "Blood coagulation disorder with prolonged bleeding
time");
RECODE3(I) = TRANWRD(RECODE3(I),"206,37 ", "Blood coagulation disorder with impaired clot
retraction time");
The SAS System 06:30 Thursday, August 12, 2021 24

Variable Name
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
AllReactionProd_1
AllReactionProd_2
AllReactionProd_3
AllReactionProd_4
AllReactionProd_5
AllReactionProd_6
AllReactionProd_7
AllReactionProd_8
AllReactionProd_9
AllReactionProd_10
AllReactionProd_11
AllReactionProd_12
AllReactionProd_13
AllReactionProd_14
AllReactionProd_15
AllReactionProd_16
AllReactionProd_17
AllReactionProd_18
AllReactionProd_19
AllReactionProd_20
AllReactionProd_21
AllReactionProd_22
AllReactionProd_23
AllReactionProd_24
AllReactionProd_25
AllReactionProd_26
AllReactionProd_27
AllReactionProd_28
AllReactionProd_29
AllReactionProd_30
AllReactionProd_31
AllReactionProd_32
AllReactionProd_33
AllReactionProd_34
All_Dx_Type_1
All_Dx_Type_2
All_Dx_Type_3
All_Dx_Type_4
AscertainMethodTreatEvents_1
AscertainMethodTreatEvents_2
AscertainMethodTreatEvents_3
AscertainMethodTreatEvents_4
AscertainMethodTreatEvents_5
AscertainMethodTreatEvents_6
AscertainMethod_1
AscertainMethod_2
AscertainMethod_3
AscertainMethod_4
AscertainMethod_5
AscertainMethod_6
CVADComplications_1
The SAS System 06:30 Thursday, August 12, 2021 25

Variable Name
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
CVADComplications_2
CVADComplications_3
CVADComplications_4
CVADComplications_5
CurrentBleedTreat_1
CurrentBleedTreat_2
CurrentBleedTreat_3
CurrentBleedTreat_4
CurrentClotFactorProduct_1
CurrentClotFactorProduct_2
CurrentClotFactorProduct_3
CurrentClotFactorProduct_4
CurrentClotFactorProduct_5
CurrentClotFactorProduct_6
CurrentClotFactorProduct_7
CurrentClotFactorProduct_8
CurrentClotFactorProduct_9
CurrentClotFactorProduct_10
CurrentClotFactorProduct_11
CurrentClotFactorProduct_12
CurrentClotFactorProduct_13
CurrentClotFactorProduct_14
CurrentClotFactorProduct_15
CurrentClotFactorProduct_16
CurrentClotFactorProduct_17
CurrentClotFactorProduct_18
CurrentClotFactorProduct_19
CurrentClotFactorProduct_20
CurrentClotFactorProduct_21
CurrentClotFactorProduct_22
CurrentClotFactorProduct_23
CurrentClotFactorProduct_24
CurrentClotFactorProduct_25
CurrentClotFactorProduct_26
CurrentClotFactorProduct_27
CurrentClotFactorProduct_28
CurrentClotFactorProduct_29
CurrentClotFactorProduct_30
CurrentClotFactorProduct_31
CurrentClotFactorProduct_32
CurrentClotFactorProduct_33
CurrentClotFactorProduct_34
Dx_TypeFPD_1
Dx_TypeFPD_2
Dx_TypeNLD_1
Dx_TypeNLD_2
Dx_TypeVWD_1
Dx_TypeVWD_2
Dx_Type_1
Dx_Type_2
HIO_1
The SAS System 06:30 Thursday, August 12, 2021 26

Variable Name
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
HIO_2
HIO_3
HTCService_1
HTCService_2
HTCService_3
InhibFactorDetect_1
InhibFactorDetect_2
Method_1
Method_2
OtherBleed2_Gastrointestinal_1
OtherBleed2_Gastrointestinal_2
OtherBleed2_Gastrointestinal_3
OtherBleed2_Geni_Hema_1
OtherBleed2_Geni_Hema_2
OtherBleed2_Geni_Oth_1
OtherBleed2_Geni_Oth_2
OtherBleed2_Geni_Oth_3
OtherBleed2_Hea_Extr_1
OtherBleed2_Hea_Extr_2
OtherBleed2_Muscle_1
OtherBleed2_Muscle_2
OtherBleed2_Muscle_3
OtherBleed2_Nasal_Mucosa_1
OtherBleed2_Nasal_Mucosa_2
OtherBleed2_Nasal_Mucosa_3
OtherBleed2_Oral_1
OtherBleed2_Oral_2
OtherBleed2_Oral_3
OtherBleed2_Other_Site_1
OtherBleed2_Other_Site_2
OtherBleed2_Other_Site_3
OtherBleed2_Soft_tissue_1
OtherBleed2_Soft_tissue_2
OtherBleed2_Soft_tissue_3
OtherBleed2_Soft_tissue_4
OtherBleed2_Soft_tissue_5
OtherBleed2_Soft_tissue_6
OtherBleed2_Spine_1
OtherBleed2_Spine_2
OtherBleed_Geni_Hema_1
OtherBleed_Geni_Hema_2
OtherBleed_Genito_Oth_1
OtherBleed_Genito_Oth_2
OtherBleed_Head_Extracranial_1
OtherBleed_Head_Extracranial_2
OtherBleed_Head_Extracranial_3
OtherBleed_Muscle_1
OtherBleed_Nasal_Mucosa_1
OtherBleed_Oral_1
OtherBleed_Other_Site_1
OtherBleed_Other_Site_2
The SAS System 06:30 Thursday, August 12, 2021 27

Variable Name
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
OtherBleed_Soft_tissue_1
OtherBleed_Soft_tissue_2
OtherBleed_Soft_tissue_3
OtherBleed_Umbilicus_1
ProPerf_Arthrodesis_Ankle_1
ProPerf_Arthrodesis_Ankle_2
ProPerf_Arthrodesis_Elbow_1
ProPerf_Arthrodesis_Elbow_2
ProPerf_Arthrodesis_Hip_1
ProPerf_Arthrodesis_Hip_2
ProPerf_Arthrodesis_Knee_1
ProPerf_Arthrodesis_Knee_2
ProPerf_Arthrodesis_Shoulder_1
ProPerf_Arthrodesis_Shoulder_2
ProPerf_Arthrop_Shou_1
ProPerf_Arthrop_Shou_2
ProPerf_Arthroplasty_Ankle_1
ProPerf_Arthroplasty_Ankle_2
ProPerf_Arthroplasty_Elbow_1
ProPerf_Arthroplasty_Elbow_2
ProPerf_Arthroplasty_Hip_1
ProPerf_Arthroplasty_Hip_2
ProPerf_Arthroplasty_Knee_1
ProPerf_Arthroplasty_Knee_2
ProPerf_Arthros_Shou_1
ProPerf_Arthros_Shou_2
ProPerf_Arthroscopic_Ankle_1
ProPerf_Arthroscopic_Ankle_2
ProPerf_Arthroscopic_Elbow_1
ProPerf_Arthroscopic_Elbow_2
ProPerf_Arthroscopic_Hip_1
ProPerf_Arthroscopic_Hip_2
ProPerf_Arthroscopic_Knee_1
ProPerf_Arthroscopic_Knee_2
ProPerf_Joint_Pro_Sho_1
ProPerf_Joint_Pro_Sho_2
ProPerf_Joint_Proc_Ankle_1
ProPerf_Joint_Proc_Ankle_2
ProPerf_Joint_Proc_Elbow_1
ProPerf_Joint_Proc_Elbow_2
ProPerf_Joint_Procedure_Hip_1
ProPerf_Joint_Procedure_Hip_2
ProPerf_Joint_Procedure_Knee_1
ProPerf_Joint_Procedure_Knee_2
ProPerf_Open_Ankle_1
ProPerf_Open_Ankle_2
ProPerf_Open_Elbow_1
ProPerf_Open_Elbow_2
ProPerf_Open_Hip_1
ProPerf_Open_Hip_2
ProPerf_Open_Knee_1
The SAS System 06:30 Thursday, August 12, 2021 28

Variable Name
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
ProPerf_Open_Knee_2
ProPerf_Open_Shoulder_1
ProPerf_Open_Shoulder_2
ProPerf_Radioi_Shou_1
ProPerf_Radioi_Shou_2
ProPerf_Radioisotopic_Ankle_1
ProPerf_Radioisotopic_Ankle_2
ProPerf_Radioisotopic_Elbow_1
ProPerf_Radioisotopic_Elbow_2
ProPerf_Radioisotopic_Hip_1
ProPerf_Radioisotopic_Hip_2
ProPerf_Radioisotopic_Knee_1
ProPerf_Radioisotopic_Knee_2
ProPerf_Type_Unk_Shou_1
ProPerf_Type_Unk_Shou_2
ProPerf_Type_Unknown_Ankle_1
ProPerf_Type_Unknown_Ankle_2
ProPerf_Type_Unknown_Elbow_1
ProPerf_Type_Unknown_Elbow_2
ProPerf_Type_Unknown_Hip_1
ProPerf_Type_Unknown_Hip_2
ProPerf_Type_Unknown_Knee_1
ProPerf_Type_Unknown_Knee_2
Race_1
Race_2
Race_3
Race_4
TreatProd_1
TreatProd_2
TreatProd_3
TreatProd_4
TreatProd_5
TreatProd_6
TreatProd_7
TreatProd_8
TreatProd_9
TreatProd_10
TreatProd_11
TreatProd_12
TreatProd_13
TreatProd_14
TreatProd_15
TreatProd_16
TreatProd_17
TreatProd_18
TreatProd_19
TreatProd_20
TreatProd_21
TreatProd_22
TreatProd_23
TreatProd_24
The SAS System 06:30 Thursday, August 12, 2021 29

Variable Name
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
TreatProd_25
TreatProd_26
TreatProd_27
TreatProd_28
TreatProd_29
TreatProd_30
TreatProd_31
TreatProd_32
TreatProd_33
TreatProd_34
TreatProd_35
TreatProd_36
TreatProd_37
TreatProd_38
TreatProd_39
TreatProd_40
TreatProd_41
TreatProd_42
TreatProd_43
TreatProd_44
TreatProd_45
TreatProd_46
TypeHeadImage_1
TypeHeadImage_2
TypeHeadImage_3
NOTE: PROCEDURE SQL used (Total process time):
real time 0.28 seconds
cpu time 0.07 seconds

NOTE: There were 5289 observations read from the data set WORK._JUNK.
NOTE: The data set WORK._JUNK has 5289 observations and 281 variables.
NOTE: DATA statement used (Total process time):
real time 2:08.27
cpu time 2:08.20

NOTE: There were 5289 observations read from the data set WORK._JUNK.
NOTE: The data set WORK._JUNK has 5289 observations and 281 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.56 seconds
cpu time 0.56 seconds

NOTE: There were 5294 observations read from the data set WORK._REG_ALL.
NOTE: There were 5289 observations read from the data set WORK._JUNK.
NOTE: The data set WORK._PPF_COMBINE has 5294 observations and 571 variables.
NOTE: DATA statement used (Total process time):
real time 0.35 seconds
cpu time 0.36 seconds

NOTE: Numeric values have been converted to character values at the places given by:
(Line):(Column).
2139:1 2139:1 2140:1 2140:1 2145:1 2145:1 2146:1 2146:1 2147:1 2147:1
2148:1 2148:1 2149:1 2149:1 2150:1 2150:1 2151:1 2151:1 2152:1 2152:1
2153:1 2153:1 2154:1 2154:1
NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
10 at 2141:16 117 at 2143:17
NOTE: There were 5294 observations read from the data set WORK._PPF_COMBINE.
NOTE: The data set WORK._PPF_COMBINE has 5294 observations and 587 variables.
NOTE: DATA statement used (Total process time):
real time 0.68 seconds
cpu time 0.68 seconds

WARNING: The variable i in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 5294 observations read from the data set WORK._PPF_COMBINE.
NOTE: The data set WORK._PPF_COMBINE2 has 5294 observations and 588 variables.
NOTE: DATA statement used (Total process time):
real time 0.42 seconds
cpu time 0.34 seconds

NOTE: There were 5294 observations read from the data set WORK._PPF_COMBINE2.
NOTE: The data set WORK._PPF_COMBINE2 has 5294 observations and 588 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.68 seconds
cpu time 0.68 seconds

NOTE: The data set WORK._JUNK has 588 observations and 2 variables.
NOTE: PROCEDURE CONTENTS used (Total process time):
real time 1.18 seconds
cpu time 0.09 seconds

NOTE: There were 588 observations read from the data set WORK._JUNK.
NOTE: The data set WORK._JUNK has 588 observations and 2 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds

NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

WARNING: Multiple lengths were specified for the variable SubjectID by input data set(s). This
can cause truncation of data.
NOTE: There were 2605 observations read from the data set WORK.PPF_FWP_COMBINE3.
NOTE: There were 5294 observations read from the data set WORK._PPF_COMBINE2.
NOTE: The data set WORK.IP_SP_COMBINED has 7899 observations and 588 variables.
NOTE: DATA statement used (Total process time):
real time 0.46 seconds
cpu time 0.46 seconds

NOTE: Deleting WORK._DOSES (memtype=DATA).
NOTE: Deleting WORK._DOSES1 (memtype=DATA).
NOTE: Deleting WORK._DOSES2 (memtype=DATA).
NOTE: Deleting WORK._DOSES3 (memtype=DATA).
NOTE: Deleting WORK._DOSESALL (memtype=DATA).
NOTE: Deleting WORK._DX (memtype=DATA).
NOTE: Deleting WORK._DX1 (memtype=DATA).
NOTE: Deleting WORK._DX2 (memtype=DATA).
NOTE: Deleting WORK._DX3 (memtype=DATA).
NOTE: Deleting WORK._DX4 (memtype=DATA).
NOTE: Deleting WORK._DXC (memtype=DATA).
NOTE: Deleting WORK._ICH (memtype=DATA).
NOTE: Deleting WORK._ICH1 (memtype=DATA).
NOTE: Deleting WORK._ICH2 (memtype=DATA).
NOTE: Deleting WORK._ICH3 (memtype=DATA).
NOTE: Deleting WORK._ICH4 (memtype=DATA).
NOTE: Deleting WORK._ICHALL (memtype=DATA).
NOTE: Deleting WORK._JUNK (memtype=DATA).
NOTE: Deleting WORK._JUNK2 (memtype=DATA).
NOTE: Deleting WORK._LUDC (memtype=DATA).
NOTE: Deleting WORK._LUDC1 (memtype=DATA).
NOTE: Deleting WORK._LUDC2 (memtype=DATA).
NOTE: Deleting WORK._LUDCALL (memtype=DATA).
NOTE: Deleting WORK._PPF_COMBINE (memtype=DATA).
NOTE: Deleting WORK._PPF_COMBINE2 (memtype=DATA).
NOTE: Deleting WORK._REG (memtype=DATA).
NOTE: Deleting WORK._REG_ALL (memtype=DATA).
NOTE: Deleting WORK._SPRO (memtype=DATA).
NOTE: Deleting WORK._SPRO1 (memtype=DATA).
NOTE: Deleting WORK._SPRO2 (memtype=DATA).
NOTE: Deleting WORK._SPRO3 (memtype=DATA).
NOTE: Deleting WORK._SPRO4 (memtype=DATA).
NOTE: Deleting WORK._SPRO5 (memtype=DATA).
NOTE: Deleting WORK._SPROALL (memtype=DATA).
NOTE: Deleting WORK._UCS (memtype=DATA).
NOTE: Deleting WORK._UCS2 (memtype=DATA).
NOTE: Deleting WORK.PPF_FWP_COMBINE3 (memtype=DATA).
NOTE: PROCEDURE DATASETS used (Total process time):
real time 0.18 seconds
cpu time 0.18 seconds

NOTE: There were 7899 observations read from the data set WORK.IP_SP_COMBINED.
NOTE: The data set WORK._ISP has 7899 observations and 589 variables.
NOTE: DATA statement used (Total process time):
real time 0.46 seconds
cpu time 0.46 seconds

Directory

Libref WORK
Engine V9
Physical Name C:\Users\bil7\AppData\Local\Temp\SAS Temporary Files\_TD14916_D347430_
Filename C:\Users\bil7\AppData\Local\Temp\SAS Temporary Files\_TD14916_D347430_

Member
# Name Type File Size Last Modified

1 IE_SE_COMBINED DATA 6GB 08/12/2021 06:34:27
2 IP_SP_COMBINED DATA 494MB 08/12/2021 06:37:46
3 REC DATA 384KB 08/12/2021 06:35:32
4 _ISP DATA 494MB 08/12/2021 06:37:47

NOTE: MODIFY was successful for WORK._ISP.DATA.

NOTE: PROCEDURE DATASETS used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds

NOTE: The data set WORK._VAR_ISP has 589 observations and 2 variables.
NOTE: PROCEDURE CONTENTS used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

NOTE: Numeric values have been converted to character values at the places given by:
(Line):(Column).
2863:32 2864:22
NOTE: There were 589 observations read from the data set WORK._VAR_ISP.
NOTE: The data set WORK._VAR_ISP has 589 observations and 4 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds

NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

NOTE: There were 7899 observations read from the data set WORK._ISP.
NOTE: The data set WORK._ISP2 has 7899 observations and 589 variables.
NOTE: DATA statement used (Total process time):
real time 0.48 seconds
cpu time 0.48 seconds

NOTE: WORK.CLOT data set was successfully created.
NOTE: The data set WORK.CLOT has 1101 observations and 2 variables.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.88 seconds
cpu time 0.56 seconds

NOTE: There were 1101 observations read from the data set WORK.CLOT.
NOTE: The data set WORK.CLOT2 has 1101 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds

NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

NOTE: Numeric values have been converted to character values at the places given by:
(Line):(Column).
2970:34 2975:32 2980:35 3031:1 3034:1 3076:1
NOTE: Character values have been converted to numeric values at the places given by:
(Line):(Column).
3031:92 3034:91 3076:89 3271:90 3282:90
NOTE: There were 7899 observations read from the data set WORK._ISP2.
NOTE: The data set WORK._ISP_C has 7892 observations and 648 variables.
NOTE: DATA statement used (Total process time):
real time 3.12 seconds
cpu time 3.12 seconds

NOTE: There were 7892 observations read from the data set WORK._ISP_C.
NOTE: The data set WORK._ISP_C2 has 7892 observations and 653 variables.
NOTE: DATA statement used (Total process time):
real time 0.68 seconds
cpu time 0.67 seconds

NOTE: Numeric values have been converted to character values at the places given by:
(Line):(Column).
3317:63 3318:62
NOTE: There were 7892 observations read from the data set WORK._ISP_C2.
NOTE: The data set WORK._ISP_C3 has 7892 observations and 653 variables.
NOTE: DATA statement used (Total process time):
real time 1.37 seconds
cpu time 0.76 seconds

NOTE: Numeric values have been converted to character values at the places given by:
(Line):(Column).
3437:9 3441:9 3456:21 3470:22 3541:27 3556:19 3595:21 3596:21 3616:23
3671:24 3699:22 3705:17 3706:17
NOTE: There were 7892 observations read from the data set WORK._ISP_C3.
NOTE: The data set WORK._ISP_C4 has 7892 observations and 807 variables.
NOTE: DATA statement used (Total process time):
real time 1.45 seconds
cpu time 0.89 seconds

NOTE: There were 7892 observations read from the data set WORK._ISP_C4.
NOTE: The data set WORK.IP_SP_COMBINED3 has 7892 observations and 807 variables.
NOTE: DATA statement used (Total process time):
real time 1.40 seconds
cpu time 0.76 seconds

NOTE: The file WORK.IP_SP_COMBINED1 (memtype=DATA) was not found, but appears on a DELETE
statement.
NOTE: Deleting WORK._ISP (memtype=DATA).
NOTE: Deleting WORK._ISP2 (memtype=DATA).
NOTE: Deleting WORK._ISP_C (memtype=DATA).
NOTE: Deleting WORK._ISP_C2 (memtype=DATA).
NOTE: Deleting WORK._ISP_C3 (memtype=DATA).
NOTE: Deleting WORK._ISP_C4 (memtype=DATA).
NOTE: Deleting WORK._VAR_ISP (memtype=DATA).
NOTE: PROCEDURE DATASETS used (Total process time):
real time 1.40 seconds
cpu time 0.57 seconds

Directory

Libref WORK
Engine V9
Physical Name C:\Users\bil7\AppData\Local\Temp\SAS Temporary Files\_TD14916_D347430_
Filename C:\Users\bil7\AppData\Local\Temp\SAS Temporary Files\_TD14916_D347430_

Member
# Name Type File Size Last Modified

1 CLOT DATA 192KB 08/12/2021 06:37:48
2 CLOT2 DATA 256KB 08/12/2021 06:37:48
3 IE_SE_COMBINED DATA 6GB 08/12/2021 06:34:27
4 IP_SP_COMBINED DATA 494MB 08/12/2021 06:37:46
5 IP_SP_COMBINED3 DATA 709MB 08/12/2021 06:37:58
6 REC DATA 384KB 08/12/2021 06:35:32

NOTE: MODIFY was successful for WORK.IE_SE_COMBINED.DATA.

NOTE: PROCEDURE DATASETS used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds

NOTE: There were 7892 observations read from the data set WORK.IP_SP_COMBINED3.
NOTE: The data set WORK._IP_SP_COMBINED4 has 7892 observations and 806 variables.
NOTE: DATA statement used (Total process time):
real time 0.73 seconds
cpu time 0.73 seconds

NOTE: Data source is connected in READ ONLY mode.
NOTE: WORK.KEEP data set was successfully created.
NOTE: The data set WORK.KEEP has 829 observations and 3 variables.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.70 seconds
cpu time 0.31 seconds

NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

NOTE: Numeric values have been converted to character values at the places given by:
(Line):(Column).
4525:35
NOTE: Character values have been converted to numeric values at the places given by:
(Line):(Column).
4525:26
WARNING: The variable _inhi_hemlibra_use in the DROP, KEEP, or RENAME list has never been
referenced.
WARNING: The variable _inhi_mostrcnt_titr_assay in the DROP, KEEP, or RENAME list has never
been referenced.
NOTE: There were 49241 observations read from the data set WORK.IE_SE_COMBINED.
NOTE: There were 7892 observations read from the data set WORK._IP_SP_COMBINED4.
NOTE: The data set WORK._UDC2_MAP has 57133 observations and 488 variables.
NOTE: DATA statement used (Total process time):
real time 8.34 seconds
cpu time 8.23 seconds

NOTE: There were 57133 observations read from the data set WORK._UDC2_MAP.
NOTE: The data set WORK._UDC2_MAP has 57133 observations and 488 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 49.42 seconds
cpu time 13.23 seconds

NOTE: There were 57133 observations read from the data set WORK._UDC2_MAP.
NOTE: The data set WORK._UDC2_MAP2 has 57133 observations and 488 variables.
NOTE: DATA statement used (Total process time):
real time 5.96 seconds
cpu time 4.95 seconds

NOTE: Character values have been converted to numeric values at the places given by:
(Line):(Column).
4833:6 4833:30 4833:55 4833:192 4833:1 4833:1 4833:1 4836:7
4836:31 4836:56 4836:193 4836:1 4836:1 4836:1
NOTE: Numeric values have been converted to character values at the places given by:
(Line):(Column).
4833:201 4836:202
NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
54319 at 4833:23 53567 at 4833:47 53025 at 4833:72 55255 at 4836:24
54765 at 4836:48 54173 at 4836:73 1 at 4836:244 1 at 4836:23
NOTE: There were 57133 observations read from the data set WORK._UDC2_MAP2.
NOTE: The data set WORK._UDC2_MAP3 has 57133 observations and 490 variables.
NOTE: DATA statement used (Total process time):
real time 12.32 seconds
cpu time 5.87 seconds

NOTE: Character values have been converted to numeric values at the places given by:
(Line):(Column).
4955:1 4955:1 4955:1 4955:1
NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
41395 at 4955:43 56930 at 4955:43 57125 at 4955:43 57130 at 4955:43
NOTE: There were 57133 observations read from the data set WORK._UDC2_MAP3.
NOTE: The data set WORK._UDC2_FINAL has 57133 observations and 496 variables.
NOTE: DATA statement used (Total process time):
real time 43.91 seconds
cpu time 39.17 seconds

NOTE: Character values have been converted to numeric values at the places given by:
(Line):(Column).
5003:2 5003:2 5003:2 5003:2 5003:2 5003:1 5003:1 5003:1
5004:2 5004:2 5004:2 5004:2 5004:2 5004:1 5004:1 5004:1
5005:2 5005:2 5005:2 5005:2 5005:2 5005:1 5005:1 5005:1
5006:2 5006:2 5006:2 5006:2 5006:2 5006:1 5006:1 5006:1
5007:2 5007:2 5007:2 5007:2 5007:2 5007:1 5007:1 5007:1
5008:2 5008:2 5008:2 5008:2 5008:2 5008:1 5008:1 5008:1
5009:2 5009:2 5009:2 5009:2 5009:2 5009:1 5009:1 5009:1
5013:2 5013:2 5013:2 5013:2 5013:2 5013:1 5013:1 5013:1
5014:2 5014:2 5014:2 5014:2 5014:2 5014:1 5014:1 5014:1
5015:2 5015:2 5015:2 5015:2 5015:2 5015:1 5015:1 5015:1
5016:2 5016:2 5016:2 5016:2 5016:2 5016:1 5016:1 5016:1
5017:2 5017:2 5017:2 5017:2 5017:2 5017:1 5017:1 5017:1
5018:2 5018:2 5018:2 5018:2 5018:2 5018:1 5018:1 5018:1
5019:2 5019:2 5019:2 5019:2 5019:2 5019:1 5019:1 5019:1
5020:2 5020:2 5020:2 5020:2 5020:2 5020:1 5020:1 5020:1
5021:2 5021:2 5021:2 5021:2 5021:2 5021:1 5021:1 5021:1
5022:2 5022:2 5022:2 5022:2 5022:2 5022:1 5022:1 5022:1
5023:2 5023:2 5023:2 5023:2 5023:2 5023:1 5023:1 5023:1
5024:2 5024:2 5024:2 5024:2 5024:2 5024:1 5024:1 5024:1
5025:2 5025:2 5025:2 5025:2 5025:2 5025:1 5025:1 5025:1
5026:2 5026:2 5026:2 5026:2 5026:2 5026:1 5026:1 5026:1
5027:2 5027:2 5027:2 5027:2 5027:2 5027:1 5027:1 5027:1
5028:2 5028:2 5028:2 5028:2 5028:2 5028:1 5028:1 5028:1
5083:130 5083:1 5093:130 5093:1 5117:1 5117:17 5165:23
NOTE: Numeric values have been converted to character values at the places given by:
(Line):(Column).
5003:111 5003:155 5003:163 5004:111 5004:155 5004:163 5005:111 5005:155
5005:163 5006:111 5006:155 5006:163 5007:111 5007:155 5007:163 5008:111
5008:155 5008:163 5009:111 5009:155 5009:163 5013:111 5013:155 5013:163
5014:111 5014:155 5014:163 5015:111 5015:155 5015:163 5016:111 5016:155
5016:163 5017:111 5017:155 5017:163 5018:111 5018:155 5018:163 5019:111
5019:155 5019:163 5020:111 5020:155 5020:163 5021:111 5021:155 5021:163
5022:111 5022:155 5022:163 5023:111 5023:155 5023:163 5024:111 5024:155
5024:163 5025:111 5025:155 5025:163 5026:111 5026:155 5026:163 5027:111
5027:155 5027:163 5028:111 5028:155 5028:163 5117:22
NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
55669 at 5003:177 56913 at 5004:177 57076 at 5005:177 57113 at 5006:177
57125 at 5007:177 57128 at 5008:177 57130 at 5009:177 18624 at 5013:177
1169 at 5014:177 2564 at 5015:177 39349 at 5016:177 56480 at 5017:177
57107 at 5018:177 57131 at 5019:177 42533 at 5020:177 44311 at 5021:177
21730 at 5022:177 55443 at 5023:177 53025 at 5024:177 54173 at 5025:177
56588 at 5026:177 56202 at 5027:177 56824 at 5028:177 46 at 5035:16
18624 at 5037:25 1169 at 5038:22 2564 at 5039:22 39349 at 5040:21
56480 at 5041:21 57107 at 5042:21 57131 at 5043:21 42533 at 5044:22
44311 at 5045:27 21730 at 5046:30 55443 at 5047:26 54173 at 5048:27
56588 at 5049:23 53025 at 5050:22 46 at 5070:17 46 at 5070:38
46 at 5070:54 46 at 5071:17 46 at 5071:38 46 at 5071:54
39350 at 5073:13 39350 at 5073:35 39350 at 5073:51 56480 at 5074:13
56480 at 5074:35 56480 at 5074:51 57107 at 5075:13 57107 at 5075:35
57107 at 5075:51 57131 at 5076:13 57131 at 5076:35 57131 at 5076:51
55670 at 5085:14 55670 at 5085:35 55670 at 5085:51 56914 at 5086:14
56914 at 5086:35 56914 at 5086:51 57076 at 5087:14 57076 at 5087:35
57076 at 5087:51 57113 at 5088:14 57113 at 5088:35 57113 at 5088:51
57125 at 5089:14 57125 at 5089:35 57125 at 5089:51 57128 at 5090:14
57128 at 5090:35 57128 at 5090:51 57130 at 5091:14 57130 at 5091:35
57130 at 5091:51 410462 at 5117:22 46199 at 5165:53
NOTE: There were 57133 observations read from the data set WORK._UDC2_FINAL.
NOTE: The data set WORK.UDC2_FINAL2 has 57133 observations and 745 variables.
NOTE: DATA statement used (Total process time):
real time 46.75 seconds
cpu time 15.93 seconds

NOTE: Deleting WORK._IP_SP_COMBINED4 (memtype=DATA).
NOTE: Deleting WORK._UDC2_FINAL (memtype=DATA).
NOTE: Deleting WORK._UDC2_MAP (memtype=DATA).
NOTE: Deleting WORK._UDC2_MAP2 (memtype=DATA).
NOTE: Deleting WORK._UDC2_MAP3 (memtype=DATA).
NOTE: Deleting WORK.IE_SE_COMBINED (memtype=DATA).
NOTE: Deleting WORK.IP_SP_COMBINED3 (memtype=DATA).
NOTE: PROCEDURE DATASETS used (Total process time):
real time 4.79 seconds
cpu time 2.54 seconds

NOTE: There were 57133 observations read from the data set WORK.UDC2_FINAL2.
NOTE: The data set WORK.UDC2_FINAL3 has 57133 observations and 746 variables.
NOTE: DATA statement used (Total process time):
real time 3.71 seconds
cpu time 3.00 seconds

NOTE: Libref REFDIR was successfully assigned as follows:
Engine: V9
Physical Name: \\cdc\project\CCHP_NCBDDD_DBD\SHARE\Binh Le\DUKE\BINH\SAS program\cdc

NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
46 at 5240:9 46 at 5240:51 46 at 5240:73
NOTE: There were 57133 observations read from the data set WORK.UDC2_FINAL3.
NOTE: The data set WORK.MYDATA has 27908 observations and 10 variables.
NOTE: DATA statement used (Total process time):
real time 1.95 seconds
cpu time 1.34 seconds

NOTE: There were 27908 observations read from the data set WORK.MYDATA.
NOTE: The data set WORK._ORIG has 27908 observations and 13 variables.
NOTE: The data set WORK._MYDATA has 27908 observations and 13 variables.
NOTE: The data set WORK._OLD has 0 observations and 13 variables.
NOTE: DATA statement used (Total process time):
real time 1.54 seconds
cpu time 0.04 seconds

NOTE: There were 27908 observations read from the data set WORK._MYDATA.
NOTE: The data set WORK._CINAGE has 27908 observations and 16 variables.
NOTE: The data set WORK._CINLEN has 0 observations and 16 variables.
NOTE: The data set WORK._CINHT has 27162 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 1.53 seconds
cpu time 0.11 seconds

NOTE: There were 482 observations read from the data set REFDIR.CDCREF_D.
WHERE denom='age';
NOTE: The data set WORK.CREFAGE has 482 observations and 52 variables.
NOTE: DATA statement used (Total process time):
real time 0.71 seconds
cpu time 0.04 seconds

NOTE: There were 482 observations read from the data set WORK.CREFAGE.
NOTE: The data set WORK.CREFAGE has 482 observations and 52 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.60 seconds
cpu time 0.01 seconds

NOTE: There were 27908 observations read from the data set WORK._CINAGE.
NOTE: The data set WORK._CINAGE has 27908 observations and 16 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.48 seconds
cpu time 0.06 seconds

NOTE: Variable headcir is uninitialized.
NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
161286 at 5336:20 161286 at 5336:28 161286 at 5336:34 161286 at 5336:41
760 at 5353:21
NOTE: There were 27908 observations read from the data set WORK._CINAGE.
NOTE: There were 482 observations read from the data set WORK.CREFAGE.
NOTE: The data set WORK.FINFAGE has 27908 observations and 66 variables.
NOTE: DATA statement used (Total process time):
real time 1.13 seconds
cpu time 0.17 seconds

NOTE: Input data set is empty.
NOTE: The data set WORK._CINLEN has 0 observations and 16 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.46 seconds
cpu time 0.00 seconds

NOTE: There were 118 observations read from the data set REFDIR.CDCREF_D.
WHERE denom='length';
NOTE: The data set WORK.CREFLG has 118 observations and 11 variables.
NOTE: DATA statement used (Total process time):
real time 0.57 seconds
cpu time 0.04 seconds

NOTE: There were 118 observations read from the data set WORK.CREFLG.
NOTE: The data set WORK.CREFLG has 118 observations and 11 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.53 seconds
cpu time 0.01 seconds

NOTE: There were 0 observations read from the data set WORK._CINLEN.
NOTE: There were 118 observations read from the data set WORK.CREFLG.
NOTE: The data set WORK.FINFLG has 0 observations and 9 variables.
NOTE: DATA statement used (Total process time):
real time 0.56 seconds
cpu time 0.04 seconds

NOTE: There were 27162 observations read from the data set WORK._CINHT.
NOTE: The data set WORK._CINHT has 27162 observations and 16 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.21 seconds
cpu time 0.06 seconds

NOTE: There were 90 observations read from the data set REFDIR.CDCREF_D.
WHERE denom='height';
NOTE: The data set WORK.CREFHT has 90 observations and 11 variables.
NOTE: DATA statement used (Total process time):
real time 0.70 seconds
cpu time 0.01 seconds

NOTE: There were 90 observations read from the data set WORK.CREFHT.
NOTE: The data set WORK.CREFHT has 90 observations and 11 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.59 seconds
cpu time 0.01 seconds

NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
51 at 5395:17 51 at 5395:36 153 at 5399:19 153 at 5399:26 153 at 5399:32
153 at 5399:39 51 at 5401:30 51 at 5401:102 51 at 5401:152 51 at 5401:164
51 at 5401:195 51 at 5401:244 51 at 5401:85
NOTE: There were 27162 observations read from the data set WORK._CINHT.
NOTE: There were 90 observations read from the data set WORK.CREFHT.
NOTE: The data set WORK.FINFHT has 5596 observations and 9 variables.
NOTE: DATA statement used (Total process time):
real time 0.06 seconds
cpu time 0.03 seconds

NOTE: Input data set is empty.
NOTE: The data set WORK.FINFLG has 0 observations and 9 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.64 seconds
cpu time 0.01 seconds

NOTE: There were 5596 observations read from the data set WORK.FINFHT.
NOTE: The data set WORK.FINFHT has 5596 observations and 9 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.48 seconds
cpu time 0.03 seconds

NOTE: There were 0 observations read from the data set WORK.FINFLG.
NOTE: There were 5596 observations read from the data set WORK.FINFHT.
NOTE: The data set WORK.LENHT has 5596 observations and 13 variables.
NOTE: DATA statement used (Total process time):
real time 0.54 seconds
cpu time 0.03 seconds

NOTE: There were 27908 observations read from the data set WORK.FINFAGE.
NOTE: The data set WORK.FINFAGE has 27908 observations and 66 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.60 seconds
cpu time 0.09 seconds

NOTE: Variable _bivac is uninitialized.
NOTE: Variable _bivssf is uninitialized.
NOTE: Variable _bivtsf is uninitialized.
NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
391 at 5422:7 391 at 5424:7
NOTE: There were 27908 observations read from the data set WORK.FINFAGE.
NOTE: There were 5596 observations read from the data set WORK.LENHT.
NOTE: The data set WORK._OUTDATA has 27908 observations and 89 variables.
NOTE: DATA statement used (Total process time):
real time 0.70 seconds
cpu time 0.11 seconds

NOTE: There were 27908 observations read from the data set WORK._OUTDATA.
NOTE: The data set WORK._OUTDATA has 27908 observations and 44 variables.
NOTE: DATA statement used (Total process time):
real time 0.62 seconds
cpu time 0.07 seconds

NOTE: There were 27908 observations read from the data set WORK._OUTDATA.
NOTE: There were 0 observations read from the data set WORK._OLD.
NOTE: The data set WORK._OUTDATA has 27908 observations and 53 variables.
NOTE: DATA statement used (Total process time):
real time 0.95 seconds
cpu time 0.07 seconds

NOTE: There were 27908 observations read from the data set WORK._OUTDATA.
NOTE: The data set WORK._OUTDATA has 27908 observations and 53 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 1.01 seconds
cpu time 0.09 seconds

NOTE: There were 27908 observations read from the data set WORK._ORIG.
NOTE: The data set WORK._ORIG has 27908 observations and 13 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.59 seconds
cpu time 0.04 seconds

NOTE: There were 27908 observations read from the data set WORK._OUTDATA.
NOTE: There were 27908 observations read from the data set WORK._ORIG.
NOTE: The data set WORK._CDCDATA has 27908 observations and 36 variables.
NOTE: DATA statement used (Total process time):
real time 0.62 seconds
cpu time 0.07 seconds

NOTE: There were 27908 observations read from the data set WORK._CDCDATA.
NOTE: The data set WORK._PART1 has 27908 observations and 25 variables.
NOTE: DATA statement used (Total process time):
real time 0.59 seconds
cpu time 0.09 seconds

NOTE: Libref REFDIR was successfully assigned as follows:
Engine: V9
Physical Name: \\cdc.gov\project\CCHP_NCBDDD_DBD\SHARE\Binh Le\Community Count\whodata

NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
46 at 5466:9 46 at 5466:51 46 at 5466:73
NOTE: There were 57133 observations read from the data set WORK.UDC2_FINAL3.
NOTE: The data set WORK.MYDATA has 1261 observations and 10 variables.
NOTE: DATA statement used (Total process time):
real time 1.85 seconds
cpu time 1.34 seconds

NOTE: There were 1261 observations read from the data set WORK.MYDATA.
NOTE: The data set WORK._MYDATA has 1261 observations and 14 variables.
NOTE: The data set WORK._WINDATA has 1261 observations and 14 variables.
NOTE: The data set WORK._WOLD has 0 observations and 14 variables.
NOTE: DATA statement used (Total process time):
real time 1.65 seconds
cpu time 0.07 seconds

NOTE: There were 16716 observations read from the data set REFDIR.WHOREF_D.
NOTE: The data set WORK._WREF1 has 1462 observations and 29 variables.
NOTE: DATA statement used (Total process time):
real time 1.10 seconds
cpu time 0.10 seconds

NOTE: There were 1462 observations read from the data set WORK._WREF1.
NOTE: The data set WORK._WREF1 has 1462 observations and 29 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.85 seconds
cpu time 0.03 seconds

NOTE: There were 1261 observations read from the data set WORK._WINDATA.
NOTE: The data set WORK._WINDATA has 1261 observations and 14 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.43 seconds
cpu time 0.01 seconds

NOTE: There were 1462 observations read from the data set WORK._WREF1.
NOTE: There were 1261 observations read from the data set WORK._WINDATA.
NOTE: The data set WORK._WT1 has 1261 observations and 40 variables.
NOTE: DATA statement used (Total process time):
real time 0.29 seconds
cpu time 0.06 seconds

NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
76 at 5504:15 76 at 5504:63 76 at 5504:64 1261 at 5505:20 1261 at 5505:79
1261 at 5505:80 3880 at 5518:6 3880 at 5525:10 3880 at 5525:11
NOTE: There were 1261 observations read from the data set WORK._WT1.
NOTE: The data set WORK._WT1 has 1261 observations and 64 variables.
NOTE: DATA statement used (Total process time):
real time 0.40 seconds
cpu time 0.06 seconds

NOTE: There were 1261 observations read from the data set WORK._WINDATA.
NOTE: The data set WORK._WINDATA2 has 1186 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.35 seconds
cpu time 0.04 seconds

NOTE: There were 13002 observations read from the data set REFDIR.WHOREF_D.
WHERE _denom='forlen';
NOTE: The data set WORK._WREF2 has 13002 observations and 6 variables.
NOTE: DATA statement used (Total process time):
real time 1.25 seconds
cpu time 0.07 seconds

NOTE: There were 13002 observations read from the data set WORK._WREF2.
NOTE: The data set WORK._WREF2 has 13002 observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 1.03 seconds
cpu time 0.03 seconds

NOTE: There were 1186 observations read from the data set WORK._WINDATA2.
NOTE: The data set WORK._WINDATA2 has 1186 observations and 5 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.48 seconds
cpu time 0.03 seconds

NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
15 at 5539:37 15 at 5541:5 15 at 5548:14 15 at 5548:15
NOTE: There were 1186 observations read from the data set WORK._WINDATA2.
NOTE: There were 13002 observations read from the data set WORK._WREF2.
NOTE: The data set WORK._WT2 has 1186 observations and 17 variables.
NOTE: DATA statement used (Total process time):
real time 0.26 seconds
cpu time 0.04 seconds

NOTE: There were 1261 observations read from the data set WORK._WT1.
NOTE: The data set WORK._WT1 has 1261 observations and 64 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.28 seconds
cpu time 0.01 seconds

NOTE: There were 1186 observations read from the data set WORK._WT2.
NOTE: The data set WORK._WT2 has 1186 observations and 17 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.32 seconds
cpu time 0.01 seconds

NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
21 at 5565:7 21 at 5567:7
NOTE: There were 1261 observations read from the data set WORK._WT1.
NOTE: There were 1186 observations read from the data set WORK._WT2.
NOTE: The data set WORK._WD1 has 1261 observations and 78 variables.
NOTE: DATA statement used (Total process time):
real time 0.31 seconds
cpu time 0.04 seconds

NOTE: There were 1261 observations read from the data set WORK._WD1.
NOTE: There were 0 observations read from the data set WORK._WOLD.
NOTE: The data set WORK._WOUTDATA has 1261 observations and 30 variables.
NOTE: DATA statement used (Total process time):
real time 0.28 seconds
cpu time 0.01 seconds

NOTE: There were 1261 observations read from the data set WORK._WOUTDATA.
NOTE: The data set WORK._WOUTDATA has 1261 observations and 30 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.28 seconds
cpu time 0.01 seconds

NOTE: There were 1261 observations read from the data set WORK._MYDATA.
NOTE: The data set WORK._MYDATA has 1261 observations and 14 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.23 seconds
cpu time 0.03 seconds

NOTE: There were 1261 observations read from the data set WORK._WOUTDATA.
NOTE: There were 1261 observations read from the data set WORK._MYDATA.
NOTE: The data set WORK._WHODATA has 1261 observations and 40 variables.
NOTE: DATA statement used (Total process time):
real time 0.10 seconds
cpu time 0.03 seconds

NOTE: There were 1261 observations read from the data set WORK._WHODATA.
NOTE: The data set WORK._WHODATA has 1261 observations and 37 variables.
NOTE: DATA statement used (Total process time):
real time 0.37 seconds
cpu time 0.01 seconds

NOTE: There were 1261 observations read from the data set WORK._WHODATA.
NOTE: The data set WORK._WHODATA2 has 1261 observations and 36 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds

NOTE: There were 27908 observations read from the data set WORK._PART1.
NOTE: The data set WORK._CDCDATA2 has 27908 observations and 24 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds

WARNING: The variable _bmi in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable _bmi_cat in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 1261 observations read from the data set WORK._WHODATA2.
NOTE: There were 27908 observations read from the data set WORK._CDCDATA2.
NOTE: The data set WORK._CALL has 29169 observations and 4 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds

NOTE: There were 29169 observations read from the data set WORK._CALL.
NOTE: The data set WORK._CALL has 29169 observations and 4 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.04 seconds
cpu time 0.03 seconds

NOTE: There were 29169 observations read from the data set WORK._CALL.
NOTE: There were 57133 observations read from the data set WORK.UDC2_FINAL3.
NOTE: The data set WORK._CALL2 has 57133 observations and 749 variables.
NOTE: DATA statement used (Total process time):
real time 3.63 seconds
cpu time 3.21 seconds

NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
74 at 5610:39 2649 at 5610:68 668983 at 5646:8 56588 at 5666:19
56588 at 5666:44 56588 at 5666:60
NOTE: There were 57133 observations read from the data set WORK._CALL2.
NOTE: The data set WORK._FINAL has 57133 observations and 775 variables.
NOTE: DATA statement used (Total process time):
real time 4.28 seconds
cpu time 3.42 seconds

NOTE: There were 57133 observations read from the data set WORK._FINAL.
NOTE: The data set WORK._A has 57133 observations and 6 variables.
NOTE: DATA statement used (Total process time):
real time 2.04 seconds
cpu time 1.40 seconds

NOTE: There were 57133 observations read from the data set WORK._A.
NOTE: The data set WORK._B has 57133 observations and 37 variables.
NOTE: DATA statement used (Total process time):
real time 1.90 seconds
cpu time 0.84 seconds

NOTE: IML Ready
NOTE: Closing WORK._B

NOTE: Exiting IML.
NOTE: PROCEDURE IML used (Total process time):
real time 4.43 seconds
cpu time 1.73 seconds

NOTE: PROCEDURE SQL used (Total process time):
real time 0.06 seconds
cpu time 0.06 seconds

NOTE: There were 57133 observations read from the data set WORK._B1.
NOTE: The data set WORK._SET1 has 57133 observations and 34 variables.
NOTE: DATA statement used (Total process time):
real time 1.21 seconds
cpu time 0.18 seconds

NOTE: There were 57133 observations read from the data set WORK._SET1.
NOTE: The data set WORK._SET1 has 57133 observations and 34 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 1.73 seconds
cpu time 0.34 seconds

NOTE: There were 57133 observations read from the data set WORK._B1.
NOTE: The data set WORK._SET2 has 57133 observations and 34 variables.
NOTE: DATA statement used (Total process time):
real time 0.70 seconds
cpu time 0.15 seconds

NOTE: There were 57133 observations read from the data set WORK._SET2.
NOTE: The data set WORK._SET2 has 57133 observations and 34 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 1.53 seconds
cpu time 0.36 seconds

NOTE: There were 57133 observations read from the data set WORK._B1.
NOTE: The data set WORK._SET3 has 57133 observations and 34 variables.
NOTE: DATA statement used (Total process time):
real time 0.63 seconds
cpu time 0.17 seconds

NOTE: There were 57133 observations read from the data set WORK._SET3.
NOTE: The data set WORK._SET3 has 57133 observations and 34 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 1.07 seconds
cpu time 0.40 seconds

NOTE: There were 57133 observations read from the data set WORK._B1.
NOTE: The data set WORK._SET4 has 57133 observations and 34 variables.
NOTE: DATA statement used (Total process time):
real time 0.70 seconds
cpu time 0.17 seconds

NOTE: There were 57133 observations read from the data set WORK._SET4.
NOTE: The data set WORK._SET4 has 57133 observations and 34 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 2.09 seconds
cpu time 0.35 seconds

NOTE: There were 57133 observations read from the data set WORK._B1.
NOTE: The data set WORK._SET5 has 57133 observations and 34 variables.
NOTE: DATA statement used (Total process time):
real time 1.15 seconds
cpu time 0.17 seconds

NOTE: There were 57133 observations read from the data set WORK._SET5.
NOTE: The data set WORK._SET5 has 57133 observations and 34 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 2.04 seconds
cpu time 0.39 seconds

NOTE: There were 57133 observations read from the data set WORK._B1.
NOTE: The data set WORK._SET6 has 57133 observations and 34 variables.
NOTE: DATA statement used (Total process time):
real time 0.71 seconds
cpu time 0.17 seconds

NOTE: There were 57133 observations read from the data set WORK._SET6.
NOTE: The data set WORK._SET6 has 57133 observations and 34 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 1.32 seconds
cpu time 0.37 seconds

NOTE: There were 57133 observations read from the data set WORK._B1.
NOTE: The data set WORK._SET7 has 57133 observations and 34 variables.
NOTE: DATA statement used (Total process time):
real time 0.76 seconds
cpu time 0.17 seconds

NOTE: There were 57133 observations read from the data set WORK._SET7.
NOTE: The data set WORK._SET7 has 57133 observations and 34 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 2.09 seconds
cpu time 0.39 seconds

NOTE: MERGE statement has more than one data set with repeats of BY values.
NOTE: There were 57133 observations read from the data set WORK._SET1.
NOTE: There were 57133 observations read from the data set WORK._SET2.
NOTE: There were 57133 observations read from the data set WORK._SET3.
NOTE: There were 57133 observations read from the data set WORK._SET4.
NOTE: There were 57133 observations read from the data set WORK._SET5.
NOTE: There were 57133 observations read from the data set WORK._SET6.
NOTE: There were 57133 observations read from the data set WORK._SET7.
NOTE: The data set WORK._ALL has 57133 observations and 98 variables.
NOTE: DATA statement used (Total process time):
real time 1.98 seconds
cpu time 1.14 seconds

NOTE: There were 57133 observations read from the data set WORK._ALL.
NOTE: The data set WORK._JUNK has 57133 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 1.42 seconds
cpu time 0.76 seconds

NOTE: There were 57133 observations read from the data set WORK._JUNK.
NOTE: The data set WORK._JUNK has 57133 observations and 16 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 2.21 seconds
cpu time 0.62 seconds

NOTE: There were 57133 observations read from the data set WORK._FINAL.
NOTE: The data set WORK._FINAL has 57133 observations and 775 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 1:23.20
cpu time 15.26 seconds

NOTE: MERGE statement has more than one data set with repeats of BY values.
NOTE: There were 57133 observations read from the data set WORK._JUNK.
NOTE: There were 57133 observations read from the data set WORK._FINAL.
NOTE: The data set WORK._FINAL2 has 57133 observations and 788 variables.
NOTE: DATA statement used (Total process time):
real time 4.77 seconds
cpu time 3.84 seconds

NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
9 at 5916:5
NOTE: There were 57133 observations read from the data set WORK._FINAL2.
NOTE: The data set WORK._CC_IV_SV_JUNK has 57133 observations and 794 variables.
NOTE: DATA statement used (Total process time):
real time 41.94 seconds
cpu time 14.15 seconds

NOTE: There were 57133 observations read from the data set WORK._CC_IV_SV_JUNK.
NOTE: The data set WORK._CC_IV_SV_JUNK has 57133 observations and 794 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 1:49.30
cpu time 19.62 seconds

NOTE: There were 57133 observations read from the data set WORK._CC_IV_SV_JUNK.
NOTE: The data set WORK.CC_IV_SV has 57133 observations and 794 variables.
NOTE: DATA statement used (Total process time):
real time 6.34 seconds
cpu time 5.51 seconds

NOTE: Deleting WORK._A (memtype=DATA).
NOTE: Deleting WORK._ALL (memtype=DATA).
NOTE: Deleting WORK._B (memtype=DATA).
NOTE: Deleting WORK._B1 (memtype=DATA).
NOTE: Deleting WORK._CALL (memtype=DATA).
NOTE: Deleting WORK._CALL2 (memtype=DATA).
NOTE: Deleting WORK._CC_IV_SV_JUNK (memtype=DATA).
NOTE: Deleting WORK._CDCDATA (memtype=DATA).
NOTE: Deleting WORK._CDCDATA2 (memtype=DATA).
NOTE: Deleting WORK._CINAGE (memtype=DATA).
NOTE: Deleting WORK._CINHT (memtype=DATA).
NOTE: Deleting WORK._CINLEN (memtype=DATA).
NOTE: Deleting WORK._FINAL (memtype=DATA).
NOTE: Deleting WORK._FINAL2 (memtype=DATA).
NOTE: Deleting WORK._JUNK (memtype=DATA).
NOTE: Deleting WORK._MYDATA (memtype=DATA).
NOTE: Deleting WORK._OLD (memtype=DATA).
NOTE: Deleting WORK._ORIG (memtype=DATA).
NOTE: Deleting WORK._OUTDATA (memtype=DATA).
NOTE: Deleting WORK._PART1 (memtype=DATA).
NOTE: Deleting WORK._SET1 (memtype=DATA).
NOTE: Deleting WORK._SET2 (memtype=DATA).
NOTE: Deleting WORK._SET3 (memtype=DATA).
NOTE: Deleting WORK._SET4 (memtype=DATA).
NOTE: Deleting WORK._SET5 (memtype=DATA).
NOTE: Deleting WORK._SET6 (memtype=DATA).
NOTE: Deleting WORK._SET7 (memtype=DATA).
NOTE: Deleting WORK._WD1 (memtype=DATA).
NOTE: Deleting WORK._WHODATA (memtype=DATA).
NOTE: Deleting WORK._WHODATA2 (memtype=DATA).
NOTE: Deleting WORK._WINDATA (memtype=DATA).
NOTE: Deleting WORK._WINDATA2 (memtype=DATA).
NOTE: Deleting WORK._WOLD (memtype=DATA).
NOTE: Deleting WORK._WOUTDATA (memtype=DATA).
NOTE: Deleting WORK._WREF1 (memtype=DATA).
NOTE: Deleting WORK._WREF2 (memtype=DATA).
NOTE: Deleting WORK._WT1 (memtype=DATA).
NOTE: Deleting WORK._WT2 (memtype=DATA).
NOTE: Deleting WORK.UDC2_FINAL3 (memtype=DATA).
NOTE: Deleting WORK.MYDATA (memtype=DATA).
NOTE: Deleting WORK.CREFAGE (memtype=DATA).
NOTE: Deleting WORK.CREFHT (memtype=DATA).
NOTE: Deleting WORK.CREFLG (memtype=DATA).
NOTE: Deleting WORK.FINFAGE (memtype=DATA).
NOTE: Deleting WORK.FINFHT (memtype=DATA).
NOTE: Deleting WORK.FINFLG (memtype=DATA).
NOTE: Deleting WORK.LENHT (memtype=DATA).
NOTE: PROCEDURE DATASETS used (Total process time):
real time 11.34 seconds
cpu time 2.64 seconds

NOTE: There were 57133 observations read from the data set WORK.CC_IV_SV.
NOTE: The data set WORK.CC_IV_SV has 57133 observations and 794 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 39.66 seconds
cpu time 13.06 seconds

NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
22689 at 6018:4 46 at 6044:5 156 at 6044:37
NOTE: There were 57133 observations read from the data set WORK.CC_IV_SV.
NOTE: The data set WORK._AAA has 57133 observations and 812 variables.
NOTE: DATA statement used (Total process time):
real time 7.06 seconds
cpu time 6.00 seconds

NOTE: WORK._VARNAME data set was successfully created.
NOTE: The data set WORK._VARNAME has 456 observations and 12 variables.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.71 seconds
cpu time 0.34 seconds

NOTE: There were 456 observations read from the data set WORK._VARNAME.
NOTE: The data set WORK._VARNAME has 456 observations and 13 variables.
NOTE: DATA statement used (Total process time):
real time 0.35 seconds
cpu time 0.03 seconds

NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

WARNING: Variable SubjectID already exists on file WORK._OUT1.
WARNING: Variable first_treat_ble_date already exists on file WORK._OUT1.
WARNING: Variable _first_treat_ble_date already exists on file WORK._OUT1.
WARNING: Variable circum_exce_ble already exists on file WORK._OUT1.
WARNING: Variable _circum_exce_ble already exists on file WORK._OUT1.
NOTE: There were 57133 observations read from the data set WORK._AAA.
NOTE: The data set WORK._OUT1 has 57133 observations and 807 variables.
NOTE: DATA statement used (Total process time):
real time 34.80 seconds
cpu time 10.15 seconds

NOTE: There were 57133 observations read from the data set WORK._OUT1.
NOTE: The data set WORK._TEMP has 57133 observations and 808 variables.
NOTE: DATA statement used (Total process time):
real time 50.74 seconds
cpu time 13.95 seconds

NOTE: There were 176 observations read from the data set SQLUDC.T_HTCADDRESS.
NOTE: The data set WORK.ZIP_HTC has 174 observations and 4 variables.
NOTE: DATA statement used (Total process time):
real time 0.60 seconds
cpu time 0.03 seconds

NOTE: There were 174 observations read from the data set WORK.ZIP_HTC.
NOTE: The data set WORK.ZIP_HTC has 174 observations and 4 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.65 seconds
cpu time 0.01 seconds

NOTE: There were 57133 observations read from the data set WORK._TEMP.
NOTE: The data set WORK._TEMP has 57133 observations and 808 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 1:58.78
cpu time 19.29 seconds

NOTE: There were 57133 observations read from the data set WORK._TEMP.
NOTE: There were 174 observations read from the data set WORK.ZIP_HTC.
NOTE: The data set WORK._GIS1 has 57133 observations and 811 variables.
NOTE: DATA statement used (Total process time):
real time 6.34 seconds
cpu time 5.61 seconds

NOTE: Libref BINH was successfully assigned as follows:
Engine: V9
Physical Name: \\cdc.gov\project\CCHP_NCBDDD_DBD\SHARE\Binh Le\SAS\ZIPCODE

NOTE: There were 41262 observations read from the data set BINH.ZIPCODE_FINAL.
NOTE: The data set WORK.ZIP_PT has 41262 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 2.32 seconds
cpu time 0.21 seconds

NOTE: There were 41262 observations read from the data set WORK.ZIP_PT.
NOTE: The data set WORK.ZIP_PT has 41262 observations and 2 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 1.46 seconds
cpu time 0.04 seconds

NOTE: There were 57133 observations read from the data set WORK._GIS1.
NOTE: The data set WORK._GIS1 has 57133 observations and 811 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 1:30.28
cpu time 17.40 seconds

NOTE: There were 41262 observations read from the data set WORK.ZIP_PT.
NOTE: There were 57133 observations read from the data set WORK._GIS1.
NOTE: The data set WORK._GIS2 has 57133 observations and 812 variables.
NOTE: DATA statement used (Total process time):
real time 6.57 seconds
cpu time 5.76 seconds

NOTE: There were 57133 observations read from the data set WORK._GIS2.
NOTE: The data set WORK.PTWO1 has 57133 observations and 813 variables.
NOTE: DATA statement used (Total process time):
real time 39.57 seconds
cpu time 12.90 seconds

NOTE: WORK.CLOT data set was successfully created.
NOTE: The data set WORK.CLOT has 1101 observations and 3 variables.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 1.92 seconds
cpu time 0.59 seconds

NOTE: There were 1101 observations read from the data set WORK.CLOT.
NOTE: The data set WORK.LIST2 has 1101 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.60 seconds
cpu time 0.04 seconds

NOTE: There were 1101 observations read from the data set WORK.LIST2.
NOTE: 80 observations with duplicate key values were deleted.
NOTE: The data set WORK.LIST2 has 1021 observations and 2 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.93 seconds
cpu time 0.01 seconds

NOTE: There were 1021 observations read from the data set WORK.LIST2.
NOTE: The data set WORK.LIST3 has 1021 observations and 7 variables.
NOTE: DATA statement used (Total process time):
real time 0.81 seconds
cpu time 0.04 seconds

NOTE: There were 1101 observations read from the data set WORK.CLOT.
NOTE: The data set WORK.CLOT2 has 464 observations and 8 variables.
NOTE: DATA statement used (Total process time):
real time 1.92 seconds
cpu time 0.03 seconds

NOTE: PROCEDURE SQL used (Total process time):
real time 0.04 seconds
cpu time 0.04 seconds

NOTE: There were 57133 observations read from the data set WORK.PTWO1.
NOTE: The data set WORK.A has 57133 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 4.18 seconds
cpu time 3.51 seconds

The SAS System 06:30 Thursday, August 12, 2021 30

ƒƒƒƒƒƒƒƒ
13
The SAS System 06:30 Thursday, August 12, 2021 31

ƒƒƒƒƒƒƒƒ
4
The SAS System 06:30 Thursday, August 12, 2021 32

ƒƒƒƒƒƒƒƒ
5
NOTE: PROCEDURE SQL used (Total process time):
real time 2.40 seconds
cpu time 0.09 seconds

13+0 is 13
4+0 is 4
5+0 is 5

NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
42533 at 6516:9 44311 at 6517:11 46 at 6518:10 1 at 6521:36
1 at 6521:63 1 at 6521:77 1 at 6523:45 1 at 6523:74
1 at 6523:90
NOTE: There were 57133 observations read from the data set WORK.PTWO1.
NOTE: The data set WORK._TEMP1 has 57133 observations and 926 variables.
NOTE: DATA statement used (Total process time):
real time 43.00 seconds
cpu time 31.18 seconds

NOTE: There were 57133 observations read from the data set WORK._TEMP1.
NOTE: The data set WORK.INSERT has 57133 observations and 456 variables.
NOTE: DATA statement used (Total process time):
real time 49.55 seconds
cpu time 9.09 seconds

NOTE: Libref CC was successfully assigned as follows:
Engine: V9
Physical Name: \\cdc.gov\project\CCHP_NCBDDD_DBD\SHARE\Binh Le\CC DATA

NOTE: There were 57133 observations read from the data set WORK.INSERT.
NOTE: The data set CC.CC_IV_SV_RAW_COMBINE has 57133 observations and 456 variables.
NOTE: DATA statement used (Total process time):
real time 42.97 seconds
cpu time 21.65 seconds

NOTE: There were 57133 observations read from the data set WORK.INSERT.
NOTE: The data set WORK._DM has 56633 observations and 456 variables.
NOTE: DATA statement used (Total process time):
real time 3.99 seconds
cpu time 3.07 seconds

NOTE: There were 16382 observations read from the data set WORK._DM.
WHERE _source='IE';
NOTE: 15517 observations with unique key values were deleted.
NOTE: The data set WORK._UNIQUE_IE has 15517 observations and 456 variables.
NOTE: The data set WORK._DUP_IE has 865 observations and 456 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 11.49 seconds
cpu time 3.06 seconds

NOTE: There were 865 observations read from the data set WORK._DUP_IE.
NOTE: The data set WORK._DUP_IE has 865 observations and 456 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.71 seconds
cpu time 0.17 seconds

NOTE: There were 865 observations read from the data set WORK._DUP_IE.
NOTE: 444 observations with duplicate key values were deleted.
NOTE: The data set WORK._DE_DUP_IE has 421 observations and 456 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.59 seconds
cpu time 0.12 seconds

NOTE: There were 15517 observations read from the data set WORK._UNIQUE_IE.
NOTE: There were 421 observations read from the data set WORK._DE_DUP_IE.
NOTE: The data set WORK._ALL_IE has 15938 observations and 456 variables.
NOTE: DATA statement used (Total process time):
real time 9.85 seconds
cpu time 1.73 seconds

NOTE: There were 5275 observations read from the data set WORK._DM.
WHERE _source='IP';
NOTE: The data set WORK._ALL_IP has 5275 observations and 456 variables.
NOTE: DATA statement used (Total process time):
real time 3.18 seconds
cpu time 1.71 seconds

NOTE: There were 5275 observations read from the data set WORK._ALL_IP.
NOTE: There were 15938 observations read from the data set WORK._ALL_IE.
NOTE: The data set WORK._JUNK_IV has 21213 observations and 456 variables.
NOTE: DATA statement used (Total process time):
real time 17.96 seconds
cpu time 2.73 seconds

NOTE: There were 21213 observations read from the data set WORK._JUNK_IV.
NOTE: 20099 observations with unique key values were deleted.
NOTE: The data set WORK._UNIQUE_IV has 20099 observations and 456 variables.
NOTE: The data set WORK._DUP_IV has 1114 observations and 456 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 18.55 seconds
cpu time 3.26 seconds

NOTE: There were 1114 observations read from the data set WORK._DUP_IV.
NOTE: The data set WORK._DUP_IV has 1114 observations and 456 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.78 seconds
cpu time 0.18 seconds

NOTE: There were 1114 observations read from the data set WORK._DUP_IV.
NOTE: 262 observations with duplicate key values were deleted.
NOTE: The data set WORK._DE_DUP_IV1 has 852 observations and 456 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.74 seconds
cpu time 0.15 seconds

NOTE: There were 852 observations read from the data set WORK._DE_DUP_IV1.
NOTE: The data set WORK._DE_DUP_IV1 has 852 observations and 456 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.70 seconds
cpu time 0.14 seconds

NOTE: There were 852 observations read from the data set WORK._DE_DUP_IV1.
NOTE: 295 observations with duplicate key values were deleted.
NOTE: The data set WORK._DE_DUP_IV2 has 557 observations and 456 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.73 seconds
cpu time 0.15 seconds

NOTE: There were 20099 observations read from the data set WORK._UNIQUE_IV.
NOTE: There were 557 observations read from the data set WORK._DE_DUP_IV2.
NOTE: The data set WORK._ALL_IV has 20656 observations and 456 variables.
NOTE: DATA statement used (Total process time):
real time 13.52 seconds
cpu time 2.36 seconds

NOTE: There were 32381 observations read from the data set WORK._DM.
WHERE _source='SE';
NOTE: 31552 observations with unique key values were deleted.
NOTE: The data set WORK._UNIQUE_SE has 31552 observations and 456 variables.
NOTE: The data set WORK._DUP_SE has 829 observations and 456 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 30.69 seconds
cpu time 5.60 seconds

NOTE: There were 829 observations read from the data set WORK._DUP_SE.
NOTE: The data set WORK._DUP_SE has 829 observations and 456 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 1.06 seconds
cpu time 0.15 seconds

NOTE: There were 829 observations read from the data set WORK._DUP_SE.
NOTE: 425 observations with duplicate key values were deleted.
NOTE: The data set WORK._DE_DUP_SE has 404 observations and 456 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 1.54 seconds
cpu time 0.11 seconds

NOTE: There were 31552 observations read from the data set WORK._UNIQUE_SE.
NOTE: There were 404 observations read from the data set WORK._DE_DUP_SE.
NOTE: The data set WORK._ALL_SE has 31956 observations and 456 variables.
NOTE: DATA statement used (Total process time):
real time 22.12 seconds
cpu time 4.04 seconds

NOTE: There were 2595 observations read from the data set WORK._DM.
WHERE _source='SP';
NOTE: The data set WORK._ALL_SP has 2595 observations and 456 variables.
NOTE: DATA statement used (Total process time):
real time 3.34 seconds
cpu time 1.23 seconds

NOTE: There were 2595 observations read from the data set WORK._ALL_SP.
NOTE: There were 31956 observations read from the data set WORK._ALL_SE.
NOTE: The data set WORK._ALL_SV has 34551 observations and 456 variables.
NOTE: DATA statement used (Total process time):
real time 28.33 seconds
cpu time 4.57 seconds

NOTE: There were 34551 observations read from the data set WORK._ALL_SV.
NOTE: There were 20656 observations read from the data set WORK._ALL_IV.
NOTE: The data set CC.CC_IV_SV_ANALYSIS_COMBINE has 55207 observations and 456 variables.
NOTE: DATA statement used (Total process time):
real time 59.81 seconds
cpu time 25.57 seconds

12
MPRINT(OPT): options emailhost=smtpgw.cdc.gov emailsys=SMTP nocenter nodate;
MPRINT(OPT): title;
MPRINT(OPT): options EMAILID ="bil7@cdc.gov";
SYMBOLGEN: Macro variable DAY resolves to 12
SYMBOLGEN: Macro variable DAY resolves to 12
SYMBOLGEN: Macro variable DAY resolves to 12
SYMBOLGEN: Macro variable DAY resolves to 12
MLOGIC(OPT): %IF condition &day=1|&day=7|&day=15|&day=22 is FALSE
MPRINT(OPT): FILENAME ERRREPT EMAIL EMAILSYS=SMTP to=("bil7@cdc.gov" ) subject="Combined Community Counts Dataset Creation."
content_type="text/html" ;
MLOGIC(OPT): Ending execution.
MLOGIC(AUTORUN): Beginning execution.
MPRINT(AUTORUN): data _null_;
MPRINT(AUTORUN): file ERRREPT;
MPRINT(AUTORUN): put "Hello,"/;
MPRINT(AUTORUN): put " "/;
WARNING: Apparent symbolic reference SERVER not resolved.
MPRINT(AUTORUN): put "The program to create the TWO combine community counts datasets on &server. has run.";
MPRINT(AUTORUN): put "Thank you ";
MPRINT(AUTORUN): put "Binh & Fred";
MPRINT(AUTORUN): run;

NOTE: The file ERRREPT is:
E-Mail Access Device

Message sent
To: "bil7@cdc.gov"
Cc:
Bcc:
Subject: Combined Community Counts Dataset Creation.
Attachments:
NOTE: 7 records were written to the file ERRREPT.
The minimum record length was 0.
The maximum record length was 91.
NOTE: DATA statement used (Total process time):
real time 0.17 seconds
cpu time 0.04 seconds

MLOGIC(AUTORUN): Ending execution.

NOTE: AUTOEXEC processing completed.

NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 30:58.18
cpu time 10:49.60

Re: Updating big dataset

SASKiwi — Thu, 12 Aug 2021 19:59:20 GMT

@binhle50 - Optimising program performance isn't rocket science. Identify your slowest steps and focus on improving those first. If you want guidance on that then post the SAS logs of two or three of your slowest steps so we can advise.

Re: Updating big dataset

binhle50 — Thu, 12 Aug 2021 20:02:56 GMT

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

Best,

Le

Re: Updating big dataset

jimbarbour — Thu, 12 Aug 2021 20:07:46 GMT

Le,

Can you please run the following code and post the entire log?

PROC OPTIONS OPTION=(Threads CPUcount); 
RUN;

Please use the proper log icon to post the log.

Jim

Re: Updating big dataset

binhle50 — Thu, 12 Aug 2021 20:13:03 GMT

NOTE: Copyright (c) 2002-2012 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software 9.4 (TS1M3)
Licensed to US CENTERS FOR DISEASE CONTROL & PRVNTN, Site 70024534.
NOTE: This session is executing on the W32_8PRO platform.

NOTE: Updated analytical products:

SAS/STAT 14.1
SAS/ETS 14.1
SAS/OR 14.1
SAS/IML 14.1
SAS/QC 14.1

NOTE: Additional host information:

W32_8PRO WIN 6.2.9200 Workstation

NOTE: SAS initialization used:
real time 2.63 seconds
cpu time 2.23 seconds

1 proc options option=(Threads CPUcount);
2 run;

SAS (r) Proprietary Software Release 9.4 TS1M3

THREADS Uses threaded processing for SAS applications that support it.
CPUCOUNT=4 Specifies the number of processors that thread-enabled applications should
assume are available for concurrent processing.
NOTE: PROCEDURE OPTIONS used (Total process time):
real time 0.09 seconds
cpu time 0.01 seconds

Re: Updating big dataset

SASKiwi — Thu, 12 Aug 2021 22:17:11 GMT

@binhle50 - Looks like you are running SAS on a PC using 32-bit Microsoft Windows 8 Professional. Running SAS on very old hardware and OS plus only 32-bit is a massive handbrake before you even start optimising. It would be really worth your while trialing your program on a more recent PC running 64-bit Windows 10 to see if it speeds it up, assuming you have access to such a PC.

Edit: As I understand it 32-bit Windows restricts SAS memory usage to around 2GB maximum. With lots of variables this could be having a major impact. Have a look at Windows Task Manager while your program is running to see if you are maxing out CPU or memory or both.

Re: Updating big dataset

Reeza — Thu, 12 Aug 2021 20:39:19 GMT

If you provide vague details to your process you're going to get vague suggestions back. If you want to provide the actual code you'll get more specific suggestions.

Re: Updating big dataset

jimbarbour — Thu, 12 Aug 2021 21:20:44 GMT

OK, so you do have THREADS turned on and your CPUcount set to 4. Those settings are pretty normal. If you had NOTHREADS, I'd be concerned, but these settings are fine. I don't think there's anything to optimize here.

I think @SASKiwi has a really good point. If you're running on a 32 bit machine running Windows 8, you're going to have some constraints that would be removed if you were running on a 64 bit machine with a newer operating system.

It's still worth looking at the other things that I mentioned in my earlier post, but if you can run on a newer machine -- or on a server or a grid environment, that might be the quickest way to improve performance.

Jim

Re: Updating big dataset

Kurt_Bremser — Fri, 13 Aug 2021 05:45:46 GMT

First, get to know your data. If there are lots of long character variables, the physical dataset size can become overwhelming. Even if COMPRESS is used, sort utility files will be uncompressed and take a long time to write and read.

If your "child datasets" are in fact lookup tables, these can be handled much better by hash objects than by individual joins. I have often replaced multiple SORT/MERGE or SQL JOIN steps with a single data step that uses multiple hashes in a sequential read of the large dataset, resulting in a BIG performance gain.

Locate the longest running step, run it with options fullstimer, and post the complete log Also show the relevant part of PROC CONTENTS output for the dataset at that point (number of obs and variables, observation size). Take care to edit sensitive information, if that is required.

Re: Updating big dataset

ChrisNZ — Fri, 13 Aug 2021 08:19:46 GMT

We need the full log (use options fullstimer) to identify the longest steps, and the limiting factor (disk/network, CPU, or memory) for each step. Or post the longest ones and the previous and next ones if the log is just too long.

It's very likely too that some steps are redundant or can be better written, or steps can be re-organised or combined.

Re: Updating big dataset

binhle50 — Fri, 13 Aug 2021 13:37:34 GMT

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.
Best,
Binh

Re: Updating big dataset

binhle50 — Fri, 13 Aug 2021 13:50:20 GMT

Thanks!
I don't know why the log show: W32_8PRO WIN 6.2.9200 Workstation
I have 64-bit Operating system x64-based processor with Window 10 Enterprise scientific work station desk top.
Best,
Le