Solved: Re: Conversion of dob to numeric and calculation of age to nmumeric va... - Page 2

wlierman · Posted 03-05-2021 04:13 PM

I would use something like this

Data OPERA.OPERA_ARIAS_Merge;
Set OPERA.OPERA_ARIAS_Merge;
If DOB1 NE .;
Age = int(yrdif(DOB1, today(), 'Actual'));
run;

to calculate the age.

wlierman · Posted 03-05-2021 04:15 PM

I would use something like this code

Data OPERA.OPERA_ARIAS_Merge;
  Set OPERA.OPERA_ARIAS_Merge;
  If DOB1 NE .;
Age = int(yrdif(DOB1, today(), 'Actual'));
run;

to calculate the age.

ballardw · Posted 03-05-2021 05:59 PM

@wlierman wrote:

I would use something like this code
Data OPERA.OPERA_ARIAS_Merge;
  Set OPERA.OPERA_ARIAS_Merge;
  If DOB1 NE .;
Age = int(yrdif(DOB1, today(), 'Actual'));
run;
to calculate the age.

Strongly suggest that you don't do that. If you have to do anything for modifying other variables that data step can change the age from day to day. It would be much more consistent to provide a date literal value in the AGE calculation such as

Age = int(yrdif(DOB1, '01MAR2021'd, 'Actual'));

or a static variable in the data, better in my opinion to documenting what goes on, with a date that has some meaning. Like the date other variables were collected or similar.

So you can clearly state what day was used for the calculation. Plus when you get another set of data and you calculate age you have something more comparable.

I deal with child data and have to examine things based on calendar age. I have the luxury, actually a report requirement, of a "date of collection" variable. When I look at age I am using the age at that point which is critical because one of the comparison points has a different curve value at two-week intervals. The data sets have the same children every 4 to 6 months. If I used the same "age" for all the records they would be having some biological issues when compared to that comparison curve standard.

wlierman · Posted 03-05-2021 06:46 PM

Thank you very much for the methodology based on your work.

I will follow suit. Though I am still mired in the throes of dob conversions.

Reeza · Posted 03-05-2021 08:06 PM

1. In your posts, please separate your code and text. The point of the code block is to be able to copy your code and paste it into the editor and hit run. If you don't then we have to manually separate them defeating the purpose of code blocks.

2. Have you read this paper yet? SAS Dates can seem confusing but once you understand the basics it's quite straightforward. It's a long paper, but you've likely already spent more time on this issue than it would take to read the paper.

https://communities.sas.com/t5/SAS-Communities-Library/Working-with-Dates-and-Times-in-SAS-Tutorial/...

3. Given what you've posted, my guess is you're applying the transformation to the wrong data set. Your posts are using data set names that don't match your code so it's not clear. Please post the exact output from the following code, filling in the blanks with the relevant table names.

proc sql;
create table type_issue as
select libname, memname, name, type, format
from sashelp.vcolumns
where libname = "OPERA" and upper(memname) in ("<DATA SET NAME 1>", "<DATA SET NAME 2>") and upper(name) = "DOB" ;
quit;

proc print data=type_issue;
run;

*FOR THE DATASET WITH THE CHARACTER DATE;
data check;
set opera.<insert dataset name>;
dob_num = input(dob, mmddyy10.);
keep dob dob_num;
format dob_num date9.;
run;

proc contents data=check;
run;

proc print data=check (obs=10);
run;

wlierman · Posted 03-05-2021 10:11 PM

Hello,

Thank you for being very helpful. Even though I still have work to do, your help is going to be a solution.

I will follow your directions to separate code and text and go forward from there.

I will send output once completed.

wklierman

wlierman · Posted 03-05-2021 10:36 PM

Thank you for the Karp powerpoint stack.
I have my reading cut out.

wlierman · Posted 03-06-2021 12:16 AM

I followed the steps that you outlined. Here is the code for part 1:

Proc sql noprint;
CREATE Table Opera.Type_Issue AS 
   SELECT libname, memname, name, type, format
   FROM dictionary.columns
   WHERE upcase(libname ) = "OPERA" /*and upcase(memtype) in ("OPERA.ARIAS_View_1", "OPERA.ARIAS_View_2") and upcase(name) = "DOB"*/
   ORDER by memname;
quit;

From my research, there were slight changes made from the documentation that I found.

The output from this code follows:

The SAS System 



--------------------------------------------------------------------------------
The SAS System 


