Conversion of dob to numeric and calculation of age to nmumeric value

[wlierman]

This is a follow-up to replies from Reeza and Tom.

I'll set the problem up again

I have two files of covid case records.  Doing proc contents gives me the following (which is what I want for the contacts data sets below)

Proc contents of cases

               case_1_2             age      num   8   Best.     age

                                           dob      num   8   date9.   dob

The above contents is what I need for contacts data sets

After doing proc contents on the contacts data sets this is the result

contact view_1                 dob        num   8    mmddyy10.   dob

contact view_2                 dob        Char  19         $19.        dob

So the steps that I would like help on are

1.  convert dob in the contact view_1  and  contact view_2  to the format and type shown in case_1_2 proc contents example for dob

2. calculate an age field for both contact view_1 and contact view_2 to the format and type shown in case_1_2 proc contents example for age

Your help in steps 1 & 2 is very appreciated.

wklierman

[Reeza]

You need to show what a date value will look like in the character version. In general the conversion is straightforward, unless you have multiple types and other values in there.

The format provided here should be what the date currently looks like, in this case YYMMDD10 aligns to 2021-03-05
dob_num = input(dob, yymmdd10.);

[wlierman]

The dob values look like the following in view_1( for contacts)

03/31/1997

07/25/1999

02/18/2019

and so on

The dob values in view_2 (for contacts)  are in the SAS date numbers like 30427

even though proc contents indictaes that dob is char 19  $19. - 30427 looks numeric to me though it is left-aligned in the data set. So using this code

Data OPERA.ARIAS_View_2;
Set OPERA.ARIAS_View_2(rename=(DOB=DOBNUM));
  DOB= put(DOBNUM, yymmdd10.);
  drop DOBNUM;
run;

gives a log result

Data OPERA.ARIAS_View_2;
74 Set OPERA.ARIAS_View_2(rename=(DOB=DOBNUM));
75 DOB= put(DOBNUM, yymmdd10.);
76 drop DOBNUM;
77 run;

NOTE: There were 80230 observations read from the data set OPERA.ARIAS_VIEW_2.
NOTE: The data set OPERA.ARIAS_VIEW_2 has 80230 observations and 74 variables.
NOTE: Compressing data set OPERA.ARIAS_VIEW_2 decreased size by 77.57 percent.
Compressed is 450 pages; un-compressed would require 2006 pages.
NOTE: DATA statement used (Total process time):
real time 0.44 seconds
cpu time 0.43 seconds

But the DOB field in the data set is blank (or .)

I also tried this

proc print data=opera.arias_view_2 (obs=10);
var dob;
format dob date9.;
run;

The log is

proc print data=opera.arias_view_2 (obs=10);
79 var dob;
80 format dob date9.;
ERROR: You are trying to use the numeric format DATE with the character variable DOB in data set
OPERA.ARIAS_VIEW_2.
81 run;

NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

At this juncture, I am confused about this process.

So basically I want to be able to understand how to get answers to the questions that were sent earlier:

1. converting DOB in view_1 and view_2 to the dob format in the cases dataset

2. calculating age for view_1 and view_2 to the age type in the cases dataset

[Reeza]

Terminology is important here. You're converting the variable type - from character to numeric. The actual format applied doesn't matter for the merge, it uses the underlying value, which is important with dates.

You need to use an informat of MMDDYY for a date in the format of
03/31/1997 and then apply a date format to check it.

You WANT to convert everything to numeric and SAS dates, though you could technically do it as a character. But then your dates will not sort correctly and you cannot use any of the other very convenient date functions, such as INTCK() which helps to calculate age.

Data OPERA.ARIAS_View_2v; *note I'm using a different name because otherwise its hard to debug your code;
Set OPERA.ARIAS_View_2(rename=(DOB=DOBNUM));
DOB= input(DOBNUM, mmddyy10.);
drop DOBNUM;
run;

[wlierman]

I am attempting to convert the variable as you suggested. So I tested against arias_view_1 (according to porc contents the dob is in numeric format

in the form mmddyy10.)

My code is

Data OPERA.ARIAS_View_1_check;
Set OPERA.ARIAS_View_1(rename=(DOB=DOBNUM));
  DOB= input(DOBNUM,mmddyy10.);
  drop DOBNUM;
run;

The log is

Data OPERA.ARIAS_View_1_check;
88   Set OPERA.ARIAS_View_1(rename=(DOB=DOBNUM));
89     DOB= input(DOBNUM, mmddyy10.);
90     drop DOBNUM;
91   run;

NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).
      89:14
