Answer Posted / mahesh

Hi This is Mahesh. I work for MNC and will give exposure to
live environment . Call me @ 9985052355 for any queries.

Here is the Content which I cover

Datawarehousing Concepts
• The Compelling Need for Data Warehousing
• Data Warehouse: The Building Blocks
• Trends in Data Warehousing
• Planning and Project Management of a
Datawarehousing Project
• Defining the Business Requirements
• The Architectural Components
• The Significant Role of Metadata
• Principles of Dimensional Modeling ( Star Schema,
Snowflake Schema, Fact Constellation)
• Dimensional Modeling: Advanced Topics
• OLAP in the Data Warehouse
• Data Warehousing and the Web
SAS Enterprise Guide
• Introduction on SAS EG Application.
• Customizing SAS Enterprise Guide options
• Setting up and managing profiles
• Importing files from sources other than SAS
• Accessing data via SAS libraries
• Grouping and summarizing data
• Introduction to querying data
• Filtering and sorting data
• Creating new columns with an expression
• Joining tables
• Grouping and summarizing data in a query (self-
study)
• Creating new columns by recoding values (self-study)
• Creating a frequency report
• Generating HTML, PDF, and RTF output
• Creating a listing report
• Creating a graph
• Creating Stored Process from SAS EG.
• Creating OLAP cubes from SAS EG.
• Working on different STATASTICAL Procedures

SAS/DI STUDIO (Data Integration Studio)
• Exploring SAS Data Integration Studio
• Working on Change Management
• Explaining how to define source, target data
structures and designing jobs.
• Introduction to jobs and the job editor
• Working with propagation and mappings
• Working with intermediate files
• Working with the extract transformation
• Working with summary statistics transformation
• Explore status handling for transformations and jobs
• Working with the data validation transformation
• Working with the sort transformation
• Working with the append transformation
• Working with the transpose transformation
• Working with the apply lookup standardization
transformation
• Iterating a job with Loop transformations
• Basics of the Table Loader transformation
• Load styles of the Table Loader transformation
• Table properties and load techniques of the Table
Loader transformation
• Introduction to change management and establishing
a change management environment.
• Defining slowly changing dimensions
• Using the SCD type 2 Loader and Change Data capture
transformations (Pre & Post Process).
• Analyzing metadata using impact analysis
• Deploying jobs for scheduling.
• Deploying jobs as Stored Process.
• Exporting and importing metadata
• Building an OLAP cube
• Building an information map
• Building the dimensions
• Building the fact tables.
• Creating and Exploiting OLAP Using the SAS System

SAS OLAP Cube Studio
• Introduction to Online Analytical Processing
• Overview of SAS OLAP Cube Studio
• Registering metadata
• Working with SAS OLAP Cubes Derived from Detail
Tables
• Creating a SAS OLAP Cube from a detail table
• Generating aggregations using cross- dimensional
tuning
• Setting permissions using SAS Management Console
• Viewing a SAS OLAP cube with SAS Enterprise Guide
• Working with SAS OLAP Cubes Derived from Star
Sachems
• Creating a SAS OLAP cube from a star schema
• Viewing a SAS OLAP cube with SAS Web OLAP Viewer
for JAVA
• Monitoring and Tuning a SAS OLAP Cube


SAS Web Report Studio
• Introduction on SAS Web Report Studio
• Calling Information Maps into WRS.
• Creating filters at WRS
• Creating Layouts for Reports.
• Creating Prompts.
• Customizable roles to authorize capabilities(From
SMC)
• Working on Report Creation and Templates.

SAS Information Delivery Portal
• Introduction to SAS IDP
• Adding a Portal page
• Adding Contents to Portlet.
• Adding portlets to page.
• Utilize SAS EG to create content and publish
packages to the framework
• Viewing and managing portal content.
• Portal Customization
• Call Reports from WRS to IDP.
• User level Authentication.
• Designing Portal
• Creating Dashboards.
• Calling STP into IDP.
• Cubes in PORTAL/
• Sharing portal content.