Obs libname memname name type format 
1 OPERA ARIAS_ALL Person_ID char $8. 
2 OPERA ARIAS_ALL Place_of_Employment char $100. 
3 OPERA ARIAS_ALL Native_Hawaiian_and_Pacific_Isla char $128. 
4 OPERA ARIAS_ALL Deaf_or_do_you_have_serious_diff char $20. 
5 OPERA ARIAS_ALL DOB char   
6 OPERA ARIAS_ALL Do_you_have_serious_difficulty_l char $20. 
7 OPERA ARIAS_ALL Mobile_Phone char $48. 
8 OPERA ARIAS_ALL Initial_Owner char $810. 
9 OPERA ARIAS_ALL Last_Assessment_Date num MMDDYY10. 
10 OPERA ARIAS_ALL Date_of_Last_Exposure num MMDDYY10. 
11 OPERA ARIAS_ALL Contact_Attempt_Successful char $3. 
12 OPERA ARIAS_ALL Modified_On num DATETIME16. 
13 OPERA ARIAS_ALL White char $55. 
14 OPERA ARIAS_ALL Address_1 char $115. 
15 OPERA ARIAS_ALL CaseStatus char $11. 
16 OPERA ARIAS_ALL Modified_By__Delegate_ char $27. 
17 OPERA ARIAS_ALL Physical__mental_or_emotional_co char $20. 
18 OPERA ARIAS_ALL Middle_Eastern_North_African char $14. 
19 OPERA ARIAS_ALL Age num   
20 OPERA ARIAS_ALL State char $2. 
21 OPERA ARIAS_ALL _Do_Not_Modify__Modified_On num DATETIME16. 
22 OPERA ARIAS_ALL Because_of_a_physical__mental_or char $20. 
23 OPERA ARIAS_ALL Language char $28. 
24 OPERA ARIAS_ALL Difficulty_concentrating__rememb char $20. 
25 OPERA ARIAS_ALL Asian char $105. 
26 OPERA ARIAS_ALL Begin_Monitoring_ char $3. 
27 OPERA ARIAS_ALL ZIP_Code char $5. 
28 OPERA ARIAS_ALL Modified_By char $27. 
29 OPERA ARIAS_ALL REAL_D_over_5 char $3. 
30 OPERA ARIAS_ALL Jurisdiction char $41. 
31 OPERA ARIAS_ALL _1st_Contact_Attempt num DATETIME16. 
32 OPERA ARIAS_ALL County char $20. 
33 OPERA ARIAS_ALL _Do_Not_Modify__Contact char $36. 
34 OPERA ARIAS_ALL Record_Created_On char $1. 
35 OPERA ARIAS_ALL Owner char $47. 
36 OPERA ARIAS_ALL Are_you_deaf_or_do_you_have_seri char $20. 
37 OPERA ARIAS_ALL Access_Failed_Count char $1. 
38 OPERA ARIAS_ALL American_Indian_and_Alaska_Nativ char $127. 
39 OPERA ARIAS_ALL _3rd_Contact_Attempt num DATETIME16. 
40 OPERA ARIAS_ALL First_Name char $40. 
41 OPERA ARIAS_ALL City char $27. 
42 OPERA ARIAS_ALL Black_or_African_American char $39. 
43 OPERA ARIAS_ALL Monitoring_Status char $33. 
44 OPERA ARIAS_ALL _Do_Not_Modify__Row_Checksum char $88. 
45 OPERA ARIAS_ALL Annual_Income__Base_ char $1. 
46 OPERA ARIAS_ALL Primary_Race_or_Ethnicity char $62. 
47 OPERA ARIAS_ALL End_of_Quarantine_Period num MMDDYY10. 
48 OPERA ARIAS_ALL Are_you_blind_ char $20. 
49 OPERA ARIAS_ALL Do_you_have_serious_difficulty_w char $20. 
50 OPERA ARIAS_ALL Children_s_Names char $1. 
51 OPERA ARIAS_ALL Modified_By__External_Party_ char $1. 
52 OPERA ARIAS_ALL Do_you_have_serious_difficulty_1 char $43. 
53 OPERA ARIAS_ALL Outbreak_ID char $97. 
54 OPERA ARIAS_ALL Total_Assessments_with_Symptoms num BEST. 
55 OPERA ARIAS_ALL Contact_Person_ID char $11. 
56 OPERA ARIAS_ALL Status char $8. 
57 OPERA ARIAS_ALL Last_Name char $36. 
58 OPERA ARIAS_ALL Hispanic_or_Latino_a_x char $71. 
59 OPERA ARIAS_ALL DOB1 num DATE9. 
60 OPERA ARIAS_ALL Outbreak_Related char $9. 
61 OPERA ARIAS_ALL Gender char $7. 
62 OPERA ARIAS_ALL Difficulty_walking_or_climbing_s char $20. 
63 OPERA ARIAS_ALL Contacted_Within_24_Hrs char $3. 
64 OPERA ARIAS_ALL Difficulty_doing_errands_alone_ char $20. 
65 OPERA ARIAS_ALL Contact_ID char $11. 
66 OPERA ARIAS_ALL Identify_Race_or_Ethnicity char $76. 
67 OPERA ARIAS_ALL _2nd_Contact_Attempt num DATETIME16. 
68 OPERA ARIAS_ALL Case_ID char $8. 
69 OPERA ARIAS_ALL Email char $64. 
70 OPERA ARIAS_ALL Created_By char $15. 
71 OPERA ARIAS_ALL Created_On num DATETIME16. 
72 OPERA ARIAS_ALL Annual_Income char $1. 
73 OPERA ARIAS_ALL REAL_D_over_15 char $3. 
74 OPERA ARIAS_ALL Do_you_have_difficulty_dressing char $20. 
75 OPERA ARIAS_ALL ContactedElapsedHrs num BEST. 
76 OPERA ARIAS_ALL Preferred_Method_of_Contact char $5. 
77 OPERA ARIAS_VIEW_1 Modified_By__External_Party_ char $1. 
78 OPERA ARIAS_VIEW_1 Last_Name char $36. 
79 OPERA ARIAS_VIEW_1 Gender char $7. 
80 OPERA ARIAS_VIEW_1 Case_ID char $8. 
81 OPERA ARIAS_VIEW_1 Modified_On num DATETIME16. 
82 OPERA ARIAS_VIEW_1 _1st_Contact_Attempt num DATETIME16. 
83 OPERA ARIAS_VIEW_1 DOB num MMDDYY10. 
84 OPERA ARIAS_VIEW_1 Status char $8. 
85 OPERA ARIAS_VIEW_1 First_Name char $40. 
86 OPERA ARIAS_VIEW_1 _Do_Not_Modify__Modified_On num DATETIME16. 
87 OPERA ARIAS_VIEW_1 _Do_Not_Modify__Row_Checksum char $88. 
88 OPERA ARIAS_VIEW_1 Access_Failed_Count char $1. 
89 OPERA ARIAS_VIEW_1 Monitoring_Status char $33. 
90 OPERA ARIAS_VIEW_1 CaseStatus char $11. 
91 OPERA ARIAS_VIEW_1 Are_you_blind_ char $20. 
92 OPERA ARIAS_VIEW_1 Person_ID char $8. 
93 OPERA ARIAS_VIEW_1 Language char $28. 
94 OPERA ARIAS_VIEW_1 City char $27. 
95 OPERA ARIAS_VIEW_1 Contact_Person_ID char $11. 
96 OPERA ARIAS_VIEW_1 Preferred_Method_of_Contact char $5. 
97 OPERA ARIAS_VIEW_1 Children_s_Names char $1. 
98 OPERA ARIAS_VIEW_1 Do_you_have_serious_difficulty_w char $20. 
99 OPERA ARIAS_VIEW_1 County char $20. 
100 OPERA ARIAS_VIEW_1 ZIP_Code char $5. 
101 OPERA ARIAS_VIEW_1 Hispanic_or_Latino_a_x char $71. 
102 OPERA ARIAS_VIEW_1 REAL_D_over_5 char $3. 
103 OPERA ARIAS_VIEW_1 End_of_Quarantine_Period num MMDDYY10. 
104 OPERA ARIAS_VIEW_1 American_Indian_and_Alaska_Nativ char $127. 
105 OPERA ARIAS_VIEW_1 Black_or_African_American char $39. 
106 OPERA ARIAS_VIEW_1 Created_On num DATETIME16. 
107 OPERA ARIAS_VIEW_1 Mobile_Phone char $48. 
108 OPERA ARIAS_VIEW_1 Native_Hawaiian_and_Pacific_Isla char $128. 
109 OPERA ARIAS_VIEW_1 State char $2. 
110 OPERA ARIAS_VIEW_1 _2nd_Contact_Attempt num DATETIME16. 
111 OPERA ARIAS_VIEW_1 _Do_Not_Modify__Contact char $36. 
112 OPERA ARIAS_VIEW_1 Record_Created_On char $1. 
113 OPERA ARIAS_VIEW_1 White char $55. 
114 OPERA ARIAS_VIEW_1 Address_1 char $115. 
115 OPERA ARIAS_VIEW_1 Total_Assessments_with_Symptoms num BEST. 
116 OPERA ARIAS_VIEW_1 Created_By char $15. 
117 OPERA ARIAS_VIEW_1 Owner char $47. 
118 OPERA ARIAS_VIEW_1 Identify_Race_or_Ethnicity char $76. 
119 OPERA ARIAS_VIEW_1 Modified_By__Delegate_ char $27. 
120 OPERA ARIAS_VIEW_1 REAL_D_over_15 char $3. 
121 OPERA ARIAS_VIEW_1 Jurisdiction char $41. 
122 OPERA ARIAS_VIEW_1 ContactedElapsedHrs num BEST. 
123 OPERA ARIAS_VIEW_1 Difficulty_walking_or_climbing_s char $20. 
124 OPERA ARIAS_VIEW_1 Because_of_a_physical__mental_or char $20. 
125 OPERA ARIAS_VIEW_1 Asian char $105. 
126 OPERA ARIAS_VIEW_1 Last_Assessment_Date num MMDDYY10. 
127 OPERA ARIAS_VIEW_1 Primary_Race_or_Ethnicity char $62. 
128 OPERA ARIAS_VIEW_1 Annual_Income char $1. 
129 OPERA ARIAS_VIEW_1 Outbreak_ID char $97. 
130 OPERA ARIAS_VIEW_1 Difficulty_doing_errands_alone_ char $20. 
131 OPERA ARIAS_VIEW_1 Begin_Monitoring_ char $3. 
132 OPERA ARIAS_VIEW_1 Outbreak_Related char $9. 
133 OPERA ARIAS_VIEW_1 Contacted_Within_24_Hrs char $3. 
134 OPERA ARIAS_VIEW_1 Annual_Income__Base_ char $1. 
135 OPERA ARIAS_VIEW_1 Difficulty_concentrating__rememb char $20. 
136 OPERA ARIAS_VIEW_1 Are_you_deaf_or_do_you_have_seri char $20. 
137 OPERA ARIAS_VIEW_1 Date_of_Last_Exposure num MMDDYY10. 
138 OPERA ARIAS_VIEW_1 Place_of_Employment char $100. 
139 OPERA ARIAS_VIEW_1 Contact_ID char $11. 
140 OPERA ARIAS_VIEW_1 Modified_By char $27. 
141 OPERA ARIAS_VIEW_1 Middle_Eastern_North_African char $14. 
142 OPERA ARIAS_VIEW_1 Initial_Owner char $810. 
143 OPERA ARIAS_VIEW_1 Email char $64. 
144 OPERA ARIAS_VIEW_1 Contact_Attempt_Successful char $3. 
145 OPERA ARIAS_VIEW_1 _3rd_Contact_Attempt num DATETIME16. 
146 OPERA ARIAS_VIEW_1 Do_you_have_difficulty_dressing char $20. 
147 OPERA ARIAS_VIEW_1 Deaf_or_do_you_have_serious_diff char $20. 
148 OPERA ARIAS_VIEW_1_CHECK Record_Created_On char $1. 
149 OPERA ARIAS_VIEW_1_CHECK _1st_Contact_Attempt num DATETIME16. 
150 OPERA ARIAS_VIEW_1_CHECK Outbreak_ID char $97. 
151 OPERA ARIAS_VIEW_1_CHECK Asian char $105. 
152 OPERA ARIAS_VIEW_1_CHECK State char $2. 
153 OPERA ARIAS_VIEW_1_CHECK Created_On num DATETIME16. 
154 OPERA ARIAS_VIEW_1_CHECK Contact_Person_ID char $11. 
155 OPERA ARIAS_VIEW_1_CHECK Address_1 char $115. 
156 OPERA ARIAS_VIEW_1_CHECK End_of_Quarantine_Period num MMDDYY10. 
157 OPERA ARIAS_VIEW_1_CHECK Middle_Eastern_North_African char $14. 
158 OPERA ARIAS_VIEW_1_CHECK Are_you_blind_ char $20. 
159 OPERA ARIAS_VIEW_1_CHECK Gender char $7. 
160 OPERA ARIAS_VIEW_1_CHECK Contact_ID char $11. 
161 OPERA ARIAS_VIEW_1_CHECK Hispanic_or_Latino_a_x char $71. 
162 OPERA ARIAS_VIEW_1_CHECK REAL_D_over_5 char $3. 
163 OPERA ARIAS_VIEW_1_CHECK Case_ID char $8. 
164 OPERA ARIAS_VIEW_1_CHECK Modified_By char $27. 
165 OPERA ARIAS_VIEW_1_CHECK Difficulty_concentrating__rememb char $20. 
166 OPERA ARIAS_VIEW_1_CHECK White char $55. 
167 OPERA ARIAS_VIEW_1_CHECK Modified_By__External_Party_ char $1. 
168 OPERA ARIAS_VIEW_1_CHECK Begin_Monitoring_ char $3. 
169 OPERA ARIAS_VIEW_1_CHECK Primary_Race_or_Ethnicity char $62. 
170 OPERA ARIAS_VIEW_1_CHECK Person_ID char $8. 
171 OPERA ARIAS_VIEW_1_CHECK Status char $8. 
172 OPERA ARIAS_VIEW_1_CHECK Email char $64. 
173 OPERA ARIAS_VIEW_1_CHECK Outbreak_Related char $9. 
174 OPERA ARIAS_VIEW_1_CHECK Owner char $47. 
175 OPERA ARIAS_VIEW_1_CHECK County char $20. 
176 OPERA ARIAS_VIEW_1_CHECK Last_Name char $36. 
177 OPERA ARIAS_VIEW_1_CHECK _Do_Not_Modify__Modified_On num DATETIME16. 
178 OPERA ARIAS_VIEW_1_CHECK _Do_Not_Modify__Row_Checksum char $88. 
179 OPERA ARIAS_VIEW_1_CHECK Contact_Attempt_Successful char $3. 
180 OPERA ARIAS_VIEW_1_CHECK Contacted_Within_24_Hrs char $3. 
181 OPERA ARIAS_VIEW_1_CHECK Language char $28. 
182 OPERA ARIAS_VIEW_1_CHECK Created_By char $15. 
183 OPERA ARIAS_VIEW_1_CHECK Last_Assessment_Date num MMDDYY10. 
184 OPERA ARIAS_VIEW_1_CHECK ContactedElapsedHrs num BEST. 
185 OPERA ARIAS_VIEW_1_CHECK _Do_Not_Modify__Contact char $36. 
186 OPERA ARIAS_VIEW_1_CHECK Annual_Income__Base_ char $1. 
187 OPERA ARIAS_VIEW_1_CHECK Modified_By__Delegate_ char $27. 
188 OPERA ARIAS_VIEW_1_CHECK _2nd_Contact_Attempt num DATETIME16. 
189 OPERA ARIAS_VIEW_1_CHECK First_Name char $40. 
190 OPERA ARIAS_VIEW_1_CHECK Monitoring_Status char $33. 
191 OPERA ARIAS_VIEW_1_CHECK Jurisdiction char $41. 
192 OPERA ARIAS_VIEW_1_CHECK Native_Hawaiian_and_Pacific_Isla char $128. 
193 OPERA ARIAS_VIEW_1_CHECK Date_of_Last_Exposure num MMDDYY10. 
194 OPERA ARIAS_VIEW_1_CHECK Access_Failed_Count char $1. 
195 OPERA ARIAS_VIEW_1_CHECK Preferred_Method_of_Contact char $5. 
196 OPERA ARIAS_VIEW_1_CHECK Do_you_have_difficulty_dressing char $20. 
197 OPERA ARIAS_VIEW_1_CHECK ZIP_Code char $5. 
198 OPERA ARIAS_VIEW_1_CHECK Annual_Income char $1. 
199 OPERA ARIAS_VIEW_1_CHECK City char $27. 
200 OPERA ARIAS_VIEW_1_CHECK Place_of_Employment char $100. 
201 OPERA ARIAS_VIEW_1_CHECK Because_of_a_physical__mental_or char $20. 
202 OPERA ARIAS_VIEW_1_CHECK _3rd_Contact_Attempt num DATETIME16. 
203 OPERA ARIAS_VIEW_1_CHECK Are_you_deaf_or_do_you_have_seri char $20. 
204 OPERA ARIAS_VIEW_1_CHECK REAL_D_over_15 char $3. 
205 OPERA ARIAS_VIEW_1_CHECK Black_or_African_American char $39. 
206 OPERA ARIAS_VIEW_1_CHECK Do_you_have_serious_difficulty_w char $20. 
207 OPERA ARIAS_VIEW_1_CHECK Total_Assessments_with_Symptoms num BEST. 
208 OPERA ARIAS_VIEW_1_CHECK Difficulty_walking_or_climbing_s char $20. 
209 OPERA ARIAS_VIEW_1_CHECK American_Indian_and_Alaska_Nativ char $127. 
210 OPERA ARIAS_VIEW_1_CHECK Initial_Owner char $810. 
211 OPERA ARIAS_VIEW_1_CHECK Deaf_or_do_you_have_serious_diff char $20. 
212 OPERA ARIAS_VIEW_1_CHECK CaseStatus char $11. 
213 OPERA ARIAS_VIEW_1_CHECK Difficulty_doing_errands_alone_ char $20. 
214 OPERA ARIAS_VIEW_1_CHECK Children_s_Names char $1. 
215 OPERA ARIAS_VIEW_1_CHECK Identify_Race_or_Ethnicity char $76. 
216 OPERA ARIAS_VIEW_1_CHECK Mobile_Phone char $48. 
217 OPERA ARIAS_VIEW_1_CHECK DOB num   
218 OPERA ARIAS_VIEW_1_CHECK Modified_On num DATETIME16. 
219 OPERA ARIAS_VIEW_2 _Do_Not_Modify__Contact char $36. 
220 OPERA ARIAS_VIEW_2 Modified_By__Delegate_ char $24. 
221 OPERA ARIAS_VIEW_2 Modified_By__External_Party_ char $1. 
222 OPERA ARIAS_VIEW_2 First_Name char $51. 
223 OPERA ARIAS_VIEW_2 Initial_Owner char $50. 
224 OPERA ARIAS_VIEW_2 ContactedElapsedHrs num BEST. 
225 OPERA ARIAS_VIEW_2 City char $48. 
226 OPERA ARIAS_VIEW_2 Access_Failed_Count char $1. 
227 OPERA ARIAS_VIEW_2 _3rd_Contact_Attempt num DATETIME16. 
228 OPERA ARIAS_VIEW_2 _2nd_Contact_Attempt num DATETIME16. 
229 OPERA ARIAS_VIEW_2 Created_On num DATETIME16. 
230 OPERA ARIAS_VIEW_2 Jurisdiction char $31. 
231 OPERA ARIAS_VIEW_2 Date_of_Last_Exposure num MMDDYY10. 
232 OPERA ARIAS_VIEW_2 Created_By char $15. 
233 OPERA ARIAS_VIEW_2 Modified_On num DATETIME16. 
234 OPERA ARIAS_VIEW_2 Last_Name char $37. 
235 OPERA ARIAS_VIEW_2 Last_Assessment_Date num MMDDYY10. 
236 OPERA ARIAS_VIEW_2 Monitoring_Status char $33. 
237 OPERA ARIAS_VIEW_2 Address_1 char $120. 
238 OPERA ARIAS_VIEW_2 Status char $8. 
239 OPERA ARIAS_VIEW_2 DOB char   
240 OPERA ARIAS_VIEW_2 _1st_Contact_Attempt num DATETIME16. 
241 OPERA ARIAS_VIEW_2 Do_you_have_serious_difficulty_1 char $43. 
242 OPERA ARIAS_VIEW_2 End_of_Quarantine_Period num MMDDYY10. 
243 OPERA ARIAS_VIEW_2 Owner char $36. 
244 OPERA ARIAS_VIEW_2 Mobile_Phone char $44. 
245 OPERA ARIAS_VIEW_2 American_Indian_and_Alaska_Nativ char $127. 
246 OPERA ARIAS_VIEW_2 State char $2. 
247 OPERA ARIAS_VIEW_2 Language char $28. 
248 OPERA ARIAS_VIEW_2 Total_Assessments_with_Symptoms num BEST. 
249 OPERA ARIAS_VIEW_2 County char $23. 
250 OPERA ARIAS_VIEW_2 Email char $51. 
251 OPERA ARIAS_VIEW_2 Gender char $7. 
252 OPERA ARIAS_VIEW_2 _Do_Not_Modify__Row_Checksum char $88. 
253 OPERA ARIAS_VIEW_2 Contacted_Within_24_Hrs char $3. 
254 OPERA ARIAS_VIEW_2 Record_Created_On char $1. 
255 OPERA ARIAS_VIEW_2 _Do_Not_Modify__Modified_On num DATETIME16. 
256 OPERA ARIAS_VIEW_2 REAL_D_over_15 char $3. 
257 OPERA ARIAS_VIEW_2 Preferred_Method_of_Contact char $5. 
258 OPERA ARIAS_VIEW_2 CaseStatus char $11. 
259 OPERA ARIAS_VIEW_2 REAL_D_over_5 char $3. 
260 OPERA ARIAS_VIEW_2 Modified_By char $26. 
261 OPERA ARIAS_VIEW_2 Physical__mental_or_emotional_co char $20. 
262 OPERA ARIAS_VIEW_2 Place_of_Employment char $100. 
263 OPERA ARIAS_VIEW_2 Case_ID char $8. 
264 OPERA ARIAS_VIEW_2 Contact_ID char $11. 
265 OPERA ARIAS_VIEW_2 Difficulty_concentrating__rememb char $20. 
266 OPERA ARIAS_VIEW_2 Because_of_a_physical__mental_or char $20. 
267 OPERA ARIAS_VIEW_2 Native_Hawaiian_and_Pacific_Isla char $128. 
268 OPERA ARIAS_VIEW_2 Primary_Race_or_Ethnicity char $62. 
269 OPERA ARIAS_VIEW_2 Deaf_or_do_you_have_serious_diff char $20. 
270 OPERA ARIAS_VIEW_2 Are_you_blind_ char $20. 
271 OPERA ARIAS_VIEW_2 Middle_Eastern_North_African char $29. 
272 OPERA ARIAS_VIEW_2 White char $55. 
273 OPERA ARIAS_VIEW_2 Outbreak_Related char $9. 
274 OPERA ARIAS_VIEW_2 Annual_Income__Base_ char $1. 
275 OPERA ARIAS_VIEW_2 Asian char $140. 
276 OPERA ARIAS_VIEW_2 Do_you_have_serious_difficulty_l char $20. 
277 OPERA ARIAS_VIEW_2 Outbreak_ID char $97. 
278 OPERA ARIAS_VIEW_2 Identify_Race_or_Ethnicity char $100. 
279 OPERA ARIAS_VIEW_2 Do_you_have_serious_difficulty_w char $20. 
280 OPERA ARIAS_VIEW_2 Begin_Monitoring_ char $3. 
281 OPERA ARIAS_VIEW_2 Annual_Income char $1. 
282 OPERA ARIAS_VIEW_2 ZIP_Code char $5. 
283 OPERA ARIAS_VIEW_2 Difficulty_doing_errands_alone_ char $20. 
284 OPERA ARIAS_VIEW_2 Person_ID char $8. 
285 OPERA ARIAS_VIEW_2 Are_you_deaf_or_do_you_have_seri char $20. 
286 OPERA ARIAS_VIEW_2 Contact_Attempt_Successful char $3. 
287 OPERA ARIAS_VIEW_2 Hispanic_or_Latino_a_x char $71. 
288 OPERA ARIAS_VIEW_2 Contact_Person_ID char $11. 
289 OPERA ARIAS_VIEW_2 Difficulty_walking_or_climbing_s char $20. 
290 OPERA ARIAS_VIEW_2 Children_s_Names char $1. 
291 OPERA ARIAS_VIEW_2 Do_you_have_difficulty_dressing char $20. 
292 OPERA ARIAS_VIEW_2 Black_or_African_American char $87. 
293 OPERA ARIAS_VIEW_2_CHECK Physical__mental_or_emotional_co char $20. 
294 OPERA ARIAS_VIEW_2_CHECK Difficulty_walking_or_climbing_s char $20. 
295 OPERA ARIAS_VIEW_2_CHECK REAL_D_over_5 char $3. 
296 OPERA ARIAS_VIEW_2_CHECK DOB num   
297 OPERA ARIAS_VIEW_2_CHECK Contacted_Within_24_Hrs char $3. 
298 OPERA ARIAS_VIEW_2_CHECK Contact_Attempt_Successful char $3. 
299 OPERA ARIAS_VIEW_2_CHECK Do_you_have_serious_difficulty_l char $20. 
300 OPERA ARIAS_VIEW_2_CHECK Do_you_have_difficulty_dressing char $20. 
301 OPERA ARIAS_VIEW_2_CHECK Difficulty_doing_errands_alone_ char $20. 
302 OPERA ARIAS_VIEW_2_CHECK Modified_On num DATETIME16. 
303 OPERA ARIAS_VIEW_2_CHECK Mobile_Phone char $44. 
304 OPERA ARIAS_VIEW_2_CHECK Do_you_have_serious_difficulty_1 char $43. 
305 OPERA ARIAS_VIEW_2_CHECK City char $48. 
306 OPERA ARIAS_VIEW_2_CHECK Preferred_Method_of_Contact char $5. 
307 OPERA ARIAS_VIEW_2_CHECK Monitoring_Status char $33. 
308 OPERA ARIAS_VIEW_2_CHECK Because_of_a_physical__mental_or char $20. 
309 OPERA ARIAS_VIEW_2_CHECK Identify_Race_or_Ethnicity char $100. 
310 OPERA ARIAS_VIEW_2_CHECK Children_s_Names char $1. 
311 OPERA ARIAS_VIEW_2_CHECK _Do_Not_Modify__Modified_On num DATETIME16. 
312 OPERA ARIAS_VIEW_2_CHECK Annual_Income__Base_ char $1. 
313 OPERA ARIAS_VIEW_2_CHECK Difficulty_concentrating__rememb char $20. 
314 OPERA ARIAS_VIEW_2_CHECK Do_you_have_serious_difficulty_w char $20. 
315 OPERA ARIAS_VIEW_2_CHECK REAL_D_over_15 char $3. 
316 OPERA ARIAS_VIEW_2_CHECK Deaf_or_do_you_have_serious_diff char $20. 
317 OPERA ARIAS_VIEW_2_CHECK Primary_Race_or_Ethnicity char $62. 
318 OPERA ARIAS_VIEW_2_CHECK Place_of_Employment char $100. 
319 OPERA ARIAS_VIEW_2_CHECK Outbreak_Related char $9. 
320 OPERA ARIAS_VIEW_2_CHECK Outbreak_ID char $97. 
321 OPERA ARIAS_VIEW_2_CHECK _Do_Not_Modify__Contact char $36. 
322 OPERA ARIAS_VIEW_2_CHECK Modified_By char $26. 
323 OPERA ARIAS_VIEW_2_CHECK ZIP_Code char $5. 
324 OPERA ARIAS_VIEW_2_CHECK First_Name char $51. 
325 OPERA ARIAS_VIEW_2_CHECK Native_Hawaiian_and_Pacific_Isla char $128. 
326 OPERA ARIAS_VIEW_2_CHECK Status char $8. 
327 OPERA ARIAS_VIEW_2_CHECK Hispanic_or_Latino_a_x char $71. 
328 OPERA ARIAS_VIEW_2_CHECK Person_ID char $8. 
329 OPERA ARIAS_VIEW_2_CHECK Middle_Eastern_North_African char $29. 
330 OPERA ARIAS_VIEW_2_CHECK White char $55. 
331 OPERA ARIAS_VIEW_2_CHECK County char $23. 
332 OPERA ARIAS_VIEW_2_CHECK Contact_Person_ID char $11. 
333 OPERA ARIAS_VIEW_2_CHECK Contact_ID char $11. 
334 OPERA ARIAS_VIEW_2_CHECK Last_Assessment_Date num MMDDYY10. 
335 OPERA ARIAS_VIEW_2_CHECK Case_ID char $8. 
336 OPERA ARIAS_VIEW_2_CHECK Total_Assessments_with_Symptoms num BEST. 
337 OPERA ARIAS_VIEW_2_CHECK American_Indian_and_Alaska_Nativ char $127. 
338 OPERA ARIAS_VIEW_2_CHECK End_of_Quarantine_Period num MMDDYY10. 
339 OPERA ARIAS_VIEW_2_CHECK Begin_Monitoring_ char $3. 
340 OPERA ARIAS_VIEW_2_CHECK State char $2. 
341 OPERA ARIAS_VIEW_2_CHECK Owner char $36. 
342 OPERA ARIAS_VIEW_2_CHECK Record_Created_On char $1. 
343 OPERA ARIAS_VIEW_2_CHECK Created_On num DATETIME16. 
344 OPERA ARIAS_VIEW_2_CHECK Language char $28. 
345 OPERA ARIAS_VIEW_2_CHECK Modified_By__Delegate_ char $24. 
346 OPERA ARIAS_VIEW_2_CHECK Created_By char $15. 
347 OPERA ARIAS_VIEW_2_CHECK Access_Failed_Count char $1. 
348 OPERA ARIAS_VIEW_2_CHECK ContactedElapsedHrs num BEST. 
349 OPERA ARIAS_VIEW_2_CHECK CaseStatus char $11. 
350 OPERA ARIAS_VIEW_2_CHECK _3rd_Contact_Attempt num DATETIME16. 
351 OPERA ARIAS_VIEW_2_CHECK _2nd_Contact_Attempt num DATETIME16. 
352 OPERA ARIAS_VIEW_2_CHECK _1st_Contact_Attempt num DATETIME16. 
353 OPERA ARIAS_VIEW_2_CHECK Modified_By__External_Party_ char $1. 
354 OPERA ARIAS_VIEW_2_CHECK Jurisdiction char $31. 
355 OPERA ARIAS_VIEW_2_CHECK Email char $51. 
356 OPERA ARIAS_VIEW_2_CHECK Address_1 char $120. 
357 OPERA ARIAS_VIEW_2_CHECK Last_Name char $37. 
358 OPERA ARIAS_VIEW_2_CHECK Annual_Income char $1. 
359 OPERA ARIAS_VIEW_2_CHECK Initial_Owner char $50. 
360 OPERA ARIAS_VIEW_2_CHECK Are_you_deaf_or_do_you_have_seri char $20. 
361 OPERA ARIAS_VIEW_2_CHECK Gender char $7. 
362 OPERA ARIAS_VIEW_2_CHECK _Do_Not_Modify__Row_Checksum char $88. 
363 OPERA ARIAS_VIEW_2_CHECK Asian char $140. 
364 OPERA ARIAS_VIEW_2_CHECK Black_or_African_American char $87. 
365 OPERA ARIAS_VIEW_2_CHECK Date_of_Last_Exposure num MMDDYY10. 
366 OPERA ARIAS_VIEW_2_CHECK Are_you_blind_ char $20. 
367 OPERA BIG_CHECK dob_num num DATE9. 
368 OPERA BIG_CHECK DOB char   
369 OPERA OPERA_1 TonganOIC char $11. 
370 OPERA OPERA_1 ChamOIC char $16. 
371 OPERA OPERA_1 AfricanOIC char $16. 
372 OPERA OPERA_1 CaribbeanOIC char $16. 
373 OPERA OPERA_1 EthiopianOIC char $16. 
374 OPERA OPERA_1 SomaliOIC char $16. 
375 OPERA OPERA_1 AfrAmOIC char $16. 
376 OPERA OPERA_1 SoAsianOIC char $16. 
377 OPERA OPERA_1 LaotianOIC char $16. 
378 OPERA OPERA_1 JapaneseOIC char $16. 
379 OPERA OPERA_1 ChineseOIC char $16. 
380 OPERA OPERA_1 CambodianOIC char $16. 
381 OPERA OPERA_1 AsianOthOIC char $16. 
382 OPERA OPERA_1 AIANAggOIC char $16. 
383 OPERA OPERA_1 LatIndOIC char $16. 
384 OPERA OPERA_1 AlaskNatOIC char $16. 
385 OPERA OPERA_1 REOIC char $24. 
386 OPERA OPERA_1 REansEv char $3. 
387 OPERA OPERA_1 Rac8ca char $28. 
388 OPERA OPERA_1 Rac9ca char $28. 
389 OPERA OPERA_1 Asian char $3. 
390 OPERA OPERA_1 Black char $3. 
391 OPERA OPERA_1 TribalElg num BEST. 
392 OPERA OPERA_1 White char $3. 
393 OPERA OPERA_1 MENA char $3. 
394 OPERA OPERA_1 REansV6 num BEST. 
395 OPERA OPERA_1 AmIndOIC char $16. 
396 OPERA OPERA_1 REansV4keep num BEST. 
397 OPERA OPERA_1 Jewish num BEST. 
398 OPERA OPERA_1 CanIndOIC char $16. 
399 OPERA OPERA_1 AsianAggOIC char $16. 
400 OPERA OPERA_1 REansV3 num BEST. 
401 OPERA OPERA_1 REansOrig num BEST. 
402 OPERA OPERA_1 HmongOIC char $16. 
403 OPERA OPERA_1 ModRMax num DATE9. 
404 OPERA OPERA_1 TribAfflia char $75. 
405 OPERA OPERA_1 RaceMainN num BEST. 
406 OPERA OPERA_1 AsianIndOIC char $16. 
407 OPERA OPERA_1 KoreanOIC char $16. 
408 OPERA OPERA_1 MiddleNm char $26. 
409 OPERA OPERA_1 PersonID2S num BEST. 
410 OPERA OPERA_1 CreateDtMin num DATE9. 
411 OPERA OPERA_1 CreateDtMax num DATE9. 
412 OPERA OPERA_1 Hispanic char $3. 
413 OPERA OPERA_1 Othwhite char $3. 
414 OPERA OPERA_1 VietnameseOIC char $16. 
415 OPERA OPERA_1 NatHawOIC char $16. 
416 OPERA OPERA_1 WhiteAgg char $3. 
417 OPERA OPERA_1 EastEur char $3. 
418 OPERA OPERA_1 MENAAgg char $2. 
419 OPERA OPERA_1 NoAfr char $3. 
420 OPERA OPERA_1 HisCen char $3. 
421 OPERA OPERA_1 GuamOIC char $16. 
422 OPERA OPERA_1 HisOth char $3. 
423 OPERA OPERA_1 HisSou char $3. 
424 OPERA OPERA_1 NHPIAgg char $3. 
425 OPERA OPERA_1 age num BEST. 
426 OPERA OPERA_1 DA7comp char $15. 
427 OPERA OPERA_1 HispAgg char $3. 
428 OPERA OPERA_1 Caribbean char $3. 
429 OPERA OPERA_1 BlackAgg char $3. 
430 OPERA OPERA_1 DMHDdi char $3. 
431 OPERA OPERA_1 Ethiopian char $3. 
432 OPERA OPERA_1 Somali char $3. 
433 OPERA OPERA_1 Vietnamese char $3. 
434 OPERA OPERA_1 DREMdi char $3. 
435 OPERA OPERA_1 BlackOthOIC char $16. 
436 OPERA OPERA_1 HispOldS char $12. 
437 OPERA OPERA_1 SoAsian char $3. 
438 OPERA OPERA_1 Myanmar char $3. 
439 OPERA OPERA_1 BlackAggOIC char $16. 
440 OPERA OPERA_1 Gender char $39. 
441 OPERA OPERA_1 dupes num BEST. 
442 OPERA OPERA_1 Japanese char $3. 
443 OPERA OPERA_1 PersonID num BEST. 
444 OPERA OPERA_1 AsianAgg char $3. 
445 OPERA OPERA_1 AIANAgg char $3. 
446 OPERA OPERA_1 TribMemb char $7. 
447 OPERA OPERA_1 ModRMin num DATE9. 
448 OPERA OPERA_1 LatInd char $3. 
449 OPERA OPERA_1 AmInd char $3. 
450 OPERA OPERA_1 PriRacGnA char $33. 
451 OPERA OPERA_1 Rac11caAll char $30. 
452 OPERA OPERA_1 FirstNm char $23. 
453 OPERA OPERA_1 REansV2 num BEST. 
454 OPERA OPERA_1 Tribe num BEST. 
455 OPERA OPERA_1 REansV4orig num BEST. 
456 OPERA OPERA_1 REanswer char $3. 
457 OPERA OPERA_1 REansV5 num BEST. 
458 OPERA OPERA_1 AIAN char $3. 
459 OPERA OPERA_1 DEYEdi char $3. 
460 OPERA OPERA_1 Marshalles char $3. 
461 OPERA OPERA_1 POCdi char $11. 
462 OPERA OPERA_1 NHPI char $3. 
463 OPERA OPERA_1 HisMex char $3. 
464 OPERA OPERA_1 NHPIoth char $3. 
465 OPERA OPERA_1 Samoan char $3. 
466 OPERA OPERA_1 NHPIothOIC char $16. 
467 OPERA OPERA_1 Slavic char $3. 
468 OPERA OPERA_1 NHPIAggOIC char $16. 
469 OPERA OPERA_1 MidEast char $3. 
470 OPERA OPERA_1 SamoanOIC char $16. 
471 OPERA OPERA_1 WestEur char $3. 
472 OPERA OPERA_1 COFA char $3. 
473 OPERA OPERA_1 NatHaw char $3. 
474 OPERA OPERA_1 MarshallesOIC char $16. 
475 OPERA OPERA_1 COFAOIC char $16. 
476 OPERA OPERA_1 HisMexOIC char $16. 
477 OPERA OPERA_1 DEARTime num BEST. 
478 OPERA OPERA_1 Filipino char $3. 
479 OPERA OPERA_1 FilipinoOIC char $16. 
480 OPERA OPERA_1 DCOMdi char $3. 
481 OPERA OPERA_1 DEARdi char $3. 
482 OPERA OPERA_1 BlackOth char $3. 
483 OPERA OPERA_1 Hmong char $3. 
484 OPERA OPERA_1 AfrAm char $3. 
485 OPERA OPERA_1 DPHYdi char $3. 
486 OPERA OPERA_1 DISdi char $3. 
487 OPERA OPERA_1 CountyS char $13. 
488 OPERA OPERA_1 DLEAdi char $3. 
489 OPERA OPERA_1 DOUTdi char $3. 
490 OPERA OPERA_1 Korean char $3. 
491 OPERA OPERA_1 AnwsAll char $3. 
492 OPERA OPERA_1 LastNm char $34. 
493 OPERA OPERA_1 OLDdaQs num BEST. 
494 OPERA OPERA_1 dob num DATE9. 
495 OPERA OPERA_1 Cambodian char $3. 
496 OPERA OPERA_1 DupesOrg num BEST. 
497 OPERA OPERA_1 CanInd char $3. 
498 OPERA OPERA_1 DAcompAg char $23. 
499 OPERA OPERA_1 MyanmarOIC char $11. 
500 OPERA OPERA_1 OnsetDt num DATE9. 
501 OPERA OPERA_1 DEYETime num BEST. 
502 OPERA OPERA_1 AlaskNat char $3. 
503 OPERA OPERA_1 CaseStatus char $20. 
504 OPERA OPERA_1 RaceTotN num BEST. 
505 OPERA OPERA_1 Chinese char $3. 
506 OPERA OPERA_1 AsianInd char $3. 
507 OPERA OPERA_1 DLIMdi char $3. 
508 OPERA OPERA_1 Laotian char $3. 
509 OPERA OPERA_1 AsianOth char $3. 
510 OPERA OPERA_1 DDRSdi char $3. 
511 OPERA OPERA_1 PriRacGn char $33. 
512 OPERA OPERA_1 lineTotN1 num BEST. 
513 OPERA OPERA_1 lineNL num BEST. 
514 OPERA OPERA_1 lineN1 num BEST. 
515 OPERA OPERA_1 CogLeaDi char $3. 
516 OPERA OPERA_1 yr num BEST. 
517 OPERA OPERA_1 mon num BEST. 
518 OPERA OPERA_1 PriRacGnIM char $33. 
519 OPERA OPERA_1 AsianE num BEST. 
520 OPERA OPERA_1 AsianS num BEST. 
521 OPERA OPERA_1 AnwsAny char $3. 
522 OPERA OPERA_1 AnwsLang char $3. 
523 OPERA OPERA_1 AnwsDA char $3. 
524 OPERA OPERA_1 AnwsRace char $3. 
525 OPERA OPERA_1 LEPlang char $26. 
526 OPERA OPERA_1 IntTypS char $32. 
527 OPERA OPERA_1 Year num BEST. 
528 OPERA OPERA_1 Month num BEST. 
529 OPERA OPERA_1 CountyAll char $25. 
530 OPERA OPERA_1 CountyOR char $13. 
531 OPERA OPERA_1 State char $2. 
532 OPERA OPERA_1 City char $22. 
533 OPERA OPERA_1 Rac8caR char $11. 
534 OPERA OPERA_1 Tongan char $3. 
535 OPERA OPERA_1 CovidDi char $21. 
536 OPERA OPERA_1 AgeDAacq char $11. 
537 OPERA OPERA_1 DAlife char $21. 
538 OPERA OPERA_1 DLIMTime num BEST. 
539 OPERA OPERA_1 PriRacEth char $23. 
540 OPERA OPERA_1 DDRSTime num BEST. 
541 OPERA OPERA_1 DOUTTime num BEST. 
542 OPERA OPERA_1 DPHYTime num BEST. 
543 OPERA OPERA_1 DREMTime num BEST. 
544 OPERA OPERA_1 DLEATime num BEST. 
545 OPERA OPERA_1 DMHDTime num BEST. 
546 OPERA OPERA_1 DLIM char $10. 
547 OPERA OPERA_1 DOBmark num BEST. 
548 OPERA OPERA_1 Dupes2 num BEST. 
549 OPERA OPERA_1 DPHY4cat char $8. 
550 OPERA OPERA_1 DDRS4cat char $8. 
551 OPERA OPERA_1 DEYE4cat char $8. 
552 OPERA OPERA_1 DEAR4cat char $8. 
553 OPERA OPERA_1 DMHD4cat char $8. 
554 OPERA OPERA_1 DisN num BEST. 
555 OPERA OPERA_1 DA7compA char $15. 
556 OPERA OPERA_1 DMHDage num BEST. 
557 OPERA OPERA_1 DLIM4cat char $8. 
558 OPERA OPERA_1 DLIMage num BEST. 
559 OPERA OPERA_1 DDRSage num BEST. 
560 OPERA OPERA_1 DCOMage num BEST. 
561 OPERA OPERA_1 DEYEage num BEST. 
562 OPERA OPERA_1 DCOMTime num BEST. 
563 OPERA OPERA_1 IntTypA char $19. 
564 OPERA OPERA_1 IntTyp char $15. 
565 OPERA OPERA_1 NonEngDi char $3. 
566 OPERA OPERA_1 Interp char $7. 
567 OPERA OPERA_1 IntNeedDi char $3. 
568 OPERA OPERA_1 InterpA char $19. 
569 OPERA OPERA_1 ENG4catR char $10. 
570 OPERA OPERA_1 LEPdiR char $3. 
571 OPERA OPERA_1 LEPdi char $3. 
572 OPERA OPERA_1 LanNbr num BEST. 
573 OPERA OPERA_1 DAcompNew char $25. 
574 OPERA OPERA_1 PrefLang2 char $19. 
575 OPERA OPERA_1 DEARage num BEST. 
576 OPERA OPERA_1 SignType char $22. 
577 OPERA OPERA_1 Zip num BEST. 
578 OPERA OPERA_1 Sign num BEST. 
579 OPERA OPERA_1 DLEAage num BEST. 
580 OPERA OPERA_1 WritLang char $26. 
581 OPERA OPERA_1 DREMage num BEST. 
582 OPERA OPERA_1 DOUTage num BEST. 
583 OPERA OPERA_1 SpokLang char $22. 
584 OPERA OPERA_1 PrefLang char $26. 
585 OPERA OPERA_1 ENG char $21. 
586 OPERA OPERA_1 ENG4cat char $10. 
587 OPERA OPERA_1 IntpNeedC num BEST. 
588 OPERA OPERA_1 Cham char $3. 
589 OPERA OPERA_1 Guam char $3. 
590 OPERA OPERA_1 AgAcq1st num BEST. 
591 OPERA OPERA_1 DLEA4cat char $8. 
592 OPERA OPERA_1 NonEngPre char $15. 
593 OPERA OPERA_1 AsianSE num BEST. 
594 OPERA OPERA_1 RaceHas num BEST. 
595 OPERA OPERA_1 OthwhiteOIC char $16. 
596 OPERA OPERA_1 WhiteAggOIC char $16. 
597 OPERA OPERA_1 DCOM4cat char $14. 
598 OPERA OPERA_1 DREM4cat char $8. 
599 OPERA OPERA_1 WestEurOIC char $16. 
600 OPERA OPERA_1 African char $3. 
601 OPERA OPERA_1 EastEurOIC char $16. 
602 OPERA OPERA_1 NoAfrOIC char $16. 
603 OPERA OPERA_1 MidEastOIC char $16. 
604 OPERA OPERA_1 DA4catMax char $8. 
605 OPERA OPERA_1 SlavicOIC char $16. 
606 OPERA OPERA_1 HispAggOIC char $16. 
607 OPERA OPERA_1 HisOthOIC char $16. 
608 OPERA OPERA_1 DPHYage num BEST. 
609 OPERA OPERA_1 DOUT4cat char $8. 
610 OPERA OPERA_1 HisSouOIC char $16. 
611 OPERA OPERA_1 HisCenOIC char $16. 
612 OPERA OPERA_2 CambodianOIC char $16. 
613 OPERA OPERA_2 LaotianOIC char $11. 
614 OPERA OPERA_2 yr num BEST. 
615 OPERA OPERA_2 CogLeaDi char $3. 
616 OPERA OPERA_2 OLDdaQs num BEST. 
617 OPERA OPERA_2 AsianS num BEST. 
618 OPERA OPERA_2 PriRacGnIM char $33. 
619 OPERA OPERA_2 AsianSE num BEST. 
620 OPERA OPERA_2 Year num BEST. 
621 OPERA OPERA_2 lineNLall num BEST. 
622 OPERA OPERA_2 lineN1all num BEST. 
623 OPERA OPERA_2 City char $19. 
624 OPERA OPERA_2 Zip num BEST. 
625 OPERA OPERA_2 lineN1 num BEST. 
626 OPERA OPERA_2 AnwsAll char $3. 
627 OPERA OPERA_2 State char $2. 
628 OPERA OPERA_2 AnwsLang char $3. 
629 OPERA OPERA_2 AnwsRace char $3. 
630 OPERA OPERA_2 CovidDi char $8. 
631 OPERA OPERA_2 DAcompNew char $25. 
632 OPERA OPERA_2 Dis7catMax char $14. 
633 OPERA OPERA_2 DMHDageL num BEST. 
634 OPERA OPERA_2 DOUTageL num BEST. 
635 OPERA OPERA_2 DEYEageL num BEST. 
636 OPERA OPERA_2 DEARageL num BEST. 
637 OPERA OPERA_2 HasDDRSTime num BEST. 
638 OPERA OPERA_2 HasDOUTTime num BEST. 
639 OPERA OPERA_2 HasDREMTime num BEST. 
640 OPERA OPERA_2 HasDEYETime num BEST. 
641 OPERA OPERA_2 HasDEARTime num BEST. 
642 OPERA OPERA_2 DPHYTime num BEST. 
643 OPERA OPERA_2 DLEATime num BEST. 
644 OPERA OPERA_2 DOUTage num BEST. 
645 OPERA OPERA_2 DDRSage num BEST. 
646 OPERA OPERA_2 DDRSTime num BEST. 
647 OPERA OPERA_2 DMHDage num BEST. 
648 OPERA OPERA_2 DCOMage num BEST. 
649 OPERA OPERA_2 DREMage num BEST. 
650 OPERA OPERA_2 DEYE4cat char $8. 
651 OPERA OPERA_2 DREM4cat char $8. 
652 OPERA OPERA_2 DMHD4cat char $14. 
653 OPERA OPERA_2 DOUT4cat char $8. 
654 OPERA OPERA_2 AgAcq1st num BEST. 
655 OPERA OPERA_2 DPHYage num BEST. 
656 OPERA OPERA_2 DLEA4cat char $8. 
657 OPERA OPERA_2 AgeDAacq char $11. 
658 OPERA OPERA_2 DAlife char $21. 
659 OPERA OPERA_2 DA4catMax char $14. 
660 OPERA OPERA_2 DEAR4cat char $8. 
661 OPERA OPERA_2 InterpA char $19. 
662 OPERA OPERA_2 IntTypA char $19. 
663 OPERA OPERA_2 DLEAage num BEST. 
664 OPERA OPERA_2 DEYEage num BEST. 
665 OPERA OPERA_2 LEPlang char $20. 
666 OPERA OPERA_2 IntNeedDi char $3. 
667 OPERA OPERA_2 DMHDTime num BEST. 
668 OPERA OPERA_2 LEPdiR char $3. 
669 OPERA OPERA_2 LEPdi char $3. 
670 OPERA OPERA_2 Dupes4lang num BEST. 
671 OPERA OPERA_2 Rac8caR char $11. 
672 OPERA OPERA_2 DCOM4cat char $14. 
673 OPERA OPERA_2 DEARage num BEST. 
674 OPERA OPERA_2 DEARTime num BEST. 
675 OPERA OPERA_2 IntTypS char $28. 
676 OPERA OPERA_2 HomeLang2 char $7. 
677 OPERA OPERA_2 SpokLang2 char $7. 
678 OPERA OPERA_2 HomeLang char $20. 
679 OPERA OPERA_2 WritLang char $20. 
680 OPERA OPERA_2 ENG char $21. 
681 OPERA OPERA_2 ENG4cat char $10. 
682 OPERA OPERA_2 HasDLEATime num BEST. 
683 OPERA OPERA_2 IntpNeedC num BEST. 
684 OPERA OPERA_2 PrefLang2 char $10. 
685 OPERA OPERA_2 PrefLang char $20. 
686 OPERA OPERA_2 RaceHas num BEST. 
687 OPERA OPERA_2 WhiteAggOIC char $16. 
688 OPERA OPERA_2 HasDMHDTime num BEST. 
689 OPERA OPERA_2 WestEurOIC char $16. 
690 OPERA OPERA_2 EastEurOIC char $16. 
691 OPERA OPERA_2 MidEastOIC char $16. 
692 OPERA OPERA_2 SlavicOIC char $16. 
693 OPERA OPERA_2 HispAggOIC char $16. 
694 OPERA OPERA_2 HisSouOIC char $16. 
695 OPERA OPERA_2 CountyAll char $28. 
696 OPERA OPERA_2 HisCenOIC char $16. 
697 OPERA OPERA_2 HisMexOIC char $16. 
698 OPERA OPERA_2 NHPIothOIC char $16. 
699 OPERA OPERA_2 SamoanOIC char $16. 
700 OPERA OPERA_2 COFAOIC char $16. 
701 OPERA OPERA_2 lineTotN1a num BEST. 
702 OPERA OPERA_2 MarshallesOIC char $16. 
703 OPERA OPERA_2 ChamOIC char $16. 
704 OPERA OPERA_2 NatHawOIC char $16. 
705 OPERA OPERA_2 BlackOthOIC char $16. 
706 OPERA OPERA_2 AfricanOIC char $16. 
707 OPERA OPERA_2 BlackAggOIC char $16. 
708 OPERA OPERA_2 EthiopianOIC char $11. 
709 OPERA OPERA_2 AfrAmOIC char $16. 
710 OPERA OPERA_2 AsianOthOIC char $16. 
711 OPERA OPERA_2 VietnameseOIC char $16. 
712 OPERA OPERA_2 MyanmarOIC char $11. 
713 OPERA OPERA_2 KoreanOIC char $16. 
714 OPERA OPERA_2 JapaneseOIC char $16. 
715 OPERA OPERA_2 HmongOIC char $11. 
716 OPERA OPERA_2 FilipinoOIC char $16. 
717 OPERA OPERA_2 ChineseOIC char $16. 
718 OPERA OPERA_2 SoAsianOIC char $16. 
719 OPERA OPERA_2 AsianIndOIC char $16. 
720 OPERA OPERA_2 AsianAggOIC char $16. 
721 OPERA OPERA_2 AIANAggOIC char $16. 
722 OPERA OPERA_2 SomaliOIC char $11. 
723 OPERA OPERA_2 mon num BEST. 
724 OPERA OPERA_2 AsianE num BEST. 
725 OPERA OPERA_2 CaribbeanOIC char $16. 
726 OPERA OPERA_2 LatIndOIC char $16. 
727 OPERA OPERA_2 CanIndOIC char $16. 
728 OPERA OPERA_2 AlaskNatOIC char $16. 
729 OPERA OPERA_2 AmIndOIC char $16. 
730 OPERA OPERA_2 REOIC char $24. 
731 OPERA OPERA_2 REansEv char $3. 
732 OPERA OPERA_2 REanswer char $3. 
733 OPERA OPERA_2 RaceMainN num BEST. 
734 OPERA OPERA_2 Rac9ca char $28. 
735 OPERA OPERA_2 POCdi char $11. 
736 OPERA OPERA_2 TribalElg num BEST. 
737 OPERA OPERA_2 lineTotN1 num BEST. 
738 OPERA OPERA_2 lineNL num BEST. 
739 OPERA OPERA_2 NHPIAggOIC char $16. 
740 OPERA OPERA_2 CountyOR char $13. 
741 OPERA OPERA_2 HisOthOIC char $16. 
742 OPERA OPERA_2 AnwsDA char $3. 
743 OPERA OPERA_2 NoAfrOIC char $16. 
744 OPERA OPERA_2 Hispanic char $3. 
745 OPERA OPERA_2 AIAN char $3. 
746 OPERA OPERA_2 DLEAageL num BEST. 
747 OPERA OPERA_2 OthwhiteOIC char $16. 
748 OPERA OPERA_2 MiddleNm char $12. 
749 OPERA OPERA_2 Cstatus char $15. 
750 OPERA OPERA_2 CTestTyp char $26. 
751 OPERA OPERA_2 DDRSageL num BEST. 
752 OPERA OPERA_2 DREMageL num BEST. 
753 OPERA OPERA_2 NonEngPre char $15. 
754 OPERA OPERA_2 DOUTTime num BEST. 
755 OPERA OPERA_2 HasDCOMTime num BEST. 
756 OPERA OPERA_2 SpokLang char $20. 
757 OPERA OPERA_2 HasDPHYTime num BEST. 
758 OPERA OPERA_2 Othwhite char $3. 
759 OPERA OPERA_2 MENAAgg char $2. 
760 OPERA OPERA_2 WritLang2 char $7. 
761 OPERA OPERA_2 HispAgg char $3. 
762 OPERA OPERA_2 HisCen char $3. 
763 OPERA OPERA_2 HisMex char $3. 
764 OPERA OPERA_2 Samoan char $3. 
765 OPERA OPERA_2 Guam char $2. 
766 OPERA OPERA_2 ENG4catR char $10. 
767 OPERA OPERA_2 NonEngDi char $3. 
768 OPERA OPERA_2 Caribbean char $3. 
769 OPERA OPERA_2 Somali char $3. 
770 OPERA OPERA_2 AfrAm char $3. 
771 OPERA OPERA_2 IntTyp char $15. 
772 OPERA OPERA_2 Interp char $7. 
773 OPERA OPERA_2 DPHY4cat char $8. 
774 OPERA OPERA_2 DisN num BEST. 
775 OPERA OPERA_2 DA7compA char $15. 
776 OPERA OPERA_2 Laotian char $3. 
777 OPERA OPERA_2 Myanmar char $3. 
778 OPERA OPERA_2 DDRS4cat char $8. 
779 OPERA OPERA_2 DPHYageL num BEST. 
780 OPERA OPERA_2 Korean char $3. 
781 OPERA OPERA_2 Hmong char $3. 
782 OPERA OPERA_2 Filipino char $3. 
783 OPERA OPERA_2 AsianInd char $3. 
784 OPERA OPERA_2 AIANAgg char $3. 
785 OPERA OPERA_2 LatInd char $3. 
786 OPERA OPERA_2 CanInd char $3. 
787 OPERA OPERA_2 PriRacGn char $33. 
788 OPERA OPERA_2 AmInd char $3. 
789 OPERA OPERA_2 PriRacGnA char $33. 
790 OPERA OPERA_2 PriRacEth char $23. 
791 OPERA OPERA_2 Rac11caAll char $30. 
792 OPERA OPERA_2 Status char $15. 
793 OPERA OPERA_2 OrgTypeS char $23. 
794 OPERA OPERA_2 OrganR char $70. 
795 OPERA OPERA_2 DCOMTime num BEST. 
796 OPERA OPERA_2 AlaskNat char $3. 
797 OPERA OPERA_2 DupesOrg num BEST. 
798 OPERA OPERA_2 OnsetDt num DATE9. 
799 OPERA OPERA_2 PersonID num BEST. 
800 OPERA OPERA_2 AsianAgg char $3. 
801 OPERA OPERA_2 dob num DATE9. 
802 OPERA OPERA_2 LastNm char $71. 
803 OPERA OPERA_2 FirstNm char $24. 
804 OPERA OPERA_2 DPHYdi char $3. 
805 OPERA OPERA_2 DREMdi char $3. 
806 OPERA OPERA_2 DOUTdi char $3. 
807 OPERA OPERA_2 DDRSdi char $3. 
808 OPERA OPERA_2 Chinese char $3. 
809 OPERA OPERA_2 Japanese char $3. 
810 OPERA OPERA_2 DEYEdi char $3. 
811 OPERA OPERA_2 DEARdi char $3. 
812 OPERA OPERA_2 SoAsian char $3. 
813 OPERA OPERA_2 DCOMdi char $3. 
814 OPERA OPERA_2 Cambodian char $3. 
815 OPERA OPERA_2 DMHDdi char $3. 
816 OPERA OPERA_2 Vietnamese char $3. 
817 OPERA OPERA_2 DLEAdi char $3. 
818 OPERA OPERA_2 DISdi char $3. 
819 OPERA OPERA_2 Ethiopian char $3. 
820 OPERA OPERA_2 DA7comp char $15. 
821 OPERA OPERA_2 DCOMageL num BEST. 
822 OPERA OPERA_2 BlackAgg char $3. 
823 OPERA OPERA_2 DAcompAg char $23. 
824 OPERA OPERA_2 age num BEST. 
825 OPERA OPERA_2 AsianOth char $3. 
826 OPERA OPERA_2 African char $3. 
827 OPERA OPERA_2 BlackOth char $3. 
828 OPERA OPERA_2 NatHaw char $3. 
829 OPERA OPERA_2 Marshalles char $3. 
830 OPERA OPERA_2 COFA char $3. 
831 OPERA OPERA_2 Tongan char $2. 
832 OPERA OPERA_2 NHPIoth char $3. 
833 OPERA OPERA_2 Cham char $3. 
834 OPERA OPERA_2 NHPIAgg char $3. 
835 OPERA OPERA_2 HisSou char $3. 
836 OPERA OPERA_2 Slavic char $3. 
837 OPERA OPERA_2 MidEast char $3. 
838 OPERA OPERA_2 HisOth char $3. 
839 OPERA OPERA_2 NoAfr char $3. 
840 OPERA OPERA_2 EastEur char $3. 
841 OPERA OPERA_2 WestEur char $3. 
842 OPERA OPERA_2 WhiteAgg char $3. 
843 OPERA OPERA_2 CaseIDMax num BEST. 
844 OPERA OPERA_2 CaseIDMin num BEST. 
845 OPERA OPERA_2 PersonID2S num BEST. 
846 OPERA OPERA_2 CreateDtMin num DATE9. 
847 OPERA OPERA_2 CreateDtMax num DATE9. 
848 OPERA OPERA_2 REansOrig num BEST. 
849 OPERA OPERA_2 Tribe num BEST. 
850 OPERA OPERA_2 MENA char $3. 
851 OPERA OPERA_2 Jewish num BEST. 
852 OPERA OPERA_2 White char $3. 
853 OPERA OPERA_2 Black char $3. 
854 OPERA OPERA_2 NHPI char $3. 
855 OPERA OPERA_2 Asian char $3. 
856 OPERA OPERA_2 DEYETime num BEST. 
857 OPERA OPERA_2 DREMTime num BEST. 
858 OPERA OPERA_2 Month num BEST. 
859 OPERA OPERA_2 Rac8ca char $28. 
860 OPERA OPERA_2 RRprimGn char $33. 
861 OPERA OPERA_ALL WritLang char $26. 
862 OPERA OPERA_ALL SpokLang char $22. 
863 OPERA OPERA_ALL PrefLang char $26. 
864 OPERA OPERA_ALL ENG4cat char $10. 
865 OPERA OPERA_ALL IntpNeedC num BEST. 
866 OPERA OPERA_ALL NonEngPre char $15. 
867 OPERA OPERA_ALL OthwhiteOIC char $16. 
868 OPERA OPERA_ALL WhiteAggOIC char $16. 
869 OPERA OPERA_ALL WestEurOIC char $16. 
870 OPERA OPERA_ALL EastEurOIC char $16. 
871 OPERA OPERA_ALL NoAfrOIC char $16. 
872 OPERA OPERA_ALL MidEastOIC char $16. 
873 OPERA OPERA_ALL SlavicOIC char $16. 
874 OPERA OPERA_ALL HisOthOIC char $16. 
875 OPERA OPERA_ALL HisSouOIC char $16. 
876 OPERA OPERA_ALL HisCenOIC char $16. 
877 OPERA OPERA_ALL NHPIAggOIC char $16. 
878 OPERA OPERA_ALL NHPIothOIC char $16. 
879 OPERA OPERA_ALL TonganOIC char $11. 
880 OPERA OPERA_ALL COFAOIC char $16. 
881 OPERA OPERA_ALL MarshallesOIC char $16. 
882 OPERA OPERA_ALL ChamOIC char $16. 
883 OPERA OPERA_ALL GuamOIC char $16. 
884 OPERA OPERA_ALL NatHawOIC char $16. 
885 OPERA OPERA_ALL BlackOthOIC char $16. 
886 OPERA OPERA_ALL CaribbeanOIC char $16. 
887 OPERA OPERA_ALL BlackAggOIC char $16. 
888 OPERA OPERA_ALL EthiopianOIC char $16. 
889 OPERA OPERA_ALL SomaliOIC char $16. 
890 OPERA OPERA_ALL AsianOthOIC char $16. 
891 OPERA OPERA_ALL VietnameseOIC char $16. 
892 OPERA OPERA_ALL SoAsianOIC char $16. 
893 OPERA OPERA_ALL LaotianOIC char $16. 
894 OPERA OPERA_ALL KoreanOIC char $16. 
895 OPERA OPERA_ALL JapaneseOIC char $16. 
896 OPERA OPERA_ALL HmongOIC char $16. 
897 OPERA OPERA_ALL FilipinoOIC char $16. 
898 OPERA OPERA_ALL ChineseOIC char $16. 
899 OPERA OPERA_ALL CambodianOIC char $16. 
900 OPERA OPERA_ALL AsianAggOIC char $16. 
901 OPERA OPERA_ALL AIANAggOIC char $16. 
902 OPERA OPERA_ALL LatIndOIC char $16. 
903 OPERA OPERA_ALL AlaskNatOIC char $16. 
904 OPERA OPERA_ALL AmIndOIC char $16. 
905 OPERA OPERA_ALL REOIC char $24. 
906 OPERA OPERA_ALL REanswer char $3. 
907 OPERA OPERA_ALL RaceMainN num BEST. 
908 OPERA OPERA_ALL Rac8ca char $28. 
909 OPERA OPERA_ALL Rac9ca char $28. 
910 OPERA OPERA_ALL POCdi char $11. 
911 OPERA OPERA_ALL TribalElg num BEST. 
912 OPERA OPERA_ALL Asian char $3. 
913 OPERA OPERA_ALL Black char $3. 
914 OPERA OPERA_ALL White char $3. 
915 OPERA OPERA_ALL MENA char $3. 
916 OPERA OPERA_ALL REansV6 num BEST. 
917 OPERA OPERA_ALL REansV5 num BEST. 
918 OPERA OPERA_ALL REansV4keep num BEST. 
919 OPERA OPERA_ALL Jewish num BEST. 
920 OPERA OPERA_ALL Tribe num BEST. 
921 OPERA OPERA_ALL REansV3 num BEST. 
922 OPERA OPERA_ALL REansV2 num BEST. 
923 OPERA OPERA_ALL REansOrig num BEST. 
924 OPERA OPERA_ALL ModRMin num DATE9. 
925 OPERA OPERA_ALL ModRMax num DATE9. 
926 OPERA OPERA_ALL TribAfflia char $75. 
927 OPERA OPERA_ALL MiddleNm char $26. 
928 OPERA OPERA_ALL PersonID2S num BEST. 
929 OPERA OPERA_ALL CreateDtMin num DATE9. 
930 OPERA OPERA_ALL CreateDtMax num DATE9. 
931 OPERA OPERA_ALL Hispanic char $3. 
932 OPERA OPERA_ALL Gender char $39. 
933 OPERA OPERA_ALL TribMemb char $7. 
934 OPERA OPERA_ALL HispOldS char $12. 
935 OPERA OPERA_ALL Othwhite char $3. 
936 OPERA OPERA_ALL WhiteAgg char $3. 
937 OPERA OPERA_ALL WestEur char $3. 
938 OPERA OPERA_ALL EastEur char $3. 
939 OPERA OPERA_ALL MENAAgg char $2. 
940 OPERA OPERA_ALL NoAfr char $3. 
941 OPERA OPERA_ALL MidEast char $3. 
942 OPERA OPERA_ALL REansV4orig num BEST. 
943 OPERA OPERA_ALL Slavic char $3. 
944 OPERA OPERA_ALL HispAgg char $3. 
945 OPERA OPERA_ALL HisOth char $3. 
946 OPERA OPERA_ALL HisSou char $3. 
947 OPERA OPERA_ALL AIAN char $3. 
948 OPERA OPERA_ALL HisCen char $3. 
949 OPERA OPERA_ALL HisMex char $3. 
950 OPERA OPERA_ALL NHPIAgg char $3. 
951 OPERA OPERA_ALL NHPIoth char $3. 
952 OPERA OPERA_ALL NHPI char $3. 
953 OPERA OPERA_ALL Tongan char $3. 
954 OPERA OPERA_ALL Samoan char $3. 
955 OPERA OPERA_ALL COFA char $3. 
956 OPERA OPERA_ALL Marshalles char $3. 
957 OPERA OPERA_ALL Cham char $3. 
958 OPERA OPERA_ALL Guam char $3. 
959 OPERA OPERA_ALL NatHaw char $3. 
960 OPERA OPERA_ALL African char $3. 
961 OPERA OPERA_ALL REansEv char $3. 
962 OPERA OPERA_ALL CanIndOIC char $16. 
963 OPERA OPERA_ALL BlackOth char $3. 
964 OPERA OPERA_ALL Caribbean char $3. 
965 OPERA OPERA_ALL BlackAgg char $3. 
966 OPERA OPERA_ALL Ethiopian char $3. 
967 OPERA OPERA_ALL AsianIndOIC char $16. 
968 OPERA OPERA_ALL Somali char $3. 
969 OPERA OPERA_ALL AfrAm char $3. 
970 OPERA OPERA_ALL AsianOth char $3. 
971 OPERA OPERA_ALL Vietnamese char $3. 
972 OPERA OPERA_ALL SoAsian char $3. 
973 OPERA OPERA_ALL Myanmar char $3. 
974 OPERA OPERA_ALL Laotian char $3. 
975 OPERA OPERA_ALL Korean char $3. 
976 OPERA OPERA_ALL Japanese char $3. 
977 OPERA OPERA_ALL Hmong char $3. 
978 OPERA OPERA_ALL Filipino char $3. 
979 OPERA OPERA_ALL Chinese char $3. 
980 OPERA OPERA_ALL MyanmarOIC char $11. 
981 OPERA OPERA_ALL AfrAmOIC char $16. 
982 OPERA OPERA_ALL AfricanOIC char $16. 
983 OPERA OPERA_ALL Cambodian char $3. 
984 OPERA OPERA_ALL AsianInd char $3. 
985 OPERA OPERA_ALL AsianAgg char $3. 
986 OPERA OPERA_ALL AIANAgg char $3. 
987 OPERA OPERA_ALL LatInd char $3. 
988 OPERA OPERA_ALL CanInd char $3. 
989 OPERA OPERA_ALL AlaskNat char $3. 
990 OPERA OPERA_ALL AmInd char $3. 
991 OPERA OPERA_ALL SamoanOIC char $16. 
992 OPERA OPERA_ALL PriRacGn char $33. 
993 OPERA OPERA_ALL PriRacGnA char $33. 
994 OPERA OPERA_ALL HisMexOIC char $16. 
995 OPERA OPERA_ALL PriRacEth char $23. 
996 OPERA OPERA_ALL Rac11caAll char $30. 
997 OPERA OPERA_ALL RaceTotN num BEST. 
998 OPERA OPERA_ALL CaseStatus char $20. 
999 OPERA OPERA_ALL DupesOrg num BEST. 
1000 OPERA OPERA_ALL OnsetDt num DATE9. 
1001 OPERA OPERA_ALL HispAggOIC char $16. 
1002 OPERA OPERA_ALL FirstNm char $23. 
1003 OPERA OPERA_ALL DPHYdi char $3. 
1004 OPERA OPERA_ALL DEYEdi char $3. 
1005 OPERA OPERA_ALL DMHDdi char $3. 
1006 OPERA OPERA_ALL DLEAdi char $3. 
1007 OPERA OPERA_ALL RaceHas num BEST. 
1008 OPERA OPERA_ALL age num BEST. 
1009 OPERA OPERA_ALL DAcompAg char $23. 
1010 OPERA OPERA_ALL ENG char $21. 
1011 OPERA OPERA_ALL DA7comp char $15. 
1012 OPERA OPERA_ALL DCOMdi char $3. 
1013 OPERA OPERA_ALL DEARdi char $3. 
1014 OPERA OPERA_ALL DDRSdi char $3. 
1015 OPERA OPERA_ALL DOUTdi char $3. 
1016 OPERA OPERA_ALL DREMdi char $3. 
1017 OPERA OPERA_ALL Sign num BEST. 
1018 OPERA OPERA_ALL DISdi char $3. 
1019 OPERA OPERA_ALL dupes num BEST. 
1020 OPERA OPERA_ALL DLIMdi char $3. 
1021 OPERA OPERA_ALL LastNm char $34. 
1022 OPERA OPERA_ALL dob num DATE9. 
1023 OPERA OPERA_ALL PersonID num BEST. 
1024 OPERA OPERA_ALL lineTotN1a num BEST. 
1025 OPERA OPERA_ALL lineNLall num BEST. 
1026 OPERA OPERA_ALL lineN1all num BEST. 
1027 OPERA OPERA_ALL DLEAageL num BEST. 
1028 OPERA OPERA_ALL DMHDageL num BEST. 
1029 OPERA OPERA_ALL DCOMageL num BEST. 
1030 OPERA OPERA_ALL DDRSageL num BEST. 
1031 OPERA OPERA_ALL DREMageL num BEST. 
1032 OPERA OPERA_ALL DEYEageL num BEST. 
1033 OPERA OPERA_ALL HasDMHDTime num BEST. 
1034 OPERA OPERA_ALL HasDLEATime num BEST. 
1035 OPERA OPERA_ALL HasDCOMTime num BEST. 
1036 OPERA OPERA_ALL HasDOUTTime num BEST. 
1037 OPERA OPERA_ALL HasDDRSTime num BEST. 
1038 OPERA OPERA_ALL HasDPHYTime num BEST. 
1039 OPERA OPERA_ALL HasDREMTime num BEST. 
1040 OPERA OPERA_ALL HasDEARTime num BEST. 
1041 OPERA OPERA_ALL DPHYageL num BEST. 
1042 OPERA OPERA_ALL Dupes4lang num BEST. 
1043 OPERA OPERA_ALL WritLang2 char $7. 
1044 OPERA OPERA_ALL SpokLang2 char $7. 
1045 OPERA OPERA_ALL HomeLang char $20. 
1046 OPERA OPERA_ALL Cstatus char $15. 
1047 OPERA OPERA_ALL CTestTyp char $26. 
1048 OPERA OPERA_ALL CaseIDMin num BEST. 
1049 OPERA OPERA_ALL CaseIDMax num BEST. 
1050 OPERA OPERA_ALL Status char $15. 
1051 OPERA OPERA_ALL OrgTypeS char $23. 
1052 OPERA OPERA_ALL OrganR char $70. 
1053 OPERA OPERA_ALL lineNL num BEST. 
1054 OPERA OPERA_ALL lineN1 num BEST. 
1055 OPERA OPERA_ALL CogLeaDi char $3. 
1056 OPERA OPERA_ALL yr num BEST. 
1057 OPERA OPERA_ALL mon num BEST. 
1058 OPERA OPERA_ALL PriRacGnIM char $33. 
1059 OPERA OPERA_ALL AsianE num BEST. 
1060 OPERA OPERA_ALL AsianS num BEST. 
1061 OPERA OPERA_ALL AnwsAny char $3. 
1062 OPERA OPERA_ALL AnwsAll char $3. 
1063 OPERA OPERA_ALL AnwsLang char $3. 
1064 OPERA OPERA_ALL AnwsDA char $3. 
1065 OPERA OPERA_ALL AnwsRace char $3. 
1066 OPERA OPERA_ALL IntTypS char $32. 
1067 OPERA OPERA_ALL Year num BEST. 
1068 OPERA OPERA_ALL Month num BEST. 
1069 OPERA OPERA_ALL CountyAll char $25. 
1070 OPERA OPERA_ALL CountyOR char $13. 
1071 OPERA OPERA_ALL State char $2. 
1072 OPERA OPERA_ALL CountyS char $13. 
1073 OPERA OPERA_ALL Zip num BEST. 
1074 OPERA OPERA_ALL City char $22. 
1075 OPERA OPERA_ALL Rac8caR char $11. 
1076 OPERA OPERA_ALL CovidDi char $21. 
1077 OPERA OPERA_ALL LEPlang char $26. 
1078 OPERA OPERA_ALL DAcompNew char $25. 
1079 OPERA OPERA_ALL AgeDAacq char $11. 
1080 OPERA OPERA_ALL DAlife char $21. 
1081 OPERA OPERA_ALL DLIMTime num BEST. 
1082 OPERA OPERA_ALL DDRSTime num BEST. 
1083 OPERA OPERA_ALL DOUTTime num BEST. 
1084 OPERA OPERA_ALL DPHYTime num BEST. 
1085 OPERA OPERA_ALL DREMTime num BEST. 
1086 OPERA OPERA_ALL AsianSE num BEST. 
1087 OPERA OPERA_ALL DEYETime num BEST. 
1088 OPERA OPERA_ALL DEARTime num BEST. 
1089 OPERA OPERA_ALL DLEATime num BEST. 
1090 OPERA OPERA_ALL DMHDTime num BEST. 
1091 OPERA OPERA_ALL OLDdaQs num BEST. 
1092 OPERA OPERA_ALL lineTotN1 num BEST. 
1093 OPERA OPERA_ALL DCOMTime num BEST. 
1094 OPERA OPERA_ALL DLIM char $10. 
1095 OPERA OPERA_ALL DOBmark num BEST. 
1096 OPERA OPERA_ALL Dupes2 num BEST. 
1097 OPERA OPERA_ALL DA4catMax char $8. 
1098 OPERA OPERA_ALL DLIM4cat char $8. 
1099 OPERA OPERA_ALL DPHY4cat char $8. 
1100 OPERA OPERA_ALL DDRS4cat char $8. 
1101 OPERA OPERA_ALL RRprimGn char $33. 
1102 OPERA OPERA_ALL DOUT4cat char $8. 
1103 OPERA OPERA_ALL DREM4cat char $8. 
1104 OPERA OPERA_ALL DEYE4cat char $8. 
1105 OPERA OPERA_ALL DEAR4cat char $8. 
1106 OPERA OPERA_ALL HomeLang2 char $7. 
1107 OPERA OPERA_ALL DCOM4cat char $14. 
1108 OPERA OPERA_ALL DMHD4cat char $8. 
1109 OPERA OPERA_ALL DLEA4cat char $8. 
1110 OPERA OPERA_ALL DisN num BEST. 
1111 OPERA OPERA_ALL HasDEYETime num BEST. 
1112 OPERA OPERA_ALL DA7compA char $15. 
1113 OPERA OPERA_ALL AgAcq1st num BEST. 
1114 OPERA OPERA_ALL DPHYage num BEST. 
1115 OPERA OPERA_ALL DMHDage num BEST. 
1116 OPERA OPERA_ALL DLIMage num BEST. 
1117 OPERA OPERA_ALL DLEAage num BEST. 
1118 OPERA OPERA_ALL DOUTage num BEST. 
1119 OPERA OPERA_ALL DDRSage num BEST. 
1120 OPERA OPERA_ALL DEARageL num BEST. 
1121 OPERA OPERA_ALL DOUTageL num BEST. 
1122 OPERA OPERA_ALL DEARage num BEST. 
1123 OPERA OPERA_ALL DREMage num BEST. 
1124 OPERA OPERA_ALL DCOMage num BEST. 
1125 OPERA OPERA_ALL DEYEage num BEST. 
1126 OPERA OPERA_ALL Dis7catMax char $14. 
1127 OPERA OPERA_ALL InterpA char $19. 
1128 OPERA OPERA_ALL Interp char $7. 
1129 OPERA OPERA_ALL IntTypA char $19. 
1130 OPERA OPERA_ALL IntTyp char $15. 
1131 OPERA OPERA_ALL NonEngDi char $3. 
1132 OPERA OPERA_ALL IntNeedDi char $3. 
1133 OPERA OPERA_ALL ENG4catR char $10. 
1134 OPERA OPERA_ALL LEPdiR char $3. 
1135 OPERA OPERA_ALL LEPdi char $3. 
1136 OPERA OPERA_ALL LanNbr num BEST. 
1137 OPERA OPERA_ALL PrefLang2 char $19. 
1138 OPERA OPERA_ALL SignType char $22. 
1139 OPERA OPERA_ALL_A lineTotN1a num BEST. 
1140 OPERA OPERA_ALL_A lineN1all num BEST. 
1141 OPERA OPERA_ALL_A Dis7catMax char $14. 
1142 OPERA OPERA_ALL_A DLEAageL num BEST. 
1143 OPERA OPERA_ALL_A DMHDageL num BEST. 
1144 OPERA OPERA_ALL_A DCOMageL num BEST. 
1145 OPERA OPERA_ALL_A DOUTageL num BEST. 
1146 OPERA OPERA_ALL_A DDRSageL num BEST. 
1147 OPERA OPERA_ALL_A DEYEageL num BEST. 
1148 OPERA OPERA_ALL_A DEARageL num BEST. 
1149 OPERA OPERA_ALL_A HasDMHDTime num BEST. 
1150 OPERA OPERA_ALL_A HasDCOMTime num BEST. 
1151 OPERA OPERA_ALL_A HasDOUTTime num BEST. 
1152 OPERA OPERA_ALL_A HasDDRSTime num BEST. 
1153 OPERA OPERA_ALL_A HasDREMTime num BEST. 
1154 OPERA OPERA_ALL_A HasDEYETime num BEST. 
1155 OPERA OPERA_ALL_A HasDEARTime num BEST. 
1156 OPERA OPERA_ALL_A DPHYageL num BEST. 
1157 OPERA OPERA_ALL_A Dupes4lang num BEST. 
1158 OPERA OPERA_ALL_A HomeLang2 char $7. 
1159 OPERA OPERA_ALL_A WritLang2 char $7. 
1160 OPERA OPERA_ALL_A HomeLang char $20. 
1161 OPERA OPERA_ALL_A RRprimGn char $33. 
1162 OPERA OPERA_ALL_A Cstatus char $15. 
1163 OPERA OPERA_ALL_A CaseIDMin num BEST. 
1164 OPERA OPERA_ALL_A CaseIDMax num BEST. 
1165 OPERA OPERA_ALL_A Status char $15. 
1166 OPERA OPERA_ALL_A OrganR char $70. 
1167 OPERA OPERA_ALL_A lineTotN1 num BEST. 
1168 OPERA OPERA_ALL_A lineNL num BEST. 
1169 OPERA OPERA_ALL_A lineN1 num BEST. 
1170 OPERA OPERA_ALL_A CogLeaDi char $3. 
1171 OPERA OPERA_ALL_A OLDdaQs num BEST. 
1172 OPERA OPERA_ALL_A yr num BEST. 
1173 OPERA OPERA_ALL_A PriRacGnIM char $33. 
1174 OPERA OPERA_ALL_A AsianSE num BEST. 
1175 OPERA OPERA_ALL_A AsianE num BEST. 
1176 OPERA OPERA_ALL_A AnwsAny char $3. 
1177 OPERA OPERA_ALL_A AnwsAll char $3. 
1178 OPERA OPERA_ALL_A AnwsLang char $3. 
1179 OPERA OPERA_ALL_A AnwsRace char $3. 
1180 OPERA OPERA_ALL_A LEPlang char $26. 
1181 OPERA OPERA_ALL_A IntTypS char $32. 
1182 OPERA OPERA_ALL_A Year num BEST. 
1183 OPERA OPERA_ALL_A Month num BEST. 
1184 OPERA OPERA_ALL_A CountyS char $13. 
1185 OPERA OPERA_ALL_A CountyAll char $25. 
1186 OPERA OPERA_ALL_A State char $2. 
1187 OPERA OPERA_ALL_A Zip num BEST. 
1188 OPERA OPERA_ALL_A City char $22. 
1189 OPERA OPERA_ALL_A CovidDi char $21. 
1190 OPERA OPERA_ALL_A DAcompNew char $25. 
1191 OPERA OPERA_ALL_A AgeDAacq char $11. 
1192 OPERA OPERA_ALL_A DLIMTime num BEST. 
1193 OPERA OPERA_ALL_A DDRSTime num BEST. 
1194 OPERA OPERA_ALL_A DOUTTime num BEST. 
1195 OPERA OPERA_ALL_A DPHYTime num BEST. 
1196 OPERA OPERA_ALL_A DREMTime num BEST. 
1197 OPERA OPERA_ALL_A DEYETime num BEST. 
1198 OPERA OPERA_ALL_A DEARTime num BEST. 
1199 OPERA OPERA_ALL_A DMHDTime num BEST. 
1200 OPERA OPERA_ALL_A DCOMTime num BEST. 
1201 OPERA OPERA_ALL_A DLIM char $10. 
1202 OPERA OPERA_ALL_A Dupes2 num BEST. 
1203 OPERA OPERA_ALL_A DA4catMax char $8. 
1204 OPERA OPERA_ALL_A DLIM4cat char $8. 
1205 OPERA OPERA_ALL_A DDRS4cat char $8. 
1206 OPERA OPERA_ALL_A DOUT4cat char $8. 
1207 OPERA OPERA_ALL_A DREM4cat char $8. 
1208 OPERA OPERA_ALL_A DEYE4cat char $8. 
1209 OPERA OPERA_ALL_A DEAR4cat char $8. 
1210 OPERA OPERA_ALL_A DCOM4cat char $14. 
1211 OPERA OPERA_ALL_A DMHD4cat char $8. 
1212 OPERA OPERA_ALL_A DisN num BEST. 
1213 OPERA OPERA_ALL_A DA7compA char $15. 
1214 OPERA OPERA_ALL_A AgAcq1st num BEST. 
1215 OPERA OPERA_ALL_A DMHDage num BEST. 
1216 OPERA OPERA_ALL_A DLIMage num BEST. 
1217 OPERA OPERA_ALL_A DLEAage num BEST. 
1218 OPERA OPERA_ALL_A DDRSage num BEST. 
1219 OPERA OPERA_ALL_A DEARage num BEST. 
1220 OPERA OPERA_ALL_A DREMage num BEST. 
1221 OPERA OPERA_ALL_A DCOMage num BEST. 
1222 OPERA OPERA_ALL_A DEYEage num BEST. 
1223 OPERA OPERA_ALL_A InterpA char $19. 
1224 OPERA OPERA_ALL_A Interp char $7. 
1225 OPERA OPERA_ALL_A IntTyp char $15. 
1226 OPERA OPERA_ALL_A NonEngDi char $3. 
1227 OPERA OPERA_ALL_A IntNeedDi char $3. 
1228 OPERA OPERA_ALL_A LEPdiR char $3. 
1229 OPERA OPERA_ALL_A LEPdi char $3. 
1230 OPERA OPERA_ALL_A LanNbr num BEST. 
1231 OPERA OPERA_ALL_A SignType char $22. 
1232 OPERA OPERA_ALL_A Sign num BEST. 
1233 OPERA OPERA_ALL_A WritLang char $26. 
1234 OPERA OPERA_ALL_A SpokLang char $22. 
1235 OPERA OPERA_ALL_A PrefLang char $26. 
1236 OPERA OPERA_ALL_A ENG char $21. 
1237 OPERA OPERA_ALL_A ENG4cat char $10. 
1238 OPERA OPERA_ALL_A NonEngPre char $15. 
1239 OPERA OPERA_ALL_A RaceHas num BEST. 
1240 OPERA OPERA_ALL_A OthwhiteOIC char $16. 
1241 OPERA OPERA_ALL_A WestEurOIC char $16. 
1242 OPERA OPERA_ALL_A EastEurOIC char $16. 
1243 OPERA OPERA_ALL_A NoAfrOIC char $16. 
1244 OPERA OPERA_ALL_A MidEastOIC char $16. 
1245 OPERA OPERA_ALL_A SlavicOIC char $16. 
1246 OPERA OPERA_ALL_A HispAggOIC char $16. 
1247 OPERA OPERA_ALL_A HisOthOIC char $16. 
1248 OPERA OPERA_ALL_A HisSouOIC char $16. 
1249 OPERA OPERA_ALL_A HisCenOIC char $16. 
1250 OPERA OPERA_ALL_A HisMexOIC char $16. 
1251 OPERA OPERA_ALL_A NHPIAggOIC char $16. 
1252 OPERA OPERA_ALL_A TonganOIC char $11. 
1253 OPERA OPERA_ALL_A SamoanOIC char $16. 
1254 OPERA OPERA_ALL_A COFAOIC char $16. 
1255 OPERA OPERA_ALL_A ChamOIC char $16. 
1256 OPERA OPERA_ALL_A GuamOIC char $16. 
1257 OPERA OPERA_ALL_A NatHawOIC char $16. 
1258 OPERA OPERA_ALL_A CaribbeanOIC char $16. 
1259 OPERA OPERA_ALL_A AfricanOIC char $16. 
1260 OPERA OPERA_ALL_A BlackAggOIC char $16. 
1261 OPERA OPERA_ALL_A BlackOthOIC char $16. 
1262 OPERA OPERA_ALL_A EthiopianOIC char $16. 
1263 OPERA OPERA_ALL_A SomaliOIC char $16. 
1264 OPERA OPERA_ALL_A AfrAmOIC char $16. 
1265 OPERA OPERA_ALL_A AsianOthOIC char $16. 
1266 OPERA OPERA_ALL_A MarshallesOIC char $16. 
1267 OPERA OPERA_ALL_A VietnameseOIC char $16. 
1268 OPERA OPERA_ALL_A SoAsianOIC char $16. 
1269 OPERA OPERA_ALL_A NHPIothOIC char $16. 
1270 OPERA OPERA_ALL_A MyanmarOIC char $11. 
1271 OPERA OPERA_ALL_A LaotianOIC char $16. 
1272 OPERA OPERA_ALL_A KoreanOIC char $16. 
1273 OPERA OPERA_ALL_A JapaneseOIC char $16. 
1274 OPERA OPERA_ALL_A HmongOIC char $16. 
1275 OPERA OPERA_ALL_A FilipinoOIC char $16. 
1276 OPERA OPERA_ALL_A ChineseOIC char $16. 
1277 OPERA OPERA_ALL_A CambodianOIC char $16. 
1278 OPERA OPERA_ALL_A AsianIndOIC char $16. 
1279 OPERA OPERA_ALL_A AsianAggOIC char $16. 
1280 OPERA OPERA_ALL_A AIANAggOIC char $16. 
1281 OPERA OPERA_ALL_A LatIndOIC char $16. 
1282 OPERA OPERA_ALL_A CanIndOIC char $16. 
1283 OPERA OPERA_ALL_A AlaskNatOIC char $16. 
1284 OPERA OPERA_ALL_A WhiteAggOIC char $16. 
1285 OPERA OPERA_ALL_A IntpNeedC num BEST. 
1286 OPERA OPERA_ALL_A AmIndOIC char $16. 
1287 OPERA OPERA_ALL_A REOIC char $24. 
1288 OPERA OPERA_ALL_A REansEv char $3. 
1289 OPERA OPERA_ALL_A REanswer char $3. 
1290 OPERA OPERA_ALL_A RaceMainN num BEST. 
1291 OPERA OPERA_ALL_A Rac8ca char $28. 
1292 OPERA OPERA_ALL_A Rac9ca char $28. 
1293 OPERA OPERA_ALL_A POCdi char $11. 
1294 OPERA OPERA_ALL_A PrefLang2 char $19. 
1295 OPERA OPERA_ALL_A TribalElg num BEST. 
1296 OPERA OPERA_ALL_A Asian char $3. 
1297 OPERA OPERA_ALL_A ENG4catR char $10. 
1298 OPERA OPERA_ALL_A NHPI char $3. 
1299 OPERA OPERA_ALL_A Black char $3. 
1300 OPERA OPERA_ALL_A White char $3. 
1301 OPERA OPERA_ALL_A MENA char $3. 
1302 OPERA OPERA_ALL_A AIAN char $3. 
1303 OPERA OPERA_ALL_A REansV6 num BEST. 
1304 OPERA OPERA_ALL_A IntTypA char $19. 
1305 OPERA OPERA_ALL_A REansV5 num BEST. 
1306 OPERA OPERA_ALL_A REansV4keep num BEST. 
1307 OPERA OPERA_ALL_A REansV4orig num BEST. 
1308 OPERA OPERA_ALL_A Jewish num BEST. 
1309 OPERA OPERA_ALL_A DOUTage num BEST. 
1310 OPERA OPERA_ALL_A Tribe num BEST. 
1311 OPERA OPERA_ALL_A REansV3 num BEST. 
1312 OPERA OPERA_ALL_A REansV2 num BEST. 
1313 OPERA OPERA_ALL_A REansOrig num BEST. 
1314 OPERA OPERA_ALL_A DPHYage num BEST. 
1315 OPERA OPERA_ALL_A ModRMin num DATE9. 
1316 OPERA OPERA_ALL_A ModRMax num DATE9. 
1317 OPERA OPERA_ALL_A DLEA4cat char $8. 
1318 OPERA OPERA_ALL_A TribMemb char $7. 
1319 OPERA OPERA_ALL_A TribAfflia char $75. 
1320 OPERA OPERA_ALL_A MiddleNm char $26. 
1321 OPERA OPERA_ALL_A PersonID2S num BEST. 
1322 OPERA OPERA_ALL_A Gender char $39. 
1323 OPERA OPERA_ALL_A CreateDtMin num DATE9. 
1324 OPERA OPERA_ALL_A DPHY4cat char $8. 
1325 OPERA OPERA_ALL_A CreateDtMax num DATE9. 
1326 OPERA OPERA_ALL_A Hispanic char $3. 
1327 OPERA OPERA_ALL_A HispOldS char $12. 
1328 OPERA OPERA_ALL_A Othwhite char $3. 
1329 OPERA OPERA_ALL_A DOBmark num BEST. 
1330 OPERA OPERA_ALL_A WhiteAgg char $3. 
1331 OPERA OPERA_ALL_A WestEur char $3. 
1332 OPERA OPERA_ALL_A EastEur char $3. 
1333 OPERA OPERA_ALL_A MENAAgg char $2. 
1334 OPERA OPERA_ALL_A DLEATime num BEST. 
1335 OPERA OPERA_ALL_A NoAfr char $3. 
1336 OPERA OPERA_ALL_A MidEast char $3. 
1337 OPERA OPERA_ALL_A Slavic char $3. 
1338 OPERA OPERA_ALL_A HispAgg char $3. 
1339 OPERA OPERA_ALL_A HisOth char $3. 
1340 OPERA OPERA_ALL_A HisSou char $3. 
1341 OPERA OPERA_ALL_A HisCen char $3. 
1342 OPERA OPERA_ALL_A HisMex char $3. 
1343 OPERA OPERA_ALL_A DAlife char $21. 
1344 OPERA OPERA_ALL_A Rac8caR char $11. 
1345 OPERA OPERA_ALL_A NHPIAgg char $3. 
1346 OPERA OPERA_ALL_A NHPIoth char $3. 
1347 OPERA OPERA_ALL_A Tongan char $3. 
1348 OPERA OPERA_ALL_A Samoan char $3. 
1349 OPERA OPERA_ALL_A CountyOR char $13. 
1350 OPERA OPERA_ALL_A COFA char $3. 
1351 OPERA OPERA_ALL_A Marshalles char $3. 
1352 OPERA OPERA_ALL_A Cham char $3. 
1353 OPERA OPERA_ALL_A Guam char $3. 
1354 OPERA OPERA_ALL_A NatHaw char $3. 
1355 OPERA OPERA_ALL_A African char $3. 
1356 OPERA OPERA_ALL_A BlackOth char $3. 
1357 OPERA OPERA_ALL_A Caribbean char $3. 
1358 OPERA OPERA_ALL_A AnwsDA char $3. 
1359 OPERA OPERA_ALL_A BlackAgg char $3. 
1360 OPERA OPERA_ALL_A Ethiopian char $3. 
1361 OPERA OPERA_ALL_A Somali char $3. 
1362 OPERA OPERA_ALL_A AfrAm char $3. 
1363 OPERA OPERA_ALL_A AsianS num BEST. 
1364 OPERA OPERA_ALL_A mon num BEST. 
1365 OPERA OPERA_ALL_A AsianOth char $3. 
1366 OPERA OPERA_ALL_A Vietnamese char $3. 
1367 OPERA OPERA_ALL_A SoAsian char $3. 
1368 OPERA OPERA_ALL_A Myanmar char $3. 
1369 OPERA OPERA_ALL_A Laotian char $3. 
1370 OPERA OPERA_ALL_A Korean char $3. 
1371 OPERA OPERA_ALL_A Japanese char $3. 
1372 OPERA OPERA_ALL_A Hmong char $3. 
1373 OPERA OPERA_ALL_A OrgTypeS char $23. 
1374 OPERA OPERA_ALL_A Filipino char $3. 
1375 OPERA OPERA_ALL_A Chinese char $3. 
1376 OPERA OPERA_ALL_A Cambodian char $3. 
1377 OPERA OPERA_ALL_A AsianInd char $3. 
1378 OPERA OPERA_ALL_A CTestTyp char $26. 
1379 OPERA OPERA_ALL_A AsianAgg char $3. 
1380 OPERA OPERA_ALL_A AIANAgg char $3. 
1381 OPERA OPERA_ALL_A LatInd char $3. 
1382 OPERA OPERA_ALL_A CanInd char $3. 
1383 OPERA OPERA_ALL_A SpokLang2 char $7. 
1384 OPERA OPERA_ALL_A AlaskNat char $3. 
1385 OPERA OPERA_ALL_A AmInd char $3. 
1386 OPERA OPERA_ALL_A PriRacGn char $33. 
1387 OPERA OPERA_ALL_A PriRacGnA char $33. 
1388 OPERA OPERA_ALL_A HasDPHYTime num BEST. 
1389 OPERA OPERA_ALL_A PriRacEth char $23. 
1390 OPERA OPERA_ALL_A Rac11caAll char $30. 
1391 OPERA OPERA_ALL_A RaceTotN num BEST. 
1392 OPERA OPERA_ALL_A CaseStatus char $20. 
1393 OPERA OPERA_ALL_A HasDLEATime num BEST. 
1394 OPERA OPERA_ALL_A DupesOrg num BEST. 
1395 OPERA OPERA_ALL_A OnsetDt num DATE9. 
1396 OPERA OPERA_ALL_A dob num DATE9. 
1397 OPERA OPERA_ALL_A LastNm char $34. 
1398 OPERA OPERA_ALL_A FirstNm char $23. 
1399 OPERA OPERA_ALL_A dupes num BEST. 
1400 OPERA OPERA_ALL_A DISdi char $3. 
1401 OPERA OPERA_ALL_A DLIMdi char $3. 
1402 OPERA OPERA_ALL_A DREMageL num BEST. 
1403 OPERA OPERA_ALL_A DPHYdi char $3. 
1404 OPERA OPERA_ALL_A DREMdi char $3. 
1405 OPERA OPERA_ALL_A lineNLall num BEST. 
1406 OPERA OPERA_ALL_A DOUTdi char $3. 
1407 OPERA OPERA_ALL_A DDRSdi char $3. 
1408 OPERA OPERA_ALL_A DEYEdi char $3. 
1409 OPERA OPERA_ALL_A DEARdi char $3. 
1410 OPERA OPERA_ALL_A DCOMdi char $3. 
1411 OPERA OPERA_ALL_A DMHDdi char $3. 
1412 OPERA OPERA_ALL_A DLEAdi char $3. 
1413 OPERA OPERA_ALL_A DA7comp char $15. 
1414 OPERA OPERA_ALL_A DAcompAg char $23. 
1415 OPERA OPERA_ALL_A age num BEST. 
1416 OPERA OPERA_ALL_A Contact_Person_ID char   
1417 OPERA OPERA_ARIAS_ALL DOB1 num DATE9. 
1418 OPERA OPERA_ARIAS_ALL DOB num   
1419 OPERA OPERA_ARIAS_MERGE Physical__mental_or_emotional_co char $20. 
1420 OPERA OPERA_ARIAS_MERGE Do_you_have_serious_difficulty_1 char $43. 
1421 OPERA OPERA_ARIAS_MERGE Do_you_have_serious_difficulty_l char $20. 
1422 OPERA OPERA_ARIAS_MERGE REAL_D_over_15 char $3. 
1423 OPERA OPERA_ARIAS_MERGE Do_you_have_serious_difficulty_w char $20. 
1424 OPERA OPERA_ARIAS_MERGE Do_you_have_difficulty_dressing char $20. 
1425 OPERA OPERA_ARIAS_MERGE Difficulty_doing_errands_alone_ char $20. 
1426 OPERA OPERA_ARIAS_MERGE Difficulty_concentrating__rememb char $20. 
1427 OPERA OPERA_ARIAS_MERGE Deaf_or_do_you_have_serious_diff char $20. 
1428 OPERA OPERA_ARIAS_MERGE Are_you_deaf_or_do_you_have_seri char $20. 
1429 OPERA OPERA_ARIAS_MERGE Are_you_blind_ char $20. 
1430 OPERA OPERA_ARIAS_MERGE Primary_Race_or_Ethnicity char $62. 
1431 OPERA OPERA_ARIAS_MERGE Place_of_Employment char $100. 
1432 OPERA OPERA_ARIAS_MERGE Annual_Income__Base_ char $1. 
1433 OPERA OPERA_ARIAS_MERGE Annual_Income char $1. 
1434 OPERA OPERA_ARIAS_MERGE Outbreak_Related char $9. 
1435 OPERA OPERA_ARIAS_MERGE Modified_By char $27. 
1436 OPERA OPERA_ARIAS_MERGE Identify_Race_or_Ethnicity char $76. 
1437 OPERA OPERA_ARIAS_MERGE Begin_Monitoring_ char $3. 
1438 OPERA OPERA_ARIAS_MERGE Person_ID char $8. 
1439 OPERA OPERA_ARIAS_MERGE Native_Hawaiian_and_Pacific_Isla char $128. 
1440 OPERA OPERA_ARIAS_MERGE Middle_Eastern_North_African char $14. 
1441 OPERA OPERA_ARIAS_MERGE Contact_ID char $11. 
1442 OPERA OPERA_ARIAS_MERGE Children_s_Names char $1. 
1443 OPERA OPERA_ARIAS_MERGE Case_ID char $8. 
1444 OPERA OPERA_ARIAS_MERGE Black_or_African_American char $39. 
1445 OPERA OPERA_ARIAS_MERGE American_Indian_and_Alaska_Nativ char $127. 
1446 OPERA OPERA_ARIAS_MERGE Total_Assessments_with_Symptoms num BEST. 
1447 OPERA OPERA_ARIAS_MERGE Record_Created_On char $1. 
1448 OPERA OPERA_ARIAS_MERGE Modified_By__External_Party_ char $1. 
1449 OPERA OPERA_ARIAS_MERGE Modified_By__Delegate_ char $27. 
1450 OPERA OPERA_ARIAS_MERGE Last_Assessment_Date num MMDDYY10. 
1451 OPERA OPERA_ARIAS_MERGE Created_By char $15. 
1452 OPERA OPERA_ARIAS_MERGE ContactedElapsedHrs num BEST. 
1453 OPERA OPERA_ARIAS_MERGE Contacted_Within_24_Hrs char $3. 
1454 OPERA OPERA_ARIAS_MERGE Access_Failed_Count char $1. 
1455 OPERA OPERA_ARIAS_MERGE _3rd_Contact_Attempt num DATETIME16. 
1456 OPERA OPERA_ARIAS_MERGE _2nd_Contact_Attempt num DATETIME16. 
1457 OPERA OPERA_ARIAS_MERGE _1st_Contact_Attempt num DATETIME16. 
1458 OPERA OPERA_ARIAS_MERGE Language char $28. 
1459 OPERA OPERA_ARIAS_MERGE Created_On num DATETIME16. 
1460 OPERA OPERA_ARIAS_MERGE Owner char $47. 
1461 OPERA OPERA_ARIAS_MERGE End_of_Quarantine_Period num MMDDYY10. 
1462 OPERA OPERA_ARIAS_MERGE Date_of_Last_Exposure num MMDDYY10. 
1463 OPERA OPERA_ARIAS_MERGE Mobile_Phone char $48. 
1464 OPERA OPERA_ARIAS_MERGE Preferred_Method_of_Contact char $5. 
1465 OPERA OPERA_ARIAS_MERGE County char $20. 
1466 OPERA OPERA_ARIAS_MERGE Address_1 char $115. 
1467 OPERA OPERA_ARIAS_MERGE First_Name char $40. 
1468 OPERA OPERA_ARIAS_MERGE Last_Name char $36. 
1469 OPERA OPERA_ARIAS_MERGE _Do_Not_Modify__Modified_On num DATETIME16. 
1470 OPERA OPERA_ARIAS_MERGE _Do_Not_Modify__Row_Checksum char $88. 
1471 OPERA OPERA_ARIAS_MERGE _Do_Not_Modify__Contact char $36. 
1472 OPERA OPERA_ARIAS_MERGE lineTotN1a num BEST. 
1473 OPERA OPERA_ARIAS_MERGE lineNLall num BEST. 
1474 OPERA OPERA_ARIAS_MERGE Dis7catMax char $14. 
1475 OPERA OPERA_ARIAS_MERGE DLEAageL num BEST. 
1476 OPERA OPERA_ARIAS_MERGE DMHDageL num BEST. 
1477 OPERA OPERA_ARIAS_MERGE DOUTageL num BEST. 
1478 OPERA OPERA_ARIAS_MERGE DDRSageL num BEST. 
1479 OPERA OPERA_ARIAS_MERGE DREMageL num BEST. 
1480 OPERA OPERA_ARIAS_MERGE DEARageL num BEST. 
1481 OPERA OPERA_ARIAS_MERGE HasDMHDTime num BEST. 
1482 OPERA OPERA_ARIAS_MERGE HasDLEATime num BEST. 
1483 OPERA OPERA_ARIAS_MERGE HasDCOMTime num BEST. 
1484 OPERA OPERA_ARIAS_MERGE HasDOUTTime num BEST. 
1485 OPERA OPERA_ARIAS_MERGE HasDDRSTime num BEST. 
1486 OPERA OPERA_ARIAS_MERGE HasDPHYTime num BEST. 
1487 OPERA OPERA_ARIAS_MERGE HasDEYETime num BEST. 
1488 OPERA OPERA_ARIAS_MERGE HasDEARTime num BEST. 
1489 OPERA OPERA_ARIAS_MERGE DPHYageL num BEST. 
1490 OPERA OPERA_ARIAS_MERGE HomeLang2 char $7. 
1491 OPERA OPERA_ARIAS_MERGE WritLang2 char $7. 
1492 OPERA OPERA_ARIAS_MERGE SpokLang2 char $7. 
1493 OPERA OPERA_ARIAS_MERGE RRprimGn char $33. 
1494 OPERA OPERA_ARIAS_MERGE Cstatus char $15. 
1495 OPERA OPERA_ARIAS_MERGE CTestTyp char $26. 
1496 OPERA OPERA_ARIAS_MERGE CaseIDMin num BEST. 
1497 OPERA OPERA_ARIAS_MERGE CaseIDMax num BEST. 
1498 OPERA OPERA_ARIAS_MERGE Status char $15. 
1499 OPERA OPERA_ARIAS_MERGE OrgTypeS char $23. 
1500 OPERA OPERA_ARIAS_MERGE lineTotN1 num BEST. 
1501 OPERA OPERA_ARIAS_MERGE lineNL num BEST. 
1502 OPERA OPERA_ARIAS_MERGE lineN1 num BEST. 
1503 OPERA OPERA_ARIAS_MERGE OLDdaQs num BEST. 
1504 OPERA OPERA_ARIAS_MERGE yr num BEST. 
1505 OPERA OPERA_ARIAS_MERGE mon num BEST. 
1506 OPERA OPERA_ARIAS_MERGE AsianSE num BEST. 
1507 OPERA OPERA_ARIAS_MERGE AsianE num BEST. 
1508 OPERA OPERA_ARIAS_MERGE AsianS num BEST. 
1509 OPERA OPERA_ARIAS_MERGE AnwsAny char $3. 
1510 OPERA OPERA_ARIAS_MERGE AnwsAll char $3. 
1511 OPERA OPERA_ARIAS_MERGE AnwsLang char $3. 
1512 OPERA OPERA_ARIAS_MERGE AnwsDA char $3. 
1513 OPERA OPERA_ARIAS_MERGE LEPlang char $26. 
1514 OPERA OPERA_ARIAS_MERGE IntTypS char $32. 
1515 OPERA OPERA_ARIAS_MERGE Year num BEST. 
1516 OPERA OPERA_ARIAS_MERGE CountyS char $13. 
1517 OPERA OPERA_ARIAS_MERGE CountyAll char $25. 
1518 OPERA OPERA_ARIAS_MERGE CountyOR char $13. 
1519 OPERA OPERA_ARIAS_MERGE Zip num BEST. 
1520 OPERA OPERA_ARIAS_MERGE Rac8caR char $11. 
1521 OPERA OPERA_ARIAS_MERGE CovidDi char $21. 
1522 OPERA OPERA_ARIAS_MERGE DAcompNew char $25. 
1523 OPERA OPERA_ARIAS_MERGE AgeDAacq char $11. 
1524 OPERA OPERA_ARIAS_MERGE DAlife char $21. 
1525 OPERA OPERA_ARIAS_MERGE DLIMTime num BEST. 
1526 OPERA OPERA_ARIAS_MERGE DOUTTime num BEST. 
1527 OPERA OPERA_ARIAS_MERGE DPHYTime num BEST. 
1528 OPERA OPERA_ARIAS_MERGE DREMTime num BEST. 
1529 OPERA OPERA_ARIAS_MERGE DEARTime num BEST. 
1530 OPERA OPERA_ARIAS_MERGE DLEATime num BEST. 
1531 OPERA OPERA_ARIAS_MERGE DMHDTime num BEST. 
1532 OPERA OPERA_ARIAS_MERGE DLIM char $10. 
1533 OPERA OPERA_ARIAS_MERGE DOBmark num BEST. 
1534 OPERA OPERA_ARIAS_MERGE Dupes2 num BEST. 
1535 OPERA OPERA_ARIAS_MERGE DA4catMax char $8. 
1536 OPERA OPERA_ARIAS_MERGE DLIM4cat char $8. 
1537 OPERA OPERA_ARIAS_MERGE DPHY4cat char $8. 
1538 OPERA OPERA_ARIAS_MERGE DDRS4cat char $8. 
1539 OPERA OPERA_ARIAS_MERGE DREM4cat char $8. 
1540 OPERA OPERA_ARIAS_MERGE DEYE4cat char $8. 
1541 OPERA OPERA_ARIAS_MERGE DEAR4cat char $8. 
1542 OPERA OPERA_ARIAS_MERGE DMHD4cat char $8. 
1543 OPERA OPERA_ARIAS_MERGE DLEA4cat char $8. 
1544 OPERA OPERA_ARIAS_MERGE DisN num BEST. 
1545 OPERA OPERA_ARIAS_MERGE AgAcq1st num BEST. 
1546 OPERA OPERA_ARIAS_MERGE DPHYage num BEST. 
1547 OPERA OPERA_ARIAS_MERGE DMHDage num BEST. 
1548 OPERA OPERA_ARIAS_MERGE DLIMage num BEST. 
1549 OPERA OPERA_ARIAS_MERGE DLEAage num BEST. 
1550 OPERA OPERA_ARIAS_MERGE DOUTage num BEST. 
1551 OPERA OPERA_ARIAS_MERGE DDRSage num BEST. 
1552 OPERA OPERA_ARIAS_MERGE DREMage num BEST. 
1553 OPERA OPERA_ARIAS_MERGE DCOMage num BEST. 
1554 OPERA OPERA_ARIAS_MERGE DEYEage num BEST. 
1555 OPERA OPERA_ARIAS_MERGE Interp char $7. 
1556 OPERA OPERA_ARIAS_MERGE IntTypA char $19. 
1557 OPERA OPERA_ARIAS_MERGE IntTyp char $15. 
1558 OPERA OPERA_ARIAS_MERGE IntNeedDi char $3. 
1559 OPERA OPERA_ARIAS_MERGE ENG4catR char $10. 
1560 OPERA OPERA_ARIAS_MERGE LEPdiR char $3. 
1561 OPERA OPERA_ARIAS_MERGE LEPdi char $3. 
1562 OPERA OPERA_ARIAS_MERGE LanNbr num BEST. 
1563 OPERA OPERA_ARIAS_MERGE PrefLang2 char $19. 
1564 OPERA OPERA_ARIAS_MERGE SignType char $22. 
1565 OPERA OPERA_ARIAS_MERGE WritLang char $26. 
1566 OPERA OPERA_ARIAS_MERGE SpokLang char $22. 
1567 OPERA OPERA_ARIAS_MERGE PrefLang char $26. 
1568 OPERA OPERA_ARIAS_MERGE ENG4cat char $10. 
1569 OPERA OPERA_ARIAS_MERGE IntpNeedC num BEST. 
1570 OPERA OPERA_ARIAS_MERGE NonEngPre char $15. 
1571 OPERA OPERA_ARIAS_MERGE ENG char $21. 
1572 OPERA OPERA_ARIAS_MERGE Sign num BEST. 
1573 OPERA OPERA_ARIAS_MERGE RaceHas num BEST. 
1574 OPERA OPERA_ARIAS_MERGE OthwhiteOIC char $16. 
1575 OPERA OPERA_ARIAS_MERGE WhiteAggOIC char $16. 
1576 OPERA OPERA_ARIAS_MERGE WestEurOIC char $16. 
1577 OPERA OPERA_ARIAS_MERGE EastEurOIC char $16. 
1578 OPERA OPERA_ARIAS_MERGE NoAfrOIC char $16. 
1579 OPERA OPERA_ARIAS_MERGE MidEastOIC char $16. 
1580 OPERA OPERA_ARIAS_MERGE SlavicOIC char $16. 
1581 OPERA OPERA_ARIAS_MERGE NonEngDi char $3. 
1582 OPERA OPERA_ARIAS_MERGE HispAggOIC char $16. 
1583 OPERA OPERA_ARIAS_MERGE HisOthOIC char $16. 
1584 OPERA OPERA_ARIAS_MERGE HisSouOIC char $16. 
1585 OPERA OPERA_ARIAS_MERGE HisCenOIC char $16. 
1586 OPERA OPERA_ARIAS_MERGE InterpA char $19. 
1587 OPERA OPERA_ARIAS_MERGE HisMexOIC char $16. 
1588 OPERA OPERA_ARIAS_MERGE NHPIAggOIC char $16. 
1589 OPERA OPERA_ARIAS_MERGE NHPIothOIC char $16. 
1590 OPERA OPERA_ARIAS_MERGE TonganOIC char $11. 
1591 OPERA OPERA_ARIAS_MERGE DEARage num BEST. 
1592 OPERA OPERA_ARIAS_MERGE SamoanOIC char $16. 
1593 OPERA OPERA_ARIAS_MERGE COFAOIC char $16. 
1594 OPERA OPERA_ARIAS_MERGE MarshallesOIC char $16. 
1595 OPERA OPERA_ARIAS_MERGE ChamOIC char $16. 
1596 OPERA OPERA_ARIAS_MERGE GuamOIC char $16. 
1597 OPERA OPERA_ARIAS_MERGE NatHawOIC char $16. 
1598 OPERA OPERA_ARIAS_MERGE BlackOthOIC char $16. 
1599 OPERA OPERA_ARIAS_MERGE CaribbeanOIC char $16. 
1600 OPERA OPERA_ARIAS_MERGE DA7compA char $15. 
1601 OPERA OPERA_ARIAS_MERGE DCOM4cat char $14. 
1602 OPERA OPERA_ARIAS_MERGE AfricanOIC char $16. 
1603 OPERA OPERA_ARIAS_MERGE BlackAggOIC char $16. 
1604 OPERA OPERA_ARIAS_MERGE EthiopianOIC char $16. 
1605 OPERA OPERA_ARIAS_MERGE SomaliOIC char $16. 
1606 OPERA OPERA_ARIAS_MERGE DOUT4cat char $8. 
1607 OPERA OPERA_ARIAS_MERGE AfrAmOIC char $16. 
1608 OPERA OPERA_ARIAS_MERGE AsianOthOIC char $16. 
1609 OPERA OPERA_ARIAS_MERGE VietnameseOIC char $16. 
1610 OPERA OPERA_ARIAS_MERGE SoAsianOIC char $16. 
1611 OPERA OPERA_ARIAS_MERGE MyanmarOIC char $11. 
1612 OPERA OPERA_ARIAS_MERGE LaotianOIC char $16. 
1613 OPERA OPERA_ARIAS_MERGE KoreanOIC char $16. 
1614 OPERA OPERA_ARIAS_MERGE JapaneseOIC char $16. 
1615 OPERA OPERA_ARIAS_MERGE HmongOIC char $16. 
1616 OPERA OPERA_ARIAS_MERGE FilipinoOIC char $16. 
1617 OPERA OPERA_ARIAS_MERGE ChineseOIC char $16. 
1618 OPERA OPERA_ARIAS_MERGE CambodianOIC char $16. 
1619 OPERA OPERA_ARIAS_MERGE DCOMTime num BEST. 
1620 OPERA OPERA_ARIAS_MERGE DEYETime num BEST. 
1621 OPERA OPERA_ARIAS_MERGE DDRSTime num BEST. 
1622 OPERA OPERA_ARIAS_MERGE AsianIndOIC char $16. 
1623 OPERA OPERA_ARIAS_MERGE AsianAggOIC char $16. 
1624 OPERA OPERA_ARIAS_MERGE AIANAggOIC char $16. 
1625 OPERA OPERA_ARIAS_MERGE LatIndOIC char $16. 
1626 OPERA OPERA_ARIAS_MERGE CanIndOIC char $16. 
1627 OPERA OPERA_ARIAS_MERGE AlaskNatOIC char $16. 
1628 OPERA OPERA_ARIAS_MERGE AmIndOIC char $16. 
1629 OPERA OPERA_ARIAS_MERGE REOIC char $24. 
1630 OPERA OPERA_ARIAS_MERGE State char $2. 
1631 OPERA OPERA_ARIAS_MERGE REansEv char $3. 
1632 OPERA OPERA_ARIAS_MERGE REanswer char $3. 
1633 OPERA OPERA_ARIAS_MERGE Month num BEST. 
1634 OPERA OPERA_ARIAS_MERGE RaceMainN num BEST. 
1635 OPERA OPERA_ARIAS_MERGE Rac8ca char $28. 
1636 OPERA OPERA_ARIAS_MERGE Rac9ca char $28. 
1637 OPERA OPERA_ARIAS_MERGE POCdi char $11. 
1638 OPERA OPERA_ARIAS_MERGE TribalElg num BEST. 
1639 OPERA OPERA_ARIAS_MERGE NHPI char $3. 
1640 OPERA OPERA_ARIAS_MERGE AnwsRace char $3. 
1641 OPERA OPERA_ARIAS_MERGE Black char $3. 
1642 OPERA OPERA_ARIAS_MERGE MENA char $3. 
1643 OPERA OPERA_ARIAS_MERGE AIAN char $3. 
1644 OPERA OPERA_ARIAS_MERGE REansV6 num BEST. 
1645 OPERA OPERA_ARIAS_MERGE PriRacGnIM char $33. 
1646 OPERA OPERA_ARIAS_MERGE REansV5 num BEST. 
1647 OPERA OPERA_ARIAS_MERGE REansV4keep num BEST. 
1648 OPERA OPERA_ARIAS_MERGE REansV4orig num BEST. 
1649 OPERA OPERA_ARIAS_MERGE Jewish num BEST. 
1650 OPERA OPERA_ARIAS_MERGE CogLeaDi char $3. 
1651 OPERA OPERA_ARIAS_MERGE Tribe num BEST. 
1652 OPERA OPERA_ARIAS_MERGE REansV3 num BEST. 
1653 OPERA OPERA_ARIAS_MERGE OrganR char $70. 
1654 OPERA OPERA_ARIAS_MERGE REansV2 num BEST. 
1655 OPERA OPERA_ARIAS_MERGE REansOrig num BEST. 
1656 OPERA OPERA_ARIAS_MERGE ModRMin num DATE9. 
1657 OPERA OPERA_ARIAS_MERGE ModRMax num DATE9. 
1658 OPERA OPERA_ARIAS_MERGE TribMemb char $7. 
1659 OPERA OPERA_ARIAS_MERGE TribAfflia char $75. 
1660 OPERA OPERA_ARIAS_MERGE HomeLang char $20. 
1661 OPERA OPERA_ARIAS_MERGE MiddleNm char $26. 
1662 OPERA OPERA_ARIAS_MERGE PersonID2S num BEST. 
1663 OPERA OPERA_ARIAS_MERGE Gender char $39. 
1664 OPERA OPERA_ARIAS_MERGE CreateDtMin num DATE9. 
1665 OPERA OPERA_ARIAS_MERGE Dupes4lang num BEST. 
1666 OPERA OPERA_ARIAS_MERGE CreateDtMax num DATE9. 
1667 OPERA OPERA_ARIAS_MERGE Hispanic char $3. 
1668 OPERA OPERA_ARIAS_MERGE HispOldS char $12. 
1669 OPERA OPERA_ARIAS_MERGE Othwhite char $3. 
1670 OPERA OPERA_ARIAS_MERGE HasDREMTime num BEST. 
1671 OPERA OPERA_ARIAS_MERGE WhiteAgg char $3. 
1672 OPERA OPERA_ARIAS_MERGE WestEur char $3. 
1673 OPERA OPERA_ARIAS_MERGE EastEur char $3. 
1674 OPERA OPERA_ARIAS_MERGE MENAAgg char $2. 
1675 OPERA OPERA_ARIAS_MERGE NoAfr char $3. 
1676 OPERA OPERA_ARIAS_MERGE MidEast char $3. 
1677 OPERA OPERA_ARIAS_MERGE Slavic char $3. 
1678 OPERA OPERA_ARIAS_MERGE HispAgg char $3. 
1679 OPERA OPERA_ARIAS_MERGE DEYEageL num BEST. 
1680 OPERA OPERA_ARIAS_MERGE DCOMageL num BEST. 
1681 OPERA OPERA_ARIAS_MERGE HisOth char $3. 
1682 OPERA OPERA_ARIAS_MERGE HisSou char $3. 
1683 OPERA OPERA_ARIAS_MERGE HisCen char $3. 
1684 OPERA OPERA_ARIAS_MERGE HisMex char $3. 
1685 OPERA OPERA_ARIAS_MERGE lineN1all num BEST. 
1686 OPERA OPERA_ARIAS_MERGE NHPIAgg char $3. 
1687 OPERA OPERA_ARIAS_MERGE NHPIoth char $3. 
1688 OPERA OPERA_ARIAS_MERGE Tongan char $3. 
1689 OPERA OPERA_ARIAS_MERGE Samoan char $3. 
1690 OPERA OPERA_ARIAS_MERGE COFA char $3. 
1691 OPERA OPERA_ARIAS_MERGE Marshalles char $3. 
1692 OPERA OPERA_ARIAS_MERGE Cham char $3. 
1693 OPERA OPERA_ARIAS_MERGE Guam char $3. 
1694 OPERA OPERA_ARIAS_MERGE NatHaw char $3. 
1695 OPERA OPERA_ARIAS_MERGE African char $3. 
1696 OPERA OPERA_ARIAS_MERGE BlackOth char $3. 
1697 OPERA OPERA_ARIAS_MERGE Caribbean char $3. 
1698 OPERA OPERA_ARIAS_MERGE Monitoring_Status char $33. 
1699 OPERA OPERA_ARIAS_MERGE Email char $64. 
1700 OPERA OPERA_ARIAS_MERGE Jurisdiction char $41. 
1701 OPERA OPERA_ARIAS_MERGE BlackAgg char $3. 
1702 OPERA OPERA_ARIAS_MERGE Ethiopian char $3. 
1703 OPERA OPERA_ARIAS_MERGE Somali char $3. 
1704 OPERA OPERA_ARIAS_MERGE AfrAm char $3. 
1705 OPERA OPERA_ARIAS_MERGE AsianOth char $3. 
1706 OPERA OPERA_ARIAS_MERGE Vietnamese char $3. 
1707 OPERA OPERA_ARIAS_MERGE SoAsian char $3. 
1708 OPERA OPERA_ARIAS_MERGE Myanmar char $3. 
1709 OPERA OPERA_ARIAS_MERGE Contact_Attempt_Successful char $3. 
1710 OPERA OPERA_ARIAS_MERGE Laotian char $3. 
1711 OPERA OPERA_ARIAS_MERGE Korean char $3. 
1712 OPERA OPERA_ARIAS_MERGE Japanese char $3. 
1713 OPERA OPERA_ARIAS_MERGE Hmong char $3. 
1714 OPERA OPERA_ARIAS_MERGE Initial_Owner char $810. 
1715 OPERA OPERA_ARIAS_MERGE Filipino char $3. 
1716 OPERA OPERA_ARIAS_MERGE Chinese char $3. 
1717 OPERA OPERA_ARIAS_MERGE Cambodian char $3. 
1718 OPERA OPERA_ARIAS_MERGE AsianInd char $3. 
1719 OPERA OPERA_ARIAS_MERGE Modified_On num DATETIME16. 
1720 OPERA OPERA_ARIAS_MERGE AsianAgg char $3. 
1721 OPERA OPERA_ARIAS_MERGE AIANAgg char $3. 
1722 OPERA OPERA_ARIAS_MERGE LatInd char $3. 
1723 OPERA OPERA_ARIAS_MERGE CanInd char $3. 
1724 OPERA OPERA_ARIAS_MERGE Hispanic_or_Latino_a_x char $71. 
1725 OPERA OPERA_ARIAS_MERGE AlaskNat char $3. 
1726 OPERA OPERA_ARIAS_MERGE AmInd char $3. 
1727 OPERA OPERA_ARIAS_MERGE PriRacGn char $33. 
1728 OPERA OPERA_ARIAS_MERGE PriRacGnA char $33. 
1729 OPERA OPERA_ARIAS_MERGE ZIP_Code char $5. 
1730 OPERA OPERA_ARIAS_MERGE PriRacEth char $23. 
1731 OPERA OPERA_ARIAS_MERGE Rac11caAll char $30. 
1732 OPERA OPERA_ARIAS_MERGE RaceTotN num BEST. 
1733 OPERA OPERA_ARIAS_MERGE CaseStatus char $20. 
1734 OPERA OPERA_ARIAS_MERGE Outbreak_ID char $97. 
1735 OPERA OPERA_ARIAS_MERGE DupesOrg num BEST. 
1736 OPERA OPERA_ARIAS_MERGE OnsetDt num DATE9. 
1737 OPERA OPERA_ARIAS_MERGE LastNm char $34. 
1738 OPERA OPERA_ARIAS_MERGE FirstNm char $23. 
1739 OPERA OPERA_ARIAS_MERGE dupes num BEST. 
1740 OPERA OPERA_ARIAS_MERGE DISdi char $3. 
1741 OPERA OPERA_ARIAS_MERGE Because_of_a_physical__mental_or char $20. 
1742 OPERA OPERA_ARIAS_MERGE DLIMdi char $3. 
1743 OPERA OPERA_ARIAS_MERGE DPHYdi char $3. 
1744 OPERA OPERA_ARIAS_MERGE Difficulty_walking_or_climbing_s char $20. 
1745 OPERA OPERA_ARIAS_MERGE DREMdi char $3. 
1746 OPERA OPERA_ARIAS_MERGE DOUTdi char $3. 
1747 OPERA OPERA_ARIAS_MERGE DDRSdi char $3. 
1748 OPERA OPERA_ARIAS_MERGE DEYEdi char $3. 
1749 OPERA OPERA_ARIAS_MERGE REAL_D_over_5 char $3. 
1750 OPERA OPERA_ARIAS_MERGE DEARdi char $3. 
1751 OPERA OPERA_ARIAS_MERGE DCOMdi char $3. 
1752 OPERA OPERA_ARIAS_MERGE DMHDdi char $3. 
1753 OPERA OPERA_ARIAS_MERGE DLEAdi char $3. 
1754 OPERA OPERA_ARIAS_MERGE DA7comp char $15. 
1755 OPERA OPERA_ARIAS_MERGE DAcompAg char $23. 
1756 OPERA OPERA_ARIAS_MERGE age num BEST. 
1757 OPERA OPERA_ARIAS_MERGE Contact_Person_ID char $11. 
1758 OPERA OPERA_ARIAS_MERGE DOB char   
1759 OPERA OPERA_ARIAS_MERGE City char $22. 
1760 OPERA OPERA_ARIAS_MERGE Asian char $3. 
1761 OPERA OPERA_ARIAS_MERGE White char $3. 
1762 OPERA OPERA_ARIAS_MERGE Age_group char   
1763 OPERA TYPE_ISSUE format char   
1764 OPERA TYPE_ISSUE type char   
1765 OPERA TYPE_ISSUE name char   
1766 OPERA TYPE_ISSUE memname char   
1767 OPERA TYPE_ISSUE libname char

