10 Small Business Bookkeeping Tips
November 29, 2023
Article
Grow Your Career with a SAS® Credential. Master the skills required for the SAS® Advanced Programming Professional certification.
Instructors: Peter Styliadis
9,587 already enrolled
Included with
(334 reviews)
Recommended experience
Intermediate level
Prior SAS programming knowledge is required, which can be acquired by completing the SAS Base Programmer Professional Certificate program.
(334 reviews)
Recommended experience
Intermediate level
Prior SAS programming knowledge is required, which can be acquired by completing the SAS Base Programmer Professional Certificate program.
Process data using Structured Query Language in the SAS environment
Use the SAS macro facility to design, write, and debug dynamic macro programs
Use advanced DATA step techniques and procedures to manipulate data
Add to your LinkedIn profile
When you complete this professional certificate program, you will have experience in SAS programming using SAS 9 and will be able to process data using Structured Query Language in the SAS environment, use the SAS macro facility to design, write, and debug dynamic macro programs, and use advanced DATA step techniques and procedures to manipulate data. These skills prepare you for the SAS Advanced Programming Professional certification exam.
Applied Learning Project
Two projects are included as honors lessons in this professional certificate program. Each project will demonstrate your comprehensive knowledge of the learned SAS programming skills. In the first project, you use SQL to analyze to analyze passenger claims at United States airports. In the second project, you use the SAS macro language to automate reporting and analysis of analysis of supplier sales.
Course Description
In this course, you learn about Structured Query Language (SQL) and how it can be used in SAS programs to create reports and query your data. “By the end of this course, a learner will be able to…” ● Query and subset data. ● Summarize and present data. ● Combine tables using joins and set operators. ● Create and modify tables and views. ● Create data-driven macro variables using a query. ● Access DBMS data with SAS/ACCESS technology.
In this course, you learn advanced techniques within the DATA step and procedures to manipulate data.
Course Learning Objectives: (3+ per course) “By the end of this course, a learner will be able to…” ● Perform text substitution in SAS code. ● Use macro variables and macro functions. ● Automate and customize the production of SAS code. ● Conditionally or iteratively construct SAS code. ● Write self-modifying, data-driven programs.
In this course, you learn advanced techniques within the DATA step and procedures to manipulate data.
“By the end of this course, a learner will be able to…” ● Use additional functions (LAG, FINDC/FINDW, and COUNT/COUNTC/COUNTW). ● Perform pattern matching using PRX functions. ● Process repetitive code, rotate data, and perform table lookups using arrays. ● Perform table lookups and sort data using hash and hash iterator objects. ● Create numeric templates using the FORMAT procedure. ● Create custom functions using the FCMP procedure.
Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.
When you complete this Professional Certificate, you may be able to have your learning recognized for credit if you are admitted and enroll in one of the following online degree programs.¹
When you complete this Professional Certificate, you may be able to have your learning recognized for credit if you are admitted and enroll in one of the following online degree programs.¹
Illinois Tech
Degree
¹Successful application and enrollment are required. Eligibility requirements apply. Each institution determines the number of credits recognized by completing this content that may count towards degree requirements, considering any existing credits you may have. Click on a specific course for more information.
This Professional Certificate has ACE® recommendation. It is eligible for college credit at participating U.S. colleges and universities. Note: The decision to accept specific credit recommendations is up to each institution.
Through innovative software and services, SAS empowers and inspires customers around the world to transform data into intelligence. SAS is a trusted analytics powerhouse for organizations seeking immediate value from their data. A deep bench of analytics solutions and broad industry knowledge keep our customers coming back and feeling confident. With SAS®, you can discover insights from your data and make sense of it all. Identify what’s working and fix what isn’t. Make more intelligent decisions. And drive relevant change.
Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription
Earn a degree from world-class universities - 100% online
Upskill your employees to excel in the digital economy
Prior SAS programming knowledge is required, which can be acquired by completing the SAS Programming specialization.
We recommend you take them in this order:
Structured Query Language (SQL) Using SAS
SAS Macro Language
Advanced SAS Programming Techniques
You will have completed the course work to prepare you for the SAS Advanced Programming Professional certification.
This course is completely online, so there’s no need to show up to a classroom in person. You can access your lectures, readings and assignments anytime and anywhere via the web or your mobile device.
If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.
Yes! To get started, click the course card that interests you and enroll. You can enroll and complete the course to earn a shareable certificate, or you can audit it to view the course materials for free. When you subscribe to a course that is part of a Certificate, you’re automatically subscribed to the full Certificate. Visit your learner dashboard to track your progress.
¹ Median salary and job opening data are sourced from Lightcast™ Job Postings Report. Content Creator, Machine Learning Engineer and Salesforce Development Representative (1/1/2024 - 12/31/2024) All other job roles (3/1/2024 - 3/1/2025)