SAS BI
Course
In Hyderabad
₹ 1
VAT incl.
Description
-
Type
Course
-
Location
Hyderabad
-
Class hours
30h
Facilities
Location
Start date
Hyderabad
(Andhra Pradesh)
See map
516,Annapurna Block, AdityaEnclave, Ameerpet, Hyderabad-500026, 500026
Start date
On request
Reviews
Have you taken this course?
Course programme
SAS BIDuration: 30 Hr PART-IBASE SASIntroduction to Sas System & ArchitectureHistory and different ModulesFeaturesVariables & Sas Syntax RulesSas Data SetsData Set OptionsOperatorsIf – Then Else StatementWhere StatementCreating & Redefining VariablesReading Raw DataInfile Statement With OptionsMultiple Observations and Multiple Datasets.Input StylesSAS FunctionsSelect StatementDo LoopsLeave and Continue StatementsOutput Statement & Put StatementStop And Error StatementsModifying And Combining Data SetsUpdating Master Data SetDisplay Manager CommandsBASE SAS PROCEDURESProc SortProc PrintProc MeansProc FreqProc PlotProc ChartProc CompareProc CopyProc SummaryProc AppendProc DatasetsProc ContentsProc DeleteProc FormatSAS/REPORTSFrequency statementOne-Way Frequency statementCross Tabular Frequency statementSummary StatisticsCreating A List statementDefine StatementOrder Usage and GroupPrinting Grand TotalsRbreak StatementTabulate ProcedureOne-Dimensional TablesTwo-Dimensional TablesObtaining A TotalAnalysis Variables with optionsSummary StatisticsSAS/ODSCreating Rtf FileCreating Html FileCreating Pdf FileCreating Xml FilePART IIORACLE-SQL CONCEPTSIntroductionHistoryFeaturesSql Command SetOperators In SqlOrder By ClauseGroup By ClauseHaving ClauseDistinct ClauseCreate and InsertDeleting,Populating And UpdatingSAS/SQLIntroduction To SAS/SQLFeatures & UsesTerminologyData Types, Key Words, & OperatorsFunctions, Predicates & FunctionsFormatting OutputGroup By Clause, Order By Clause & Having ClauseCase Expression and Conditional Logic.Creating ,Populating & Deleting TablesAlter Table StatementRenaming A Table & ColumnsChanging Column’s LengthJoins & ViewsSAS/ACCESSImport & Export ProceduresImporting data from Ms-Access & Ms-ExcelImporting data from Oracle databaseDbLoad Procedure SAS/MACROSMacro ConceptsMacros And Macro VariablesCreating Macro VariablesUsing Macro VariablesCreating Modular Code With MacrosInvoking A MacroAdding Parameters To MacrosMacros With Conditional LogicUsing Various Procedures In MacrosAutomatic VariablesMacro FunctionsIncluding External MacrosPART IIISAS/WAREHOUSE ADMINISTRATORIntroduction To DWRelationship Between SAS And Data WarehousingDatabase DesigningGlobal Warehouse Designing StepsSAS/ETLIntroduction To ETLApplication Of ETL In DWETL Process Model Development In SAS With Project
SAS BI
₹ 1
VAT incl.