CLINITEQ

Cliniteq aims to provide quality training on SAS® software modules, CDISC-SDTM and CDM and also consulting, staffing and service activities <br/> <br/>SAS is world’s leading statistical analytical and reporting tool. <br/> <br/>Biggest giants of Clinical / Pharmacy, Finance, Banking, Business Analytics, Market Research, etc are looking for SAS professionals, there are in a great demand in our country in other country as well <br/> <br/>CLINITEQ is providing internship program in clinical SAS with SDTM <br/> <br/>Duration-3 months <br/> <br/>ELIGIBILITY :BSc /MSc(LIFE SCIENCE), BPHARMACY/MPHARMACY, BTECH(BIOTECHNOLOGY), MBBS, BDS, PhD <br/> <br/> <br/> <br/>MODULE – 1: SAS <br/> <br/>What is SAS; <br/> <br/>SAS is a statistical software package that allows the user to manipulate and analyze data in many different ways. It is mostly used reporting tool. Because of its capabilities, this software package is used in many pharma, finance, retail, telecom and many more. <br/> <br/>This course will also be conducted over the weekend to assist busy professionals and students to attend it. <br/> <br/>Course Highlights: <br/> <br/>• Get hands-on knowledge on SAS <br/> <br/>• Learn SAS programming concepts as applied in the industry <br/> <br/>• Practice on Real-life Industry oriented case studies from Retail, Clinical, and Finance field for practical understanding <br/> <br/>• State-of-the-art lab with required software for practicing <br/> <br/>• Training by highly experienced industry experts <br/> <br/>• Access to the highly qualified instructors to clarify queries after the course <br/> <br/>• Excellent course materials, course related publications (soft copies) will be provided <br/> <br/>• Completion Certificate upon successful completion of the course <br/> <br/>• Resume preparation and mock interviews <br/> <br/>• We guide you to clear your SAS certification <br/> <br/>SAS software <br/> <br/>The latest official version of SAS 9.3 software with all its features is used for training. <br/> <br/>MODULE – SAS <br/> <br/>INTRODUCTION TO SAS <br/> <br/>History of SAS <br/> <br/>Terminology of SAS <br/> <br/>Introduction to Clinical trails <br/> <br/>Topic on real-time SAS programmer work in pharma industry <br/> <br/>Guide lines of SAS programming <br/> <br/>Protocol, DBMS, SOP, SAP <br/> <br/>SAS window environment <br/> <br/> <br/> <br/>SAS program <br/> <br/>Components of SAS Programs <br/> <br/>Characteristics of SAS Programs <br/> <br/>Layout for SAS Programs <br/> <br/>Processing SAS Programs <br/> <br/>Backend process of SAS (How SAS thinks and works according to commands) <br/> <br/>Log messages <br/> <br/>Results of processing <br/> <br/>Global statements <br/> <br/>SAS libraries <br/> <br/>How SAS files are stored <br/> <br/>Storing files temporarily and permanently <br/> <br/>Formats: <br/> <br/>Creation of user defined formats and storing them permanently <br/> <br/>Using system defined formats <br/> <br/>using formats for non-standard data like dates, currency. <br/> <br/>Creating Data files or Datasets or Tables <br/> <br/>Create temporary and permanent SAS data sets <br/> <br/>Create and manipulate SAS date values <br/> <br/>Use DATA Step statements to export data to standard and comma delimited raw data files <br/> <br/>Control which observations and variables in a SAS data set are processed and output <br/> <br/>SAS function: <br/> <br/>Round (x, 1); Mean ( ); Put ( ); Input ( ); Lag ( ); Dif ( ); N ( ); <br/> <br/>NMISS ( ); Log ( ); Int ( ); Weekday ( ); MDY ( , , ); length() compress(); <br/> <br/>Compbl(); scan(x,1); substr(var,x,y); UPCASE LOWCASE PROPCASE TRIM <br/> <br/>Cat <br/> <br/>SAS options, global options <br/> <br/>SAS data management techniques: <br/> <br/>Combining or joining datatsets- <br/> <br/>Interleaving <br/> <br/>Concatenating <br/> <br/>Merging <br/> <br/>Updating <br/> <br/>Appending <br/> <br/>SAS procedure <br/> <br/> Proc Sort <br/> <br/>Proc Print <br/> <br/> Proc Means <br/> <br/>Proc Freq <br/> <br/>Proc Plot <br/> <br/>Proc Chart <br/> <br/>Proc Compare <br/> <br/> Proc Copy <br/> <br/>Proc Summary <br/> <br/>Proc Tabulate <br/> <br/> Proc Append <br/> <br/> Proc Datasets <br/> <br/> Proc Delete <br/> <br/>Proc Format <br/> <br/>Proc Printto <br/> <br/>Proc report <br/> <br/> <br/> <br/>SAS/ODS: <br/> <br/> Creating Rtf File <br/> <br/> Creating Html File <br/> <br/>Creating Pdf File <br/> <br/> Creating Xml File <br/> <br/> <br/> <br/>Advance SAS : <br/> <br/>SAS ORACLE SQL: <br/> <br/>Introduction <br/> <br/>SQL concepts <br/> <br/>Features & Uses <br/> <br/>Terminology <br/> <br/>Data Types, Key Words, & Operators <br/> <br/>Functions, Predicates & Functions <br/> <br/>Formatting Output <br/> <br/>Group By Clause, <br/> <br/>Order By Clause & Having Clause <br/> <br/>Case Expression and Conditional Logic. <br/> <br/>Creating ,Populating & Deleting Tables <br/> <br/>Alter Table Statement <br/> <br/>Renaming A Table & Columns <br/> <br/>Changing Column’s Length <br/> <br/> <br/> <br/>What is join? <br/> <br/>Left join <br/> <br/>Right join <br/> <br/>Outer join <br/> <br/>Inner join <br/> <br/>Full join <br/> <br/>Comparison between SQL joins and data step combining techniques <br/> <br/>What are Integrity Constraints? <br/> <br/>What are index? How they are created? How to use them? <br/> <br/>Generation of summarized report, customized reports. <br/> <br/>Using conditional ‘when’ clause <br/> <br/>PTF(Pass through facility) <br/> <br/> <br/> <br/>Advance SAS II : <br/> <br/>MACROS <br/> <br/>Introduction to macros <br/> <br/>Macro variables <br/> <br/>User defined macro variables <br/> <br/>System defined macro variables <br/> <br/>Macro variable references <br/> <br/>Macro function <br/> <br/>Defining and calling macros <br/> <br/>Macro parameters <br/> <br/>Batches will start regularly. Weekend and evening batches are going to start. <br/> <br/>Additional concepts also added to above If requested. <br/>