Software Engineering White Papers
Automate Dummy Variable Creating From Large Longitudinal RDBMS Tables - A Pedagogical Example of the SAS/Connect Piping Facility
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.
| Publisher | SAS Institute | File Format | |
|---|---|---|---|
| Date Published | February 2009 | ||
| Format | White Papers | ||
| Topics | |||
-
Did you find this white paper useful? 1 out of 2 users found this white paper useful
White Paper RSSAll Things On Demand
DownloadTraditional customer relationship management (CRM) systems fall short when it comes to usability, deployment and payment speed. Software-as-a-Service (SaaS) 1.0 offers such features, but it is limited in other respects....
Trial Download: Rational AppScan Standard Edition V7.9
To improve the security of web applications, it starts by building software securely. IBM Rational AppScan is a suite of Web application vulnerability scanners that include dynamic and static analysis...
Practical Approaches for Securing Web Applications across the Software Delivery Lifecycle
Enterprises understand the importance of securing web applications to protect critical corporate and customer data. What many don't understand, is how to implement a robust process for integrating security and...
Optimize your performance with the Smart Work Advisor
Smart Work Advisor shows how businesses can optimize their performance by providing a decision tree they can use to adapt dynamically, collaborate more effectively and connect people and processes inside...
Webinar: Securing the Cloud Dec 10th, 2pm ET / 11am PT
Cloud computing promises to provide vast computing power, reliable off-site data storage, wide availability, all at lower maintenance and investment costs. But recent cloud computing mishaps have underscored the need...
