Statistical Analytical System

Reliable Technologies
In Janak Puri

Price on request
You can also call the Study Centre
98104... More
Compare this course with other similar courses
See all

Important information

  • Training
  • Janak puri
  • Duration:
    8 Weeks
Description

Important information
Venues

Where and when

Starts Location
On request
Janak Puri
B -55, Vikas Puri, Near Janak Puri West Metro Station New Delhi-110018, 110018, Delhi, India
See map

Course programme

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

Achievements for this centre


Compare this course with other similar courses
See all