Advanced SAS
Learn to program in SAS Language from the scratch, Base SAS Programming is awesome for Data Analytics & Data Science!
0+
Student Enrolled
0
Rating
100%
Skill Growth
What you'll learn
Learn Advanced SAS in the most effective way through interactive and engaging way with real time examples and case studies.
Analyze data with powerful SAS procedures that reveal amazing insights within your data
Learn to use the SQL in SAS with the help of SAS procedures (SAS SQL)
Learn Data Visualization & Data presentation in SAS
Learn to populate your SAS output/results in almost all the formats (.rtf, .word, pdf, excel etc.)
Learn Data statistical analysis
Strengthen your analytical skills and foundation to appear for SAS Advanced certification exams
Learn to use and build powerful SAS Macros to automate your jobs
Course Description
In this course, you will learn how to do coding/program in SAS Language for data handling, manipulation, data crunching, data cleansing, and data analysis. SAS language is very effective and efficient for data analytics, also SAS coding is really very easy to understand and learn since we don't need to write too much code to get great results!
People with SAS base knowledge or some experience in data, handling can enroll in this course. This course is for those who want to make their carrier in the domain of data analytics and can excel in the same domain.
To gain more from this course is to be committed to learning it and be enthusiastic to invest some hours in a week. I guarantee you that once you are done with this course, you will feel very confident and competent in data analytics.
Requirement
Course Curriculum
-
Everything From Base SASIntroduction to SQL and how to use SQL in SAS Preview12 minSQL queries12 minCreating, copying, altering, table12 minData handling with SQL12 minSELECT Clause: Assign Values Conditionally by Using a CASE Expression12 minSorting - ORDER BY12 minFinding and replacing Missing Values with COALESCE Function and Case Expression12 minSummarizing Data using aggregate functions12 minGroup by & Having Clause: Filter Grouped Data12 minUnion, Intersect & Except in SAS12 minIntroduction to Joins12 minSelf join in SAS12 minInner Join in SAS12 minLeft Join in SAS12 minRight Join in SAS12 minFull Join in SAS12 minCreating a Summary Report12 min
-
ReportsProc Means12 minProc Summary12 minDifference b/w proc means & proc summary12 minProc tabulate12 minProc Reports12 minTranspose12 minProc Freq12 minProc Univariate12 min
-
ODSIntroduction to Output Delivery System12 minExport SAS output to plain text12 minExport SAS output to delimited file12 minExport SAS output to Excel12 minExport SAS output to RTF/Word12 minExport SAS output to PDF12 min
-
Charts And GraphsIntroduction to Charts & Graphs in SAS12 minVertical Bar & 3D bar Graph12 minHorizontal Bar & 3D bar Graph12 minLine Graph or Chart12 minHistogram Chart12 minScatter Plot12 minPie and 3D Pie graph12 minStar Graph12 minDonut Graph11 min
-
SAS MacroSAS Macro overview and Introduction11 minAutomatic macro variables (System defined)11 minUser-Defined Macro Variables11 minUsing Macro Quoting Function to Mask Special Characters:%STR11 minDisplaying Macro Variable Values in the SAS Log: using %PUT11 minDisplaying Macro Variable Values in the SAS Log: using SYMBOLGEN11 minUsing Macro Functions to Manipulate Character Strings: %UPCASE11 minUsing Macro Functions to Manipulate Character Strings: %SUBSTR11 minUsing Macro Functions to Manipulate Character Strings: %SCAN11 minUsing %SYSFUNC function to execute other SAS functions11 minCreate multiple macro variables with SYMPUT and Indirect referencing with &&11 minObtaining Macro Variable Values during DATA Step Execution with SYMGET Function11 minNested macro variables and ampersand resolutions11 minCreating Macro Variables during PROC SQL Step Execution: INTO clause11 minCreating a series of related Macro Variables with the INTO Clause in Proc SQL11 minCreating one macro variable holding a Delimited List of Values with INTO clause11 minDeveloping and Debugging Macros with options: MPRINT, MLOGIC11 minUsing Macro Parameters: Positional Parameters11 minUsing Macro Parameters: Keyword Parameters11 minUsing Macro Parameters: Mixed Parameters11 minProcessing Statements Conditionally at the macro level: %IF%THEN%ELSE %DO%END11 min
Demo Certificate
Who will be your Mentor?
S M Ayetullah
Stats, SAS, Python, Database, Tableau, Power BI
0 Students
7 Courses
Experienced Senior Information Technology Consultant with a demonstrated history of working in Banking, Retail, Healthcare & Education industries. Skilled in Data Analytics, Project Management, Requirements Management, Scrum, Agile & IT Consulting.
Have 14 years of rich experience in the field of Data Analytics, Risk Analytics & IT Consulting.
Which have attained during my meticulous tenure with companies like - Bank Of America, UHG, WNS and Ministry of Commerce.
Have been working since completing my Engineering (Electronics & Telecommunication), B.Sc. (Math), PG (Statistics), MBA (IT & System Management).
Course FAQs
What is the validity of the course?
This course comes with lifetime validity.
11-month Program
This course comes with lifetime validity.
225+ hours of online learning content
This course comes with lifetime validity.
Dedicated career support through interview workshops
This course comes with lifetime validity.
Access to GL eXcelerate - curated jobs portal with Job opportunities shared by 350+ companies
This course comes with lifetime validity.
Individual doubt-solving with expert mentors
This course comes with lifetime validity.
17 real-world projects guided by industry experts
This course comes with lifetime validity.
Access to GL Confluence - Industry and Peer Networking Events
This course comes with lifetime validity.
Course Introduction
Course Introduction
