Scholars Central

Conference abstract

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

Authors: Vasanth Kumar K, Shiva Manoj Kumar, Ravali Bojja

Ask about this article

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

Ask 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.

Try:

Similar by topic

More from this journal

The newest in Journal of Pharmacovigilance.

All its articles

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”

For authors and organisers

Publish, present and keep up with your field

Find the right journal for your paper and submit your manuscript.

Photo: Pexels