The National Occupational Respiratory Mortality System: Deployment of SAS/IntrNet Application Dispatcher Queries Using SAS Component Language (SCL) Macros

Details

• Personal Author:
  Wood JM
• Description:
  Long-term viability of the system required developing effi-cient algorithms for processing all possible variable combi-nations and outcomes while minimizing file size and maximizing the processing speed. File size was substan-tially reduced by representing cause-of-death outcomes as dummy variables (yes vs. no). Nested macro subroutines and macro variables were developed for reuse in similar processes. Examples include a subroutine for calculating numbers of deaths that also functions as the first step in calculating death rates; macro variables that control the processing of any combination of selected demographic criteria; and nested subroutines that process one or more disease selections. By using WHERE clauses with proce-dure statements, and by indexing prior to merging multiple data sets, we observed shorter processing time. Consid-ering all enhancements, some queries with previous proc-essing times of minutes now often execute in fewer than 10 seconds. NORMS is a useful tool for implementation of a long-term NIOSH strategic goal of dissemination of occupational surveillance data for research purposes and disease pre-vention. [Description provided by NIOSH]
• Subjects:
  Mortality Occupational Diseases Occupational Exposure Occupational Health Respiratory Tract Diseases Safety Staff Development
• Keywords:
  Disease-prevention Diseases Mortality-data Mortality-rates Occupational-diseases Occupational-hazards Occupational-health Occupational-health-programs Occupational-safety-programs Respiratory-system-disorders Surveillance-programs

  More +
• Publisher:
  SAS Institute
• Document Type:
  Text
• Genre:
  Proceedings
• Place as Subject:
  OSHA Region 3 ; West Virginia
• CIO:
  National Institute for Occupational Safety and Health (NIOSH)
• Division:
  DRDS - Division of Respiratory Disease Studies
• Topic:
  Workplace Safety & Health
• Location:
  North America
• Pages in Document:
  1-10
• NIOSHTIC Number:
  nn:20031301
• Citation:
  Northeast SAS Users Group Inc. 19th Annual Conference Proceedings, September 17-20, 2006, Philadelphia, Pennsylvania. Heidelberg, Germany: SAS Institute, 2006 Sep; :1-10
• Federal Fiscal Year:
  2006
• Peer Reviewed:
  False
• Source Full Name:
  Northeast SAS Users Group Inc. 19th Annual Conference Proceedings, September 17-20, 2006, Philadelphia, Pennsylvania
• Collection(s):
  National Institute for Occupational Safety and Health
• Main Document Checksum:
  urn:sha-512:124c26def17ceaa6e37aecbb86ed009c6881a3035258fd06f31e401d91752fbaeba97ea3c63b4363be8137b3959e82c1034ccc70b351efa998547731459a596c
• Download URL:
  https://stacks.cdc.gov/view/cdc/191595/cdc_191595_DS1.pdf
• File Type:
  [PDF - 1.27 MB ]