Statistical Analytical System

Reliable Technologies offers a training program dealing with SAS. The syllabus of the program is:

Lesson One:- Intro to SAS

* Intro
* Require for S.A.S.
* Who utilize S.A.S.
* What is S.A.S.?
* Synopsis of base S.A.S. software
* Data mgmt. ability
* Construction of S.A.S. dataset
* S.A.S. program
* Programming language
* Element of the S.A.S. language
* Policy for S.A.S. statement
* Policy for most S.A.S. name
* Unique regulations for Variable name
* Kinds of variable
* Data examination & reporting utility
* Traditional output
* Ways to run S.A.S. program
* S.A.S windows surroundings
* Non interactive modes
* Batch modes
* Interactive line modes
* Executing programs in the S.A.S. windows surroundings

Lesson Two: How S.A.S. work

* How to write S.A.S. program
* Simple program to interpret raw data & create a report
* Enhance the program
* Comment statement
* Internal executing in S.A.S.
* How S.A.S work
* Compilation stage
* Effecting stage
* Processing a data step: a walkthrough
* Create the input buffer & the program data vector
* Writing an observation to the SAS data set
* 4 kinds of SAS library
* SAS library
* Work library
* S.A.S. help library
* S.A.S. user library

Lesson Three: Comprehension raw data into S.A.S.

* Description of raw data
* Description
* Data assessment
* Numeric assessment
* Character assessment
* Standard data
* Non- standard data
* Numeric data
* Character data
* Choose an input style
* List input
* Modify list input
* Column input
* Formating input
* Input Named
* Instream data
* How to create number of reports from only input row
* Read data from exterior file
* Read blank estranged evaluation
* Read raw data divided by commas (.csv file)
* Read in raw data divided by tab (.txt file)
* Using in formats with listing input
* Supply an informal declaration with list input
* Use list input with embedded delimit
* Read raw data align in column
* Method One: Input column
* Method Two: Input format
* Use more than one input statement: the single train
* Read column data that is on more than one line
* Mix style input
* Infile option for special circumstances
* Flow-over
* Missover
* Truncover
* Pad
* Use lrecl to examine very long line of raw data
* Check your data after it has been read into S.A.S.

Lesson Four: Read data from a dataset

* Intro
* Set statement synopsis
* Automatic variable in S.A.S.
* Interleave multiple S.A.S. data sets
* Combine multiple S.A.S. data sets
* Create & modify variable
* Create multiple datasets in a distinct data step
* Sub-setting observation
* Conditional S.A.S. statement
* Logical & Special Operator
* The S.A.S. supervisor & the set statement
* Effectiveness & the set statement
* Know your data
* Set statement data set options
* Drop and keep options
* Rename option
* Firstobs and obs alternatives
* In alternative -
* Where alternative -
* Other set statement alternatives
* End alternative
* Key alternative
* Nobs alternative
* Point alternative
* Do loop & the set statement
* Intro to maintain statement
* Carry over assessments from one observation to another
* Compare assessments across observations
* Assign initial assessments
* Determining column order in output dataset
* S.A.S. system alternatives

Lesson Five: Read data from a dataset

* Input SAS data set for example
* Selecting observations for a new SAS data set
* Deleting observations based on a condition
* Accepting observations based on a condition
* Comparing the delete and subsetting if statements
* Methods of creating new data sets with a subset
* Sub setting records from an external file with a subsetting if statement
* Sub setting observations in a data step with a where statement
* Sub setting observations in a proc step with a where statement
* Sub setting observations in proc sql
* Difference between if & where

Lesson Six: SAS informants & formats

* Overview
* Using SAS informats
* Input statement
* Input purpose
* Input & input purpose
* Attrib and in format statement
* Using S.A.S. formats
* Format statement in events
* Put statement
* Put purpose
* Put & put purpose
* bestw. Format
* Additional comment

Lesson Seven: S.A.S. purpose

* Category of purpose
* S.A.S. character Purposes
* Purpose that alter the case of characters
* Up-case
* Lower case
* Prop case
* Purposes that remove characters from strings
* Purpose: compbl
* Purpose: compress
* Purposes that search for character
* Purpose: anyalnum
* Purpose: anyalpha
* Purpose: anydigit
* Purpose: anypunct
* Purpose: anyspace
* Purpose: notalnum
* Purpose: notalpha
* Purpose: notdigit
* Purpose: notupper
* Purposes that search strings
* Find & Find
* Index, Indexc, & Indexw
* Purposes to confirm data
* Purpose confirm
* Purposes that extract parts of strings
* Purpose: substr (on the left-hand side of the equal sign)
* Purpose: substrn
* Purposes that join two or more strings together
* Purpose: cat
* Purpose: cats
* Purpose: catt
* Purpose: catx
* Purposes that remove blanks from strings
* Purpose: left
* Purpose: right
* Purpose: trim
* Purpose: trimn
* Purpose: strip
* Purposes that compare strings
* Purpose: compare
* Purposes that divide strings into "words"
* Purpose: scan
* Purpose: scanq
* Purposes that substitute letters or words in strings
* Purpose: translate
* Purpose: tranwrd
* Purposes that compute the length of strings
* Purpose: length
* Purpose: lengthc
* Purpose: lengthm
* Purpose: lengthn
* Purposes that count the number of letters or substrings in a string
* Purpose: count
* Purpose: countc
* Miscellaneous string Purposes
* Purpose: missing
* Purpose: repeat
* Purpose: reverse
* SAS date & time Purposes
* Intro
* What is a SAS date and time literal?
* Date & time Purposes
* Functions to generate date & time assessments
* Purposes to takie date-time assessments apart
* Purposes to get quarter,year or day of the date
* Purposes that job with intervals
* Using formats for date & time
* System options fordate & time

