Vehicle structure and fatalities from national highway traffic safety administration database
Too long to post here,see github
https://github.com/rogerjdeangelis/utl-altair-slc-vehicle-structure-and-fatalities-national-highway-traffic-safety-admin-database
Problem
Indentify Vehicle Structual and Crash Related Information invoved in Vehicle Fatalities
CONTENTS
1 Process (how to add fatalities to Vehicle Structual and Crash Related Information )
2 Inputs
3 All tables and columns
DOWNLOAD
https://www.nhtsa.gov/file-downloads?p=nhtsa/downloads/FARS/2023/National/
FARS2023NationalSAS.zip (unzip into e:/fars)
META DATA
Table (inn e:/fars) Keys
vpicdecode.sas7bdat vehicledescriptor with missing 9th letter(check digit) (203 variables x 57,145 obs many structual variables?)
accident.sas7bdat st_case and fatals (49 variables x 37,654 obs. st_case is a primary key)
vehicle.sas7bdat st_case and vin (110 x 58,319 variables)