SAS Management Console
• User Creation and Permissions
• Creating Libraries
• Creating connections with Data Bases and SAS
Applications
• Creating Repository and creating Folders levels at
Repository
• Checking (TEST) connections for Different SAS
Servers.
• Creating Flows For Scheduling ,Creating Jobs with
dependencies and without Dependencies.
• Migration from Test Servers to Production servers.
• What is Metadata Tree and its Uses.
• Configuring Different Servers @SAS Management
Console.
• Explain The Structure at SERVER LEVEL and SMC LEVEL
(like Where the log files, Config Files, Batch Files,
executable files are stored For running different servers
successfully.)
• Brief Explanation about LSF and Process Managers
• Brief Explanation about WEB Servers like the
purpose of XYTHOS ,TOMCAT,Websphere.
• START and STOP Servers, Take Backups

SAS Information Map Studio
• Overview of SAS Information Maps
• Creating a Metadata Profile
• Creating a SAS Information Map
• Create a Relationship
• Create Folders
• Creating Data Items
• Creating Filters
• Save the Information Map
• Test the Information Map
• Using Information Map in SAS Web Report Studio,
Information Delivery Portal, Enterprise Guide
• Creating Information Maps from SAS OLAP Cubes.
SAS Web OLAP Viewer
• Opening OLAP Cubes, Information Maps(both from OLAP
Cubes and Tables)
• Conditional Highlighting
• Filtering, drilling down, Rolling up, slice and
dice capabilities

What is the difference between nodupkey and nodup options?

1044

---

Can you suggest us materials for sdtm mapping?

4452

---

What are the best sas programming practices for handling very large datasets? : sas-grid-administration

1021

---

what are some good sas programming practices for processing very large data sets? : Sas programming

939

---

what is null hypothesis? why do you consider that?

2909

---

Hello, I have PROC SQLs results group by 3 fields and I use SUM and COUNT functions in SQL. The problem is when I try to display my result with PROC TABULATE. I am getting very big numbers. I believe I make a mistake some where in Tabulate. Here is my Proc Tabulate. PROC TABULATE DATA=OUT04_05 FORMAT=12.; CLASS YR CENTRE VISA / PRELOADFMT EXCLUSIVE; VAR NEWUSER FRAUD TRANSFER AUTUSER REISSUE; TABLE CENTRE ALL, (YR ALL)*VISA, (NEWUSER*F=COMMA12. AUTUSER*F=COMMA12. FRAUD*F=COMMA12. TRANSFER*F=COMMA12. REISSUE*F=COMMA12.) / MISSTEXT={LABEL='0'} PRINTMISS RTS=20; FORMAT VISA VISAFMT.; KEYLABEL SUM = ' ' ALL = 'TOTAL'; LABEL YR = 'DATE YEAR' NEWUSER = 'TOTAL NEW ACCT' TRANSFER = 'TOTAL TRANSFER' FRAUD = 'TOTAL FRAUD TRANSFER' AUTUSER = 'TOTAL AUTH USERS' REISSUE = 'TOTAL REISSUE'; When I code it like : NEWUSER*N*F=COMMA12. AUTUSER*N*F=COMMA12. I get same amount numbers but to find a NEWUSER I use COUNT(*) and to find AUTUSER I use SUM(xxxx) function so both result shouldn’t be the same my problem is in this point. Could you tell me where the problem in code is. How can I display my result? TX.

2280

---

What are the five ways to do a table lookup in sas? : sas-grid-administration

1065

---

what is the difference between floor and ceil functions in sas? : Sas-administrator

1265

---

What is the difference between proportion and average?

3341

---

Do you know the features of sas?

1047

---

how do you pull data from equifax?tell me the process?

1808

---

For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration

1017

---

What are the default statistics that proc means produce?

1051

---

What is the function of Stop statement in a SAS Program?

1158

---

Describe the function and untility of the most difficult SAS macro that you have written.

2114

---