Best SAS Training in Gurgaon & Best SAS Training Institute in Gurgaon

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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
• 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

• 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

• 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
• 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

• 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

• Our SAS training in gurgaon adheres to international industry standards.
• We facilitate students with modern I.T infrastructure and learning environment during the SAS training in gurgaon.
• Trainers in SAS training classes combine the self-developed practice session module with current syllabus.
• Being responsible, we provide students SAS course with placement assistance.
• SAS training in gurgaon is conducted during weekdays and weekends as per participant's needs.
• Our SAS trainers are analysts, researchers, consultants and managers possessing a decade experience in coaching SAS course in gurgaon.
• Ultra-modern I.T laboratory equipped with latest infrastructure.
• Our lab is opened 365 days in a year. Students are facilitated with online mentoring during practice sessions.
• SAS training classrooms are equipped with projectors, live racks, Wi-Fi, and digital pads.
• We facilitate students with glass-door study room and discussion zone area (meeting room).
• No cost training sessions are conducted on personality development, spoken English, group discussion, and mock interview to sharpen the presentation skills.
• No cost SAS training course materials are provided.
• Study materials include books, and soft copies of tutorials in the form of PDFs, sample papers, technical and HR interview questions.
• We also provide hostel facility at Rs.4,500/- a month.
• Our certificates are globally recognized provided after completion of course.
• We facilitate students with Extra Time Slots (E.T.S) for doing unlimited practical at no cost..
• According to the requirements, students can retake the class at no cost.
• To enhance knowledge of the students, the complex technical concepts are imparted through easy coaching.
• We accept master and visa cards (Debit & Credit), also payment mode cash, cheque, and Net Banking available.

• Our trainers are subject specialist who have mastered on SAS technology.
• Our trainers are have received excellence awards for their dedicated SAS training and coaching.
• Our trainers are researchers, consultant, and analysts working as an employee in HCL Technologies, Birla-soft, TCS, IBM, Sapient, Agilent Technologies, and so on.
• Our trainers are single, double and triple certified professionals in the subject.
• Our trainers have regular coordination with MNCs HR team on daily basis.

• APTRON's Gurgaon division having successful 96% placement rate.
• APTRON’s SAS training centre in Gurgaon assist students in writing their resume meeting the current industry needs.
• APTRON’s SAS training institute in Gurgaon sharpens students’ interview skills, provide session on personality development, spoken English, group discussion, mock interview, and presentation.
• APTRON, the best SAS training institute in Gurgaon assists students in securing placement in top IT firms such as HCL, TCS, Infosys, Wipro, Accenture, etc., confidently.