Summer Fast Track: SAS(R) Base Programming

EDU Trainings s.r.o.

Popis kurzu

Obsah kurzu

IntroductionCourse logistics.Overview of Foundation SAS.Getting Started with SASIntroduction to SAS programs.Submitting a SAS program.Working with SAS SyntaxMastering fundamental concepts.Diagnosing and correcting syntax errors.Getting Familiar with SAS Data SetsExamining descriptor and data portions.Accessing SAS data libraries.Accessing relational databases (self-study).Reading SAS Data SetsIntroduction to reading data.Using SAS data as input.Subsetting observations and variables.Adding permanent attributes.Reading Microsoft Excel WorksheetsUsing Excel data as input.Doing more with Excel worksheets (self-study).Reading Delimited Raw Data FilesUsing standard delimited data as input.Using nonstandard delimited data as input.Validating and Cleaning DataIntroduction to validating and cleaning data.Examining data errors when reading raw data files.Validating data with the PRINT and FREQ procedures.Validating data with the MEANS and UNIVARIATE procedures.Cleaning invalid data.Manipulating DataCreating variables.Creating variables conditionally.Subsetting observations.Combining SAS Data SetsIntroduction to combining data sets.Appending a data set (self-study).Concatenating data sets.Merging data sets one to one.Merging data sets one to many.Merging data sets with nonmatches.Enhancing ReportsUsing global statements.Adding labels and formats.Creating user-defined formats.Subsetting and grouping observations.Directing output to external files.Producing Summary ReportsUsing the FREQ procedure.Using the MEANS procedure.Using the TABULATE procedure (self-study).Introduction to Graphics Using SAS/GRAPH (Self-Study)Creating bar and pie charts.Creating plots.Enhancing output.Controlling Input and OutputWriting observations explicitly.Writing to multiple SAS data sets.Selecting variables and observations.Summarizing DataCreating an accumulating total variable.Accumulating totals for a group of data.Reading Raw Data FilesReading raw data files with formatted input.Controlling when a record loads.Data TransformationsManipulating character values.Manipulating numeric values.Converting variable type.Debugging TechniquesUsing the PUTLOG statement.Processing Data IterativelyDO-loop processing.Conditional DO-loop processing.SAS array processing.Using SAS arrays.Restructuring a Data SetRotating with the DATA step.Combining SAS Data SetsUsing data manipulation techniques with match-merging.Creating and Maintaining Permanent FormatsCreating permanent formats.Other SAS LanguagesOverview of other languages.Using the SQL procedure.Using SAS macro language.Learning MoreSAS resources.Next steps.

Cílová skupina

Programmers, business analysts, and anyone getting started writing SAS programs

Certifikát Na dotaz.

Hodnocení