NOTE: Invalid argument to function INPUT at line 89 column 8.
_Do_Not_Modify__Contact=46fe71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=Du6+AkhOGQt5DjxjXlwp7h4/Twgse2yKawqADyios7BN6J5WGRdg6Ap392pdLCGsg2+GWkBxQ
DLkeK+LhpisqQ== _Do_Not_Modify__Modified_On=17FEB21:16:10:58 Last_Name=McKinley First_Name=Jessie
DOBNUM=03/31/1997 Monitoring_Status=  Status=Active Address_1=758 Railroad Ave
Prairie City, OR 97869
City=Prairie City County=Grant Preferred_Method_of_Contact=  Email=  Mobile_Phone=541-620-8366
Date_of_Last_Exposure=02/11/2021 End_of_Quarantine_Period=02/25/2021 Jurisdiction=Grant CHD
Owner=Grant Created_On=17FEB21:08:10:54 Language=English _1st_Contact_Attempt=. _2nd_Contact_Attempt=.
_3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Confirmed Contact_Attempt_Successful=No
Contacted_Within_24_Hrs=No ContactedElapsedHrs=0 Created_By=SCOTT JEFFRIES Initial_Owner=
Last_Assessment_Date=. Modified_By__Delegate_=  Modified_By__External_Party_=
Modified_On=17FEB21:08:10:58 Record_Created_On=  State=OR Total_Assessments_with_Symptoms=0
American_Indian_and_Alaska_Nativ=  Black_or_African_American=  Case_ID=50896737 Children_s_Names=
Contact_ID=5336031 Contact_Person_ID=50925835 Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=
Native_Hawaiian_and_Pacific_Isla=  Person_ID=50921289 White=  ZIP_Code=97869 Asian=
Begin_Monitoring_=No Identify_Race_or_Ethnicity=  Modified_By=noreply arias Outbreak_ID=
Outbreak_Related=N Annual_Income=  Annual_Income__Base_=  Place_of_Employment=
Primary_Race_or_Ethnicity=  Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Male DOB=. _ERROR_=1
_N_=1
NOTE: Invalid argument to function INPUT at line 89 column 8.
_Do_Not_Modify__Contact=48fe71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=3ODDeRUjbd4zcbjAvHMIANAuDcgitntZEpgzXltmP1sL01wCbn9lqo87ASlZA5roMlqRiFaH0
piTAsoMiNqIIA== _Do_Not_Modify__Modified_On=17FEB21:18:18:50 Last_Name=Clark First_Name=Travis
DOBNUM=10/25/1993 Monitoring_Status=Education / Notification Complete Status=Active
Address_1=4701 Rawhide Ct NE
SALEM, OR 97305 City=SALEM County=Marion
Preferred_Method_of_Contact=Phone Email=  Mobile_Phone=503-983-0585 Date_of_Last_Exposure=02/23/2021
End_of_Quarantine_Period=03/09/2021 Jurisdiction=Marion CHD Owner=Maricarmen Reyes
Created_On=17FEB21:08:10:54 Language=  _1st_Contact_Attempt=. _2nd_Contact_Attempt=.
_3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Confirmed Contact_Attempt_Successful=No
Contacted_Within_24_Hrs=No ContactedElapsedHrs=0 Created_By=SCOTT JEFFRIES Initial_Owner=
Last_Assessment_Date=02/17/2021 Modified_By__Delegate_=  Modified_By__External_Party_=
Modified_On=17FEB21:10:18:50 Record_Created_On=  State=OR Total_Assessments_with_Symptoms=1
American_Indian_and_Alaska_Nativ=  Black_or_African_American=  Case_ID=50898861 Children_s_Names=
Contact_ID=5336034 Contact_Person_ID=50925838 Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=
Native_Hawaiian_and_Pacific_Isla=  Person_ID=50925555 White=  ZIP_Code=97305 Asian=
Begin_Monitoring_=No Identify_Race_or_Ethnicity=caucasion Modified_By=Jennifer Hagar Outbreak_ID=
Outbreak_Related=N Annual_Income=  Annual_Income__Base_=  Place_of_Employment=
Primary_Race_or_Ethnicity=  Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Male DOB=. _ERROR_=1
_N_=2
NOTE: Invalid argument to function INPUT at line 89 column 8.
_Do_Not_Modify__Contact=4afe71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=oLz3ulzZMjP50txiaw3yFHl0YCdhnb5Ex22ctZ2XuTUWLt8DcXQNSst/bb4HYJcAnxoBgpVsZ
Lhxln5aQ6JqZw== _Do_Not_Modify__Modified_On=17FEB21:16:10:59 Last_Name=Pucket First_Name=Kim
DOBNUM=06/14/1941 Monitoring_Status=  Status=Active Address_1=122 Valley View Dr
John Day, OR 97845
City=John Day County=Grant Preferred_Method_of_Contact=Phone Email=  Mobile_Phone=
Date_of_Last_Exposure=02/07/2021 End_of_Quarantine_Period=02/21/2021 Jurisdiction=Grant CHD
Owner=Grant Created_On=17FEB21:08:10:54 Language=  _1st_Contact_Attempt=. _2nd_Contact_Attempt=.
_3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Confirmed Contact_Attempt_Successful=No
Contacted_Within_24_Hrs=No ContactedElapsedHrs=0 Created_By=SCOTT JEFFRIES Initial_Owner=
Last_Assessment_Date=. Modified_By__Delegate_=  Modified_By__External_Party_=
Modified_On=17FEB21:08:10:59 Record_Created_On=  State=OR Total_Assessments_with_Symptoms=0
American_Indian_and_Alaska_Nativ=  Black_or_African_American=  Case_ID=50896737 Children_s_Names=
Contact_ID=5336035 Contact_Person_ID=50925839 Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=
Native_Hawaiian_and_Pacific_Isla=  Person_ID=50921289 White=  ZIP_Code=97845 Asian=
Begin_Monitoring_=No Identify_Race_or_Ethnicity=  Modified_By=noreply arias Outbreak_ID=
Outbreak_Related=N Annual_Income=  Annual_Income__Base_=  Place_of_Employment=
Primary_Race_or_Ethnicity=  Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Unknown DOB=. _ERROR_=1
_N_=3
NOTE: Invalid argument to function INPUT at line 89 column 8.
_Do_Not_Modify__Contact=4cfe71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=O8BS/BxbmVpLb+c36ZnUGFBzllObEJr4LtSHSaBf1hYPRP03O4H+L80sG6rpV4MA8MHisB9qk
A4oQULwDHYHxQ== _Do_Not_Modify__Modified_On=17FEB21:18:15:59 Last_Name=Clark First_Name=Parley
DOBNUM=07/25/2019 Monitoring_Status=Education / Notification Complete Status=Active
Address_1=4701 Rawhide Ct NE
SALEM, OR 97305 City=SALEM County=Marion
Preferred_Method_of_Contact=Phone Email=  Mobile_Phone=503-983-0585 Date_of_Last_Exposure=02/23/2021
End_of_Quarantine_Period=03/09/2021 Jurisdiction=Marion CHD Owner=Maricarmen Reyes
Created_On=17FEB21:08:10:54 Language=  _1st_Contact_Attempt=. _2nd_Contact_Attempt=.
_3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Confirmed Contact_Attempt_Successful=No
Contacted_Within_24_Hrs=No ContactedElapsedHrs=0 Created_By=SCOTT JEFFRIES Initial_Owner=
Last_Assessment_Date=02/17/2021 Modified_By__Delegate_=Jennifer Hagar Modified_By__External_Party_=
Modified_On=17FEB21:10:15:59 Record_Created_On=  State=OR Total_Assessments_with_Symptoms=0
American_Indian_and_Alaska_Nativ=  Black_or_African_American=  Case_ID=50898861 Children_s_Names=
Contact_ID=5336036 Contact_Person_ID=50925841 Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=
Native_Hawaiian_and_Pacific_Isla=  Person_ID=50925555 White=  ZIP_Code=97305 Asian=
Begin_Monitoring_=No Identify_Race_or_Ethnicity=caucasion Modified_By=Jennifer Hagar Outbreak_ID=
Outbreak_Related=N Annual_Income=  Annual_Income__Base_=  Place_of_Employment=
Primary_Race_or_Ethnicity=  Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Male DOB=. _ERROR_=1
_N_=4
NOTE: Invalid argument to function INPUT at line 89 column 8.
_Do_Not_Modify__Contact=50fe71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=iBklkFpTtxqg4blhrJ6BZfAaJqt5CpD0W/4tGltRs7Ug8xShftakigL5bOTHfyhJ/kgZnlnZq
U51hi9po3DrLg== _Do_Not_Modify__Modified_On=17FEB21:16:10:59 Last_Name=Mallett First_Name=Jamie
DOBNUM=01/20/1977 Monitoring_Status=  Status=Active
Address_1=26655 Chimney Gulch Rd
John Day, OR 97845 City=John Day County=Grant
Preferred_Method_of_Contact=Phone Email=  Mobile_Phone=1-541-620-1062 Date_of_Last_Exposure=.
End_of_Quarantine_Period=. Jurisdiction=Grant CHD Owner=Grant Created_On=17FEB21:08:10:55 Language=
_1st_Contact_Attempt=. _2nd_Contact_Attempt=. _3rd_Contact_Attempt=. Access_Failed_Count=
CaseStatus=Confirmed Contact_Attempt_Successful=No Contacted_Within_24_Hrs=No ContactedElapsedHrs=0
Created_By=SCOTT JEFFRIES Initial_Owner=  Last_Assessment_Date=. Modified_By__Delegate_=
Modified_By__External_Party_=  Modified_On=17FEB21:08:10:59 Record_Created_On=  State=OR
Total_Assessments_with_Symptoms=0 American_Indian_and_Alaska_Nativ=  Black_or_African_American=
Case_ID=50896737 Children_s_Names=  Contact_ID=5336040 Contact_Person_ID=50795565
Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=  Native_Hawaiian_and_Pacific_Isla=
Person_ID=50921289 White=  ZIP_Code=97845 Asian=  Begin_Monitoring_=No Identify_Race_or_Ethnicity=
Modified_By=noreply arias Outbreak_ID=  Outbreak_Related=N Annual_Income=  Annual_Income__Base_=
Place_of_Employment=  Primary_Race_or_Ethnicity=  Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Female DOB=. _ERROR_=1
_N_=5
NOTE: Invalid argument to function INPUT at line 89 column 8.
_Do_Not_Modify__Contact=52fe71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=dA+8AP96UM4hp1ZW0W4/UtgyOjakGI5K3OLe3IoSmJlgvfdqbDnjEDx7aJA44Dl3YkHLCnegh
1haohtFc8f8EQ== _Do_Not_Modify__Modified_On=17FEB21:16:10:59 Last_Name=Adams First_Name=Erika
DOBNUM=10/06/1975 Monitoring_Status=  Status=Active Address_1=30339 N River Rd
Prairie City, OR 97869
City=Prairie City County=Grant Preferred_Method_of_Contact=Phone Email=  Mobile_Phone=360-319-8426
Date_of_Last_Exposure=02/10/2021 End_of_Quarantine_Period=02/24/2021 Jurisdiction=Grant CHD
Owner=Grant Created_On=17FEB21:08:10:55 Language=  _1st_Contact_Attempt=. _2nd_Contact_Attempt=.
_3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Confirmed Contact_Attempt_Successful=No
Contacted_Within_24_Hrs=No ContactedElapsedHrs=0 Created_By=SCOTT JEFFRIES Initial_Owner=
Last_Assessment_Date=. Modified_By__Delegate_=  Modified_By__External_Party_=
Modified_On=17FEB21:08:10:59 Record_Created_On=  State=OR Total_Assessments_with_Symptoms=0
American_Indian_and_Alaska_Nativ=  Black_or_African_American=  Case_ID=50896737 Children_s_Names=
Contact_ID=5336041 Contact_Person_ID=50925849 Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=
Native_Hawaiian_and_Pacific_Isla=  Person_ID=50921289 White=  ZIP_Code=97869 Asian=
Begin_Monitoring_=No Identify_Race_or_Ethnicity=  Modified_By=noreply arias Outbreak_ID=
Outbreak_Related=N Annual_Income=  Annual_Income__Base_=  Place_of_Employment=
Primary_Race_or_Ethnicity=  Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Female DOB=. _ERROR_=1
_N_=6
NOTE: Invalid argument to function INPUT at line 89 column 8.
_Do_Not_Modify__Contact=78fe71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=lbHD6nRqcGyYGl6jlvVGeeLFh7JHh3LAKtKTAKhSCQ0OvCqEzBzvtKF7rfVB0bKOIz9knFxkt
0AFRuDqwCXeiw== _Do_Not_Modify__Modified_On=17FEB21:16:11:03 Last_Name=Kodesh First_Name=David
DOBNUM=05/26/1995 Monitoring_Status=  Status=Active Address_1=425 SW 4th St
John Day, OR 97845
City=John Day County=Grant Preferred_Method_of_Contact=  Email=  Mobile_Phone=541-620-8243
Date_of_Last_Exposure=02/11/2021 End_of_Quarantine_Period=02/25/2021 Jurisdiction=Grant CHD
Owner=Grant Created_On=17FEB21:08:10:58 Language=English _1st_Contact_Attempt=. _2nd_Contact_Attempt=.
_3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Presumptive Contact_Attempt_Successful=No
Contacted_Within_24_Hrs=No ContactedElapsedHrs=0 Created_By=SCOTT JEFFRIES Initial_Owner=
Last_Assessment_Date=. Modified_By__Delegate_=  Modified_By__External_Party_=
Modified_On=17FEB21:08:11:03 Record_Created_On=  State=OR Total_Assessments_with_Symptoms=0
American_Indian_and_Alaska_Nativ=  Black_or_African_American=  Case_ID=50899210 Children_s_Names=
Contact_ID=5336074 Contact_Person_ID=50925907 Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=
Native_Hawaiian_and_Pacific_Isla=  Person_ID=50925896 White=  ZIP_Code=97845 Asian=
Begin_Monitoring_=No Identify_Race_or_Ethnicity=  Modified_By=noreply arias Outbreak_ID=
Outbreak_Related=N Annual_Income=  Annual_Income__Base_=  Place_of_Employment=
Primary_Race_or_Ethnicity=  Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Male DOB=. _ERROR_=1
_N_=7
NOTE: Invalid argument to function INPUT at line 89 column 8.
_Do_Not_Modify__Contact=7afe71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=GdfO1Q7P6uBJPyZkoh1zcnf3ZZLcgX19LKoN0Z7b2CZgO6QvsHLMZzQ2A5Rm1KkiQYkmwGJ3o
seRxCoEAJyPBg== _Do_Not_Modify__Modified_On=17FEB21:16:11:05 Last_Name=Hyder First_Name=Cindy
DOBNUM=02/08/1955 Monitoring_Status=  Status=Active Address_1=  City=  County=Grant
Preferred_Method_of_Contact=  Email=  Mobile_Phone=458-212-4053 Date_of_Last_Exposure=02/10/2021
End_of_Quarantine_Period=02/24/2021 Jurisdiction=Grant CHD Owner=Grant Created_On=17FEB21:08:10:58
Language=English _1st_Contact_Attempt=. _2nd_Contact_Attempt=. _3rd_Contact_Attempt=.
Access_Failed_Count=  CaseStatus=Presumptive Contact_Attempt_Successful=No Contacted_Within_24_Hrs=No
ContactedElapsedHrs=0 Created_By=SCOTT JEFFRIES Initial_Owner=  Last_Assessment_Date=.
Modified_By__Delegate_=  Modified_By__External_Party_=  Modified_On=17FEB21:08:11:05
Record_Created_On=  State=  Total_Assessments_with_Symptoms=0 American_Indian_and_Alaska_Nativ=
Black_or_African_American=  Case_ID=50899210 Children_s_Names=  Contact_ID=5336079
Contact_Person_ID=50925909 Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=
Native_Hawaiian_and_Pacific_Isla=  Person_ID=50925896 White=  ZIP_Code=  Asian=  Begin_Monitoring_=No
Identify_Race_or_Ethnicity=  Modified_By=noreply arias Outbreak_ID=  Outbreak_Related=N
Annual_Income=  Annual_Income__Base_=  Place_of_Employment=  Primary_Race_or_Ethnicity=
Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=  Because_of_a_physical__mental_or=
Deaf_or_do_you_have_serious_diff=  Difficulty_concentrating__rememb=
Difficulty_doing_errands_alone_=  Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Female DOB=. _ERROR_=1
_N_=8
NOTE: Invalid argument to function INPUT at line 89 column 8.
_Do_Not_Modify__Contact=82fe71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=OJAlP310/nWPbSc5Ec3A+OaTayNWXCnJcaOxwH7lCMk2Lw62CFAsEvAVoDZt3l6YWOwEenzNJ
V9SEk+I7pjWdA== _Do_Not_Modify__Modified_On=18FEB21:00:46:40 Last_Name=Yamamoto First_Name=Brason
DOBNUM=03/04/2020 Monitoring_Status=Education / Notification Complete Status=Active
Address_1=4848 Deepwood Loop NE
Salem, OR 97305 City=Salem County=Marion
Preferred_Method_of_Contact=Phone Email=  Mobile_Phone=808-372-3248 Date_of_Last_Exposure=02/25/2021
End_of_Quarantine_Period=03/11/2021 Jurisdiction=Marion CHD Owner=Maricarmen Reyes
Created_On=17FEB21:08:10:59 Language=English _1st_Contact_Attempt=. _2nd_Contact_Attempt=.
_3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Confirmed Contact_Attempt_Successful=No
Contacted_Within_24_Hrs=No ContactedElapsedHrs=0 Created_By=SCOTT JEFFRIES Initial_Owner=
Last_Assessment_Date=02/17/2021 Modified_By__Delegate_=Yetzaveli Almonte
Modified_By__External_Party_=  Modified_On=17FEB21:16:46:40 Record_Created_On=  State=OR
Total_Assessments_with_Symptoms=0 American_Indian_and_Alaska_Nativ=  Black_or_African_American=
Case_ID=50899114 Children_s_Names=  Contact_ID=5336092 Contact_Person_ID=50925922
Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=  Native_Hawaiian_and_Pacific_Isla=
Person_ID=50925773 White=  ZIP_Code=97305 Asian=  Begin_Monitoring_=No
Identify_Race_or_Ethnicity=Micronesian Modified_By=Yetzaveli Almonte Outbreak_ID=2021-54878
Outbreak_Related=Y Annual_Income=  Annual_Income__Base_=  Place_of_Employment=
Primary_Race_or_Ethnicity=  Are_you_blind_=No Are_you_deaf_or_do_you_have_seri=No
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Male DOB=. _ERROR_=1
_N_=9
NOTE: Invalid argument to function INPUT at line 89 column 8.
_Do_Not_Modify__Contact=9cfe71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=yFK5jytKQv+NNsTJ21WWhoDisnCNc7ljF6vVKqtTEUPtOI0790+T+8LiqM5gOPu+n2XVFQMS+
zTadE4h2X+PLg== _Do_Not_Modify__Modified_On=17FEB21:16:18:51 Last_Name=Ruiz First_Name=Teresa
DOBNUM=05/30/2013 Monitoring_Status=Marked for deduplication Status=Inactive
Address_1=1205 College St
Milton Freewater, OR 97862 City=Milton Freewater County=Umatilla
Preferred_Method_of_Contact=  Email=  Mobile_Phone=509-956-0526 Date_of_Last_Exposure=02/20/2021
End_of_Quarantine_Period=03/06/2021 Jurisdiction=Umatilla CHD Owner=Umatilla
Created_On=17FEB21:08:11:01 Language=English _1st_Contact_Attempt=. _2nd_Contact_Attempt=.
_3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Confirmed Contact_Attempt_Successful=No
Contacted_Within_24_Hrs=No ContactedElapsedHrs=0 Created_By=SCOTT JEFFRIES Initial_Owner=
Last_Assessment_Date=. Modified_By__Delegate_=  Modified_By__External_Party_=
Modified_On=17FEB21:08:18:51 Record_Created_On=  State=OR Total_Assessments_with_Symptoms=0
American_Indian_and_Alaska_Nativ=  Black_or_African_American=  Case_ID=50899091 Children_s_Names=
Contact_ID=5336130 Contact_Person_ID=50925931 Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=
Native_Hawaiian_and_Pacific_Isla=  Person_ID=50925747 White=  ZIP_Code=97862 Asian=
Begin_Monitoring_=No Identify_Race_or_Ethnicity=  Modified_By=Linsey Ware Outbreak_ID=
Outbreak_Related=N Annual_Income=  Annual_Income__Base_=  Place_of_Employment=
Primary_Race_or_Ethnicity=  Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Female DOB=. _ERROR_=1
_N_=10
NOTE: Invalid argument to function INPUT at line 89 column 8.
_Do_Not_Modify__Contact=9efe71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=TPD0f+NYF92mcdVqM6sWT7y6Jc7/VoBTVzi7rF7w41uH7UuVokDJR1cCIFufkvh27EFYuy+yO
nuyGoYMvuicDw== _Do_Not_Modify__Modified_On=17FEB21:16:19:00 Last_Name=Ruiz First_Name=Valery
DOBNUM=06/19/2012 Monitoring_Status=Marked for deduplication Status=Inactive
Address_1=1205 College St
Milton Freewater, OR 97862 City=Milton Freewater County=Umatilla
Preferred_Method_of_Contact=  Email=  Mobile_Phone=509-956-0526 Date_of_Last_Exposure=02/20/2021
End_of_Quarantine_Period=03/06/2021 Jurisdiction=Umatilla CHD Owner=Umatilla
Created_On=17FEB21:08:11:01 Language=English _1st_Contact_Attempt=. _2nd_Contact_Attempt=.
_3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Confirmed Contact_Attempt_Successful=No
Contacted_Within_24_Hrs=No ContactedElapsedHrs=0 Created_By=SCOTT JEFFRIES Initial_Owner=
Last_Assessment_Date=. Modified_By__Delegate_=  Modified_By__External_Party_=
Modified_On=17FEB21:08:19:00 Record_Created_On=  State=OR Total_Assessments_with_Symptoms=0
American_Indian_and_Alaska_Nativ=  Black_or_African_American=  Case_ID=50899091 Children_s_Names=
Contact_ID=5336132 Contact_Person_ID=50925933 Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=
Native_Hawaiian_and_Pacific_Isla=  Person_ID=50925747 White=  ZIP_Code=97862 Asian=
Begin_Monitoring_=No Identify_Race_or_Ethnicity=  Modified_By=Linsey Ware Outbreak_ID=
Outbreak_Related=N Annual_Income=  Annual_Income__Base_=  Place_of_Employment=
Primary_Race_or_Ethnicity=  Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Female DOB=. _ERROR_=1
_N_=11
NOTE: Invalid argument to function INPUT at line 89 column 8.
_Do_Not_Modify__Contact=a0fe71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=TTswvU1FrXgPsOMqI/2pqhHA0cRqe+vp1YYQi8sqadFbgfMIB23efXFyuyydXNtWKcBILy5N5
6U4QRgn7/8jdg== _Do_Not_Modify__Modified_On=17FEB21:16:20:37 Last_Name=Hernandez First_Name=Jose
DOBNUM=09/12/1992 Monitoring_Status=Marked for deduplication Status=Inactive
Address_1=1205 College St
Milton Freewater, OR 97862 City=Milton Freewater County=Umatilla
Preferred_Method_of_Contact=  Email=  Mobile_Phone=509-200-1829 Date_of_Last_Exposure=02/20/2021
End_of_Quarantine_Period=03/06/2021 Jurisdiction=Umatilla CHD Owner=Umatilla
Created_On=17FEB21:08:11:01 Language=English _1st_Contact_Attempt=. _2nd_Contact_Attempt=.
_3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Confirmed Contact_Attempt_Successful=No
Contacted_Within_24_Hrs=No ContactedElapsedHrs=0 Created_By=SCOTT JEFFRIES Initial_Owner=
Last_Assessment_Date=. Modified_By__Delegate_=  Modified_By__External_Party_=
Modified_On=17FEB21:08:20:37 Record_Created_On=  State=OR Total_Assessments_with_Symptoms=0
American_Indian_and_Alaska_Nativ=  Black_or_African_American=  Case_ID=50899091 Children_s_Names=
Contact_ID=5336133 Contact_Person_ID=50925935 Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=
Native_Hawaiian_and_Pacific_Isla=  Person_ID=50925747 White=  ZIP_Code=97862 Asian=
Begin_Monitoring_=No Identify_Race_or_Ethnicity=  Modified_By=Linsey Ware Outbreak_ID=
Outbreak_Related=N Annual_Income=  Annual_Income__Base_=  Place_of_Employment=
Primary_Race_or_Ethnicity=  Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Male DOB=. _ERROR_=1
_N_=12
NOTE: Invalid argument to function INPUT at line 89 column 8.
_Do_Not_Modify__Contact=b4fe71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=DzHlvPUadqd012GXJuAtvktZwl/CMFncKLL81V4pA0k4+ZgRJjjsmffjMwf9vtujc1O2kPELO
T+TiyEmXkqbvQ== _Do_Not_Modify__Modified_On=18FEB21:00:46:40 Last_Name=Gericke First_Name=Janice
DOBNUM=02/18/1992 Monitoring_Status=Education / Notification Complete Status=Active
Address_1=2660 Ladd Ave NE
Salem, OR 97301 City=Salem County=Marion Preferred_Method_of_Contact=Phone
Email=janicegericke@yahoo.com Mobile_Phone=971-332-7509 Date_of_Last_Exposure=02/21/2021
End_of_Quarantine_Period=03/07/2021 Jurisdiction=Marion CHD Owner=Maricarmen Reyes
Created_On=17FEB21:08:11:04 Language=English _1st_Contact_Attempt=. _2nd_Contact_Attempt=.
_3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Confirmed Contact_Attempt_Successful=No
Contacted_Within_24_Hrs=No ContactedElapsedHrs=0 Created_By=SCOTT JEFFRIES Initial_Owner=
Last_Assessment_Date=02/17/2021 Modified_By__Delegate_=Yetzaveli Almonte
Modified_By__External_Party_=  Modified_On=17FEB21:16:46:40 Record_Created_On=  State=OR
Total_Assessments_with_Symptoms=0 American_Indian_and_Alaska_Nativ=  Black_or_African_American=
Case_ID=50898801 Children_s_Names=  Contact_ID=5336151 Contact_Person_ID=50925984
Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=  Native_Hawaiian_and_Pacific_Isla=
Person_ID=50925423 White=  ZIP_Code=97301 Asian=  Begin_Monitoring_=No
Identify_Race_or_Ethnicity=Hispanic, White Modified_By=Yetzaveli Almonte Outbreak_ID=
Outbreak_Related=N Annual_Income=  Annual_Income__Base_=  Place_of_Employment=
Primary_Race_or_Ethnicity=Yes. Please list your primary racial or ethnic identity below:
Are_you_blind_=No Are_you_deaf_or_do_you_have_seri=No Because_of_a_physical__mental_or=No
Deaf_or_do_you_have_serious_diff=  Difficulty_concentrating__rememb=
Difficulty_doing_errands_alone_=  Difficulty_walking_or_climbing_s=
Do_you_have_difficulty_dressing=No Do_you_have_serious_difficulty_w=No REAL_D_over_15=Yes
REAL_D_over_5=Yes Gender=Female DOB=. _ERROR_=1 _N_=15
NOTE: Invalid argument to function INPUT at line 89 column 8.
_Do_Not_Modify__Contact=e6fe71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=tbfiN+30/9LMdp7GK7OrxVw5XnAZA5GwvjrNAlqxod7DryYMgcJY9+F3CKHAm670tFZ/fUiC2
44H5eI6P1nauQ== _Do_Not_Modify__Modified_On=22FEB21:00:58:05 Last_Name=Vickers First_Name=Eleanor
DOBNUM=09/08/2008 Monitoring_Status=Marked for deduplication Status=Inactive
Address_1=142 Wenaha Ln
Roseburg, OR 97471 City=Roseburg County=Douglas
Preferred_Method_of_Contact=Phone Email=  Mobile_Phone=541-671-9001 Date_of_Last_Exposure=02/25/2021
End_of_Quarantine_Period=03/11/2021 Jurisdiction=Douglas CHD Owner=CALVIN NGUYEN
Created_On=17FEB21:08:11:08 Language=  _1st_Contact_Attempt=. _2nd_Contact_Attempt=.
_3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Confirmed Contact_Attempt_Successful=No
Contacted_Within_24_Hrs=No ContactedElapsedHrs=0 Created_By=SCOTT JEFFRIES Initial_Owner=
Last_Assessment_Date=. Modified_By__Delegate_=  Modified_By__External_Party_=
Modified_On=21FEB21:16:58:05 Record_Created_On=  State=OR Total_Assessments_with_Symptoms=0
American_Indian_and_Alaska_Nativ=  Black_or_African_American=  Case_ID=50898851 Children_s_Names=
Contact_ID=5336210 Contact_Person_ID=50924511 Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=
Native_Hawaiian_and_Pacific_Isla=  Person_ID=50924508 White=  ZIP_Code=97471 Asian=
Begin_Monitoring_=No Identify_Race_or_Ethnicity=  Modified_By=CALVIN NGUYEN Outbreak_ID=2021-54976
Outbreak_Related=Y Annual_Income=  Annual_Income__Base_=  Place_of_Employment=
Primary_Race_or_Ethnicity=  Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Female DOB=. _ERROR_=1
_N_=16
NOTE: Invalid argument to function INPUT at line 89 column 8.
_Do_Not_Modify__Contact=f0fe71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=YKKenp6MZoe85y0+xrBda+BZmT2XeO6e1MjkCQkuvRjuI1nznxR1WxlhtiKoxTEccYTi48n0+
1RH+p3Z20vRnQ== _Do_Not_Modify__Modified_On=20FEB21:16:39:14 Last_Name=De Jesus First_Name=Yahrixa
DOBNUM=01/29/2018 Monitoring_Status=Lost to Follow-up Status=Inactive Address_1=  City=
County=Umatilla Preferred_Method_of_Contact=Phone Email=  Mobile_Phone=541-215-3982
Date_of_Last_Exposure=02/14/2021 End_of_Quarantine_Period=02/28/2021 Jurisdiction=Umatilla CHD
Owner=Hunter Blake Created_On=17FEB21:08:11:09 Language=  _1st_Contact_Attempt=.
_2nd_Contact_Attempt=. _3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Confirmed
Contact_Attempt_Successful=No Contacted_Within_24_Hrs=No ContactedElapsedHrs=0
Created_By=SCOTT JEFFRIES Initial_Owner=  Last_Assessment_Date=. Modified_By__Delegate_=
Modified_By__External_Party_=  Modified_On=20FEB21:08:39:14 Record_Created_On=  State=
Total_Assessments_with_Symptoms=0 American_Indian_and_Alaska_Nativ=  Black_or_African_American=
Case_ID=50899093 Children_s_Names=  Contact_ID=5336225 Contact_Person_ID=50926050
Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=  Native_Hawaiian_and_Pacific_Isla=
Person_ID=50925749 White=  ZIP_Code=  Asian=  Begin_Monitoring_=No Identify_Race_or_Ethnicity=
Modified_By=Hunter Blake Outbreak_ID=  Outbreak_Related=N Annual_Income=  Annual_Income__Base_=
Place_of_Employment=  Primary_Race_or_Ethnicity=  Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Female DOB=. _ERROR_=1
_N_=17
NOTE: Invalid argument to function INPUT at line 89 column 8.
_Do_Not_Modify__Contact=f4fe71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=jwNftnUvlBI27zoVqwMDcPZhYG6OtzRCD7n9zQ6HBXCzM6CrqVF5G8lKo2yGDXqhVXVCJfcsw
oI9p+knFksbgA== _Do_Not_Modify__Modified_On=22FEB21:00:53:55 Last_Name=Goodman First_Name=Evan
DOBNUM=08/27/2004 Monitoring_Status=Marked for deduplication Status=Inactive
Address_1=142 Wenaha Ln
Roseburg, OR 97471 City=Roseburg County=Douglas
Preferred_Method_of_Contact=Phone Email=  Mobile_Phone=541-671-9001 Date_of_Last_Exposure=02/25/2021
End_of_Quarantine_Period=03/11/2021 Jurisdiction=Douglas CHD Owner=CALVIN NGUYEN
Created_On=17FEB21:08:11:09 Language=  _1st_Contact_Attempt=. _2nd_Contact_Attempt=.
_3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Confirmed Contact_Attempt_Successful=No
Contacted_Within_24_Hrs=No ContactedElapsedHrs=0 Created_By=SCOTT JEFFRIES Initial_Owner=
Last_Assessment_Date=. Modified_By__Delegate_=  Modified_By__External_Party_=
Modified_On=21FEB21:16:53:55 Record_Created_On=  State=OR Total_Assessments_with_Symptoms=0
American_Indian_and_Alaska_Nativ=  Black_or_African_American=  Case_ID=50898851 Children_s_Names=
Contact_ID=5336227 Contact_Person_ID=50924513 Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=
Native_Hawaiian_and_Pacific_Isla=  Person_ID=50924508 White=  ZIP_Code=97471 Asian=
Begin_Monitoring_=No Identify_Race_or_Ethnicity=  Modified_By=CALVIN NGUYEN Outbreak_ID=2021-54976
Outbreak_Related=Y Annual_Income=  Annual_Income__Base_=  Place_of_Employment=
Primary_Race_or_Ethnicity=  Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Male DOB=. _ERROR_=1
_N_=18
NOTE: Invalid argument to function INPUT at line 89 column 8.
_Do_Not_Modify__Contact=00ff71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=hdQiUIhKeCBfDRvLfsLKItKJO63VaK+wHfjVilBeCXgm+PLLHvSxjVKj7aoiD+DYunESWqW9A
KhYi9CI7+eYtw== _Do_Not_Modify__Modified_On=22FEB21:00:12:37 Last_Name=Blevins First_Name=Natalie
DOBNUM=08/09/2006 Monitoring_Status=Marked for deduplication Status=Inactive
Address_1=142 Wenaha Ln
Roseburg, OR 97471 City=Roseburg County=Douglas
Preferred_Method_of_Contact=Phone Email=  Mobile_Phone=541-671-9001 Date_of_Last_Exposure=02/25/2021
End_of_Quarantine_Period=03/11/2021 Jurisdiction=Douglas CHD Owner=CALVIN NGUYEN
Created_On=17FEB21:08:11:10 Language=  _1st_Contact_Attempt=. _2nd_Contact_Attempt=.
_3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Confirmed Contact_Attempt_Successful=No
Contacted_Within_24_Hrs=No ContactedElapsedHrs=0 Created_By=SCOTT JEFFRIES Initial_Owner=
Last_Assessment_Date=. Modified_By__Delegate_=  Modified_By__External_Party_=
Modified_On=21FEB21:16:12:37 Record_Created_On=  State=OR Total_Assessments_with_Symptoms=0
American_Indian_and_Alaska_Nativ=  Black_or_African_American=  Case_ID=50898851 Children_s_Names=
Contact_ID=5336236 Contact_Person_ID=50924510 Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=
Native_Hawaiian_and_Pacific_Isla=  Person_ID=50924508 White=  ZIP_Code=97471 Asian=
Begin_Monitoring_=No Identify_Race_or_Ethnicity=  Modified_By=Jolene MCGEE Outbreak_ID=2021-54976
Outbreak_Related=Y Annual_Income=  Annual_Income__Base_=  Place_of_Employment=
Primary_Race_or_Ethnicity=  Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Female DOB=. _ERROR_=1
_N_=19
NOTE: Invalid argument to function INPUT at line 89 column 8.
_Do_Not_Modify__Contact=06ff71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=rUCpdBi2hqOQ5VSlWjg7Lxr8RjDqu+KM6lS/6cO4S5yiUGdviuq1w4324hLZJVkIGstx7WSFn
3yUM+xR6gY9gg== _Do_Not_Modify__Modified_On=22FEB21:00:28:45 Last_Name=Hatch First_Name=Sophia
DOBNUM=02/10/2011 Monitoring_Status=Marked for deduplication Status=Inactive
Address_1=142 Wenaha Ln
Roseburg, OR 97471 City=Roseburg County=Douglas
Preferred_Method_of_Contact=Phone Email=  Mobile_Phone=541-671-9001 Date_of_Last_Exposure=02/25/2021
End_of_Quarantine_Period=03/11/2021 Jurisdiction=Douglas CHD Owner=CALVIN NGUYEN
Created_On=17FEB21:08:11:11 Language=  _1st_Contact_Attempt=. _2nd_Contact_Attempt=.
_3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Confirmed Contact_Attempt_Successful=No
Contacted_Within_24_Hrs=No ContactedElapsedHrs=0 Created_By=SCOTT JEFFRIES Initial_Owner=
Last_Assessment_Date=. Modified_By__Delegate_=  Modified_By__External_Party_=
Modified_On=21FEB21:16:28:45 Record_Created_On=  State=OR Total_Assessments_with_Symptoms=0
American_Indian_and_Alaska_Nativ=  Black_or_African_American=  Case_ID=50898851 Children_s_Names=
Contact_ID=5336239 Contact_Person_ID=50924509 Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=
Native_Hawaiian_and_Pacific_Isla=  Person_ID=50924508 White=  ZIP_Code=97471 Asian=
Begin_Monitoring_=No Identify_Race_or_Ethnicity=  Modified_By=Jolene MCGEE Outbreak_ID=2021-54976
Outbreak_Related=Y Annual_Income=  Annual_Income__Base_=  Place_of_Employment=
Primary_Race_or_Ethnicity=  Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Female DOB=. _ERROR_=1
_N_=20
NOTE: Invalid argument to function INPUT at line 89 column 8.
_Do_Not_Modify__Contact=200072aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=RFGP9g2sPY7A0IusUji9pEIqth35WgIpUIwEIepuhOlcXj3/OjKxbWtZm0W4qbL9sEMkg20vI
4PQy8thq39d/w== _Do_Not_Modify__Modified_On=24FEB21:19:52:28 Last_Name=Gilbert First_Name=Dj
DOBNUM=03/15/2020 Monitoring_Status=Monitoring Status=Active
Address_1=7253 Hwy 3
Warm Springs, OR 97761 City=Warm Springs County=Jefferson
Preferred_Method_of_Contact=Phone Email=  Mobile_Phone=541-777-2080 Date_of_Last_Exposure=02/16/2021
End_of_Quarantine_Period=03/02/2021 Jurisdiction=Confederated Tribes of Warm Springs
Owner=Jennifer Robbins2 Created_On=17FEB21:08:11:34 Language=  _1st_Contact_Attempt=.
_2nd_Contact_Attempt=. _3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Confirmed
Contact_Attempt_Successful=No Contacted_Within_24_Hrs=No ContactedElapsedHrs=0
Created_By=SCOTT JEFFRIES Initial_Owner=  Last_Assessment_Date=02/24/2021 Modified_By__Delegate_=
Modified_By__External_Party_=  Modified_On=24FEB21:11:52:28 Record_Created_On=  State=OR
Total_Assessments_with_Symptoms=0 American_Indian_and_Alaska_Nativ=  Black_or_African_American=
Case_ID=50899429 Children_s_Names=  Contact_ID=5336600 Contact_Person_ID=50926341
Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=  Native_Hawaiian_and_Pacific_Isla=
Person_ID=50926293 White=  ZIP_Code=97761 Asian=  Begin_Monitoring_=No Identify_Race_or_Ethnicity=
Modified_By=Jennifer Robbins2 Outbreak_ID=  Outbreak_Related=N Annual_Income=  Annual_Income__Base_=
Place_of_Employment=  Primary_Race_or_Ethnicity=  Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Male DOB=. _ERROR_=1
_N_=21
NOTE: Invalid argument to function INPUT at line 89 column 8.
WARNING: Limit set by ERRORS= option reached.  Further errors of this type will not be printed.
_Do_Not_Modify__Contact=2c0072aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=88fHyyVVjzz15JVpWDyVZvJiJkm62HLWWMUNlhozwvcNUYxnm4sqVt80ldkdLpIQoVOE+7WKu
Qxc8njBLXovxg== _Do_Not_Modify__Modified_On=23FEB21:21:42:14 Last_Name=Gilbert First_Name=Daniel
DOBNUM=07/01/1989 Monitoring_Status=Monitoring Status=Active
Address_1=7253 Hwy 3
Warm Springs, OR 97761 City=Warm Springs County=Jefferson
Preferred_Method_of_Contact=Phone Email=  Mobile_Phone=541-777-2080 Date_of_Last_Exposure=02/16/2021
End_of_Quarantine_Period=03/02/2021 Jurisdiction=Confederated Tribes of Warm Springs
Owner=Jennifer Robbins2 Created_On=17FEB21:08:11:35 Language=  _1st_Contact_Attempt=.
_2nd_Contact_Attempt=. _3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Confirmed
Contact_Attempt_Successful=No Contacted_Within_24_Hrs=No ContactedElapsedHrs=0
Created_By=SCOTT JEFFRIES Initial_Owner=  Last_Assessment_Date=02/23/2021 Modified_By__Delegate_=
Modified_By__External_Party_=  Modified_On=23FEB21:13:42:14 Record_Created_On=  State=OR
Total_Assessments_with_Symptoms=0 American_Indian_and_Alaska_Nativ=  Black_or_African_American=
Case_ID=50899429 Children_s_Names=  Contact_ID=5336609 Contact_Person_ID=50926349
Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=  Native_Hawaiian_and_Pacific_Isla=
Person_ID=50926293 White=  ZIP_Code=97761 Asian=  Begin_Monitoring_=No Identify_Race_or_Ethnicity=
Modified_By=Jennifer Robbins2 Outbreak_ID=  Outbreak_Related=N Annual_Income=  Annual_Income__Base_=
Place_of_Employment=  Primary_Race_or_Ethnicity=  Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Male DOB=. _ERROR_=1
_N_=22
NOTE: Mathematical operations could not be performed at the following places. The results of the
      operations have been set to missing values.
      Each place is given by: (Number of times) at (Line):(Column).
      67103 at 89:8
