Building Stored Processes
Create a stored process from a SAS Enterprise Guide ProjectCreate a stored process from a SAS ProgramAdd prompts to a stored processCreate a stored process to provide a dynamic data sourceDefine the macro variables generated for each prompt type

SAS BUSINESS INTELLIGENCE OVERVIEW

SAS Business intelligence has analytical capabilities like statistics, reporting, data mining, predictions, forecasting and optimization. They help in getting data in the format desired. It helps in improving quality of data.

SAS has developed end to end business intelligence solution named as SAS Enterprise Intelligence Platform. It enables the users to extract and transform enterprise wide data into fully integrated reporting warehouse, leading to more usable business data and more effective decision making.With the way; the platform is structured and the way metadata (The metadata is explored in details at the below sections) is handled; it becomes feasible to represent the single version of truth to the intended users.

SAS stores the data only once which and shares its metadata across all the applications dealing with that data which might be ETL tool trying to update that data or data mining tool trying to dig out that data for some ad-hoc queries or might be reporting tool producing monthly report for the business.

SAS is platform designed for Business intelligence solution.It has got different parts or tiers. The metadata sits alongside these tiers and works as glue to stick all these layers together. There are 4 different tiers; Data tier, Server tier, Client and Web tier.

All tiers can have been installed on the same machine or might be on different machines; however it is common practise to have server tier and web tier on one machine and data tier and client tier on different machines.

SAS application server is a way of grouping together different logical servers.A logical server is nothing but a group of one or more servers. Might be a group of logical workspace servers; a group of many workspace servers.Or a logical stored process servers etc.On SAS Application servers these different types of logical servers are usually grouped together. Different logical servers taking part to form SAS application server are SAS Work space servers, SAS Stored process servers, SAS OLAP Server, SAS Grid Server, SAS Batch Server and SAS/Connect Server.