SaS Training in Pune & Base SAS Certification Training Institute in Pune

SAS Course Content

introduction to SAS

• introduction
• need for SAS
• who uses SAS
• what is SAS?
• overview of base SAS software
• data management facility
• structure of SAS dataset
• SAS program
• programming language
• elements of the SAS language
• rules for SAS statements
• rules for most SAS names
• special rules for variable names
• types of variables
• data analysis and reporting utilities
• traditional output
• ways to run SAS programs
• SAS windowing environment
• noninteractive mode
• batch mode
• interactive line mode
• running programs in the SAS windowing environment

how SAS works

• writing your first SAS program
• a simple program to read raw data and produce a report
• enhancing the program
• more on comment statements
• internal processing in SAS
• how SAS works
• the compilation phase
• the execution phase
• processing a data step a walkthrough
• creating the input buffer and the program data vector
• writing an observation to the SAS data set
• four types of SAS libraries
• SAS libraries
• work library
• SAShelp library
• SASuser library

reading raw data into SAS

• what is raw data
• definitions
• data values
• numeric value
• character value
• standard data
• nonstandard data
• numeric data
• character data
• choosing an input style
• list input
• modified list input
• column input
• formatted input
• named input
• instream data
• creating multiple records from single input row
• reading data from external files
• reading blank separated values (list or free form data)
• reading raw data separated by commas (.csv files)
• reading in raw data separated by tabs (.txt files)
• using informats with list input
• supplying an informat statement with list input
• using list input with embedded delimiters
• reading raw data that are aligned in columns
• method 1 column input
• method 2 formatted input
• using more than one input statement the single trailing @
• reading column data that is on more than one line
• mixed-style input
• infile options for special situations
• flowover
• missover
• truncover
• pad
• using lrecl to read very long lines of raw data
• checking your data after it has been read into SAS

reading data from a dataset

• introduction
• set statement overview
• automatic variables in SAS
• interleave multiple SAS data sets
• combine multiple SAS data sets
• creating & modifying variables
• creating multiple datasets in a single data-step
• subsetting observations
• conditional SAS statements
• logical and special operators
• the SAS supervisor and the set statement
• efficiency and the set statement
• know your data
• set statement data set options
• drop and keep options
• rename option
• firstobs and obs options
• in option -
• where option -
• other set statement options
• end option
• key option
• nobs option
• point option
• do loops and the set statement
• introduction to retain statement
• carry over values from one observation to another
• compare values across observations
• assign initial values
• determining column order in output dataset
• SAS system options

reading 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
• subsetting records from an external file with a subsetting if statement
• subsetting observations in a data step with a where statement
• subsetting observations in a proc step with a where statement
• subsetting observations in proc sql
• difference between if and where

SAS informats and formats

• overview
• using SAS informats
• input statement
• input function
• inputn and inputc functions
• attrib and informat statements
• using SAS formats
• format statement in procedures
• put statement
• put function
• putn and putc functions
• bestw. Format
• additional comments

SAS functions

• categories of functions
• SAS character functions
• functions that change the case of characters
• upcase
• lowcase
• propcase
• functions that remove characters from strings
• function compbl
• function compress
• functions that search for characters
• function anyalnum
• function anyalpha
• function anydigit
• function anypunct
• function anyspace
• function notalnum
• function notalpha
• function notdigit
• function notupper
• functions that search strings
• find and findc
• index, indexc, and indexw
• functions to verify data
• function verify
• functions that extract parts of strings
• function substr (on the left-hand side of the equal sign)
• function substrn
• functions that join two or more strings together
• function cat
• function cats
• function catt
• function catx
• functions that remove blanks from strings
• function left
• function right
• function trim
• function trimn
• function strip
• functions that compare strings
• function compare
• functions that divide strings into "words"
• function scan
• function scanq
• functions that substitute letters or words in strings
• function translate
• function tranwrd
• functions that compute the length of strings
• function length
• function lengthc
• function lengthm
• function lengthn
• functions that count the number of letters or substrings in a string
• function count
• function countc
• miscellaneous string functions
• function missing
• function repeat
• function reverse
• SAS date and time functions
• introduction
• what is a SAS date and time literal?
• date and time functions
• functins to create date and time values
• functions to takie datetime values apart
• functions to get quarter ,year or day of the date
• functions that work with intervals
• using formats for date and time
• system options fordate and time

an introduction to arrays and array processing

• why do we need arrays?
• basic array concepts
• array statement
• array references
• variable name array reference
• using array indexes
• one dimension arrays
• multi-dimension arrays
• temporary arrays
• sorting arrays
• determining array bounds lbound and hbound functions
• when to use arrays
• common errors and misunderstandings
• invalid index range
• function name as an array name
• array referenced in multiple data steps, but defined in only one

by - group processing

• definitions for by-group processing
• by-group processing
• by value
• by group
• first.variable and last.variable
• modifying SAS data sets examples.
• invoking by-group processing
• preprocessing input data for by-group processing
• sorting observations for by-group processing
• indexing for by-group processing
• how the data step identifies by groups
• processing observations in a by group
• how SAS determines first.variable and last.variable
• processing by-groups in the data step
• overview
• processing by-groups conditionally
• data not in alphabetic or numeric order
• data grouped by formatted values

