Example Four
This Text File holds survey response records.
It is a flat, fixed-width, unenclosed file without header or type records.
The Schema File only has fields if they have a value (Base.[Field Presence]), and it does not have trailing delimiters (Base.[Trailing Delimiters]).
Sample Source File
2015 AZ Arizona Tobacco Use – Survey Data Cessation (Youth) Percent of Current Smokers Who Want to Quit YTS % Percentage * Data in these cells have been suppressed because of a small sample size Overall All Races All Ages Middle School (34.865970280000454, -111.76381127699972) BEH 105BEH 170CES 1GEN 8AGE 6RAC 1EDU YTS01 1
2015 AZ Arizona Tobacco Use – Survey Data Cessation (Youth) Percent of Current Smokers Who Want to Quit YTS % Percentage * Data in these cells have been suppressed because of a small sample size Male All Races All Ages Middle School (34.865970280000454, -111.76381127699972) BEH 105BEH 170CES 2GEN 8AGE 6RAC 1EDU YTS02 2
2015 AZ Arizona Tobacco Use – Survey Data Cessation (Youth) Percent of Current Smokers Who Want to Quit YTS % Percentage * Data in these cells have been suppressed because of a small sample size Female All Races All Ages Middle School (34.865970280000454, -111.76381127699972) BEH 105BEH 170CES 3GEN 8AGE 6RAC 1EDU YTS03 3
2015 AZ Arizona Tobacco Use – Survey Data Cessation (Youth) Quit Attempt in Past Year Among Current Cigarette Smokers YTS % Percentage * Data in these cells have been suppressed because of a small sample size Overall All Races All Ages Middle School (34.865970280000454, -111.76381127699972) BEH 105BEH 169QUA 1GEN 8AGE 6RAC 1EDU YTS04 4
2015 AZ Arizona Tobacco Use – Survey Data Cessation (Youth) Quit Attempt in Past Year Among Current Cigarette Smokers YTS % Percentage * Data in these cells have been suppressed because of a small sample size Male All Races All Ages Middle School (34.865970280000454, -111.76381127699972) BEH 105BEH 169QUA 2GEN 8AGE 6RAC 1EDU YTS05 5
2015 AZ Arizona Tobacco Use – Survey Data Cessation (Youth) Quit Attempt in Past Year Among Current Cigarette Smokers YTS % Percentage * Data in these cells have been suppressed because of a small sample size Female All Races All Ages Middle School (34.865970280000454, -111.76381127699972) BEH 105BEH 169QUA 3GEN 8AGE 6RAC 1EDU YTS06 6
2015 AZ Arizona Tobacco Use – Survey Data Cigarette Use (Youth) Smoking Status YTS Current % Percentage 3.2 1.5 0.3 6.1 1377 Overall All Races All Ages Middle School (34.865970280000454, -111.76381127699972) BEH 106BEH 166SSA 1GEN 8AGE 6RAC 1EDU YTS07 7
2015 AZ Arizona Tobacco Use – Survey Data Cigarette Use (Youth) Smoking Status YTS Current % Percentage 3.2 1.5 0.3 6.2 700 Male All Races All Ages Middle School (34.865970280000454, -111.76381127699972) BEH 106BEH 166SSA 2GEN 8AGE 6RAC 1EDU YTS07 7
2015 AZ Arizona Tobacco Use – Survey Data Cigarette Use (Youth) Smoking Status YTS Current % Percentage 3.1 1.6 0.1 6.1 671 Female All Races All Ages Middle School (34.865970280000454, -111.76381127699972) BEH 106BEH 166SSA 3GEN 8AGE 6RAC 1EDU YTS07 7
2015 AZ Arizona Tobacco Use – Survey Data Cigarette Use (Youth) Smoking Status YTS Ever % Percentage 12.5 2.7 7.2 17.9 1331 Overall All Races All Ages Middle School (34.865970280000454, -111.76381127699972) BEH 106BEH 166SSA 1GEN 8AGE 6RAC 1EDU YTS08 8
2015 AZ Arizona Tobacco Use – Survey Data Cigarette Use (Youth) Smoking Status YTS Ever % Percentage 12.9 2.6 7.7 18.1 669 Male All Races All Ages Middle School (34.865970280000454, -111.76381127699972) BEH 106BEH 166SSA 2GEN 8AGE 6RAC 1EDU YTS08 8
2015 AZ Arizona Tobacco Use – Survey Data Cigarette Use (Youth) Smoking Status YTS Ever % Percentage 12.2 3.8 4.8 19.7 656 Female All Races All Ages Middle School (34.865970280000454, -111.76381127699972) BEH 106BEH 166SSA 3GEN 8AGE 6RAC 1EDU YTS08 8
2015 AZ Arizona Tobacco Use – Survey Data Cigarette Use (Youth) Smoking Status YTS Frequent % Percentage 0.5 0.3 0.0 1.1 1377 Overall All Races All Ages Middle School (34.865970280000454, -111.76381127699972) BEH 106BEH 166SSA 1GEN 8AGE 6RAC 1EDU YTS09 9
2015 AZ Arizona Tobacco Use – Survey Data Cigarette Use (Youth) Smoking Status YTS Frequent % Percentage 0.8 0.6 0.0 1.9 700 Male All Races All Ages Middle School (34.865970280000454, -111.76381127699972) BEH 106BEH 166SSA 2GEN 8AGE 6RAC 1EDU YTS09 9
2015 AZ Arizona Tobacco Use – Survey Data Cigarette Use (Youth) Smoking Status YTS Frequent % Percentage 0.1 0.1 0.0 0.3 671 Female All Races All Ages Middle School (34.865970280000454, -111.76381127699972) BEH 106BEH 166SSA 3GEN 8AGE 6RAC 1EDU YTS09 9
2015 CT Connecticut Tobacco Use – Survey Data Cessation (Youth) Percent of Current Smokers Who Want to Quit YTS % Percentage * Data in these cells have been suppressed because of a small sample size Overall All Races All Ages Middle School (41.56266102000046, -72.64984095199964) BEH 105BEH 170CES 1GEN 8AGE 6RAC 1EDU YTS01 1
2015 CT Connecticut Tobacco Use – Survey Data Cessation (Youth) Percent of Current Smokers Who Want to Quit YTS % Percentage 38.3 5.9 26.9 49.8 94 Overall All Races All Ages High School (41.56266102000046, -72.64984095199964) BEH 105BEH 170CES 1GEN 8AGE 6RAC 2EDU YTS01 1
2015 CT Connecticut Tobacco Use – Survey Data Cessation (Youth) Percent of Current Smokers Who Want to Quit YTS % Percentage * Data in these cells have been suppressed because of a small sample size Male All Races All Ages Middle School (41.56266102000046, -72.64984095199964) BEH 105BEH 170CES 2GEN 8AGE 6RAC 1EDU YTS02 2
2015 CT Connecticut Tobacco Use – Survey Data Cessation (Youth) Percent of Current Smokers Who Want to Quit YTS % Percentage * Data in these cells have been suppressed because of a small sample size Male All Races All Ages High School (41.56266102000046, -72.64984095199964) BEH 105BEH 170CES 2GEN 8AGE 6RAC 2EDU YTS02 2
2015 CT Connecticut Tobacco Use – Survey Data Cessation (Youth) Percent of Current Smokers Who Want to Quit YTS % Percentage * Data in these cells have been suppressed because of a small sample size Female All Races All Ages Middle School (41.56266102000046, -72.64984095199964) BEH 105BEH 170CES 3GEN 8AGE 6RAC 1EDU YTS03 3
2015 CT Connecticut Tobacco Use – Survey Data Cessation (Youth) Percent of Current Smokers Who Want to Quit YTS % Percentage * Data in these cells have been suppressed because of a small sample size Female All Races All Ages High School (41.56266102000046, -72.64984095199964) BEH 105BEH 170CES 3GEN 8AGE 6RAC 2EDU YTS03 3
2015 CT Connecticut Tobacco Use – Survey Data Cessation (Youth) Quit Attempt in Past Year Among Current Cigarette Smokers YTS % Percentage * Data in these cells have been suppressed because of a small sample size Overall All Races All Ages Middle School (41.56266102000046, -72.64984095199964) BEH 105BEH 169QUA 1GEN 8AGE 6RAC 1EDU YTS04 4
2015 CT Connecticut Tobacco Use – Survey Data Cessation (Youth) Quit Attempt in Past Year Among Current Cigarette Smokers YTS % Percentage 59.6 5.8 48.4 70.9 107 Overall All Races All Ages High School (41.56266102000046, -72.64984095199964) BEH 105BEH 169QUA 1GEN 8AGE 6RAC 2EDU YTS04 4
2015 CT Connecticut Tobacco Use – Survey Data Cessation (Youth) Quit Attempt in Past Year Among Current Cigarette Smokers YTS % Percentage * Data in these cells have been suppressed because of a small sample size Male All Races All Ages Middle School (41.56266102000046, -72.64984095199964) BEH 105BEH 169QUA 2GEN 8AGE 6RAC 1EDU YTS05 5
2015 CT Connecticut Tobacco Use – Survey Data Cessation (Youth) Quit Attempt in Past Year Among Current Cigarette Smokers YTS % Percentage 69.5 8.0 53.9 85.1 51 Male All Races All Ages High School (41.56266102000046, -72.64984095199964) BEH 105BEH 169QUA 2GEN 8AGE 6RAC 2EDU YTS05 5
2015 CT Connecticut Tobacco Use – Survey Data Cessation (Youth) Quit Attempt in Past Year Among Current Cigarette Smokers YTS % Percentage * Data in these cells have been suppressed because of a small sample size Female All Races All Ages Middle School (41.56266102000046, -72.64984095199964) BEH 105BEH 169QUA 3GEN 8AGE 6RAC 1EDU YTS06 6
2015 CT Connecticut Tobacco Use – Survey Data Cessation (Youth) Quit Attempt in Past Year Among Current Cigarette Smokers YTS % Percentage 50.2 7.0 36.6 63.9 54 Female All Races All Ages High School (41.56266102000046, -72.64984095199964) BEH 105BEH 169QUA 3GEN 8AGE 6RAC 2EDU YTS06 6
2015 CT Connecticut Tobacco Use – Survey Data Cigarette Use (Youth) Smoking Status YTS Current % Percentage 0.8 0.2 0.4 1.2 2462 Overall All Races All Ages Middle School (41.56266102000046, -72.64984095199964) BEH 106BEH 166SSA 1GEN 8AGE 6RAC 1EDU YTS07 7
2015 CT Connecticut Tobacco Use – Survey Data Cigarette Use (Youth) Smoking Status YTS Current % Percentage 5.6 1.0 3.6 7.7 2260 Overall All Races All Ages High School (41.56266102000046, -72.64984095199964) BEH 106BEH 166SSA 1GEN 8AGE 6RAC 2EDU YTS07 7
2015 CT Connecticut Tobacco Use – Survey Data Cigarette Use (Youth) Smoking Status YTS Current % Percentage 0.7 0.2 0.3 1.1 1253 Male All Races All Ages Middle School (41.56266102000046, -72.64984095199964) BEH 106BEH 166SSA 2GEN 8AGE 6RAC 1EDU YTS07 7
2015 CT Connecticut Tobacco Use – Survey Data Cigarette Use (Youth) Smoking Status YTS Current % Percentage 5.6 1.1 3.5 7.7 1166 Male All Races All Ages High School (41.56266102000046, -72.64984095199964) BEH 106BEH 166SSA 2GEN 8AGE 6RAC 2EDU YTS07 7
2015 CT Connecticut Tobacco Use – Survey Data Cigarette Use (Youth) Smoking Status YTS Current % Percentage 1.0 0.2 0.5 1.4 1198 Female All Races All Ages Middle School (41.56266102000046, -72.64984095199964) BEH 106BEH 166SSA 3GEN 8AGE 6RAC 1EDU YTS07 7
2015 CT Connecticut Tobacco Use – Survey Data Cigarette Use (Youth) Smoking Status YTS Current % Percentage 5.6 1.3 3.0 8.2 1088 Female All Races All Ages High School (41.56266102000046, -72.64984095199964) BEH 106BEH 166SSA 3GEN 8AGE 6RAC 2EDU YTS07 7
2015 CT Connecticut Tobacco Use – Survey Data Cigarette Use (Youth) Smoking Status YTS Ever % Percentage 4.4 0.8 2.9 5.9 2344 Overall All Races All Ages Middle School (41.56266102000046, -72.64984095199964) BEH 106BEH 166SSA 1GEN 8AGE 6RAC 1EDU YTS08 8
2015 CT Connecticut Tobacco Use – Survey Data Cigarette Use (Youth) Smoking Status YTS Ever % Percentage 21.8 1.6 18.6 25.0 2174 Overall All Races All Ages High School (41.56266102000046, -72.64984095199964) BEH 106BEH 166SSA 1GEN 8AGE 6RAC 2EDU YTS08 8
2015 CT Connecticut Tobacco Use – Survey Data Cigarette Use (Youth) Smoking Status YTS Ever % Percentage 4.6 0.8 3.1 6.2 1182 Male All Races All Ages Middle School (41.56266102000046, -72.64984095199964) BEH 106BEH 166SSA 2GEN 8AGE 6RAC 1EDU YTS08 8
2015 CT Connecticut Tobacco Use – Survey Data Cigarette Use (Youth) Smoking Status YTS Ever % Percentage 22.4 1.7 19.0 25.7 1113 Male All Races All Ages High School (41.56266102000046, -72.64984095199964) BEH 106BEH 166SSA 2GEN 8AGE 6RAC 2EDU YTS08 8
2015 CT Connecticut Tobacco Use – Survey Data Cigarette Use (Youth) Smoking Status YTS Ever % Percentage 4.2 0.8 2.6 5.8 1154 Female All Races All Ages Middle School (41.56266102000046, -72.64984095199964) BEH 106BEH 166SSA 3GEN 8AGE 6RAC 1EDU YTS08 8
2015 CT Connecticut Tobacco Use – Survey Data Cigarette Use (Youth) Smoking Status YTS Ever % Percentage 21.1 1.9 17.4 24.8 1055 Female All Races All Ages High School (41.56266102000046, -72.64984095199964) BEH 106BEH 166SSA 3GEN 8AGE 6RAC 2EDU YTS08 8
2015 CT Connecticut Tobacco Use – Survey Data Cigarette Use (Youth) Smoking Status YTS Frequent % Percentage 0.1 0.1 0.0 0.2 2462 Overall All Races All Ages Middle School (41.56266102000046, -72.64984095199964) BEH 106BEH 166SSA 1GEN 8AGE 6RAC 1EDU YTS09 9
2015 CT Connecticut Tobacco Use – Survey Data Cigarette Use (Youth) Smoking Status YTS Frequent % Percentage 1.8 0.6 0.6 3.0 2260 Overall All Races All Ages High School (41.56266102000046, -72.64984095199964) BEH 106BEH 166SSA 1GEN 8AGE 6RAC 2EDU YTS09 9
2015 CT Connecticut Tobacco Use – Survey Data Cigarette Use (Youth) Smoking Status YTS Frequent % Percentage 0.2 0.1 0.0 0.5 1253 Male All Races All Ages Middle School (41.56266102000046, -72.64984095199964) BEH 106BEH 166SSA 2GEN 8AGE 6RAC 1EDU YTS09 9
2015 CT Connecticut Tobacco Use – Survey Data Cigarette Use (Youth) Smoking Status YTS Frequent % Percentage 2.0 0.7 0.6 3.4 1166 Male All Races All Ages High School (41.56266102000046, -72.64984095199964) BEH 106BEH 166SSA 2GEN 8AGE 6RAC 2EDU YTS09 9
2015 CT Connecticut Tobacco Use – Survey Data Cigarette Use (Youth) Smoking Status YTS Frequent % Percentage 0.0 0.0 0.0 0.0 1198 Female All Races All Ages Middle School (41.56266102000046, -72.64984095199964) BEH 106BEH 166SSA 3GEN 8AGE 6RAC 1EDU YTS09 9
2015 CT Connecticut Tobacco Use – Survey Data Cigarette Use (Youth) Smoking Status YTS Frequent % Percentage 1.6 0.7 0.3 2.9 1088 Female All Races All Ages High School (41.56266102000046, -72.64984095199964) BEH 106BEH 166SSA 3GEN 8AGE 6RAC 2EDU YTS09 9
Text File Schema Definition
Type=CONTROL,ID=1,SchemaEnclosureCharacter=22,Version=1.0.1.22
Type=META,ID=2,Name=Youth_Tobacco_Survey__YTS__Data,Version=2016-06-17,FileType=FIXED-WIDTH,DelimiterCharacter=,EnclosureCharacter=,EncloseWhen=,CharacterEncoding=,EndOfLine=NEWLINE,FieldIDMethod=POSITION
Type=RECORD,ID=3,Name=Data,Position=1,ParentID=2,Required=YES,HasData=ALWAYS,MinimumAllowed=1,Width=403,IsHeader=NO,TrailingDelimiter=NO
Type=FIELD,ID=4,Name=YEAR,Position=1,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=4,MaximumLength=4,DataType=STRING,Start=1,Width=4,Alignment=LEFT,FillCharacter=32
Type=FIELD,ID=5,Name=LocationAbbr,Position=2,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=2,MaximumLength=2,DataType=STRING,Start=6,Width=2,Alignment=LEFT,FillCharacter=32
Type=FIELD,ID=6,Name=LocationDesc,Position=3,ParentID=3,Required=YES,HasData=ALWAYS,DataType=STRING,Start=9,Width=24,Alignment=LEFT,FillCharacter=32
Type=FIELD,ID=7,Name=TopicType,Position=4,ParentID=3,Required=YES,HasData=ALWAYS,DataType=STRING,Start=34,Width=25,Alignment=LEFT,FillCharacter=32
Type=FIELD,ID=8,Name=TopicDesc,Position=5,ParentID=3,Required=YES,HasData=ALWAYS,DataType=STRING,Start=60,Width=29,Alignment=LEFT,FillCharacter=32
Type=FIELD,ID=9,Name=MeasureDesc,Position=6,ParentID=3,Required=YES,HasData=ALWAYS,DataType=STRING,Start=90,Width=57,Alignment=LEFT,FillCharacter=32
Type=FIELD,ID=10,Name=DataSource,Position=7,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=3,MaximumLength=4,DataType=STRING,Start=148,Width=4,Alignment=LEFT,FillCharacter=32
Type=FIELD,ID=11,Name=Response,Position=8,ParentID=3,Required=YES,HasData=OPTIONAL,DataType=STRING,Start=153,Width=8,Alignment=LEFT,FillCharacter=32
Type=FIELD,ID=12,Name=Data_Value_Unit,Position=9,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=1,MaximumLength=1,DataType=STRING,Start=162,Width=1,Alignment=LEFT,FillCharacter=32
Type=FIELD,ID=13,Name=Data_Value_Type,Position=10,ParentID=3,Required=YES,HasData=ALWAYS,DataType=STRING,Start=164,Width=10,Alignment=LEFT,FillCharacter=32
Type=FIELD,ID=14,Name=Data_Value,Position=11,ParentID=3,Required=YES,HasData=OPTIONAL,DataType=NUMBER,Start=175,Width=4,Alignment=LEFT,FillCharacter=32
Type=FIELD,ID=15,Name=Data_Value_Footnote_Symbol,Position=12,ParentID=3,Required=YES,HasData=OPTIONAL,MinimumLength=1,MaximumLength=1,DataType=STRING,Start=180,Width=1,Alignment=LEFT,FillCharacter=32
Type=FIELD,ID=16,Name=Data_Value_Footnote,Position=13,ParentID=3,Required=YES,HasData=OPTIONAL,DataType=STRING,Start=182,Width=71,Alignment=LEFT,FillCharacter=32
Type=FIELD,ID=17,Name=Data_Value_Std_Err,Position=14,ParentID=3,Required=YES,HasData=OPTIONAL,DataType=NUMBER,Start=254,Width=4,Alignment=LEFT,FillCharacter=32
Type=FIELD,ID=18,Name=Low_Confidence_Limit,Position=15,ParentID=3,Required=YES,HasData=OPTIONAL,DataType=NUMBER,Start=259,Width=4,Alignment=LEFT,FillCharacter=32
Type=FIELD,ID=19,Name=High_Confidence_Limit,Position=16,ParentID=3,Required=YES,HasData=OPTIONAL,DataType=NUMBER,Start=264,Width=4,Alignment=LEFT,FillCharacter=32
Type=FIELD,ID=20,Name=Sample_Size,Position=17,ParentID=3,Required=YES,HasData=OPTIONAL,DataType=NUMBER,Start=269,Width=5,Alignment=LEFT,FillCharacter=32
Type=FIELD,ID=21,Name=Gender,Position=18,ParentID=3,Required=YES,HasData=ALWAYS,DataType=STRING,Start=275,Width=7,Alignment=LEFT,FillCharacter=32
Type=FIELD,ID=22,Name=Race,Position=19,ParentID=3,Required=YES,HasData=ALWAYS,DataType=STRING,Start=283,Width=9,Alignment=LEFT,FillCharacter=32
Type=FIELD,ID=23,Name=Age,Position=20,ParentID=3,Required=YES,HasData=ALWAYS,DataType=STRING,Start=293,Width=8,Alignment=LEFT,FillCharacter=32
Type=FIELD,ID=24,Name=Education,Position=21,ParentID=3,Required=YES,HasData=ALWAYS,DataType=STRING,Start=302,Width=13,Alignment=LEFT,FillCharacter=32
Type=FIELD,ID=25,Name=GeoLocation,Position=22,ParentID=3,Required=YES,HasData=OPTIONAL,DataType=STRING,Start=316,Width=41,Alignment=LEFT,FillCharacter=32
Type=FIELD,ID=26,Name=TopicTypeId,Position=23,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=3,MaximumLength=3,DataType=STRING,Start=361,Width=3,Alignment=LEFT,FillCharacter=32
Type=FIELD,ID=27,Name=TopicId,Position=24,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=6,MaximumLength=6,DataType=STRING,Start=368,Width=6,Alignment=LEFT,FillCharacter=32
Type=FIELD,ID=28,Name=MeasureId,Position=25,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=6,MaximumLength=6,DataType=STRING,Start=375,Width=6,Alignment=LEFT,FillCharacter=32
Type=FIELD,ID=29,Name=StratificationID1,Position=26,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=4,MaximumLength=4,DataType=STRING,Start=380,Width=4,Alignment=LEFT,FillCharacter=32
Type=FIELD,ID=30,Name=StratificationID2,Position=27,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=4,MaximumLength=4,DataType=STRING,Start=385,Width=4,Alignment=LEFT,FillCharacter=32
Type=FIELD,ID=31,Name=StratificationID3,Position=28,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=4,MaximumLength=4,DataType=STRING,Start=390,Width=4,Alignment=LEFT,FillCharacter=32
Type=FIELD,ID=32,Name=StratificationID4,Position=29,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=4,MaximumLength=4,DataType=STRING,Start=395,Width=4,Alignment=LEFT,FillCharacter=32
Type=FIELD,ID=33,Name=SubMeasureID,Position=30,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=5,MaximumLength=5,DataType=STRING,Start=401,Width=5,Alignment=LEFT,FillCharacter=32
Type=FIELD,ID=34,Name=DisplayOrder,Position=31,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=1,MaximumLength=2,DataType=NUMBER,Start=402,Width=2,Alignment=LEFT,FillCharacter=32
Type=SUMMARY,ID=35,ControlCount=1,MetaCount=1,RecordCount=1,FieldCount=31,ListCount=0,ValueCount=0,ConditionCount=0,RuleCount=0,SummaryCount=1,TotalCount=35