Lesson Eight: An Intro to array & array dealing out

* Why do we need arrays?
* Fundamental array idea
* Array statement
* Array references
* Variable name array refer
* Using Array index
* One-dimension array
* Multi-dimension array
* Temp. Array
* Sort array
* Determine Array bound: lbound & hbound purpose
* When to utilize arrays
* Common errors & Mis-understanding
* Invalid index Range
* Purpose name as an array name
* Array reference in multiple data step, but define in only one

Lesson Nine: By group process

* Definitions for by-group process
* By group process
* By evaluation
* By grouping
* 1st variable & last variable
* Modify S.A.S. data sets: illustration.
* Invoking by group process
* Pre-process input data for by-group process
* Sort observation for by-group process
* Index for by-group process
* Identify data step by group
* Process observations by group
* How S.A.S. verify 1st.variable & last variable
* Process by-groups in the data steps
* Synopsis
* Process by-groups condition
* Data not in alphabetic or numeric order
* Data group by format evaluation

Lesson Ten: Synopsis of technique for uniting S.A.S. data set

* Meaning
* Concatenating
* Inter-leaving
* one-to-one Read or one-to-one integration
* Matching-merge
* Update
* Modify
* Definition for Read, Combine, & modify S.A.S. data sets
* Read a S.A.S. data set
* Combine S.A.S. data set
* Modify S.A.S. data set
* Synopsis of tool
* Read S.A.S. data sets
* Read a particular S.A.S. data set
* Read from various SAS data sets
* Combine SAS data sets: Fundamental idea
* One-to-many and many-to-one
* Many-to-many
* Access methodology: sequent vs direct
* Sequent entrance
* Direct entrance
* One-to-one Reading
* Data step process during a one-to-one Read
* one-to-one merge
* Matching Merge
* Updated with the modernize & the amended statement:
* Definitions
* Syntax of the update statement
* Syntax of the amend statement
* Update with no match clarification, misplaced evaluation, & new variable
* Usage of an index with the amend statement

Lesson Eleven: S.A.S. measures

* Intro
* Anatomy of a proc
* Proc statement
* Title & foot-note statements
* Statement
* Labeled statement
* Formatting statement
* Run or give up statement
* Description of data use in report
* S.A.S. report method
* Procs for every factor
* Use proc print
* Use proc S.Q.L
* Proc details
* Procs that sum up
* Use proc chart
* Use proc freq
* Use proc mean
* Use proc unvaried
* Intro to proc tabularize
* Data handling & mgmt process
* Proc kind
* Proc Data-sets
* Proc format
* Proc content
* Significant procs
* Proc transpose
* Meaning
* Proc printto
* Contrast practice
* Proc affix
* Import an excel file into S.A.S.

Lesson Twelve: Intro to proc S.Q.L.

* Intro
* Purpose to proc S.Q.L.?
* Select statement
* Select statement syntax
* Easy proc S.Q.L.
* Compound proc S.Q.L.
* Restrictive info on the choose
* Creat new variable
* Calculate selection on the select
* Using label & format
* Case appearance on the choice
* Additional select statement clause
* Re-merge
* Re-merge for total
* Calculate %
* Sort the data in proc S.Q.L.
* Sort on latest column
* Sub setting usage the where
* Incorrect where clause
* Compute column
* Selection on group column
* Use having clause
* Create latest table
* Joining dataset usage proc S.Q.L.
* Inner links
* Combining 3 or more table
* Outer links
* Include non-match row with the right outer links
* Select all row with the full outer links
* Concatenating query outcome

Lesson thirteen: An Intro to S.A.S. Macros

* Intro
* S.A.S Macro synopsis
* Traditional S.A.S. programming
* The SAS Macro language
* Macro language components
* Macro variable
* Macro statement
* Macro processor flow
* Automated Macro variable
* Macro debug option
* Macro?
* Meaning & usage Macros
* Position Macro parameter
* Keyword Macro parameter
* Conditional Macro collection
* The % do statement
* S.A.S. data step interface

Lesson Fourteen: O.D.S.

* Intro
* Create different kinds of report list output
* Other destination
* HTML
* P.D.F.& Postscripts
* R.T.F. file
* MS excel
* Adjoin style to your details
* Place exist style
* O.D.S. style= option
* Modify your details
* O.D.S. choose; & O.D.S. eliminate;
* Customization
* O.D.S. proclabel= ;
* O.D.S proctitle; & O.D.S noproctitle;
* Advance technique
* O.D.S. doc.
* Proc guide

Lesson fifteen: Intro to diagnose & avoid error

* Intro
* Understanding how the SAS supervisor checks a job
* Understanding how SAS processes errors
* Distinguishing types of errors .SAS recognizes four kinds of errors:
* Syntax errors
* Execution-time errors
* Data errors
* Semantic errors
* Diagnose errors
* Diagnose syntax errors
* Diagnose data errors
* Using a eminence manage checklist