For part 2, here is the code:

**** For Opera.Arias_View_2 with the CHARACTER Date ***;

Data OPERA.Big_Check;
  Set OPERA.Arias_View_2;
  dob_num = input(dob, mmddyy10.);
  keep dob dob_num;
  format dob_num date9.;
run;

proc contents data = OPERA.Big_Check;
run;

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

Here is the output result from the Proc contents:

The SAS System 


The CONTENTS Procedure

Data Set Name OPERA.BIG_CHECK Observations 80230 
Member Type DATA Variables 2 
Engine V9 Indexes 0 
Created 03/05/2021 21:12:33 Observation Length 18 
Last Modified 03/05/2021 21:12:33 Deleted Observations 0 
Protection   Compressed CHAR 
Data Set Type   Reuse Space NO 
Label   Point to Observations YES 
Data Representation WINDOWS_64 Sorted NO 
Encoding wlatin1 Western (Windows)     



Engine/Host Dependent Information 
Data Set Page Size 65536 
Number of Data Set Pages 26 
Number of Data Set Repairs 0 
ExtendObsCounter YES 
Filename M:\DATA\OR0206965\OPERA_ARIAS_SAS\big_check.sas7bdat 
Release Created 9.0401M5 
Host Created X64_SRV16 
Owner Name DHS\OR0206965 
File Size 2MB 
File Size (bytes) 1769472 



Alphabetic List of Variables and Attributes 
# Variable Type Len Format 
1 DOB Char 10   
2 dob_num Num 8 DATE9.

And the output from the Proc print of obs = 10:

The SAS System 


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

I can't figure out why the missing values through the entire data set.

Thank you for your continued help and assistance.

wklierman

PaigeMiller · Posted 03-05-2021 04:18 PM

@wlierman wrote:
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

data view_1;
    set view_1;
    format dob date9.;
run;

Data that looks like 30427 in view_2 isn't a date of birth that I recognize. If it is a SAS date, it would be some time in the year 2043, as far as I know, no one has been born in that year so far. Unless it means 03/04/1927 or the opposite 04/03/1927, and you'd have to let us know what it really means.

--
Paige Miller

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

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

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

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

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

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

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

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

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

2025 SAS Hackathon: There is still time!

SAS Training: Just a Click Away