Add to basket or enquire
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
-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;
sum & sum;
- 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
-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
Who is this course for?
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).
Questions and answers
No questions or answers found containing ''.
for the exam Exam 70-463 is there any other fee ? diferentes steps to enquire and start the corse thank you
Hello Brahim, We don't fully understand what you're looking for? We have no courses related to 'exam Exam 70-463" ThanksThis was helpful. Thank you for your feedback.
I want to prepare the certification ( Exam 70-463) as soon as possible how does'it work ? it cost only £29 no other fee ?thank you
Please elaborate your query also we do not have curses n Exam 70-463 ThanksThis was helpful. Thank you for your feedback.
Currently there are no reviews for this course. Be the first to leave a review.