Conference abstract · 19 Jul 2019
Conference abstract
Development of efficient SAS programs, table templates and data listings for preparing, processing and analyzing clinical data by using SQL
Abstract
Select any words in the title or abstract, or press this and choose a sentence.
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 PDF HTML
Keywords
Subjects
Pharmaceutical SciencesAsk about this article
Answers come only from this article's title, abstract and keywords, each sentence pointing to where it comes from. Your question is sent to OpenAI to write the answer. Scholars Central does not store it.
Similar by topic
Conference abstract
Basic SAS macros development for reducing program development and maintenance time in clinical reporting
Mini review · 28 Sep 2023
Optimizing Clinical Data Management Processes for Enhanced Research Efficiency
Research article · 30 Jun 2013
Computational fluid dynamics analyzing to optimize tangential-inlet swirlnozzle for preparing nano-drug during a SEDS process
Research article · 22 Feb 2013
Integration of genetic and clinical data to analyze pharmacokinetic profile of mycophenolic acid in a population of Chinese patients with glomerular disease
More from this journal
The newest in Journal of Pharmacovigilance.
Article · 19 Jun 2026
Advancing Patient Safety Through Modern Pharmacovigilance Practices
Article · 19 Jun 2026
Strengthening Healthcare Outcomes Through Effective Drug Safety Practices
Article · 19 Jun 2026
Expanding Patient Care Through Clinical Pharmacy Services in Modern Healthcare
Conferences in this field
Upcoming conferences in this field.
Follow
New articles from what you follow go into your email digest, once you agree to alert emails.
- JournalJournal of Pharmacovigilance
- SubjectPharmaceutical Sciences
- BylineArticles whose byline prints “Vasanth Kumar K”
- BylineArticles whose byline prints “Shiva Manoj Kumar”
- BylineArticles whose byline prints “Ravali Bojja”

