Introduction to SAS Base using SAS Studio Csicsman

  • Slides: 44
Download presentation
Introduction to SAS Base (using SAS Studio) Csicsman József BME Matematikai intézet, Sztochasztika Tanszék

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

The frame system of SAS 1. l The BASE SAS software is a programing

The frame system of SAS 1. l The BASE SAS software is a programing lanquage for data handling and calculation l l l 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: l SAS/STAT: Multidimensional data analysis l

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

The frame system of SAS 3. End user applications: l SAS/EG: simple application frame

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

SAS end use platforms(SAS screens) l l l Program Editor: for SAS code Explorer:

SAS end use platforms(SAS screens) l l l 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 24

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 Csicsman@calculus. hu Outumn 2017 Introduction to SAS BASE by

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