SAS Programming  Training

             SAS Names , SAS Data Sets and SAS Data Types , SAS Programs, Components of SAS Programs, Characteristics of SAS ProgramsLayout for SAS Programs, Processing SAS Programs, Log Messages Results of Processing, SAS Libraries, How SAS Files Are Stored Storing Files Temporarily or Permanently, Referencing SAS Files  Two-Level  Names  Referencing  Temporary SAS Files.

SAS Programs, Components of SAS Programs, Characteristics of SAS Programs, Layout for SAS Programs, Processing SAS Programs, Log Messages, Results of Processing, SAS Libraries, How SAS Files Are Stored, Storing Files Temporarily or Permanently, Referencing SAS Files, Two-Level Names, Referencing Temporary SAS Files , Referencing Permanent SAS Files ,Rules for SAS Names, SAS Data Sets, Overview of Data Sets, Descriptor Portion, Data Portion, Observations  , Variables  , Variable Attributes, Missing Values, Attrib, Name ,Type, Length, Format, In format, Label

Formats and In formats

Definition of Formats& In formats, Syntax, Using Formats, Formats by Category
 

Accessing Data

               Use FORMATTED, LIST, MODIFIED LIST INPUT ,MIXED INPUT NAMED AND COLUMN 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 ,Combine SAS data sets using the DATA step
  Option in SAS

System options , Data Options

SAS Functions

 Using Functions, Functions by Category,
 Working with Dates ,Working with Numeric Functions
 Working with Character Functions

SUB SETTING and Combining SAS DATA SETS,

            Introduction , Subsetting a SAS Data Sets using operators (Arithmetic Logical and Comparison), Creating More Than One Subset Data Set in One DATA Step , Adding Observations to a SAS Data Set , Interleaving Data Sets , Combining Detail and Summary Data , Merging Two Data Sets , Omitting the BY Statement in a Merge ,Controlling Observations in a Merged Data Set , IN= Variables , Merging Two Data Sets with Different BY Variable Names , Merging Two Data Sets with Different BY Variable Data Types ,One-to-One, One-to-Many, and Many-to-Many Merges , Updating a Master File from a Transaction File
 

Managing Data

              Investigate SAS data libraries using base SAS utility procedures ,Sort observations in a SAS data set ,Conditionally execute SAS statements ,Use assignment statements in the DATA step ,Modify variable attributes using options and statements in the DATA step Accumulate sub-totals and totals using DATA step statements ,Use SAS functions to manipulate character data, numeric data, and SAS date values ,Use SAS functions to convert character data to numeric and vice versa ,Process data using DO LOOPS ,Process data using SAS arrays
 

Handling Errors

 Identify and resolve programming logic errors , Recognize and correct syntax errors , Examine and resolve data errors
 

SAS Procedures

 PROC Print, PROC Format, PROC Sort, PROC Contents, PROC
 Import, PROC Append, PROC Rename, PROC Summary, PROC
 Compare, PROC Report,PROC Tabulate, PROC Printto, PROC
 Chart, PROC Plot, PROC Transpose, PROC Rank,PROC Import ,
 PROC Export, PROC Options, PROC Copy
 
 

SAS Macros 

              Substituting Text with Macro Variables , Creating Modular Code with Macros, Adding Parameters to Macros , Writing Macros with Conditional Logic , Automatic Macro Variables, SAS Macro Variables, Macro Processing , Writing Data-Driven Programs with CALL SYMPUT and SYMGET, Macro Functions, Debugging Macro Errors
 Enhancing Your Output With ODS
 Concepts of the Output Delivery System , Tracing and Selecting Procedure Output , Creating SAS Data Sets from Procedure Output , Using ODS Statements to Create HTML Output , Using ODS Statements to Create RTF Output , Using ODS Statements to Create PRINTER Output , Customizing Titles and Footnotes , Customizing PROC PRINT Output with the STYLE= Option , Customizing PROC REPORT Output with the STYLE= Option , Customizing PROC TABULATE Output with the STYLE= Option , Adding Traffic-Lighting to Your Output , Selected Style Attributes                                 
  

SAS / STAT

               SAS/STAT software provides extensive statistical capabilities, with tools for both specialized and enterprise-wide analytical,needs. Ready-to-use procedures handle a wide range of Statistical
 analyses, including analysis of variance, regression, categorical, data analysis, Multivariate analysis, survival analysis, psychometric, analysis, cluster analysis, and Nonparametric analysis. SAS / STAT , includes techniques for scoring, linear and nonlinear transformations
 of variables, and multiple testing

SAS / GRAPH

               SAS / GRAPH software provides capabilities to produce a wide variety of business and scientific charts, plots, and maps in many colors and patterns, SAS/GRAPH software enables you to summarize your data and present your summary using vertical and horizontal bar, pie, donut, sub grouped pie and donut, star, and block charts
 SAS/GRAPH software can also generate scatter, line, area, bubble, multiple axis, and overlay plots, as well as choropleth, prism, block, and surface maps
 Capabilities for graphics editing, image capture and playback, video playback, and batch processing of high-volume graphics
  

 SAS SQL

What Is SQL, What Is the SQL Procedure,  Terminology, Comparing,  PROC SQL with the SAS DATA Step, Retrieving Data from a Single Table Retrieving Data from Multiple Tables, Creating and Updating Tables
and Views, Programming with the SQL Procedure, Practical , Problem-Solving with PROC SQL.

SAS / ACCESS

Accessing data in a relational database or Microsoft Excel workbook SAS/ACCESS LIBNAME statement , SQL pass-through facility ,Passing queries to a DBMS , Passing non-queries to the DBMS ,SAS/ACCESS LIBNAME engines (like Oracle , Teradata and SQL Server), Joining tables ,Importing and exporting PC file data ,Creating and updating SAS/ACCESS access and view descriptors , CV2VIEW procedure