GITS ACADEMY
#16, 3rd floor, 10th cross,Sampige Road
Above Vijaya Bank, Malleswaram, Bangalore=560003.
Contact: 080-23467842,+91-9900867154
Mail: info@[Link]
Web:[Link]
Course Topics
1) SAS/Base
2) SAS/ODS
3) SAS/ GRAPH
4) SAS/ SQL
5) SAS/ MACROS
6) SAS/ STAT
7) SAS/ACCESS
1) SAS/BASE
I. Introduction
• Introduction SAS.
• Log File
• Output File
• Work File
• Permanent SAS datasets
• Environments where SAS runs
• SAS System Options
• Step boundaries and run-group processing
II. Advanced Input Features
• Where is my raw data?
• INFILE
• DATALINES
• Input statement
• Column INPUT
• Formatted INPUT
• List INPUT
• MISSOVER, DLM
• Informats with list INPUT
• :
• &
• Advanced input pointers
• Formatted lists with pointers
• Reading multiple line input
• Multiple INPUT statements
• / and # pointers
• The trailing @
• The double trailing @@
III. DATA step functions
• Character functions (Left, Tranwrd, Index,Find,Trim,catx,
Compress, Put, Input, Scan, Substr, Upcase, Lowcase Etc.)
• Numaric functions (Int, ceil, floor, Round, Min, Max, sum,
mean).
• Date Function (Todat, Datetime, Date, Time, Timepart, Day,
Month, Year, Qtr).
• Arrays
IV. SAS Structures and Flow
• Input and output
• DATA step overview
• Compile processing
• DATA
• LENGTH
• FORMATS, INFORMATS, LABELS
• RENAME
• RETAIN
• DROP and KEEP
• If, If- then, Else-if, If then Do.
• Reading existing SAS datasets with SET
V. SAS Executable Statements
• Assignment statements
• Numeric-character conversion
• Character concatenation
• Accumulating totals
• RETAIN and SUM
• SUM statement
• SELECT statement
• Subsetting observations
• Deleting observations
• Subsetting IF statement
• WHERE statement
• OUTPUT
• PUT
VI. Procedures
• Proc Print
• Proc Contents
• Proc Sort
• Proc Means
• Proc Freq
• Proc Report
• Proc Tabulate
• Proc Printto
• Proc Transpose
• Proc Format
• Proc Import
• Proc Export
• Proc Append
• Proc Summary
VII. SAS Do-loops
• Syntax
• How to create Do loops.
• Conditional Do loops(DO until, DO while, by clause).
• Nesting DO loops.
VIII. Merging SAS Datasets
• Syntax
• One to one merges
• Match merging
• Multiple OBS with the same BY variable
• Merging with identical variable names
• Merging without a common variable
• Update statement
2. SAS/ODS
• ODS /Trace/Select/Exclude
• ODS /HTML FILE
• ODS/PDF FILE
• ODS/RTF FILE
• ODS REPORT WITH STYLE OPTION.
3. SAS/GRAPH
• Proc PLOT
• Proc GPLOT
• Proc CHART
• Proc GCHART
4. SAS/SQL
• SQL/CREATE TABLE
• SQL/ALTER
• SQL/DROP
• SQL/INSERT
• SQL/UPDATE
• SQL/SELECT
• SQL/DELETE
• SQL/WHERE
• SQL/OPERATORS
• SQL/JOIN
• SQL/UNION
• SQL/ORDER BY
• SQL/GROUP BY
5. SAS/MACROS
X. An Introduction to SAS Macros
• Functions of the SAS macro processor
• Defining and using a macro
• Macro processor flow
• Macro and macro variable
• Local and global macro
• Avoid macro errors
• Positional macro parameters
• Automatic macro variables
• Call Symput
• System options for debugging macro
6. SAS/STATISTICS
• Proc UNIVARIATE
• Proc MEANS
• Proc FREQ
• Proc GLM
• Proc RANK
• Proc ANOVA
• Proc REG
• Proc TTEST (Paired)
• Proc CORR (correlation)
7. SAS/ACCESS
• How to connect with data server
• Libname Code
• Sql Code