Hi,
Greetings from Stansys Software Solutions,
Stansys Software Solutions is a premier IT training, Consulting and Development Company located at Hyderabad (S.R.Nagar, Kukatpally & Nallkunta), India. STANSYS means STATISTICAL ANALYSIS SYSTEM it’s originated for complete SAS trainings solutions with consulting and outsourcing.
We provide excellent quality Classroom Trainings, Corporate Trainings and online trainings on various SAS modules like SAS/BASE, SAS/ADVANCED, SAS/DI, SAS/BI, SAS/ANALYTICS, SAS/FORECASTING, SAS/ADMIN etc...
We are teaching SAS in different domains with domain specific faculties like
CLINICAL/HEALTHCARE/BANKING/FINANANCE/insurance/RETAIL&TELECOM
domains with real time projects and placements
COURSE CONTENTS
SAS-9.2 (Clinical/Healthcare/Life science) Domains
SAS/BASE
SAS/EG (ENTERPRISE GUIDE)
SAS/ACCESS
SAS/MACROS
SAS/CONNECT
SAS/DDE & AUTOMATION
SAS/STAT
SAS/GRAPHS
SAS/ODS
SAS/SQL
SAS/certification CLASSES
excel, ADVANCED EXCEL
UNIX
ORACLE (SQL)
1 MONTH CLINICAL DOMAIN TRAINING
PROTOCOL(CLINICAL ORG)
ICH-GCP GUIDELINES
CLINICAL DOMAINS&DATASETS
1) Adverse Events Dataset (AEV)
2) Treatment Dataset (TRT)
3) Demographic Dataset (DMG)
4) Study Completion Information Dataset (CMP)
5) Death Information Dataset (CMPDTH)
6) Medical history Dataset (CND)
7) Laboratory Measurements Dataset (LRS)
8) Visit Information Dataset (VIS)
9) Vital Signs Dataset (VSN)
10) Randomization Patients Dataset (RND)
11) Concomitant Medication (CMD)
12) ECG Dataset (ECG)
13) Pregnancy Dataset (PGN)
14) Comment Dataset (COM)
CDISC
SDTM
RANDOMISATION
SAP
SOP
ISS
ISE
CRF
CRT
21CRF11
CDM TO SAS
SAS TO CDM
TEAMS IN CLINICAL ORG
CLINICAL TRAILS IN CLINICAL ORG
DRUG ANALYSIS
BLINDING
CRS
TRT(TREATMENT)
ARM
FDA
RDBMS
DBMS
SDLC (SOFTWARE DEVELOPMENT LIFE CYCLE)
RESUME PREPARATION
CODING ON REALTIME EXISTING PROJECT
FAQ’S
CONSULTING / OUTSOURCING
DEVELOPMENT ON LIVE PROJECTS
SAS-9.2 (Banking/Finance/Healthcare/Retail & Telecom) Domains
SAS/BASE
SAS/EG (ENTERPRISE GUIDE)
SAS/ACCESS
SAS/MACROS
SAS/CONNECT
SAS/DDE & AUTOMATION
SAS/STAT
SAS/GRAPHS
SAS/ODS
SAS/SQL
SAS/CERTIFICATION CLASSES
EXCEL, ADVANCED EXCEL
VBA MACROS
UNIX
ORACLE (SQL)
MS-ACCESS
SDLC (SOFTWARE DEVELOPMENT LIFE CYCLE)
1 MONTH DOMAIN TRAINING
RESUME PREPARATION
CODING ON REALTIME EXISTING PROJECT
FAQ’S
CONSULTING / OUTSOURCING
DEVELOPMENT ON LIVE PROJECTS
SAS-BI (#Package 2) Latest Versions
SAS/Enterprise Guide 4.2
SAS/DI Studio 4.2 (with Data ware housing concepts)
SAS/Information Map Studio 4.2
SAS/Web Report Studio
SAS/OLAP Cube Studio 4.2
SAS/Information Delivery Portal
SAS/Microsoft Add In
SAS/management Console 9.2
SAS/Forecasting Studio
SAS/FM Studio
SAS/Data flux power Studio 8.1
SAS-ANALYTICS (#Package 3)
SAS/STAT
SAS/Analytics
SAS/Data Modeling
SAS/E-Miner
SAS-ADMIN (#Package 4)
SOFTWARE INSTALLATION & configuration
HANDLING servers
ADMIN CONCEPTS
MANAGEMENT CONSOLE 9.2
SAS-RISK MANAGEMENT (#Package 5)
SAS DI STUDIO
SAS RISK STUDIO
-> credit RISK
-> OPERATIONAL RISK
-> MARKET RISK
SAS RISK DIMENSIONS
SAS 9.3 COURSE CONTENT Daily 1:30 minutes
60Days SAS Training 5Days Certification Training 25Days Domain training (Project)
SAS/BASE
BASIC THEORY & RULES ETC
SAS WINDOWING ENVIRONMENT
CREATION OF LIBRARIES
SAS programming (BRIEFLY)
- DATASTEP
- PROC STEP
WAYS TO READ DATA INTO SAS
BACK END PROCESS OF DATASTEP
INSTALLATION PROCESS
DATASTEP
DATA STATEMENT &DATASET OPTIONS
INFILE STATEMENT & OPTIONS
INPUT STATEMENT &STYLES & OPTIONS
DATALINES STATEMENT
ATTRIBUTES OF THE VARIABLES
LENGTH, LABEL STATEMENTS
INFORMATS & FORMATS
HOW DATES works IN SAS
ATTRIB STATEMENT & INDIVIDUAL ATTRIBUTES
SUM STATEMENT
STOP, RETAIN STATEMENTS
GOTO STATEMENT
CONDITIONAL STATEMENTS& LOOPS
IF, IF/THEN, IF/THEN/ELSE,IF/THEN OUTPUT, IF/THEN DELETE STATEMENTS
WHERE STATEMENT& OPERATORS
DO, DO ITERATIVE, DO UNTIL & DO WHILE STATEMENTS
COMBINING DATASETS
CONCATENATION
INTEREAVING
MERGE
UPDATE
MODIFY
FUNCTIONS
CHARACTER FUNCTIONS
NUMERIC FUNCTIONS
DATE FUNCTIONS
ARRAYS
OTHERS MISSING CONCEPTS
REVIEW OF DATASTEP
EXAM & DISCUSSION
PROC STEP
UTILITY PROCEDURES
PROC CONTENTS
PROC COPY
PROC SETINIT
PROC DELETE
PROC PWENCODE
PROC APPEND
PROC SORT
PROC DATASETS
PROC OPTIONS
PROC COMPARE
PROC TRANSPOSE
PROC RANK
PROC FORMAT
PROC IMPORT
PROC EXPORT
PROC CPORT
PROC CIMPORT
PROC MIGRATE
REVIEW OF UTILITY PROCEDURES
SAS/ACCESS
BASIC THEORY OF SAS/ACCESS
WAYS TO ACCESS DATA FROM DIFFERENT SOURCES LIKE NOTEPADS, EXCEL, CSV
FILES, MS-ACCESS, ORACLE, DB2, SYBASE AND TERRADATA etc…
PROC IMPORT
INFILE STATEMENT
SQL PASS THRU QUERY
LIBNAME STATEMENT
PROC DBLOAD
PROC ACCESS
REVIEW OF ACCESS PROCEDURES
REPORTING PROCEDURES
PROC PRINT
PROC TABULATE
P ROC REPORT
_NULL_ REPORT (Data step Reporting)
REVIEW OF REPORTING PROCEDURES
SAS/GRAPHS & ODS CONCEPTS
PROC GPLOT
PROC GCHART
PROC SGHART
ODS
REVIEW OF GRAPHS PROCEDURES
SAS/STAT
BASIC FUNCTIONAL CLASSES OF STATISTICS
STATISTICAL PROCEDURES
PROC MEANS
PROC SUMMARY
PROC UNIVARIATE
PROC FREQ
PROC CORR
PROC REG
PROC ANOVA
PROC TTEST
PROC LIFE TEST
REVIEW OF STATS PROCEDURES
SAS/MACROS
INTRODUCTION TO THE MACRO FACILITY
PURPOSE OF THE MACRO FACILITY
PROGRAM FLOW
MACRO VARIABLES
INTRODUCTION TO MACRO VARIABLES
AUTOMATIC MACRO VARIABLES
MACRO VARIABLE REFERENCES
USER-DEFINED MACRO VARIABLES
DELIMITING MACRO VARIABLE NAMES
DELETING MACRO VARIABLES
MACRO FUNCTIONS
MACRO DEFINITIONS
DEFINING AND CALLING A MACRO
MACRO PARAMETERS
MACRO STORAGE
DATA STEP AND SQL INTERFACES
CREATING MACRO VARIABLES IN THE DATA STEP
INDIRECT REFERENCES TO MACRO VARIABLES
RETRIEVING MACRO VARIABLES IN THE DATA STEP
CREATING MACRO VARIABLES IN SQL
MACRO programs
CONDITIONAL PROCESSING
PARAMETER VALIDATION
ITERATIVE PROCESSING
GLOBAL AND LOCAL SYMBOL TABLES
FRAMEWORK FOR DEVELOPING MACRO applications
DEBUGGING AND TROUBLESHOOTING
GENERATING CUSTOM MESSAGES
CREATING EFFICIENT MACROS
REVIEW OF MACROS
PERFORMANANCE TUNING CONCEPTS
TESTING/DEBUGGING TECHNIQUES
ERROR HANDLING
ADDITIONAL FEATURES BETWEEN SAS VERSIONS
CERTIFICATION CLASSES
DOMAIN SPECIFIC PROJECT
PRACTICE
SDLC (Software Development Life Cycle)
CODING ON REAL TIME DATA
INTERVIEW QUESTIONS
RESUME PREPARATION
WRITTEN TESTS
MOCK INTERVIEWS
PLACEMENTS & OUTSOURCING
CONSULTING
DEVELOPMENT
UNIX / LINUX / SOLARIS BASICS
OVERVIEW OF UNIX
HISTORY OF LINUX
LINUX ARCHITECTURE
UNDERSTANDING LINUX COMMANDS
DISPLAYING SYSTEM DATE AND TIME : DATE
DISPLAYING PRESENT AND WORKING USERS : WHO AND WHOAMI
CALCULATOR : BC
MACHINE CHARACTERISTICS : UNAME
KNOWING A TERMINAL : TTY
DISPLAYING A CALENDAR : CAL
DISPLAYING A MESSAGE : ECHO AND PRINTF
FILES SYSTEM
LINUX FILE HIERARCHY CONCEPTS
LISTING FILES AND DIRECTORIES : LS
MORE AND LESS COMMAND
THE SEVEN FUNDAMENTAL FILE TYPES
CREATING AND VIEWING THE FILES: CAT
CREATING, MODIFYING, CHANGING AND REMOVING DIRECTORIES:
MKDIR, CD, RMDIR
MOVING AND RENAMING FILES : MV
COPYING A FILES : CP COMMAND WITH ATTRIBUTES
DELETING A FILES : RM COMMAND WITH ATTRIBUTES
LINKS – HARD LINK AND SOFT LINK
ABSOLUTE PATH NAME
RELATIVE PATH NAME
COMPARISONS
COMPRESSIONS
ZIP
COMPRESS
GZIP
BZIP2
FILE ATTRIBUTES
CHMOD
CHOWN
CHGRP
FILTER COMMANDS
WHICH, WHERIS, LOCATE WHATIS
FIND COAMMNDS WITH ATTRIBUTES.
STRING PROCESSING
HEAD, TAIL
WC, SORT, UNIQ
CUT, PASTE
STRING PROCESSING WITH REGULAR EXPRESSIONS
SED
GREP
PROCESS
INTRODUCTION PROCESS CONCEPTS
PROCESS BASICS
PROCESS COMMANDS
JOB CONTROL
AT,BATCH,CRON,
SHELL
CONFIGURING SHELL
VARIABLES
LOCAL VARIABLE
ENVIRONMENT VARIABLE
SHELL STARTUP SCRIPTS
LOGIN SHELL
NON-LOGIN SHELL
VI EDITOR
OVERVIEW OF VI EDITOR
THREE MODES OF VI EDITOR
SAVING AND QUITTING
NAVIGATION
EDITING A TEXT
UNDOING CHANGES
YANK AND PASTE
CHANGING, DELETING
SEARCHING FOR PATTERN
SEARCH AND REPLACE
HANDLING MULTIPLE FILES IN EX-MODE
COMMUNICATION TOOLS
SQL (STRUCTURED QUERY language)
DDL (DATA DEFINITIONLANGUAGE)
CREATE
ALTER I.
ADD
II. MODIFY
III. DROP
IV. RENAME
TRUNCATE
DROP
RENAME
CREATING EXACT COPY OF A TABLE
REATE A COPY WITHOUT DATA
DML (DATA MANIPULATION LANGUAGE)
TCL (TRANSACTION CONTROL LANGUAGE)
COMMIT
ROLLBACK
SAVE POINT
DCL (DATA CONTROL LANGUAGE)
DRL/DQL (DATA RETRIEVAL/DATA QUERY LANGUAGE):
RETRIEVING DATA BY USING
SELECT CLAUSE
HANDLING NULL VALUES
NVL FUNCTION
NVL2 FUNCTION
NULLIF FUNCTION
COALESCE FUNCTION
DEFINING ALIAS NAMES
COLUMN ALIAS
TABLE ALIAS
INTEGRITY CONSTRAINTS
VARIOUS TYPES OF CONSTRAINTS
NOT NULL
UNIQUE
PRIMARY KEY CONSTRAINTS
FOREIGN KEY CONSTRAINTS
CHECK
DEFAULT
DROPPING CONSTRAINTS
ENABLING, DISABLING CONSTRAINTS
JOINS:
TYPES OF JOINS:
SELF JOIN
EQUI JOIN
NON EQUI JOIN
INNER JOIN
OUTER JOIN I.LEFT
OUTER JOIN
II.RIGHT OUTER JOIN
III. FULL OUTER JOIN
NATURAL JOIN
CROSS JOIN
CONDITIONAL CLAUSE
WHERE CLAUSE
ORDER BY CLAUSE
HAVING CLAUSE
GROUP BY CLAUSE
OPERATORS:
CONCATENATION OPERATORS
RELATIONAL OR COMPARISON OPERATORS
LOGICAL OPERATORS
SET OPERATORS
MULTIPLE-ROW COMPARISON OPERATORS
SQL *PLUS OPERATORS
VIEWS:
SIMPLE VIEW
COMPLEX VIEW
DROPIND VIEWS
ILLINE VIEW
VIEW CONSTRAINTS
FORCE VIEW
SNAP SHOT
MATERIALIZED VIEW
INDEXES
WHEN TO CREATE INDEXES
AUTOMATIC INDEXES
MANUAL INDEXES
REMOVING INDEXES
PRE-DEFINED FUNCTIONS
CHARACTER FUNCTIONS
NUMBER FUNCTIONS
DATE FUNCTIONS
CONVERSION FUNCTIONS
NUMBER CONVERSION
DATE CONVERSION
AGGREGATE FUNCTIONS
HIERARCHICAL QUERIES PEUEDO COLUMNS:
SEQUENCE:
OLAP FEATURES:
ROLLUP
CUBE
DECODE RANK ()
DENSE_RANK ()
ROLES IN ORACLE SYNONYMS:
PRIVATE SYNONYM
PUBLIC SYNONYM
LOCKS:
ROW LEVEL LOCK
TABLE LEVEL LOCK
DEAD LOCK
___________________________________________________________________
Contact us
@ STANSYS SOFTWARE SOLUTIONS
#7-1-621/113(67/3RT), Beside: Nagarjuna Jr. College, Near S.R.Nagar Community Hall,
S.R.Nagar, Hyd-38 | Ph: 040-42204449 | 8143408688 | 9542195422.
www.stansys.co.in
stansys.sas@gmail.com
Ad details
- Type:
- Classes
- Type:
- Language Classes
Photos: Pictures of SAS Online Training
India > Karnataka > Bangalore
Free classifieds in India > Jobs & Services in India > Jobs & Services in Karnataka > Jobs & Services in Bangalore > study 12 pass jobs
Services in India > Services in Karnataka > Services in Bangalore > SAS Online Training
Popular Searches