Welcome to Top 10 SAS Functions

[Pages:63]Welcome to Top 10 SAS? Functions

Copyright ? SAS Institute Inc. All rights reserved.

Goal and Agenda

By the end of this meeting, you will understand 10 key SAS? functions' purpose, value and features.

What are SAS? functions? Why use them?

Use Case ? Manipulating character data ? Working with dates (derive durations) ? Summarizing and rounding numeric data

Copyright ? SAS Institute Inc. All rights reserved.

What to remember

SAS? functions conduct a wealth of data manipulation operations so you can transform raw data into intelligence and insight.

Categories of functions

? Character ? Currency ? Financial ? Trigonometric ? Descriptive statistics ? Date/time/temporal

Why?

? Prepare data for reporting and analytics ? enhance / combine / convert data for reporting and analytics

Copyright ? SAS Institute Inc. All rights reserved.

What are SAS Functions? Why use SAS Functions?

What?

SAS functions perform computations, data manipulation, and enhancement ? Character ? Numeric ? Dates/temporal ? Mathematics

Why?

You need to transform raw/operational data into report- and analytics-ready structures ? DATA step programming ? SQL

Copyright ? SAS Institute Inc. All rights reserved.

What are the top 10 functions?

Why these 10?

? 2017 surveys of SAS technical support (what customers submit most often) ? a 2016 survey on communities. ? Other trusted sources

Which 10?

? character manipulation (SUBSTR, SCAN, CATX, FIND) ? temporal / date / time (DATEPART, DATEDIF) ? data conversion (PUT, INPUT) ? numeric (SUM, ROUND)

Copyright ? SAS Institute Inc. All rights reserved.

Where to find SAS Functions 1 of 2

Copyright ? SAS Institute Inc. All rights reserved.

Where to find SAS Functions 2 of 2

Copyright ? SAS Institute Inc. All rights reserved.

Use Case ? Raw data before functions

The human resources team at a fictitious organization needs to know more about its divisions' employees. ? employee attrition ? tenure ? total compensation

Copyright ? SAS Institute Inc. All rights reserved.

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download