The course is designed to provide hand-on training on Base SAS programming, and help students to pass Base SAS programming Certificate exam.  Base SAS is the foundation for efficient programming using SAS language.  The scope of this course ranges from fundamentals of the SAS programming to report writing and data manipulation.



At the end of this course, students should be able to:

1.Understand the SAS fundamentals such variable types, naming conventions, etc.

2.Understand SAS programming environments, and difference in various SAS software versions.

3.Set up system options to customerize SAS programming environment.

4.Understand SAS programming process.

5.Detect various SAS programming errors, and make corrections accordingly.

6.Utilize temporary and permanent SAS datasets.

7.Utilize SAS formats, create and apply user-defined formats.

8.Create list and summary reports by using different reporting techniques.

9.Generate tabulation, plots and graphs

  1. Generate reports in different formats by using ODS.
  2. Create SAS datasets from raw data by using different approaches.
  3. Create and efficiently manage variables within Data Step.
  4. Combine SAS datasets through different techniques.
  5. Transform data with SAS functions.
  6. Efficiently utilize Do Loops and Array in Data Step programming.



  • No previous computer programming training/skills required
  • General typing skills
  • General understanding of the Windows operating system
  • Ability to use a text editor such as Notepad



The students are responsible for attending all classes.  Attendance will be taken — lateness and absences will be reflected in the student’s grade.If you have to miss a class, you must notify the instructor in person or via email the week before the class.

Classroom discussions are encouraged and the students are expected to make meaningful contributions to the discussions. The students are responsible for doing all assignments, including quiz, homework, and projects, and handing them in on time.

Exams must be taken at the given times including mid-term exam and final exam.  No make-up exams will be given. Special handicaps and/or needs can be accommodated, but the instructor must be notified at least one week in advance.

The student must behave in a mature manner at all times – unusual, disturbing or harassing behavior will not be tolerated. Such behavior will lead to ejection from class and possible further actions, including a requested withdrawal from class. Avtech Institute’s school policies must be followed at all times.



Base SAS Programming Class Notes, By John Ao, 5th Edition

The Little SAS Book, A Premier, By Lora D. Delwiche and Susan J. Slaughter



35 hours (9 am – 4:30 pm every Sunday, totally 5 weeks)



Attendance and Class Participation  40%

Homework/Quiz  40%

Mid-Term Exam  10%

Final  10%

Course Overview
SAS Fundamentals(I)
SAS Fundamentals(II)
Report Writing
Enhanced Report Writing
Descriptive Statistics
Using ODS facility
Create SAS dataset from raw data(I)
Midterm exam
Create SAS dataset from raw data(II)
Manage SAS data and variables
Combine SAS datasets


Using SAS functions
Final exam
Explanation of Midterm and Final exam
Manipulate data with Do Loops and Arrays
Teacher Evaluation by students

Note: For more detailed description of each chapter, Contact Us.


源于美国 始于1998 艾威(AVTECH)是北美著名的培训机构,总部位于美国新泽西州,2000 年进入中国,以培养国际化的中高端信息人才为己任,专注于国际前沿的新技术研发与教育,艾威主要的业务为培训与咨询两大类,目前培训的主要产品有:项目管理培训、IT 管理培训、IT 技术培训、云计算大数据培训、需求管理培训、产品管理培训,信息安全类,AI 人工智能等....近十类上几百门的课程的培训与咨询服务。
艾威(中国)秉承总部“诚信为本、品质为先”的理念,凭借美国艾威科学的课程体系和多年积累的丰富教学经验,结合中国本土企业文化、实际需求,为企业、个人提供定制化的培训解决方案。艾威进入中国这十八年来已经服务了超过 10000 多家客户,获得了良好的口碑!已被众多 500强企业纳入培训供应商,如 HP,NOKIA,CISCO,INTEL,GE,华为,宝马,德电,通用,大陆汽车,中国银行,交行,工行,罗氏,赛诺菲,埃森哲……等。
  • 艾威是 Prometric,VUE,PSI……等众多国际认证中心授权的考点
  • 艾威是PMI国际项目管理协会PMP、PGMP、PFMP、PMI-ACP、PMI-PBA授权培训机构
  • 艾威是IIBA(国际商业分析师行业协会)授权的EECBA、CCBA、CBAP、CDBA、IIBA-AAC、IIBA-CCA授权培训机构
  • 艾威是 IT 服务管理官方 EXIN 授权的 ITIL,ITIL EXPERT,Prince2,EXIN Agile Scrum Master 教育机构,同时也是此系列课程的认证考试中心。
  • 艾威是ISACA国际信息系统审计师行业协会授权的CISA、COBIT、CDPSE、CRISC、CISM认证培训考试机构。
  • 艾威是The Open Group 授权的 TOGAF 企业架构的官方培训机构。
  • 艾威是 EPI 授权的数据中心 CDCP 培训机构,华东地区唯一 CDCP 授权培训机构,同时也是 CDCP 认证考试考场。
  • 艾威是国际外包专业协会(IAOP)独家授权外包治理国际认证 SGF(Sourcing Governance Foundation)
  • 艾威是Peoplecert授权的ITIL、Prince2、MSP、P3O、MOP、DevOps、Alige Scrum Master认证培训考试机构