NOTE: There were 79176 observations read from the data set OPERA.ARIAS_VIEW_1.
NOTE: The data set OPERA.ARIAS_VIEW_1_CHECK has 79176 observations and 71 variables.
NOTE: Compressing data set OPERA.ARIAS_VIEW_1_CHECK decreased size by 82.25 percent.
      Compressed is 343 pages; un-compressed would require 1932 pages.
NOTE: DATA statement used (Total process time):
      real time           0.53 seconds
      cpu time            0.49 seconds


92   Data OPERA.ARIAS_View_1_check;
93   Set OPERA.ARIAS_View_1(rename=(DOB=DOBNUM));
94     DOB= input(DOBNUM,mmddyy10.);
95     drop DOBNUM;
96   run;

NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).
      94:14
NOTE: Invalid argument to function INPUT at line 94 column 8.
_Do_Not_Modify__Contact=46fe71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=Du6+AkhOGQt5DjxjXlwp7h4/Twgse2yKawqADyios7BN6J5WGRdg6Ap392pdLCGsg2+GWkBxQ
DLkeK+LhpisqQ== _Do_Not_Modify__Modified_On=17FEB21:16:10:58 Last_Name=McKinley First_Name=Jessie
DOBNUM=03/31/1997 Monitoring_Status=  Status=Active Address_1=758 Railroad Ave
Prairie City, OR 97869
City=Prairie City County=Grant Preferred_Method_of_Contact=  Email=  Mobile_Phone=541-620-8366
Date_of_Last_Exposure=02/11/2021 End_of_Quarantine_Period=02/25/2021 Jurisdiction=Grant CHD
Owner=Grant Created_On=17FEB21:08:10:54 Language=English _1st_Contact_Attempt=. _2nd_Contact_Attempt=.
_3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Confirmed Contact_Attempt_Successful=No
Contacted_Within_24_Hrs=No ContactedElapsedHrs=0 Created_By=SCOTT JEFFRIES Initial_Owner=
Last_Assessment_Date=. Modified_By__Delegate_=  Modified_By__External_Party_=
Modified_On=17FEB21:08:10:58 Record_Created_On=  State=OR Total_Assessments_with_Symptoms=0
American_Indian_and_Alaska_Nativ=  Black_or_African_American=  Case_ID=50896737 Children_s_Names=
Contact_ID=5336031 Contact_Person_ID=50925835 Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=
Native_Hawaiian_and_Pacific_Isla=  Person_ID=50921289 White=  ZIP_Code=97869 Asian=
Begin_Monitoring_=No Identify_Race_or_Ethnicity=  Modified_By=noreply arias Outbreak_ID=
Outbreak_Related=N Annual_Income=  Annual_Income__Base_=  Place_of_Employment=
Primary_Race_or_Ethnicity=  Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Male DOB=. _ERROR_=1
_N_=1
NOTE: Invalid argument to function INPUT at line 94 column 8.
_Do_Not_Modify__Contact=48fe71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=3ODDeRUjbd4zcbjAvHMIANAuDcgitntZEpgzXltmP1sL01wCbn9lqo87ASlZA5roMlqRiFaH0
piTAsoMiNqIIA== _Do_Not_Modify__Modified_On=17FEB21:18:18:50 Last_Name=Clark First_Name=Travis
DOBNUM=10/25/1993 Monitoring_Status=Education / Notification Complete Status=Active
Address_1=4701 Rawhide Ct NE
SALEM, OR 97305 City=SALEM County=Marion
Preferred_Method_of_Contact=Phone Email=  Mobile_Phone=503-983-0585 Date_of_Last_Exposure=02/23/2021
End_of_Quarantine_Period=03/09/2021 Jurisdiction=Marion CHD Owner=Maricarmen Reyes
Created_On=17FEB21:08:10:54 Language=  _1st_Contact_Attempt=. _2nd_Contact_Attempt=.
_3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Confirmed Contact_Attempt_Successful=No
Contacted_Within_24_Hrs=No ContactedElapsedHrs=0 Created_By=SCOTT JEFFRIES Initial_Owner=
Last_Assessment_Date=02/17/2021 Modified_By__Delegate_=  Modified_By__External_Party_=
Modified_On=17FEB21:10:18:50 Record_Created_On=  State=OR Total_Assessments_with_Symptoms=1
American_Indian_and_Alaska_Nativ=  Black_or_African_American=  Case_ID=50898861 Children_s_Names=
Contact_ID=5336034 Contact_Person_ID=50925838 Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=
Native_Hawaiian_and_Pacific_Isla=  Person_ID=50925555 White=  ZIP_Code=97305 Asian=
Begin_Monitoring_=No Identify_Race_or_Ethnicity=caucasion Modified_By=Jennifer Hagar Outbreak_ID=
Outbreak_Related=N Annual_Income=  Annual_Income__Base_=  Place_of_Employment=
Primary_Race_or_Ethnicity=  Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Male DOB=. _ERROR_=1
_N_=2
NOTE: Invalid argument to function INPUT at line 94 column 8.
_Do_Not_Modify__Contact=4afe71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=oLz3ulzZMjP50txiaw3yFHl0YCdhnb5Ex22ctZ2XuTUWLt8DcXQNSst/bb4HYJcAnxoBgpVsZ
Lhxln5aQ6JqZw== _Do_Not_Modify__Modified_On=17FEB21:16:10:59 Last_Name=Pucket First_Name=Kim
DOBNUM=06/14/1941 Monitoring_Status=  Status=Active Address_1=122 Valley View Dr
John Day, OR 97845
City=John Day County=Grant Preferred_Method_of_Contact=Phone Email=  Mobile_Phone=
Date_of_Last_Exposure=02/07/2021 End_of_Quarantine_Period=02/21/2021 Jurisdiction=Grant CHD
Owner=Grant Created_On=17FEB21:08:10:54 Language=  _1st_Contact_Attempt=. _2nd_Contact_Attempt=.
_3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Confirmed Contact_Attempt_Successful=No
Contacted_Within_24_Hrs=No ContactedElapsedHrs=0 Created_By=SCOTT JEFFRIES Initial_Owner=
Last_Assessment_Date=. Modified_By__Delegate_=  Modified_By__External_Party_=
Modified_On=17FEB21:08:10:59 Record_Created_On=  State=OR Total_Assessments_with_Symptoms=0
American_Indian_and_Alaska_Nativ=  Black_or_African_American=  Case_ID=50896737 Children_s_Names=
Contact_ID=5336035 Contact_Person_ID=50925839 Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=
Native_Hawaiian_and_Pacific_Isla=  Person_ID=50921289 White=  ZIP_Code=97845 Asian=
Begin_Monitoring_=No Identify_Race_or_Ethnicity=  Modified_By=noreply arias Outbreak_ID=
Outbreak_Related=N Annual_Income=  Annual_Income__Base_=  Place_of_Employment=
Primary_Race_or_Ethnicity=  Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Unknown DOB=. _ERROR_=1
_N_=3
NOTE: Invalid argument to function INPUT at line 94 column 8.
_Do_Not_Modify__Contact=4cfe71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=O8BS/BxbmVpLb+c36ZnUGFBzllObEJr4LtSHSaBf1hYPRP03O4H+L80sG6rpV4MA8MHisB9qk
A4oQULwDHYHxQ== _Do_Not_Modify__Modified_On=17FEB21:18:15:59 Last_Name=Clark First_Name=Parley
DOBNUM=07/25/2019 Monitoring_Status=Education / Notification Complete Status=Active
Address_1=4701 Rawhide Ct NE
SALEM, OR 97305 City=SALEM County=Marion
Preferred_Method_of_Contact=Phone Email=  Mobile_Phone=503-983-0585 Date_of_Last_Exposure=02/23/2021
End_of_Quarantine_Period=03/09/2021 Jurisdiction=Marion CHD Owner=Maricarmen Reyes
Created_On=17FEB21:08:10:54 Language=  _1st_Contact_Attempt=. _2nd_Contact_Attempt=.
_3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Confirmed Contact_Attempt_Successful=No
Contacted_Within_24_Hrs=No ContactedElapsedHrs=0 Created_By=SCOTT JEFFRIES Initial_Owner=
Last_Assessment_Date=02/17/2021 Modified_By__Delegate_=Jennifer Hagar Modified_By__External_Party_=
Modified_On=17FEB21:10:15:59 Record_Created_On=  State=OR Total_Assessments_with_Symptoms=0
American_Indian_and_Alaska_Nativ=  Black_or_African_American=  Case_ID=50898861 Children_s_Names=
Contact_ID=5336036 Contact_Person_ID=50925841 Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=
Native_Hawaiian_and_Pacific_Isla=  Person_ID=50925555 White=  ZIP_Code=97305 Asian=
Begin_Monitoring_=No Identify_Race_or_Ethnicity=caucasion Modified_By=Jennifer Hagar Outbreak_ID=
Outbreak_Related=N Annual_Income=  Annual_Income__Base_=  Place_of_Employment=
Primary_Race_or_Ethnicity=  Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Male DOB=. _ERROR_=1
_N_=4
NOTE: Invalid argument to function INPUT at line 94 column 8.
_Do_Not_Modify__Contact=50fe71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=iBklkFpTtxqg4blhrJ6BZfAaJqt5CpD0W/4tGltRs7Ug8xShftakigL5bOTHfyhJ/kgZnlnZq
U51hi9po3DrLg== _Do_Not_Modify__Modified_On=17FEB21:16:10:59 Last_Name=Mallett First_Name=Jamie
DOBNUM=01/20/1977 Monitoring_Status=  Status=Active
Address_1=26655 Chimney Gulch Rd
John Day, OR 97845 City=John Day County=Grant
Preferred_Method_of_Contact=Phone Email=  Mobile_Phone=1-541-620-1062 Date_of_Last_Exposure=.
End_of_Quarantine_Period=. Jurisdiction=Grant CHD Owner=Grant Created_On=17FEB21:08:10:55 Language=
_1st_Contact_Attempt=. _2nd_Contact_Attempt=. _3rd_Contact_Attempt=. Access_Failed_Count=
CaseStatus=Confirmed Contact_Attempt_Successful=No Contacted_Within_24_Hrs=No ContactedElapsedHrs=0
Created_By=SCOTT JEFFRIES Initial_Owner=  Last_Assessment_Date=. Modified_By__Delegate_=
Modified_By__External_Party_=  Modified_On=17FEB21:08:10:59 Record_Created_On=  State=OR
Total_Assessments_with_Symptoms=0 American_Indian_and_Alaska_Nativ=  Black_or_African_American=
Case_ID=50896737 Children_s_Names=  Contact_ID=5336040 Contact_Person_ID=50795565
Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=  Native_Hawaiian_and_Pacific_Isla=
Person_ID=50921289 White=  ZIP_Code=97845 Asian=  Begin_Monitoring_=No Identify_Race_or_Ethnicity=
Modified_By=noreply arias Outbreak_ID=  Outbreak_Related=N Annual_Income=  Annual_Income__Base_=
Place_of_Employment=  Primary_Race_or_Ethnicity=  Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Female DOB=. _ERROR_=1
_N_=5
NOTE: Invalid argument to function INPUT at line 94 column 8.
_Do_Not_Modify__Contact=52fe71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=dA+8AP96UM4hp1ZW0W4/UtgyOjakGI5K3OLe3IoSmJlgvfdqbDnjEDx7aJA44Dl3YkHLCnegh
1haohtFc8f8EQ== _Do_Not_Modify__Modified_On=17FEB21:16:10:59 Last_Name=Adams First_Name=Erika
DOBNUM=10/06/1975 Monitoring_Status=  Status=Active Address_1=30339 N River Rd
Prairie City, OR 97869
City=Prairie City County=Grant Preferred_Method_of_Contact=Phone Email=  Mobile_Phone=360-319-8426
Date_of_Last_Exposure=02/10/2021 End_of_Quarantine_Period=02/24/2021 Jurisdiction=Grant CHD
Owner=Grant Created_On=17FEB21:08:10:55 Language=  _1st_Contact_Attempt=. _2nd_Contact_Attempt=.
_3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Confirmed Contact_Attempt_Successful=No
Contacted_Within_24_Hrs=No ContactedElapsedHrs=0 Created_By=SCOTT JEFFRIES Initial_Owner=
Last_Assessment_Date=. Modified_By__Delegate_=  Modified_By__External_Party_=
Modified_On=17FEB21:08:10:59 Record_Created_On=  State=OR Total_Assessments_with_Symptoms=0
American_Indian_and_Alaska_Nativ=  Black_or_African_American=  Case_ID=50896737 Children_s_Names=
Contact_ID=5336041 Contact_Person_ID=50925849 Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=
Native_Hawaiian_and_Pacific_Isla=  Person_ID=50921289 White=  ZIP_Code=97869 Asian=
Begin_Monitoring_=No Identify_Race_or_Ethnicity=  Modified_By=noreply arias Outbreak_ID=
Outbreak_Related=N Annual_Income=  Annual_Income__Base_=  Place_of_Employment=
Primary_Race_or_Ethnicity=  Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Female DOB=. _ERROR_=1
_N_=6
NOTE: Invalid argument to function INPUT at line 94 column 8.
_Do_Not_Modify__Contact=78fe71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=lbHD6nRqcGyYGl6jlvVGeeLFh7JHh3LAKtKTAKhSCQ0OvCqEzBzvtKF7rfVB0bKOIz9knFxkt
0AFRuDqwCXeiw== _Do_Not_Modify__Modified_On=17FEB21:16:11:03 Last_Name=Kodesh First_Name=David
DOBNUM=05/26/1995 Monitoring_Status=  Status=Active Address_1=425 SW 4th St
John Day, OR 97845
City=John Day County=Grant Preferred_Method_of_Contact=  Email=  Mobile_Phone=541-620-8243
Date_of_Last_Exposure=02/11/2021 End_of_Quarantine_Period=02/25/2021 Jurisdiction=Grant CHD
Owner=Grant Created_On=17FEB21:08:10:58 Language=English _1st_Contact_Attempt=. _2nd_Contact_Attempt=.
_3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Presumptive Contact_Attempt_Successful=No
Contacted_Within_24_Hrs=No ContactedElapsedHrs=0 Created_By=SCOTT JEFFRIES Initial_Owner=
Last_Assessment_Date=. Modified_By__Delegate_=  Modified_By__External_Party_=
Modified_On=17FEB21:08:11:03 Record_Created_On=  State=OR Total_Assessments_with_Symptoms=0
American_Indian_and_Alaska_Nativ=  Black_or_African_American=  Case_ID=50899210 Children_s_Names=
Contact_ID=5336074 Contact_Person_ID=50925907 Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=
Native_Hawaiian_and_Pacific_Isla=  Person_ID=50925896 White=  ZIP_Code=97845 Asian=
Begin_Monitoring_=No Identify_Race_or_Ethnicity=  Modified_By=noreply arias Outbreak_ID=
Outbreak_Related=N Annual_Income=  Annual_Income__Base_=  Place_of_Employment=
Primary_Race_or_Ethnicity=  Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Male DOB=. _ERROR_=1
_N_=7
NOTE: Invalid argument to function INPUT at line 94 column 8.
_Do_Not_Modify__Contact=7afe71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=GdfO1Q7P6uBJPyZkoh1zcnf3ZZLcgX19LKoN0Z7b2CZgO6QvsHLMZzQ2A5Rm1KkiQYkmwGJ3o
seRxCoEAJyPBg== _Do_Not_Modify__Modified_On=17FEB21:16:11:05 Last_Name=Hyder First_Name=Cindy
DOBNUM=02/08/1955 Monitoring_Status=  Status=Active Address_1=  City=  County=Grant
Preferred_Method_of_Contact=  Email=  Mobile_Phone=458-212-4053 Date_of_Last_Exposure=02/10/2021
End_of_Quarantine_Period=02/24/2021 Jurisdiction=Grant CHD Owner=Grant Created_On=17FEB21:08:10:58
Language=English _1st_Contact_Attempt=. _2nd_Contact_Attempt=. _3rd_Contact_Attempt=.
Access_Failed_Count=  CaseStatus=Presumptive Contact_Attempt_Successful=No Contacted_Within_24_Hrs=No
ContactedElapsedHrs=0 Created_By=SCOTT JEFFRIES Initial_Owner=  Last_Assessment_Date=.
Modified_By__Delegate_=  Modified_By__External_Party_=  Modified_On=17FEB21:08:11:05
Record_Created_On=  State=  Total_Assessments_with_Symptoms=0 American_Indian_and_Alaska_Nativ=
Black_or_African_American=  Case_ID=50899210 Children_s_Names=  Contact_ID=5336079
Contact_Person_ID=50925909 Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=
Native_Hawaiian_and_Pacific_Isla=  Person_ID=50925896 White=  ZIP_Code=  Asian=  Begin_Monitoring_=No
Identify_Race_or_Ethnicity=  Modified_By=noreply arias Outbreak_ID=  Outbreak_Related=N
Annual_Income=  Annual_Income__Base_=  Place_of_Employment=  Primary_Race_or_Ethnicity=
Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=  Because_of_a_physical__mental_or=
Deaf_or_do_you_have_serious_diff=  Difficulty_concentrating__rememb=
Difficulty_doing_errands_alone_=  Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Female DOB=. _ERROR_=1
_N_=8
NOTE: Invalid argument to function INPUT at line 94 column 8.
_Do_Not_Modify__Contact=82fe71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=OJAlP310/nWPbSc5Ec3A+OaTayNWXCnJcaOxwH7lCMk2Lw62CFAsEvAVoDZt3l6YWOwEenzNJ
V9SEk+I7pjWdA== _Do_Not_Modify__Modified_On=18FEB21:00:46:40 Last_Name=Yamamoto First_Name=Brason
DOBNUM=03/04/2020 Monitoring_Status=Education / Notification Complete Status=Active
Address_1=4848 Deepwood Loop NE
Salem, OR 97305 City=Salem County=Marion
Preferred_Method_of_Contact=Phone Email=  Mobile_Phone=808-372-3248 Date_of_Last_Exposure=02/25/2021
End_of_Quarantine_Period=03/11/2021 Jurisdiction=Marion CHD Owner=Maricarmen Reyes
Created_On=17FEB21:08:10:59 Language=English _1st_Contact_Attempt=. _2nd_Contact_Attempt=.
_3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Confirmed Contact_Attempt_Successful=No
Contacted_Within_24_Hrs=No ContactedElapsedHrs=0 Created_By=SCOTT JEFFRIES Initial_Owner=
Last_Assessment_Date=02/17/2021 Modified_By__Delegate_=Yetzaveli Almonte
Modified_By__External_Party_=  Modified_On=17FEB21:16:46:40 Record_Created_On=  State=OR
Total_Assessments_with_Symptoms=0 American_Indian_and_Alaska_Nativ=  Black_or_African_American=
Case_ID=50899114 Children_s_Names=  Contact_ID=5336092 Contact_Person_ID=50925922
Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=  Native_Hawaiian_and_Pacific_Isla=
Person_ID=50925773 White=  ZIP_Code=97305 Asian=  Begin_Monitoring_=No
Identify_Race_or_Ethnicity=Micronesian Modified_By=Yetzaveli Almonte Outbreak_ID=2021-54878
Outbreak_Related=Y Annual_Income=  Annual_Income__Base_=  Place_of_Employment=
Primary_Race_or_Ethnicity=  Are_you_blind_=No Are_you_deaf_or_do_you_have_seri=No
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Male DOB=. _ERROR_=1
_N_=9
NOTE: Invalid argument to function INPUT at line 94 column 8.
_Do_Not_Modify__Contact=9cfe71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=yFK5jytKQv+NNsTJ21WWhoDisnCNc7ljF6vVKqtTEUPtOI0790+T+8LiqM5gOPu+n2XVFQMS+
zTadE4h2X+PLg== _Do_Not_Modify__Modified_On=17FEB21:16:18:51 Last_Name=Ruiz First_Name=Teresa
DOBNUM=05/30/2013 Monitoring_Status=Marked for deduplication Status=Inactive
Address_1=1205 College St
Milton Freewater, OR 97862 City=Milton Freewater County=Umatilla
Preferred_Method_of_Contact=  Email=  Mobile_Phone=509-956-0526 Date_of_Last_Exposure=02/20/2021
End_of_Quarantine_Period=03/06/2021 Jurisdiction=Umatilla CHD Owner=Umatilla
Created_On=17FEB21:08:11:01 Language=English _1st_Contact_Attempt=. _2nd_Contact_Attempt=.
_3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Confirmed Contact_Attempt_Successful=No
Contacted_Within_24_Hrs=No ContactedElapsedHrs=0 Created_By=SCOTT JEFFRIES Initial_Owner=
Last_Assessment_Date=. Modified_By__Delegate_=  Modified_By__External_Party_=
Modified_On=17FEB21:08:18:51 Record_Created_On=  State=OR Total_Assessments_with_Symptoms=0
American_Indian_and_Alaska_Nativ=  Black_or_African_American=  Case_ID=50899091 Children_s_Names=
Contact_ID=5336130 Contact_Person_ID=50925931 Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=
Native_Hawaiian_and_Pacific_Isla=  Person_ID=50925747 White=  ZIP_Code=97862 Asian=
Begin_Monitoring_=No Identify_Race_or_Ethnicity=  Modified_By=Linsey Ware Outbreak_ID=
Outbreak_Related=N Annual_Income=  Annual_Income__Base_=  Place_of_Employment=
Primary_Race_or_Ethnicity=  Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Female DOB=. _ERROR_=1
_N_=10
NOTE: Invalid argument to function INPUT at line 94 column 8.
_Do_Not_Modify__Contact=9efe71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=TPD0f+NYF92mcdVqM6sWT7y6Jc7/VoBTVzi7rF7w41uH7UuVokDJR1cCIFufkvh27EFYuy+yO
nuyGoYMvuicDw== _Do_Not_Modify__Modified_On=17FEB21:16:19:00 Last_Name=Ruiz First_Name=Valery
DOBNUM=06/19/2012 Monitoring_Status=Marked for deduplication Status=Inactive
Address_1=1205 College St
Milton Freewater, OR 97862 City=Milton Freewater County=Umatilla
Preferred_Method_of_Contact=  Email=  Mobile_Phone=509-956-0526 Date_of_Last_Exposure=02/20/2021
End_of_Quarantine_Period=03/06/2021 Jurisdiction=Umatilla CHD Owner=Umatilla
Created_On=17FEB21:08:11:01 Language=English _1st_Contact_Attempt=. _2nd_Contact_Attempt=.
_3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Confirmed Contact_Attempt_Successful=No
Contacted_Within_24_Hrs=No ContactedElapsedHrs=0 Created_By=SCOTT JEFFRIES Initial_Owner=
Last_Assessment_Date=. Modified_By__Delegate_=  Modified_By__External_Party_=
Modified_On=17FEB21:08:19:00 Record_Created_On=  State=OR Total_Assessments_with_Symptoms=0
American_Indian_and_Alaska_Nativ=  Black_or_African_American=  Case_ID=50899091 Children_s_Names=
Contact_ID=5336132 Contact_Person_ID=50925933 Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=
Native_Hawaiian_and_Pacific_Isla=  Person_ID=50925747 White=  ZIP_Code=97862 Asian=
Begin_Monitoring_=No Identify_Race_or_Ethnicity=  Modified_By=Linsey Ware Outbreak_ID=
Outbreak_Related=N Annual_Income=  Annual_Income__Base_=  Place_of_Employment=
Primary_Race_or_Ethnicity=  Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Female DOB=. _ERROR_=1
_N_=11
NOTE: Invalid argument to function INPUT at line 94 column 8.
_Do_Not_Modify__Contact=a0fe71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=TTswvU1FrXgPsOMqI/2pqhHA0cRqe+vp1YYQi8sqadFbgfMIB23efXFyuyydXNtWKcBILy5N5
6U4QRgn7/8jdg== _Do_Not_Modify__Modified_On=17FEB21:16:20:37 Last_Name=Hernandez First_Name=Jose
DOBNUM=09/12/1992 Monitoring_Status=Marked for deduplication Status=Inactive
Address_1=1205 College St
Milton Freewater, OR 97862 City=Milton Freewater County=Umatilla
Preferred_Method_of_Contact=  Email=  Mobile_Phone=509-200-1829 Date_of_Last_Exposure=02/20/2021
End_of_Quarantine_Period=03/06/2021 Jurisdiction=Umatilla CHD Owner=Umatilla
Created_On=17FEB21:08:11:01 Language=English _1st_Contact_Attempt=. _2nd_Contact_Attempt=.
_3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Confirmed Contact_Attempt_Successful=No
Contacted_Within_24_Hrs=No ContactedElapsedHrs=0 Created_By=SCOTT JEFFRIES Initial_Owner=
Last_Assessment_Date=. Modified_By__Delegate_=  Modified_By__External_Party_=
Modified_On=17FEB21:08:20:37 Record_Created_On=  State=OR Total_Assessments_with_Symptoms=0
American_Indian_and_Alaska_Nativ=  Black_or_African_American=  Case_ID=50899091 Children_s_Names=
Contact_ID=5336133 Contact_Person_ID=50925935 Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=
Native_Hawaiian_and_Pacific_Isla=  Person_ID=50925747 White=  ZIP_Code=97862 Asian=
Begin_Monitoring_=No Identify_Race_or_Ethnicity=  Modified_By=Linsey Ware Outbreak_ID=
Outbreak_Related=N Annual_Income=  Annual_Income__Base_=  Place_of_Employment=
Primary_Race_or_Ethnicity=  Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Male DOB=. _ERROR_=1
_N_=12
NOTE: Invalid argument to function INPUT at line 94 column 8.
_Do_Not_Modify__Contact=b4fe71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=DzHlvPUadqd012GXJuAtvktZwl/CMFncKLL81V4pA0k4+ZgRJjjsmffjMwf9vtujc1O2kPELO
T+TiyEmXkqbvQ== _Do_Not_Modify__Modified_On=18FEB21:00:46:40 Last_Name=Gericke First_Name=Janice
DOBNUM=02/18/1992 Monitoring_Status=Education / Notification Complete Status=Active
Address_1=2660 Ladd Ave NE
Salem, OR 97301 City=Salem County=Marion Preferred_Method_of_Contact=Phone
Email=janicegericke@yahoo.com Mobile_Phone=971-332-7509 Date_of_Last_Exposure=02/21/2021
End_of_Quarantine_Period=03/07/2021 Jurisdiction=Marion CHD Owner=Maricarmen Reyes
Created_On=17FEB21:08:11:04 Language=English _1st_Contact_Attempt=. _2nd_Contact_Attempt=.
_3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Confirmed Contact_Attempt_Successful=No
Contacted_Within_24_Hrs=No ContactedElapsedHrs=0 Created_By=SCOTT JEFFRIES Initial_Owner=
Last_Assessment_Date=02/17/2021 Modified_By__Delegate_=Yetzaveli Almonte
Modified_By__External_Party_=  Modified_On=17FEB21:16:46:40 Record_Created_On=  State=OR
Total_Assessments_with_Symptoms=0 American_Indian_and_Alaska_Nativ=  Black_or_African_American=
Case_ID=50898801 Children_s_Names=  Contact_ID=5336151 Contact_Person_ID=50925984
Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=  Native_Hawaiian_and_Pacific_Isla=
Person_ID=50925423 White=  ZIP_Code=97301 Asian=  Begin_Monitoring_=No
Identify_Race_or_Ethnicity=Hispanic, White Modified_By=Yetzaveli Almonte Outbreak_ID=
Outbreak_Related=N Annual_Income=  Annual_Income__Base_=  Place_of_Employment=
Primary_Race_or_Ethnicity=Yes. Please list your primary racial or ethnic identity below:
Are_you_blind_=No Are_you_deaf_or_do_you_have_seri=No Because_of_a_physical__mental_or=No
Deaf_or_do_you_have_serious_diff=  Difficulty_concentrating__rememb=
Difficulty_doing_errands_alone_=  Difficulty_walking_or_climbing_s=
Do_you_have_difficulty_dressing=No Do_you_have_serious_difficulty_w=No REAL_D_over_15=Yes
REAL_D_over_5=Yes Gender=Female DOB=. _ERROR_=1 _N_=15
NOTE: Invalid argument to function INPUT at line 94 column 8.
_Do_Not_Modify__Contact=e6fe71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=tbfiN+30/9LMdp7GK7OrxVw5XnAZA5GwvjrNAlqxod7DryYMgcJY9+F3CKHAm670tFZ/fUiC2
44H5eI6P1nauQ== _Do_Not_Modify__Modified_On=22FEB21:00:58:05 Last_Name=Vickers First_Name=Eleanor
DOBNUM=09/08/2008 Monitoring_Status=Marked for deduplication Status=Inactive
Address_1=142 Wenaha Ln
Roseburg, OR 97471 City=Roseburg County=Douglas
Preferred_Method_of_Contact=Phone Email=  Mobile_Phone=541-671-9001 Date_of_Last_Exposure=02/25/2021
End_of_Quarantine_Period=03/11/2021 Jurisdiction=Douglas CHD Owner=CALVIN NGUYEN
Created_On=17FEB21:08:11:08 Language=  _1st_Contact_Attempt=. _2nd_Contact_Attempt=.
_3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Confirmed Contact_Attempt_Successful=No
Contacted_Within_24_Hrs=No ContactedElapsedHrs=0 Created_By=SCOTT JEFFRIES Initial_Owner=
Last_Assessment_Date=. Modified_By__Delegate_=  Modified_By__External_Party_=
Modified_On=21FEB21:16:58:05 Record_Created_On=  State=OR Total_Assessments_with_Symptoms=0
American_Indian_and_Alaska_Nativ=  Black_or_African_American=  Case_ID=50898851 Children_s_Names=
Contact_ID=5336210 Contact_Person_ID=50924511 Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=
Native_Hawaiian_and_Pacific_Isla=  Person_ID=50924508 White=  ZIP_Code=97471 Asian=
Begin_Monitoring_=No Identify_Race_or_Ethnicity=  Modified_By=CALVIN NGUYEN Outbreak_ID=2021-54976
Outbreak_Related=Y Annual_Income=  Annual_Income__Base_=  Place_of_Employment=
Primary_Race_or_Ethnicity=  Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Female DOB=. _ERROR_=1
_N_=16
NOTE: Invalid argument to function INPUT at line 94 column 8.
_Do_Not_Modify__Contact=f0fe71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=YKKenp6MZoe85y0+xrBda+BZmT2XeO6e1MjkCQkuvRjuI1nznxR1WxlhtiKoxTEccYTi48n0+
1RH+p3Z20vRnQ== _Do_Not_Modify__Modified_On=20FEB21:16:39:14 Last_Name=De Jesus First_Name=Yahrixa
DOBNUM=01/29/2018 Monitoring_Status=Lost to Follow-up Status=Inactive Address_1=  City=
County=Umatilla Preferred_Method_of_Contact=Phone Email=  Mobile_Phone=541-215-3982
Date_of_Last_Exposure=02/14/2021 End_of_Quarantine_Period=02/28/2021 Jurisdiction=Umatilla CHD
Owner=Hunter Blake Created_On=17FEB21:08:11:09 Language=  _1st_Contact_Attempt=.
_2nd_Contact_Attempt=. _3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Confirmed
Contact_Attempt_Successful=No Contacted_Within_24_Hrs=No ContactedElapsedHrs=0
Created_By=SCOTT JEFFRIES Initial_Owner=  Last_Assessment_Date=. Modified_By__Delegate_=
Modified_By__External_Party_=  Modified_On=20FEB21:08:39:14 Record_Created_On=  State=
Total_Assessments_with_Symptoms=0 American_Indian_and_Alaska_Nativ=  Black_or_African_American=
Case_ID=50899093 Children_s_Names=  Contact_ID=5336225 Contact_Person_ID=50926050
Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=  Native_Hawaiian_and_Pacific_Isla=
Person_ID=50925749 White=  ZIP_Code=  Asian=  Begin_Monitoring_=No Identify_Race_or_Ethnicity=
Modified_By=Hunter Blake Outbreak_ID=  Outbreak_Related=N Annual_Income=  Annual_Income__Base_=
Place_of_Employment=  Primary_Race_or_Ethnicity=  Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Female DOB=. _ERROR_=1
_N_=17
NOTE: Invalid argument to function INPUT at line 94 column 8.
_Do_Not_Modify__Contact=f4fe71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=jwNftnUvlBI27zoVqwMDcPZhYG6OtzRCD7n9zQ6HBXCzM6CrqVF5G8lKo2yGDXqhVXVCJfcsw
oI9p+knFksbgA== _Do_Not_Modify__Modified_On=22FEB21:00:53:55 Last_Name=Goodman First_Name=Evan
DOBNUM=08/27/2004 Monitoring_Status=Marked for deduplication Status=Inactive
Address_1=142 Wenaha Ln
Roseburg, OR 97471 City=Roseburg County=Douglas
Preferred_Method_of_Contact=Phone Email=  Mobile_Phone=541-671-9001 Date_of_Last_Exposure=02/25/2021
End_of_Quarantine_Period=03/11/2021 Jurisdiction=Douglas CHD Owner=CALVIN NGUYEN
Created_On=17FEB21:08:11:09 Language=  _1st_Contact_Attempt=. _2nd_Contact_Attempt=.
_3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Confirmed Contact_Attempt_Successful=No
Contacted_Within_24_Hrs=No ContactedElapsedHrs=0 Created_By=SCOTT JEFFRIES Initial_Owner=
Last_Assessment_Date=. Modified_By__Delegate_=  Modified_By__External_Party_=
Modified_On=21FEB21:16:53:55 Record_Created_On=  State=OR Total_Assessments_with_Symptoms=0
American_Indian_and_Alaska_Nativ=  Black_or_African_American=  Case_ID=50898851 Children_s_Names=
Contact_ID=5336227 Contact_Person_ID=50924513 Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=
Native_Hawaiian_and_Pacific_Isla=  Person_ID=50924508 White=  ZIP_Code=97471 Asian=
Begin_Monitoring_=No Identify_Race_or_Ethnicity=  Modified_By=CALVIN NGUYEN Outbreak_ID=2021-54976
Outbreak_Related=Y Annual_Income=  Annual_Income__Base_=  Place_of_Employment=
Primary_Race_or_Ethnicity=  Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Male DOB=. _ERROR_=1
_N_=18
NOTE: Invalid argument to function INPUT at line 94 column 8.
_Do_Not_Modify__Contact=00ff71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=hdQiUIhKeCBfDRvLfsLKItKJO63VaK+wHfjVilBeCXgm+PLLHvSxjVKj7aoiD+DYunESWqW9A
KhYi9CI7+eYtw== _Do_Not_Modify__Modified_On=22FEB21:00:12:37 Last_Name=Blevins First_Name=Natalie
DOBNUM=08/09/2006 Monitoring_Status=Marked for deduplication Status=Inactive
Address_1=142 Wenaha Ln
Roseburg, OR 97471 City=Roseburg County=Douglas
Preferred_Method_of_Contact=Phone Email=  Mobile_Phone=541-671-9001 Date_of_Last_Exposure=02/25/2021
End_of_Quarantine_Period=03/11/2021 Jurisdiction=Douglas CHD Owner=CALVIN NGUYEN
Created_On=17FEB21:08:11:10 Language=  _1st_Contact_Attempt=. _2nd_Contact_Attempt=.
_3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Confirmed Contact_Attempt_Successful=No
Contacted_Within_24_Hrs=No ContactedElapsedHrs=0 Created_By=SCOTT JEFFRIES Initial_Owner=
Last_Assessment_Date=. Modified_By__Delegate_=  Modified_By__External_Party_=
Modified_On=21FEB21:16:12:37 Record_Created_On=  State=OR Total_Assessments_with_Symptoms=0
American_Indian_and_Alaska_Nativ=  Black_or_African_American=  Case_ID=50898851 Children_s_Names=
Contact_ID=5336236 Contact_Person_ID=50924510 Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=
Native_Hawaiian_and_Pacific_Isla=  Person_ID=50924508 White=  ZIP_Code=97471 Asian=
Begin_Monitoring_=No Identify_Race_or_Ethnicity=  Modified_By=Jolene MCGEE Outbreak_ID=2021-54976
Outbreak_Related=Y Annual_Income=  Annual_Income__Base_=  Place_of_Employment=
Primary_Race_or_Ethnicity=  Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Female DOB=. _ERROR_=1
_N_=19
NOTE: Invalid argument to function INPUT at line 94 column 8.
_Do_Not_Modify__Contact=06ff71aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=rUCpdBi2hqOQ5VSlWjg7Lxr8RjDqu+KM6lS/6cO4S5yiUGdviuq1w4324hLZJVkIGstx7WSFn
3yUM+xR6gY9gg== _Do_Not_Modify__Modified_On=22FEB21:00:28:45 Last_Name=Hatch First_Name=Sophia
DOBNUM=02/10/2011 Monitoring_Status=Marked for deduplication Status=Inactive
Address_1=142 Wenaha Ln
Roseburg, OR 97471 City=Roseburg County=Douglas
Preferred_Method_of_Contact=Phone Email=  Mobile_Phone=541-671-9001 Date_of_Last_Exposure=02/25/2021
End_of_Quarantine_Period=03/11/2021 Jurisdiction=Douglas CHD Owner=CALVIN NGUYEN
Created_On=17FEB21:08:11:11 Language=  _1st_Contact_Attempt=. _2nd_Contact_Attempt=.
_3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Confirmed Contact_Attempt_Successful=No
Contacted_Within_24_Hrs=No ContactedElapsedHrs=0 Created_By=SCOTT JEFFRIES Initial_Owner=
Last_Assessment_Date=. Modified_By__Delegate_=  Modified_By__External_Party_=
Modified_On=21FEB21:16:28:45 Record_Created_On=  State=OR Total_Assessments_with_Symptoms=0
American_Indian_and_Alaska_Nativ=  Black_or_African_American=  Case_ID=50898851 Children_s_Names=
Contact_ID=5336239 Contact_Person_ID=50924509 Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=
Native_Hawaiian_and_Pacific_Isla=  Person_ID=50924508 White=  ZIP_Code=97471 Asian=
Begin_Monitoring_=No Identify_Race_or_Ethnicity=  Modified_By=Jolene MCGEE Outbreak_ID=2021-54976
Outbreak_Related=Y Annual_Income=  Annual_Income__Base_=  Place_of_Employment=
Primary_Race_or_Ethnicity=  Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Female DOB=. _ERROR_=1
_N_=20
NOTE: Invalid argument to function INPUT at line 94 column 8.
_Do_Not_Modify__Contact=200072aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=RFGP9g2sPY7A0IusUji9pEIqth35WgIpUIwEIepuhOlcXj3/OjKxbWtZm0W4qbL9sEMkg20vI
4PQy8thq39d/w== _Do_Not_Modify__Modified_On=24FEB21:19:52:28 Last_Name=Gilbert First_Name=Dj
DOBNUM=03/15/2020 Monitoring_Status=Monitoring Status=Active
Address_1=7253 Hwy 3
Warm Springs, OR 97761 City=Warm Springs County=Jefferson
Preferred_Method_of_Contact=Phone Email=  Mobile_Phone=541-777-2080 Date_of_Last_Exposure=02/16/2021
End_of_Quarantine_Period=03/02/2021 Jurisdiction=Confederated Tribes of Warm Springs
Owner=Jennifer Robbins2 Created_On=17FEB21:08:11:34 Language=  _1st_Contact_Attempt=.
_2nd_Contact_Attempt=. _3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Confirmed
Contact_Attempt_Successful=No Contacted_Within_24_Hrs=No ContactedElapsedHrs=0
Created_By=SCOTT JEFFRIES Initial_Owner=  Last_Assessment_Date=02/24/2021 Modified_By__Delegate_=
Modified_By__External_Party_=  Modified_On=24FEB21:11:52:28 Record_Created_On=  State=OR
Total_Assessments_with_Symptoms=0 American_Indian_and_Alaska_Nativ=  Black_or_African_American=
Case_ID=50899429 Children_s_Names=  Contact_ID=5336600 Contact_Person_ID=50926341
Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=  Native_Hawaiian_and_Pacific_Isla=
Person_ID=50926293 White=  ZIP_Code=97761 Asian=  Begin_Monitoring_=No Identify_Race_or_Ethnicity=
Modified_By=Jennifer Robbins2 Outbreak_ID=  Outbreak_Related=N Annual_Income=  Annual_Income__Base_=
Place_of_Employment=  Primary_Race_or_Ethnicity=  Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Male DOB=. _ERROR_=1
_N_=21
NOTE: Invalid argument to function INPUT at line 94 column 8.
WARNING: Limit set by ERRORS= option reached.  Further errors of this type will not be printed.
_Do_Not_Modify__Contact=2c0072aa-3a71-eb11-b0b1-001dd801877a
_Do_Not_Modify__Row_Checksum=88fHyyVVjzz15JVpWDyVZvJiJkm62HLWWMUNlhozwvcNUYxnm4sqVt80ldkdLpIQoVOE+7WKu
Qxc8njBLXovxg== _Do_Not_Modify__Modified_On=23FEB21:21:42:14 Last_Name=Gilbert First_Name=Daniel
DOBNUM=07/01/1989 Monitoring_Status=Monitoring Status=Active
Address_1=7253 Hwy 3
Warm Springs, OR 97761 City=Warm Springs County=Jefferson
Preferred_Method_of_Contact=Phone Email=  Mobile_Phone=541-777-2080 Date_of_Last_Exposure=02/16/2021
End_of_Quarantine_Period=03/02/2021 Jurisdiction=Confederated Tribes of Warm Springs
Owner=Jennifer Robbins2 Created_On=17FEB21:08:11:35 Language=  _1st_Contact_Attempt=.
_2nd_Contact_Attempt=. _3rd_Contact_Attempt=. Access_Failed_Count=  CaseStatus=Confirmed
Contact_Attempt_Successful=No Contacted_Within_24_Hrs=No ContactedElapsedHrs=0
Created_By=SCOTT JEFFRIES Initial_Owner=  Last_Assessment_Date=02/23/2021 Modified_By__Delegate_=
Modified_By__External_Party_=  Modified_On=23FEB21:13:42:14 Record_Created_On=  State=OR
Total_Assessments_with_Symptoms=0 American_Indian_and_Alaska_Nativ=  Black_or_African_American=
Case_ID=50899429 Children_s_Names=  Contact_ID=5336609 Contact_Person_ID=50926349
Hispanic_or_Latino_a_x=  Middle_Eastern_North_African=  Native_Hawaiian_and_Pacific_Isla=
Person_ID=50926293 White=  ZIP_Code=97761 Asian=  Begin_Monitoring_=No Identify_Race_or_Ethnicity=
Modified_By=Jennifer Robbins2 Outbreak_ID=  Outbreak_Related=N Annual_Income=  Annual_Income__Base_=
Place_of_Employment=  Primary_Race_or_Ethnicity=  Are_you_blind_=  Are_you_deaf_or_do_you_have_seri=
Because_of_a_physical__mental_or=  Deaf_or_do_you_have_serious_diff=
Difficulty_concentrating__rememb=  Difficulty_doing_errands_alone_=
Difficulty_walking_or_climbing_s=  Do_you_have_difficulty_dressing=
Do_you_have_serious_difficulty_w=  REAL_D_over_15=No REAL_D_over_5=No Gender=Male DOB=. _ERROR_=1
_N_=22
NOTE: Mathematical operations could not be performed at the following places. The results of the
      operations have been set to missing values.
      Each place is given by: (Number of times) at (Line):(Column).
      67103 at 94:8
