FREE Registration is required
Overview:
Given a list of patient demographic characteristics and the patient lab records in RDBMS tables separated by years, one can create a list of summary variables per specification per person almost automatically using 3 parallel processes: process #1 selects all lab records only for the patients in the ID list and writes them into pipe #1; process #2 reads records from pipe #1, cleans lab results into appropriate numeric values and writes them into pipe #2; process #3 reads lab values from pipe #2 and aggregates them into person-level characteristics. Tricks of SAS/Access for OLEDB, regular expression, Hash object, and macro programming are illustrated too. The paper also discusses the advantages and limitations of the methods.
(Is this item miscategorized? Does it need more tags? Let us know.)
| Format: | Size: | 178 KB | |
| Date: | Feb 2009 | ||
| Pages: | 10 |
Top results from Database Management
» View all Database Management listings
Top results from Software Engineering
White Papers, Webcasts, and Resources
- Live Webcast: Saving 70% with Google Apps over Microsoft Exchange with Mattson Technology GoogleHear how a global technology company transformed the way it does business--and turned off 6 of its servers--simply by switching to Google Apps.
- Designing High Availability for Internet Information Services CA XOsoftEnd downtime forever on your Web servers running Microsoft Internet Information Services with this step-by-step guide to high availability.
- Live Webcast: Enhanced Availability in a Virtual Data Center with the Dell PS Series and Microsoft Windows Server 2008 R2 Hyper-V Dell EqualLogicLearn how to use the new features of Microsoft Windows Server 2008 R2 Hyper-V to boost the availability of your virtualized data center.
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
Featured Training Courses
- Implementing and Administering Windows 7 in the Enterprise
- CCNA Boot Camp v2.0
- VMware vSphere: Install, Configure, Manage [V4]
- Certified Ethical Hacker
- Management and Leadership Skills
- Browse all Training Courses
SmartPlanet
- Thought-provoking progressive ideas on diverse topics that intersect with technology, business, and life, and matter to the world at large. Visit SmartPlanet
- More from IBM
- Can your business work smarter? Learn more about Lotus Symphony
- Learn how to work smarter and optimize cost using the IBM Smart SOA approach Download the eBook
- Smarter ways to make smarter products Read the brief from IBM



