SAS Clinical

An online course designed to make you an expert in using SAS Clinical and learn all that is required to provide centralized metadata management using the SAS Metadata Server and the tools to visually transform data


    Course Objectives

      • SAS/BASE
      • SAS/ACCESS
      • SAS/STAT



    Basic theory of sas and it’s rules etc..

      • Sas windowing environment
      • All windows (window,output window, editor window, results window & explore window etc..) Will be explained
      • Creation of libraries(temporary &permanent)
      • Sas programming (briefly)
      • Data step
      • Proc step
      • Ways to access the data into sas environment
      • Back end process of datastep
      • Installation process explanation.
    Data step
        • Data statement & dataset options·
        • Infile statement & options·
        • Input statement &styles & options·
        • Datalines statement
    Attributes of the variables
        •  length, label statements·
        •  informats & formats·
        •  how dates works in sas 
    Other statements
        • Sum statement·
        • retain statements
        • goto statement
        • link statement
        • return statement
        • keep statement
        • drop statement
        • rename statement

    Following conditional statements for data filtration & loops

      • If statement, if/then statement, if/then/else,if/then output, if/then delete statements
      • Where statement& it’s operators
      • Do, do iterative, do until & do while statements
    Combining datasets
      • Concatenation
      • Intereaving concept
      • Merge concept with all joins
      • Update
      • Modify
      • Character functions
      • Numeric functions
      • Date functions
      • Arrays
      • Others missing concepts
      • Review of datastep
    Proc step
    Utility procedures
      • Proc contents and options
      • Proc copy and it’s options
      • Proc setinit (to know the liscence information of sas software)
      • Proc delete
      • Proc pwencode
      • Proc append
      • Proc sort
      • Proc datasets
      • Proc options
      • Proc compare
      • Proc transpose
      • Proc transpose with multiple scenarios
      • Proc rank
      • Proc format
      • Proc import
      • Proc export
      • Proc catalog
      • Proc cport
      • Proc cimport
      • Proc template
      • Proc migrate
      • Review of utility procedures


    Basic theory of sas/access

    Ways to access data from different sources like

    Notepads, excel, csv,files, ms   access, oracle, db   , sybase and terradata etc…

      • Sql pass thru query
      • Libname statement
      • Proc dbload
      • Proc access
      • Review of access procedures
    Reporting procedures
      • Proc print
      • Proc tabulate
      • Proc report
      • _null_ report (data step reporting)
      • Review of reporting procedures
    Sas/graphs & ods concepts
      • Proc gplot
      • Proc gchart
      • Proc sgplot
      • Proc annotate
      • Ods
      • Review of graphs procedures
    Statistical procedures
      • Proc means
      • Proc summary
      • Proc univariate
      • Proc freq
      • Proc corr
      • Proc reg
      • Review of stats procedures
    Introduction to the macro facility in sas purpose of the macro facility
    Macro variables
      • Introduction to macro variables
      • Macro variable references
      • User defined macro variables
      • Delimiting macro variable names
      • Deleting macro variables
    Macro functions
      • Without parameters
      • With parameters
      • Positional parameters
      • Keyword parameters
    Macro definitions
      • Defining and calling a macro
      • Macro parameters
      • Macro storage
    Data step and sql interfaces
      • Creating macro variables in the data step
      • Indirect references to macro variables
      • Retrieving macro variables in the data step
      • Creating macro variables in sql
    Proc sql:
    Sql pass-through query with all concepts
    Sql (structured query language)
      • Ddl (data definition language)
      • Dml (data manipulation language)
      • Tcl (transaction control language)
      • Dcl (data control language)
      • Drl/dql (data retrieval/data query language)
      • Handling null values
      • Defining alias names
      • Integrity constraints
      • Various types of constraints
      • Types of joins:
          • Self join
          • Equi join
          • Non equi join
          • Inner join
    Outer join

    I.left outer join

      • Right outer join
      • Full outer join
          • Natural join
          • Cross join
    Conditional clause
      • Where clause
      • Order by clause
      • Having clause
      • Group by clause

    The following operators we use in oracle(sql)

      • Concatenation operators
          • Relational or comparison operators
          • Logical operators
          • Set operators
          • Multiple-row comparison operators
          • Sql *plus operators
    Pre-defined functions
      • Character functions
      • Number functions
      • Date functions
      • Conversion functions
      • Number conversion
      • Date conversion
    Domain specific project:
      • Driving projects by students
        • Project provided with live data
        • Hands on experience will be provided for the project
        • Real time project support & guidelines provided
        • Clinical/banking/retail/finance projects with complete details
        • Scope & object of project
        • Data cleaning & handling missing values
        • Frequency distributions of demographical variables
        • Error values reporting to client
        • Data management (combining multiple datasets & preparing final meaningful datasets)
        • Report generations & presenting to client
        • Data analysis & conclusion driving
      • Faqs
          • Interview prospect questions
          • Explanation logics in faqs
          • Domain specific faqs
      • Interview handling
          • Guidelines to handle interview
          • Suggestions & precautions for clearing interview
          • Trail run on interview.


    Clinical project work shop(technical project):
      • Introduction to clinical research
      • Clinical domain knowledge and terminology
      • Phases in clinical trails
          • Phase -i
          • Phase -ii
          • Phase -iii
          • Phase -iv
      • Detail about data generation in clinical research and import and export clinical trials data
      • Manage clinical trials data
      • Transform clinical trials data, examine and explore clinical trials input data (find outliers, missing vs. Zero values, etc.).
      • Macro programming for clinical trials
      • Create and use user-defined and automatic macro variables.
      • Automate programs by defining and calling macros.
      • Use system options to debug macros and display values of macro variables in the sas log (mprint, symbolgen, mlogic and macrogen).
      • Report clinical trials results
      • Create output data sets from statistical procedures.
      • Use proc report to produce tables and listings for clinical trials reports.
      • Use ods and global statements to produce and augment clinical trials reports.
      • Obtain counts of events in clinical trials.
      • Apply statistical procedures for clinical trials
      • Overview of locf, bocf & change from baseline
      • Validate clinical trial data reporting
      • Explain the principles of programming validation in the clinical trial industry.
      • Utilize the log file to validate clinical trial data reporting.
      • Use programming techniques to validate clinical trial data reporting (proc compare, msglevel).
      • Identify and resolve data, syntax and logic errors.
      • Real time scenarios
    Clinical project:
      • Description of project
      • Creating various clinical reports
      • Introduction with various clinical study documents (sop, crf, ecrf, sap-i&ii, protocol, editcheck doccument, mockshel etc.)

    We record every live session we hold. Video recordings of each and every session will be posted on our blog too. So, this means you can get access to what the session is about and this way you do not miss any class. But take a note of it that you can have access to these Video recordings for 6 months only from the date you start your training. Access to these videos or to other required course material will be provided using Google Drive Cloud for lifetime.

    Yes, you can cancel your enrolment. We provide a complete refund after deducting the administration fee. To know more, please go through our Refund Policy.

    We have a team of industry-expert instructors or trainers who possess 8-10 yrs. of relevant experience in various Business Technologies. Every instructor / trainer undergo our specialized training program called “Train the Trainer” at Xoomtrainings. Our trainers are trained so that our learners get a great learning experience.

    Yes, classes at Xoomtrainings are conducted through online video streaming where there is two-way communication between users and instructors. The users can speak by using a microphone, chat by sending a message through a chat window and share their screens with an instructor. For better understanding, users can take the sample recorded class on this page to know of the quality of instruction and the way the class is conducted.

    Yes, the instructor will allocate you a real-time project to have a clear understanding of how you are able to conceptualize and implement the real-world application of the course content.

    Yes, we run multiple offers from time-to-time. Please, contact the support team they will give the Coupon Code.

    Yes, we will give you a discount of Rs 1500/- on selected course if you refer someone. We also offer special discount for groups.

    Yes, we will provide you the links of the software to download (trial version) which are open source and for proprietary tools we will provide you trial version, if available.

    For your practical work, we will help you set up a Virtual Machine on your system with IDE’s. This will be local access for you. The detailed step-wise installation guides are present in your LMS which will help you install and set-up the environment for any course. In case, you come across any doubt, the 24/7 support team will promptly assist you through mail (support@xoomtrainings.in) or Phone (+91 -40-4018 3355)

    4 Mbps of internet speed is recommended to attend LIVE classes. However, we have seen people attending the classes with a much slower internet connection too.

    Yes. You will receive a Digital E-Certificate from us once you complete the course. You can include this is in your Resume to get placed better.

    Xoomtrainings is the largest online education company and a large number of recruitment firms contacts us for our student’s profiles from time-to-time. Since there is a big demand for this skill, we help our certified students get connected to prospective employers. We also help our customers prepare their resumes, work on real life projects and provide assistance for interview preparation. Having said that, please understand that we don’t guarantee any placement. However, if you go through the course diligently and complete the project you will have a very good hands on experience to work on a Live project.

    No doubt, your transaction is always safe and secure with Xoomtrainings.

    You will get 24/7 access to the blog to post your questions. Trainers will answer your questions through email within 24 hrs. of time. Also, our support team will help you 24/7 through mail (support@xoomtrainings.in) or Phone (+91-40-4018 3355 ,7093502091,92 ).

    You can give us a CALL at INDIA: +91-40-4018 3355 ,7093502091,92  Or Email at contact@xoomtrainings.in


    Tab Content

    Course Reviews

    No Reviews found for this course.

    • Rs.24,999.00
    • 45 Hours

    Course Features

    Lifetime access to the learning management system including Class recordings, presentations, sample code and projects

    Lifetime access to the support team (available 24/7) in resolving queries during and after the course completion

    Xoomtrainings certified based on your project performance, reviewed by our expert panel

    Xoomtrianings enjoys strong relationship with multiple staffing companies in US, UK and India. If you are looking out for exploring Placement opportunities, you can pass your resumes once you complete the course and we will help you with job assistance. We don’t charge any extra fees for passing the resume to our partners and clients

    Course Enquiry

    © 2015 - 2016 Xoom Trainings powered by Innovin IT Solutions Pvt.LTD..All Rights Reserved.
    There are no courses Added to Cart