Best SAS Training in Pune India
Corporate Training & Class room Training
Duration of Training: 4 days.
Advantages of using SAS
Major components of SAS suite
2. Accessing Data in SAS
Use COLUMN, FORMATTED and LIST input to read raw data files.
Use INFILE statement options to control processing when reading raw data files.
Use various components of an INPUT statement to process raw data files including column and line pointer controls, and trailing @ controls.
SAS libraries: Creating temporary and permanant libraries
Options to read raw data: Missover,Truncover,Stopover,Flowover,DSD,DLM
3. Behind the scene
SAS DATA Step Processing – Compilation Phase and Execution Phase
Program Data Vector (PDV)
SAS dataset: data and descriptor portions
Understanding how SAS files are stored
4. SAS statements
Differences between system options, data set options and statement options
Informats, Formats, Attrib, Datalines, Delete, Drop, Keep, Label, Length, Retain, Sum, Dim
5. SAS Options
Data set options: KEEP, DROP, RENAME, FIRSTOBS, OBS, IN, LABEL, WHERE
SAS System Options – OBS, FIRSTOBS, BUFNO, BUFSIZE, LINESIZE,PAGESIZE, NODATE, YEARCUTOFF
6. SAS Functions
INPUT and PUT
Functions for Date and Time – MONTH, YEAR, DAY, MDY, DATE, TODAY, DATETIME
Other SAS functions – SCAN, SUBSTR, TRIM, LEFT, RIGHT, INDEX, UPCASE, LOWCASE, MEAN, COMPRESS, LENGTH
Creating variables using Arrays
Assigning Initial Values to Arrays
8. Conditional Processing
Nesting of the DO Loop
DO UNTIL statement
DO WHILE statement
9. Connecting to outside world
FTP thru SAS
Connect to different servers (SQL server etc)
Export data to create standard and comma-delimited raw data files.
10. Merging & Appending Data
SET and MERGE Statements
MODIFY and UPDATE Statements
WHERE Statement and differences with IF
RETAIN and RETURN Statements
11. Analysis and report generation: SAS Procedures
Proc Print, Proc Sort, Proc Means and Proc Contents
Enhance reports through the use of user-defined formats, titles, footnotes
12. SAS Macros
Storing SAS Macros
Defining and Calling Macros
Referencing Macro Variables
Macro Quoting Technique
Macro Debugging Technique
13. Error Handling
Identify and resolve programming logic errors.
Recognize and correct syntax errors.
We are glad that you preferred to contact us. Please fill our short form and one of our friendly team members will contact you back.