The National Occupational Respiratory Mortality System: deployment of SAS/IntrNet application dispatcher queries using SAS component language (SCL) macros.
Northeast SAS Users Group Inc. 19th Annual Conference Proceedings, September 17-20, 2006, Philadelphia, Pennsylvania. Heidelberg, Germany: SAS Institute, 2006 Sep; :1-10
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.
Occupational-health; Occupational-hazards; Mortality-rates; Mortality-data; Respiratory-system-disorders; Occupational-health-programs; Occupational-safety-programs; Occupational-diseases; Diseases; Disease-prevention; Surveillance-programs
Northeast SAS Users Group Inc. 19th Annual Conference Proceedings, September 17-20, 2006, Philadelphia, Pennsylvania