Answer / 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

Answer / prasad

For SAS Clinical Programming the best point of contact is Mr.Prasad.Y with more than 7 years of SAS clinical Programming Experience. Of course, He is a bit costly, But you will get the extensive knowledge on SAS clinical Programming.
You can reach him on 8978784848.

Answer / nagamani

We learnt the SAS Clinical part from Mr.Kranthi for 45 days. After the training I got a job in Cognizant,Mumbai with 6 lakhs package. I suggest the students to approach Kranthi who will guide you in a proper way with a less fee.

Answer / kranthi

This is the answer for Satya venkata chinni us who asked my
qualification. I got trained from SAS Institute both
Advanced SAS and in BI tools and my qualification is M.Sc
and I did Post graduate diploma in Biostatistics and
Datamanagement from IIPH.
Mr. Satya, try to comment people after knowing them
properly. Dont' be stupid and know the spelling for foolish.

Answer / krishna

STANSYS SOFTWARE SOLUTIONS is best SAS training institute in
Hyderabad STANSYS means STATISTICAL ANALYSIS SYSTEM it’s
originated for complete SAS trainings.

How STANSYS is differ with others

 STANSYS has good domain expertise SAS certified working
professionals as trainers
 Trainers are available at lab also, and they can take care
of each student
 STANSYS is giving trainings on various domains like
CLINICAL/ BANKING/FINANCE/HEALTHCARE/TELECOM & RETAIL
 24/7 Lab facility with Lab Assistants
 Additional free classes on UNIX, SQL & Excel along with SAS
 2+1 month training (2months SAS Technology and 1 month
PROJECT on student required domains)
 Providing trainings according to Client requirement based
on market situation
 Conducting Mock interviews to identify knowledge of each
student and taking separate classes for technically poor
students
 Helping them to get the placements who proves in mock
interviews
 Giving support for each student upto getting the job and
Updating knowledge thru mails according to market situations
who are not available after trainings
 Giving trainings on
SAS/BASE
SAS/ADVANCED
SAS/DI
SAS/BI
SAS/ANALYTICS
SAS/ADMIN
SAS/RISK MANAGEMENT
SAS/Certification classes

For further details please visit www.stansys.co.in
or contact on]

STANSYS SOFTWARE SOLUTIONS
7-1-621/113(67/3RT),
Near Community Hall,
Beside Nagarjuna Jr.College,
S.R.Nagar,
040-42204449
8143408688
9542195422

Answer / varahakumar

Hi. my name is santosh. i am working with care clinicals,
new york, US. i was trained under the guidance of Mr. Varaha
Kumar. He will give u best training in SAS with real time
scenarios. you can contact him through mail:
varahakumar@yahoo.com or 9985224936

Answer / srinivas

STANSYS SOFTWARE SOLUTIONS
NEAR NAGARJUNA JUNIOR COLLEGE,
S R NAGAR, HYDERBAD-500 038,
PHONE 040-42204449.

Answer / trainer

I'am Ram and having 7+ years of real time experience on SAS
BI in multiple domains like General Insurance, Banking,
Human Resources and Health Care. I have completed SAS BI
Training from SAS Institute in 2004 from 9.1 to 9.2 and
Certified.

So far I have trained about 75 students from real time
exposure on base sas and freshers and have a good track
record of students getting selected for SAS BI Developer
role under my training and guidance.

Please find the course contents below:

******SAS Business Intelligence Platform Tools******
- SAS Enterprise Guide 4.1
- SAS Data Integration Studio(ETL) 3.4
- SAS Management Console
- SAS OLAP Cube Studio
- SAS Information Map Studio 3.1
- SAS Web Report Studio 3.1
- SAS Stored Process
- SAS OALP Cube Viewer
- SAS Add In for Microsoft Office

********Business Intelligence & DWH Concepts********
- Why Data Warehouses
- Steps to Design Datawarehouse
- Components of Data Warehousing
- Dimensional Data Modelling
* Star Schema Design
* Snowflake Schema Design
& Dimensions and Fact Tables
& Types of Fact Tables
& Slowly Changing Dimensions Type 1 to 3
& Degenerate Dimensions / Conformed Dimensions
- Why OLAP Reporting
- OLAP Cube Components / Types of OLAP Cubes

Additional Information:
- All the tools are covered with exercises and notes
- Each and every tool is given with presentation
- Class notes are handed over to you in hard copy
- Remote access to our server for working on the
tools
- Interview(discuss interview questions on SAS BI)
and Resume Guidance

Contact: Mr Ram on 8106883078 (1pm to 4pm)

Regards,
Ram

Answer / rahul

RAHULCSAS IS THE BEST CLINICAL SAS TRAINER
HE WILL YOU GUIDE PROPERLY

THEN do not search here and there Just contact him for

SAS training

contact No: 8885388091

Answer / raju

I think Sanctuary Biolabs is best in price and quality
wise..
even though its not reputed as others i found it best ..

data abc; input x y ; cards; 1 2 5 6 7 8 7 8 1 7 5 7 ; run; Proc Freq data=abc; tables x*y / chisq nopercent nocol norow PLCORR; RUN; If we run the code, we have Polychoric Correlation = 0.9054 in the last table. I want to extract this particular entry with the value. Means I will create one dataset in which this value will be stored/extracted. I need your help in coding this. Please help me out.

2 Answers  

how do you test for missing values? : Sas programming

0 Answers  

what are the differences between proc report and proc tabulate?

3 Answers  

HOW DO WE CREATE A SAS STORED PROCESS IN SAS EG ?

1 Answers   TCS,

explain about sas business intelligence? : Sas-bi

0 Answers  

6) Explain about below automatic variables a) _N_ b) _ERROR_ c) _CHAR_ d) _NUMERIC_ e) _ALL_ f) FIRST.BY VARIABLE g) LAST.BY VARIABLE h) _NAME_ i) _TYPE_ j) _FREQ_ k) _STAT_ l) _BREAK

1 Answers   IBM, SAS,

firstobs and obs are working only option wise,but we are using infile statement with firstobs and obs in a statement wise? so firstobs,obs working at options and statemnts or not?

1 Answers  

what is ae onset date n what is RDS

0 Answers   Accenture,

what is function of retain statment

0 Answers   PPD,

hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

0 Answers   Pfizer,

What is the length assigned to the target variable by the scan function?

0 Answers  

if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...

0 Answers   Accenture,