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

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

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.