Sasintroduction for beginners. Learn complete EXCELfrom scratch!

31 ratings, 5,347 students enrolled

Instructed by Abrar Hussain Development / Programming Languages

र 2345

Take this course

  • Lectures                     24
  • Video                         1 Hour
  • Skill Level                  Beginner Level
  • Languages                  English

Who should do this course?

Often people who are skilled with spreadsheets shy away from learning Visual Basic for Applications. Excel carries a lot of built-in functionality so they don’t feel the need to learn programming. In fact, there are a number of reasons to get comfortable with writing macros in Visual Basic for Applications (VBA).! – See more at: http://umeacademy.com/courses/sas-for-beginner/

What are the pre-requisites?

When you first learn Visual Basic for Applications, Excel built-in functions might seem like a faster way to do things. Puzzling out program structure and getting results to come out right takes longer than using quick and dirty shortcuts on the spreadsheet.! – See more at: http://umeacademy.com/courses/sas-for-beginner/

Course Description

Accessing Data

  • Use FORMATTED, LIST 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

Creating Data Structures

  • Create temporary and permanent SAS data sets
  • Create and manipulate SAS date values
  • Use DATA Step statements to export data to standard and comma delimited raw data files
  • Control which observations and variables in a SAS data set are processed and output

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

Generating Reports

  • Generate list reports using the PRINT and REPORT procedures
  • Generate summary reports and frequency tables using base SAS procedures
  • Enhance reports through the use of labels, SAS formats, user-defined formats, titles, footnotes and SAS System reporting options
  • Generate HTML reports using ODS statements
Handling Errors
  • Identify and resolve programming logic errors
  • Recognize and correct syntax errors
  • Examine and resolve data errors