Course Overview
What is SAS & Advanced Business Analytics?
SAS short for Statistical Analysis System (SAS) is a software suite developed by SAS Institute for Advanced Analytics. It was developed at North Carolina State University from 1966 until 1976, incorporated in the same year. It was further developed in 1980’s and 1990’s with the addition of new statistical procedures, JMP was introduced , and social media analytics was added in 2010. It is an integrated software system that performs data entry, retrieval, management, report writing, graphics design, business forcecasting,decision support, operations research , applications development and project management. Business Analysis refers to practice of iterative, methodic al exploring of organisation’s data with emphasis on statistical analysis. It is used by companies that do data-driven decision making.
About Advanced Business Analytics using SAS
The Advanced Business Analytics using SAS course is intended to provide conceptual and practical understanding of the topic. It enables learners to study about Macro Applications, Macro Variables, Macro-Putting Code, SAS Macro and comprehensive module on understanding SQL. The course contains 42 lectures and 8 hours of HD Video.
-
Introduction to Advanced SAS:
This section introduces advanced SAS to learners.
-
Macro Applications:
SAS Macros enable programmers to automate codes instead of writing the same set of codes every day. SAS Macros makes programming faster and easier. For eg. if a program needs to update current date, it can be programmed to accept system data thus doing away with writing same code every day.
-Why Macro- makes job easier – re-using similar code multiple times after defining it once, make changes in variables at single place, reflect them in multiple locations, make programs data driven. SAS program.- reducing the amount of text to be entered for common tasks. Perform repetitive tasks conditional execution of SAS code-based on type of data set or user requirements, packaging blocks of reusable SAS code for quick retrieval later.
– Developing Macro Applications- SAS programming –DATA Step contains tools for application development. User interaction- PUT/INPUT, WINDOW/DISPLAY statement. User Interaction- % PUT, %PUT output statements – interact with user in line mode- output to SAS Log. % WINDOW, % DISPLAY statements for windows display. Statement Style macros- eg. PROC MEANS DATA=&dsname. Integrate macros into SAS system. AUTOCALL facility- making a library of commonly used SAS macros. If Macro is in the library, SAS system reads it, compile and run it. Data driven macros- tools to facilitate data exchange between macro facility and SAS data sets.
-Macro Quoting- kinds of macro quoting- to generate fragments of SAS Code. Two kindsof quoting functions- %STR, %NRSTR. Debugging tools- SAS System options and statements-OPTIKONS Statement- MPRINT, SYMBOLGEN, MTRACE, %PUT Statement. System variables-&SYSDATE, &SYSTIME, &SYSDEVIC, &SYSDSN, &SYSMSG, &SYSMSG, &SYSERR, &SYSRC.
-Tokens-processes a program – word scanner to read the program. It reads character by character, groups of character into words. These words are called tokens. Literal, Name, Number, Special Character, maximum length of tokens 32,767 characters.
-
Macro Variables:
enables user to dynamically modify text in a SAS program by way of symbolic substitution- assigning text- to macro variables.- referencing variable to use text. Macro variables- max length 65,534 characters- only character data- evaluation as a number- independent of SAS Data set variables. User defined macro variables by programmer, automatic macro variables defined by macro processor. Macro Variable Examples, Macro Variables demo. Display of Macro Variable- %PUT statement,writes SAS to log. , %PUT Statement to view available macro variables.
Defining and calling macro: compiled programs that can be called in a submitted SAS program/SAS command prompt. Macro definitions,macros accept parameters, write generic macros for multi-use.%MACROMacro_name
<macro_text>
%MEND <macro_name).
-Submitting macro definition – compiling –session catalog-member- statements and text.
-
Macro Putting Code:
%PUT statement writes text or macro variable info to as log. – Displaying text,displaying automatic variables, displaying user generated variables,displaying local variables. SYNTAX, no argument,text,_ALL_, _AUTOMATIC_, _GLOBAL_, _LOCAL_, _USER_.
-Macro Programming- SAS macro language- statements, functions, automatic macro variables. Macro statements. Macro Statement- instructs macro processor to do an operation.- contains string of keywords, SAS names and special characters and operators.% Comment- designates comment text,%COPY- copies specified items from SAS Library. % DISPLAY- displays a macro window…. Statements that perform automatic evaluation,.
-Examples of macro programming.
-
SAS Macro:
-Positional Parameters- Parameter names one or more local macro variables based on user specified values when macro is invoked. Local parameters –parameter name. Parameter list can contain any number of macro parameters separated by commas. Parameter list- positional parameter-1>, Positional parameter-n>, <Keyword-Parameter+,value> <.., keyword-parameter-n+<value>>>. Positional parameter- specifies one or more positional parameters- in any order- listing in %MACRO Statement. KeyWord Parameter Value, options.
-Example of positional parameters- %macro print (var, sum);
proc print data =srhigh;
var &var;
sum & sum;
run;
%mend print;
-
Storing of macro variables:
Macro definition submission- macro processor compiles and stores in SAS catalog in the work library.- Session compiled macros- exist in current session .Autocall library,autocall facility. Compiled macros- SAS Catalog, saving and maintaining the source for macro definitions. Name style macros for efficiency. In UNIX-member name that contains autocall macro will be lower case.
-Creating and Updating Variables-invoking SAS, macro processor creates automatic macro variables- supplying information related to SAS session.- Automatic variables –global except SYSBUFF- local. Conditional logic- IF statement, %IF-%THEN%ELSE Statement. Read only status Defining macro variables- changing their values , defining scope. Creating macro variables- simplest way – use macro program statement %LET. %let dsname=Newdata. Character, numeric values, text. Macro variable reference.Macro variable references with text
-
SQL:
-SAS With SQL- Structured Query Language, for retrieving and updating data in databases, relational tables. SAS SQL- create tables, views, retrieve data in tables, SQL and SAS/ACCESS, add ,modify values in tables, add or modify values in SQL, SAS/ACCESS views.
-Understanding SQL procedure- INTO Clause, SELECT Statement – SAS macro variables. – multiple macro variables with a single INTO. INTO clause –scoping rules-%LET statement. Controlling Job Execution-
-How to use SQL in SAS.
-PROC SQL provides macro tools – stop execution of a job on error occurrence, execute programs conditionally.
-NOEXEC Key word- PROC SQL Query– check query without executing it. Verify syntax, existence of columns and tables- NOEXEC option in PROC SQL Statement, Validate Keyword before a SELECT statement. Examples of NOEXEC- specified in PROC SQL Statement. Showing error messages, SAS Checks syntax of queries in PROC SQL- NOEXEC. Validate Keyword before SELECT Statement,syntax. Valid queries, invalid queries. Differences between VALIDATE and NOEXEC.
-SQL Average Function: to find average of field in various records, average of various recors- GROUP BY. Examples..
-Minimum Function: aggregate function helps select the lowest (minimum) value for a certain column.
-Count Function: aggregate function used to count the number of rows in a database table.
-Executing Count Function
-
Group by Clause:
used in collaboration with SELECT statement to arrange identical data into groups. Follows the WHERE Clause in SELECT statement, Syntax, preceding ORDER clause.
-Executing Group and having clause
-Order by clause- SQL Order by Clause – sort data in ascending/descending order, one or more columns. Syntax, using more than one column in ORDER clause.
-Executing order by clause
-SubQuery
-Executing Subquery
-What are SQL joins:
used to combine records from two or more tables – it means combining fields from two tables by using values common to each. INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, SELF JOIN, CARTESIAN, SYNTEX
-Syntax for outer join
-Practical examples of joins
-Creating table in SQL:
naming the table, defining its columns and data type in columns, Examples of table creation- CREATE Table key word .
-Practical Example for creating table
-Inserting Data into table
-Practical Example for inserting data into table
-Practical example for deleting record from table
-Understanding SQL view-
SQL statement stored in database with an associated name. Table with a predefined SQL query.
-View – all rows or select from table, structure data that is intuitive, restrict access to data, summarize data.
-Practical Example for view.
-Techniques for programming efficiency
Requirements of Advanced Business Analytics using SAS:
The basic requirement is computer knowledge, database awareness and internet connectivity. Learners should have undergone Base SAS Training which is mandatory for getting certified in Advanced Business Analytics.
Why do Advanced Business Analytics Course
With the increasing use of business analytics in industry and efficacy of database systems, there are newer opportunities for SAS analyst, Lead analysts,Business Analyts, SAS Programmer, SAS Developer, SAS Programmer Analyst and so on.
Frequently Asked Questions (FAQ).
- What does a learner get by doing Advanced Business Analytics Course?
This is a comprehensive course that covers introduction to SAS, macro variables, SAS SQL and provides examples for creation of SAS Advanced programming syntax and exceptions.
- Do we get global certification in Advanced Business Analytics at the end of the course?
No,this provides a a comprehensive training that will equip learners to tackle the global certification exams in Advanced SAS.
- Is it easy for beginners to do the course?
No, preferably learners should have completed training in Base SAS to understand the advanced concetps in this course and appear for global certification.
- Who can join this course?
This course is open to students, professionals and anyone interested in a career in SAS.
- What if I don’t understand a section of the course?
You can interact with the course instructors and also go over the topics again to get a better understanding of difficult parts.
- Has this got any university recognition?
No, this is not affiliated to any university.
- Who gives certification on completion of Course?
EduCBA provides course completion certificates to all learners who complete the programme.
- What is the delivery mode of content?
It is a 100% online course and content is delivered through lectures and video.
- How many people are enrolled in this programme?
Thousands of learners all over the world have enrolled for EduCBA programs and the number keeps increasing.
- What are the payment options available for the course?
The payments section gives details of all the payment (credit card,net banking, debit cards etc).
Testimonials
Carlos J Sorto:
Changes in technology, growth of internet and streaming video all have combined to make learning a pleasurable experience outside of classroom, I laud the efforts of EduCBA in organizing several hundred courses across multiple topics and domains. The videos are of high quality and helps the learner grasp concept s easily. They are all structured in an easy to understand manner. I had undergone Base programming in SAS and was looking forward to a good course that is comprehensive enough to cover Advanced Business Analytics. That’s when I came across the EduCBA program on Advanced Business Analytics. . I look forward to appearing for global certification. All those who are keen on SAS should be learning this advanced course and it is sure to help them achieve success in their career.
William Allan Dare:
I am really happy to take the Advanced Business Analytics Course with SAS program. I initially thought it may be difficult to learn considering the complexities involved. I am thankful to EduCBA for structuring the program in an easy to understand manner. The inclusion of SQL in the program also makes it appealing to all database experts who need it to frame queries and get the right data from the database. I recommend this programme to students, professionals and even entrepreneurs who wish to take up good projects in business analytics and intelligence. The course covers both the conceptual part and practical side of SAS programming which is beneficial for analyst and programmers.
Mathew Foster:
Long ago professionals could go for reskilling only by attending short term courses in the early morning or evening sessions. That meant rushing to office or from office to catch the class. Now with e-learning, it is now possible to learn at our pace either at home or office. I am grateful to EduCBA for bringing large number of specialized courses within easy access to global learners. I am happy to have undergone the Advance Business Analytics with SAS course after doing my Base SAS. Being involved in business analytics and relational databases,I found the content appealing and is sure to take my career graph further upwards.
Where do our learners come from? |
Professionals from around the world have benefited from eduCBA’s SAS & Advanced Business Analytics Training Courses. Some of the top places that our learners come from include New York, Dubai, San Francisco, Bay Area, New Jersey, Houston, Seattle, Toronto, London, Berlin, UAE, Chicago, UK, Hong Kong, Singapore, Australia, New Zealand, India, Bangalore, New Delhi, Mumbai, Pune, Kolkata, Hyderabad and Gurgaon among many. |