Journal of Pharmacovigilance

Development of efficient SAS programs, table templates and data listings for preparing, processing and analyzing clinical data by using SQL

2^nd International Conference and Exhibition on Pharmacovigilance & Clinical Trials

November 18-19, 2013 Hilton San Antonio Airport, TX, USA

Vasanth Kumar K, Shiva Manoj Kumar and Ravali Bojja

Accepted Abstracts: J Pharmacovigilance

Abstract:

The talk is the overview of the structured query language procedure on specifying columns, rows, data presenting, summarizing and subqueries. Mainly discussed about simple joins, complex joins and set operators for creating and modifying tables, views and indexes. It covers about how to maintain the SQL tables and dictionary tables and also setting the SQL procedure options and views about program testing and performance. The main advantage of the SQL tool is it is an augmentation to the data step. Comparison between PROC SQL Join versus DATA Step Merge. To check the PROC SQL view which is a stored PROC SQL query that retrieves the data that is stored in other files. Finally it describe about how to control and use the SQL tool to develop the efficiency SAS programs, table templates and data listings for preparing, processing and analyzing clinical data by using SQL . Key Words: Structured query language, table templates, data listings, data validation, analyzing clinical data, queries report