Publication Details

Highway Safety Information System guidebook for the Utah state data files. Volume I: SAS file formats

Type: Paper

Author(s): Council, Forrest M.; Williams, Carolyn D.; Mohamedshah, Yusuf M.

Publisher: Federal Highway Administration

Url: https://rosap.ntl.bts.gov/view/dot/4803

Publication Date: Mar-2000

Number: FHWA RD 01 056

Address: Washington, DC

Abstract: Utah's basic highway information system is one of the most complete data base management systems found in any of the Highway Safety Information System (HSIS) States in terms of the number of files included in the system and the flexibility of output. The system is a relational system built on a database management system named ADABAS. The flexibility of ADABAS allows Utah to "spin off" any number of variables into different file formats. In 2000, the older IBM-based system was converted to a Client/Server system run on a UNIX platform, with Informix as the relational database. The accident data are in three separate files. The Accident Subfile (including crashes from 1985-97), containing basic information on accident type, location, environment, etc., can be linked with the Vehicle Subfile (which contains information on each vehicle in the crash and each driver) and the Occupant Subfile (which contains information on each occupant in each vehicle and non-occupants such as pedestrians, pedalcyclists, etc.) through use of the accident case number, vehicle number, and year. This report, Volume I: SAS File Formats, contains the following: Introduction; Details of Major Files; Utah Contacts; Composite List of Variables; Accident Files (Accident Subfile, Vehicle Subfile, Occupant Subfile); Roadlog File; Curve File; and Grade File. The Single Variable Tabulations are found in Volume II of this report.