Detail kurzu

SAS(R) Programming Fast Track

EDU Trainings s.r.o.

Obsah kurzu

Introductionoverview of SAS Foundationcourse logistics course data filesSAS Programsintroduction to SAS programssubmitting a SAS programSAS program syntaxAccessing Dataexamining SAS data setsaccessing SAS librariesProducing Detail Reportssubsetting report datasorting and grouping report dataenhancing reportsFormatting Data Valuesusing SAS formatsuser-defined formatsReading SAS Data Setsreading a SAS data setcustomizing a SAS data setReading Spreadsheet and Database Datareading spreadsheet datareading database dataReading Raw Data Filesintroduction to reading raw data filesreading standard delimited datareading nonstandard delimited datahandling missing dataManipulating Datausing SAS functionsconditional processingCombining Data Setsconcatenating data setsmerging data sets one-to-onemerging data sets one-to-manymerging data sets with non-matchesCreating Summary Reports FREQ procedureMEANS and UNIVARIATE proceduresusing the output delivery systemControlling Input and Outputwriting observations explicitlywriting to multiple SAS data setsselecting variables and observationsSummarizing Datacreating an accumulating total variableaccumulating totals for a group of dataData Transformationsintroductionmanipulating character valuesmanipulating numeric valuesconverting variable typeProcessing Data IterativelyDO loop processingconditional DO loop processingSAS array processingusing SAS arraysIntroduction to the Macro Facilitypurpose of the macro facilityprogram flowMacro Variablesintroduction to macro variablesautomatic macro variablesmacro variable referencesuser-defined macro variablesdelimiting macro variable referencesmacro functionsMacro Programsdefining and calling a macromacro parametersmacro conditional processingBasic Queriesoverview of the SQL procedurespecifying columnsspecifying rowsOutputting Query Resultspresenting datacreating tablessummarizing dataSubqueries and Joinsnoncorrelated subqueriesinner joins
Certifikát Na dotaz.
Hodnocení




Organizátor