In Hyderabad

Rs 1
You can also call the Study Centre
80081... More

Important information

  • Course
  • Hyderabad
  • 30 hours of class

Important information

Where and when

Starts Location
On request
516,Annapurna Block, AdityaEnclave, Ameerpet, Hyderabad-500026, 500026, Andhra Pradesh, India
See map

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