SAS Programmer Project

Summary:

SAS is a powerful system that helps companies to turn data into intelligent decision-making resourses, provide them with the means to access data no matter where it's stored, to analyze data to reveal trends, and to produce reports that drive decisions.

This course accesses all aspects of the SAS System: data access, data management, data analysis, data presentation, data warehousing, and applications development.

After this course, you will gain the hands-on experience to access data quickly and easily from many different sources such as Database Management Systems (DBMS), flat files, operating system-specific file structures, or other software products through the many tools that the SAS System provides. You will also learn how to create graphical reports or textual reports, and publish reports or create dynamic reporting applications by using the Web or an EIS. You will also use procedures to handle a wide range of statistical techniques including simple descriptive statistics, data visualization, analysis of variance, regression, categorical data analysis, multivariate analysis, cluster analysis, and nonparametric analysis.

• The SAS Language
  
• Syntax and naming conventions
  
• Data sets, variables and observations
  
• Programming logic
  
• Data library
  
• SAS data Sets
  
• The Two Parts of a SAS program
  
• The DATA Step's Built-in Loop
  
• Windows and Commands in the Programs
  
• Reading the SAS Log
  
• Using System Options

Unit 2: Getting Data into the SAS System

• Basic statements
  
• Methods for getting data into the SAS System
  
• Reading raw data
  --Hierarchical files and mixed records types
  --Packed-decimal data
  
• Mix input styles (column, formatted, pointer control)
  
• Random sample
  

Unit 3: Working with SAS Data Sets

• Creating and redefining variables (numeric, character, and date)
  
• SAS functions
• SAS date values
  
• Grouping observations
• Subsetting the data
  
• Informats
• Formats
  
• RETAIN
• Arrays
  Checking the structure and the attributes of SAS data set
  

• Modifying a data set using the SET statement
  
• Stacking and interleaving data sets
  
• One-to-one match merge
  
• One-to-many match merge
  
• Merging summary statistics with the original data
  
• Updating master data set with transactions
  
• Proc transpose
  
• Automatic variables
  

Unit 5: Debugging SAS Programs

• Data step debugger
  

• PUT statement

• Macro concepts
  
• Substituting text with Macro variables
  
• Creating Module Code with Macros
  
• Adding parameters
  
• Macros with conditional logic
  
• CALL SYMPUT
  
• Debugging Macro Errors
  

Unit 7: Using Utility, Reporting, and Basic Statistical Procedures

• Proc Sort
• Proc Print
  
• Proc Means
• Proc Freq
  
• Proc Tabulate
• Proc Report
  
• Proc SQL
• Proc Gchart
  
• Proc Format
• Proc Datasets
  
• Proc Tabulate
• Proc Rank
  
• Programming approach to write simple custom report
  
• Proc Univariate
• Proc Summary
  
• Proc Corr
• Analyst Application