NOTE: There were 79176 observations read from the data set OPERA.ARIAS_VIEW_1.
NOTE: The data set OPERA.ARIAS_VIEW_1_CHECK has 79176 observations and 71 variables.
NOTE: Compressing data set OPERA.ARIAS_VIEW_1_CHECK decreased size by 82.25 percent.
      Compressed is 343 pages; un-compressed would require 1932 pages.
NOTE: DATA statement used (Total process time):
      real time           0.50 seconds
      cpu time            0.46 seconds

I then ran the same code against the arias_view_2 (according to proc contents it is char format $19.

Data OPERA.ARIAS_View_2_check;
Set OPERA.ARIAS_View_2(rename=(DOB=DOBNUM));
  DOB= input(DOBNUM,mmddyy10.);
  drop DOBNUM;
run;

The log is

Data OPERA.ARIAS_View_2_check;
98   Set OPERA.ARIAS_View_2(rename=(DOB=DOBNUM));
99     DOB= input(DOBNUM,mmddyy10.);
100    drop DOBNUM;
101  run;

NOTE: There were 80230 observations read from the data set OPERA.ARIAS_VIEW_2.
NOTE: The data set OPERA.ARIAS_VIEW_2_CHECK has 80230 observations and 74 variables.
NOTE: Compressing data set OPERA.ARIAS_VIEW_2_CHECK decreased size by 77.52 percent.
      Compressed is 451 pages; un-compressed would require 2006 pages.
NOTE: DATA statement used (Total process time):
      real time           0.59 seconds
      cpu time            0.46 seconds

I ran a check using a date format

proc print data=opera.arias_view_2_check (obs=10);
var dob;
format dob date9.;
run;

The result view

The SAS System 


Obs DOB 
1 . 
2 . 
3 . 
4 . 
5 . 
6 . 
7 . 
8 . 
9 . 
10 . 


So not sure on next steps.  SAS dates very perplexing.

[wlierman]

I'm circling back to try and lay out the information about the dob and age conundrum. 

I have four chunks of cases / contact data

First, involves bringing cases over so I will label Opera_1  and Opera_2 and for contacts Arias_1 and Arias_2

Opera_1:  data comes in an xlsx Excel worksheet. In the worksheet  dob  appears (if you are just looking at the worksheet) as

                   9-Jun-84                                                                                                                                                                  6/9/1984

                 21-May-00              and so on        when I highlight the cells the format values in the formula bar appears as        5/21/2000   and so on

                 16-Apr-13                                                                                                                                                                   4/16/2013 

After running proc import to move Opera_1 into a SAS data set the values in the dob field appear as    10APR1963  and so on.  Checking the dob

variable shows that           type = numeric    length = 8    format = date9.   no informat          transcode = No

Similarly, turning attention to Opera_2

Opera_2:  data comes in an xlsx Excel worksheet. In the worksheet  dob  appears (if you are just looking at the worksheet) as

                  13-Mar-01                                                                                                                                                                  3/13/2001

                  17-Dec-97              and so on        when I highlight the cells the format values in the formula bar appears as        12/17/1997   and so on

                  16-Mar-17                                                                                                                                                                   3/16/2017

After running proc import to move Opera_2 into a SAS data set the values in the dob field appear as    14JAN1957  and so on.  Checking the dob

variable shows that           type = numeric    length = 8    format = date9.   no informat          transcode = No

NOW THE TWO CONTACTS IN ARIAS STEPS:

Arias_1:  data comes in an xlsx Excel worksheet. In the worksheet  dob  appears (if you are just looking at the worksheet) as

                  12/22/2000                                                                                                                                                               12/22/2000

                   5/21/1966             and so on        when I highlight the cells the format values in the formula bar appears as         5/21/1966   and so on

                  11/22/2010                                                                                                                                                                11/22/2010

After running proc import to move Arias_1 into a SAS data set the values in the dob field appear as    11/15/1995  and so on.  Checking the dob

variable shows that           type = numeric    length = 8    format = MMDDYY10.         no informat          transcode = No

Arias_2:  data comes in an xlsx Excel worksheet. In the worksheet  dob  appears (if you are just looking at the worksheet) as

                  12/22/2000                                                                                                                                                               12/22/2000

                   5/21/1966             and so on        when I highlight the cells the format values in the formula bar appears as         5/21/1966   and so on

                  11/22/2010                                                                                                                                                                11/22/2010

THIS WHERE A PROBLEM OCCURS

After running proc import to move Arias_2 into a SAS data set the values in the dob field appear as    20292, 38052  and so on.  Checking the dob

variable shows that           type = text    length = 19    format = $19.      informat  = $19.        transcode = Yes

(I noticed that in Arias_2 it is the only dob field of the 4 that has an informat and transcode = yes).

How do I correct Arias_2?  And then I am going to match Opera obs with Arias obs to see how many cases came over into the contact tracing data set.

What is the correct way to convert the dob field in Opera_1 and Opera_2  to match correctly (smoothly) with the dob field in Arias_1 and Arias_2 after Arias_2  is corrected?

Then the last question is what can I do to prevent this mismatch from occurring again, since I will be merging Opera and Arias data for soem time to come?

Thank you for your continued help.

wklierman

[Kurt_Bremser · Accepted solution]

Do this:

date_var = input(string_var,19.) + '30dec1899'd;
format date_var mmddyy10.;

[wlierman]

That worked converting the text strings to the dob in form mm/dd/yyyy.

 Data SASCDC_2.Arias_VIEW_2;
462    Set SASCDC_2.Arias_VIEW_2;
463      dob_var = input(DOB,19.) + '30dec1899'd;
464      format dob_var mmddyy10.;
465  run;

NOTE: Invalid argument to function INPUT at line 463 column 15.

The only thing in the log that I couldn't see where the issue was is stated in the note.

Otherwise, thank you for the code solution.  In the future, if similar issues (text strings appearing) arise this would be the strategy to follow?

Thank you.

wklierman

[Kurt_Bremser]

There has to be a reason why PROC IMPORT made the variable character, and it is the observation that caused the NOTE. You have a string in there which is neither a date nor a valid missing value. The log should have a listing of the variable values for the offending observation(s).

[Kurt_Bremser]

And if you ask why we add this particular date:

SAS considers 1960-01-01 to be day zero, while Excel considers 1900-01-01 as day one.

But Excel also has a bug (taken over from Lotus 1-2-3, and yes, we are talking ancient computing here) and sees 1900 as a leap year (which it wasn't). Therefore we go back one day because of the zero/one difference, and another for the bug.

[Kurt_Bremser]

And if you have a fixed string appearing repeatedly (like "NA" for a missing value), you can build a custom informat that catches this string and uses a standard informat for the date.

But this will only really help when reading from text files, when importing from Excel you have to fix the data after the import.

[Kurt_Bremser]

A string containing '30427' looks like a misread Excel date to me.

Do

dob_num = input(dob,best.) + '30dec1899'd;
format dob_num yymmdd10.;

to see if you get reasonable values.

[wlierman]

Hello,

I ran the following code

Data OPERA.Big_Check;
  Set OPERA.Arias_View_2;
  dob_num = input(dob, best.) + '30dec1899'd;
  keep dob dob_num;
  format dob_num yymmdd10.;
run;

The log read as follows noting the msg on the missing values

Data OPERA.Big_Check;
15     Set OPERA.Arias_View_2;
16     dob_num = input(dob, best.) + '30dec1899'd;
17     keep dob dob_num;
18     format dob_num yymmdd10.;
19   run;

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).
      80230 at 16:31
NOTE: There were 80230 observations read from the data set OPERA.ARIAS_VIEW_2.
NOTE: The data set OPERA.BIG_CHECK has 80230 observations and 2 variables.
NOTE: Compressing data set OPERA.BIG_CHECK decreased size by 13.33 percent.
      Compressed is 26 pages; un-compressed would require 30 pages.
NOTE: DATA statement used (Total process time):
      real time           0.82 seconds
      cpu time            0.17 seconds

I ran a code as a check

proc print data = OPERA.Big_Check (obs = 10);
run;

With the resulting results view

The SAS System 


Obs DOB dob_num 
1 . . 
2 . . 
3 . . 
4 . . 
5 . . 
6 . . 
7 . . 
8 . . 
9 . . 
10 . . 

While it doesn't show up here in the results: DOB is left-justified (like a character var) and dob_num is right-justified (like a numeric var).

[Kurt_Bremser]

As you can see, dob is always missing (dot), so you cannot expect a non-missing result.

[ballardw]

Any calculation of AGE requires two dates: the DOB and the "as of" date to report the age.

Have you determined what the "as of" date will be? Or the rule for assigning it? Another date variable in the data such as date of service/contact/or similar activity? If so, does this second data variable have the same problem as a character variable?