overview of methods for combining SAS data sets

• definitions
• concatenating
• interleaving
• one-to- one reading or one-to-one merging
• match-merging
• updating
• modifying
• definitions for reading, combining, and modifying SAS data sets
• reading a SAS data set
• combining SAS data sets
• modifying SAS data sets
• overview of tools
• reading SAS data sets
• reading a single SAS data set
• reading from multiple SAS data sets
• combining SAS data sets basic concepts
• one-to-one
• one-to-many and many-to-one
• many-to-many
• access methods sequential versus direct
• sequential access
• direct access
• one-to-one reading
• data step processing during a one-to-one reading
• one-to-one merging
• match-merging
• updating with the update and the modify statements
• definitions
• syntax of the update statement
• syntax of the modify statement -
• updating with nonmatched observations, missing values, and new variables -
• using an index with the modify statement

SAS procedures

• introduction
• the anatomy of a proc
• the proc statement
• title and footnote statements
• by statement
• label statement
• format statement
• run or quit statement
• description of data used in reports
• SAS reporting procedures
• procs for all that detail
• using proc print
• using proc sql
• proc report
• procs that summarize
• using proc chart
• using proc freq
• using proc means
• using proc univariate
• introduction to proc tabulate
• data manipulation and management procedure
• proc sort
• proc datasets
• proc format
• proc contents
• other important procs
• proc transpose
• definitions
• proc printto
• compare procedure
• proc append
• how to import an excel file into SAS

introduction to proc sql

• introduction
• why learn proc sql?
• select statement
• the select statement syntax
• a simple proc sql
• a complex proc sql
• limiting information on the select
• creating new variables
• the calculated option on the select
• using labels and formats
• the case expression on the select
• additional select statement clauses
• remerging
• remerging for totals
• calculating percentage
• sorting the data in proc sql
• sort on new column
• subsetting using the where
• incorrect where clause
• where on computed column
• selection on group column
• use having clause
• creating new tables
• joining datasets using proc sql
• inner join
• joining three or more tables
• outer joins
• including nonmatching rows with the right outer join
• selecting all rows with the full outer join
• concatenating query results

an introduction to SAS macros

• introduction
• SAS macro overview
• traditional SAS programming
• the SAS macro language
• macro language components
• macro variables
• macro statements
• macro processor flow
• automatic macro variables
• macro debugging options
• what is a macro?
• defining and using macros
• positional macro parameters
• keyword macro parameters
• conditional macro compilation
• the %do statement
• SAS data step interfaces

the output delivery system (ods)

• introduction
• creating various types of reports listing output
• other destinations
• html
• pdf and postscript
• rtf files
• microsoft excel
• adding style to your reports
• locate existing styles
• ods style= option
• customize your reports
• ods select; and ods exclude;
• other customizations
• ods proclabel= ;
• ods proctitle; and ods noproctitle;
• advanced techniques
• ods document
• proc template

introduction to diagnosing and avoiding errors

• introduction
• 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
• diagnosing errors
• diagnosing syntax errors
• diagnosing data errors
• using a quality control checklist

advance topics in SAS

• performing advanced queries using proc sql
• introducing macro variables
• creating and using macro programs
• storing macro programs
• creating samples and indexes
• using lookup tables to match data
• modifying SAS data sets and tracking changes
• introduction to efficient SAS programming

SaS training duration in Pune

Regular Classes( Morning, Day time & Evening)

• Duration : 4 weeks

Weekend Training Classes( Saturday, Sunday & Holidays)

• Duration : 5 Weeks

Fast Track Training Program( 2+ hours classes daily)

• Duration : within 2 weeks

SaS trainer Profile & Placement

Our SaS Trainers

• More than 8 Years of experience in SaS Technologies
• Has worked on 8 realtime SaS projects
• Working in a MNC company in Pune
• Trained 166+ Students so far.
• Strong Theoretical & Practical Knowledge
• SaS certified Professionals

SaS (sas bi clinical di studio programming) Placement Training in Pune

• More than 166+ students Trained
• 97 percent Placement Record
• 83 Interviews Organized
• Placement Supported by InterviewDesk.com

SaS training Locations in Pune

Our SAS BI/Clinical Research/DI Studio Training centers

• Aundh
• Baner Road
• Camp
• Chinchwad
• Deccan Gymkhana
• Karve Road
• Kothrud
• NIBM ROAD
• Pimpri Colony
• Sadashiv Peth
• Shivaji Nagar
• Yerwada

SaS training batch size in Pune

Regular Batch ( Morning, Day time & Evening)

• Seats Available : 4 (maximum)

Weekend Training Batch( Saturday, Sunday & Holidays)

• Seats Available : 6 (maximum)

Fast Track batch

• Seats Available : 3 (maximum)

SaS related training courses

• Base SAS Training in Pune with placement support