SAS
- Overview of SAS
- SAS Variables/Data Types
- SAS Functions
- Input Data reading techniques
- Loops
Overview of SAS
- Uses & Advantages of SAS
- SAS Architecture
- SAS Components
- SAS Members (Datasets, Catalogues)
- SAS Compilation/Execution Phase
- SAS Software demo
- Steps in SAS Editor Window (Data, Proc)
SAS Variables/Data Types
- 1. Number(dates also)
- 2. Character
SAS Naming conventions
- 1. Data set names
- 2. Catalogue names
- 3. Lib reference
- 4. Index names
SAS Operators
SAS Options (system, macro, data step)
SAS Functions
- 1. Character/String functions
- 2. Number functions
- 3. Aggregate functions
- 4. Statistical functions
- 5. Miscellaneous
Input Data reading techniques
- 1. Import Wizard
- 2. Infile/Input(flat files - .csv, .txt, .doc)
- 3. DDE(Excel files)
- 4. Libname(any type of file)
- 5. Proc SQL(Pass-thru-query, servers, warehouse)
- 6. Proc Import(PC Files – Access, Excel)
- 7. SET Statement ( data sets)
- 8. Proc download(rsubmit)
Conditional Statements
- 1. Simple If statement
- 2. If – else statement
- 3. Nested-If statement
- 4. If – do
- 5. Where clause
- 6. Where dataset option
- 7. If Vs Where
Loops
- 1. Do loop
- 2. Do-While
- 3. While-Do
- 4. Continue
- 5. Leave
Formats/Informats
- 1. Predefined Formats
- a. Date formats.
- b. Character formats
- c. Numeric formats
2. User defined Formats
- a. Proc Format
- i. Invalue (Input())
- ii. Value (Put())
- iii. Fmtlib
- iv. Cntlin=
- v. Cntlout=
- b. Using Data step
Data descriptive Information
- 1. Proc Contents
- 2. Proc Datasets
- 3. Attrib Statement
- 4. Rename Statement
- 5. Length Statement
- 6. Proc Compare
Sorting/Merging techniques
- 1. Proc Sort
- 2. Data step Merge
- 3. Proc SQL
Data Management techniques
- 1. Proc Sort
- 2. Proc Transpose
- 3. Proc Append
- 4. Proc Compare
- 5. Proc Datasets
Outputting Data techniques
- 1. File/Put statement
- 2. DDE
- 3. Proc Export
- 4. Proc SQL
- 5. Proc Upload
Analysis techniques
- 1. Proc Freq
- 2. Proc Means
- 3. Proc Univariate
- 4. Proc Summary
- 5. Proc Rank
- 6. Proc Chart
- 7. Proc Graph
- 8. Proc Plot
Reporting Techniques
- 1. Proc Print
- 2. Proc Report
- 3. Proc Tabulate
- 4. ODS
Macro Concepts
- 1. What is Macros?
- 2. Macros how it works?
- 3. Macro variables ( Declare, Define, Use & Debugg)
- 4. Macro statements & blocks
- 5. Macro calling(Varibales & blocks )
- 6. Type of Macros
- a. Local
- b. Global
- c. Symbol tables
- d. Scope of types
- 7. Macro Debugging
- a. MPrint/MPrintNest
- b. MLogic/MLogicNest
- c. Symbolgen
- 8. Macro Functions
- 9. Auto-call Libraries
- 10. Stored and Compiled macros
Performance Techniques
- 1. Indexes
- a. About
- b. Ways to create
- c. Advantages & Disadvantages
- d. Modify
- e. Delete
- f. Update
- 2. Data Compression techniques
- a. Data compression
- b. Advantages & Disadvantages
- c. Zipping concepts
SAS Jobs Management
- 1. Batch Job Processing
- 2. Diff between Interactive & Batch Job processing
- 3. Job Scheduling
- 4. E-mailing techniques
- a. Sending Emails
- b. Sending Attachments
- c. Advantages & Disadvantages
Real time project scenarios and explanation
Most advanced topics explanation
- 1. SDTM
- 2. CDISC STANDARDS
- 3. TLF(TABLES,LISTINGS & FIGURES EXPLANATION)
- 4. ADAMS CREATION
We provide guidance for BASE & ADVANCED certifications and materials.
- Interview Guidance.
- Domain Explanation
Our distinct services include :
- Material and Documents: We provide real time working documents and materials to our students.
- Free System Access : We have the latest and most up to date platforms deployed on high-end servers that are available remotely and in-class on a 24/7 basis.
- Interview Preparation: We will prepare you for interviews in your specialized area by providing some real time interview questions. We also conduct mock interviews and assist you in preparing a professional resume.
- Placement Assistance: Our placement service division provides job placement support by submitting your resumes to prospective clients and emails you any new job opportunities in the market. However, we do not provide false guarantees on securing any jobs for you. We have a history of several ex-students who have secured excellent jobs based on our WORLD class training approach, implementation of case study projects and post training support.
- Initial Job Stabilization Support: We support our students to get stabilized in their job in the first TWO months. If our students come across any issues, we are there to help them. Students can send an email to us with their issues, our experts will reply back with possible solutions within 24 hours.
- Free Class Room sessions recording: In addition to the e-class training, we will give you authorization to record all of your e-class room training sessions, so that you can go back and review.
Other Courses related
Course registration
Key Points of Training Program :
-
SAS training course teaches the fundamentals of SAS including data access, manipulation, analysis and reporting. Participants will learn how to get data in and out of SAS, manipulate and transform data sets, combine SAS data sets, create summary reports using SAS procedures, and identify and correct data, syntax and programming logic errors. It also prepares students for Base SAS certification officially known as The SAS Certified Base Programmer which is the essential requirements for many other advanced SAS certifications. Entire training course is divided into Base and Advanced modules. Your key learning will be:
• Understand file structure and write system commands to create and access files
• Understand programming logic concepts (IF/THEN logic
• Understand the compilation and execution process of the DATA step
• Use different kinds of input to create SAS data sets from external files
• Use SAS software to access SAS data libraries
• Create and use SAS date values
• Read, concatenate, merge, match-merge and interleave SAS data sets
• Create multiple output data sets
• Use array processing and DO loops to process data iteratively
• Use SAS functions to perform data manipulation and transformations -
• Overview of SAS
• What is SAS Language?
• What are SAS Files?
• SAS Data
• What are the basic system options available in SAS?
• SAS Log -
• Base SAS - Basic procedures and data management
• SAS/STAT - Statistical analysis
• SAS/GRAPH - Graphics and presentation
• SAS/OR - Operations research
• SAS/ETS - Econometrics and Time Series Analysis
• SAS/IML - Interactive matrix language
• SAS/AF - Applications facility
• SAS/QC - Quality control
• SAS/INSIGHT - Data mining
• SAS/PH - Clinical trial analysis
• Enterprise Miner - data mining