Introduction to SAS Base (using SAS Studio) Csicsman József

Introduction to SAS Base (using SAS Studio) Csicsman József BME Matematikai intézet, Sztochasztika Tanszék Külső oktató [email protected] Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 1

The frame system of SAS 1. The BASE SAS software is a programing lanquage for data handling and calculation DATA step for reading datasets, creating and manupalating SAS data files, Proc steps for calculating predefined algoritmus (elementary statistics, graphs, muldidimensional data analysis, ), SAS BASE generate executable codes Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 2

The frame system of SAS 2. SAS components: SAS/STAT: Multidimensional data analysis SAS/INSIGHT: 3D data visualisation SAS/ETS: Time series, economic models, SAS/GRAPH: graphical presentation. SAS Ap Dev Studio: for application development Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 3

The frame system of SAS 3. End user applications: SAS/EG: simple application frame to generate SAS Base code SAS/EG Enterprise Miner for data Mining SAS Graph-N-Go: to generate graphics Time Series Forecasting System Project Management . Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 4

SAS end use platforms(SAS screens) Program Editor: for SAS code Explorer: for data dictionaries LOG: how SAS syste understood your req. Output: non graphical results Result: for handling the different kind of results Result viewer: to access HTML outputs Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 5

Login Screen for registrated user Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 6

To Select SAS Studio Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 7

The Screens of SAS Studio The data explorer Log lists Outumn 2017 For the SAS program codes For results handling Introduction to SAS BASE by SAS Sudio Csicsman J 8

At the first time we must to create a workind directory Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 9

Each registrated user has a home directory and we can create a new subdirectory on it Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 10

It is important to click for the usage it at the next SAS section Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 11

The predefined library will be my working directory Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 12

Upload file to my cloud dictionary 1. Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 13

Upload file to my cloud dictionary 2. Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 14

Upload file to my cloud dictionary 3. Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 15

Copy Excel sheet to SAS file using Snippet 1. Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 16

Copy Excel sheet to SAS file using Snippet 2. Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 17

The result of the data transformation Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 18

Using Proc Contents for the data description (Meta informations) of SAS dataset Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 19

The result Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 20

To use confortable name exept Excel origins, and to select first 524 boats, with real results Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 21

First step to get informations from data, elementary statistics Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 22

Convert classification variables to numeric Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 23

The results Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 24

The results Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 25

To sort the data with ys variable (ys is a number about the rapidly of boats) and to sreate frequensy table Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 26

The results Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 27

To calculate correlation matrix Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 28

The result of corralation. How to interpret its? Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 29

To create frequency by the cathegories of the boats, using freq and gchart procedures Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 30

The results Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 31

To create distribution diagram Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 32

The results Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 33

SAS statement for data handling, to create new variables form time format value Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 34

The results with the new calculated values Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 35

To create 3 datesets by sepatation of ys number Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 36

The results Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 37

To check the ys distributions of 3 datasets Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 38

The results Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 39

How many boats are with different ys number? To calculate one dimension statistical table Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 40

The reult tables Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 41

To create two dimensional statistical table Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 42

The rows are ys categiries, the colums are the number of boats and average results of the race Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 43

Thank you for your attention [email protected] Outumn 2017 Introduction to SAS BASE by SAS Sudio Csicsman J 44