We've noticed this is not your region.
Redirect me to my region
SpeedyCourse Logo
Events Providers
SpeedyCourse Logo or
What do you want to learn today?
  Back to Courses

Base SAS 9 Programming

Online Training by  OEM Office Elearning Menu - Microsoft Partner and Authorized Testing Center
Inquire Now
Online / Training
Inquire to Request Schedule
View this Course
EUR  369.00
Inquire Book Now Add to Wishlist
OEM Office Elearning Menu - Microsoft Partner and Authorized Testing Center's Logo
RESPONSE RATE
Book Now
Inquire

Details

Order this great Elearning Training Base SAS 9 Programming online, 1 year 24/7 access to rich interactive videos, voice, practice assignments, progress monitoring through reports and tests per subject to test the knowledge directly. After the course you will receive a certificate of participation.

Availabilty: 16 hours
Language: English
Certificate of participation: Yes
Online access: 365 days
Progress monitoring: Yes
Award Winning E-learning: Yes
Suitable for mobile: Yes

Outline

Base SAS 9 Programming: The SAS Environment

  • start the course
  • describe the purpose of SAS programming
  • describe the various SAS environments used for SAS programming
  • describe ways in which a SAS environment is obtained
  • list the attributes of the three main interfaces to SAS – SAS Studio, SAS Enterprise Guide, and SAS Windowing Environment
  • create a simple SAS program
  • run a simple SAS program
  • list the characteristics of the SAS Studio environment
  • list SAS Studio interface elements
  • use the SAS Studio navigation pane
  • use the SAS Studio Code Tab
  • use the SAS Studio Log Tab
  • use the SAS Studio Results Tab
  • work with autocomplete in SAS Studio
  • work with tasks in SAS Studio
  • work with libraries in SAS Studio
  • create and run a simple SAS program in one of the SAS environments
Base SAS 9 Programming: Introduction to Data Sets
  • start the course
  • describe the components of a SAS data set
  • use the CONTENTS procedure to view a data set descriptor, and the PRINT procedure to display the data
  • describe SAS libraries, including temporary and permanent libraries
  • browse a SAS library using the SAS Explorer and the CONTENTS procedure
  • use the LIBNAME statement to assign a library reference name to a relational database in SAS
  • reference a relational database table using a SAS two-level name
  • describe different scenarios for reading from a data source in SAS
  • use the DATA statement to begin a data step in SAS
  • use the SET statement to read observations from a SAS data set
  • use the WHERE statement with conditionals to subset an observation in SAS
  • use the DROP and KEEP statements to specify variables for omission or retention in a SAS data set
  • use the LABEL statement to add labels to the descriptor portion of a SAS data set
  • use the FORMAT statement to add formats to the descriptor portion of a SAS data set
  • create a data set from an Excel sheet using the PROC step in SAS
  • read from an Excel sheet using the libname statement
  • use the PROC step to create an Excel sheet in SAS
  • use the ODS to create an Excel sheet in SAS
  • use the IMPORT wizard to import data from an Excel sheet in SAS
  • use the EXPORT wizard to write to an Excel Sheet in SAS
  • create a data set from a delimited raw data file using the DATA step in SAS
  • use the LENGTH statement to define the length of a variable in SAS
  • read nonstandard data in SAS using informants
  • use additional SAS statements to process nonstandard data in the DATA step
  • read consecutive delimiters as missing values using the DSD option in SAS
  • recognize missing data at the end of a record with the MISSOVER option
  • read data from a variety of sources in SAS
Base SAS 9 Programming: Working with Data Sets
  • start the course
  • describe how SAS handles errors in raw data files
  • describe procedures and techniques for validating and cleaning data in SAS
  • use the SAS log to examine data errors
  • use conditionals to handle data errors in SAS
  • use the PRINT procedure with the WHERE statement to validate data in SAS
  • use the FREQ procedure with the TABLES statement to validate data in SAS
  • use the MEANS procedure with the VAR statement to validate data in SAS
  • use the UNIVARIATE procedure with the VAR statement to validate data in SAS
  • open the source data to clean data for SAS
  • use assignment statements in the DATA step to clean data in SAS
  • use IF-THEN and ELSE statements in the DATA step to clean data in SAS
  • use the assignment statement in the DATA step to create variables in SAS
  • use operators, including SAS functions, to create data values
  • use the IF-THEN statement and the IF-THEN DO statement to execute statements conditionally in SAS
  • use the ELSE statement to execute alternative actions in an IF-THEN statement in SAS
  • use the subsetting IF statement and the WHERE statement to subset observations in SAS
  • use the IF-THEN DELETE statement to subset observations in SAS
  • describe the methods for combining data sets in SAS
  • use the APPEND procedure to append a SAS data set to another SAS data set
  • use the FORCE option with the APPEND procedure to append one SAS data set to another SAS data set
  • use the SET statement in a DATA step to concatenate two or more SAS data sets
  • use the RENAME= data set option to change the names of variables in SAS
  • merge SAS data sets one-to-one based on a common variable using MERGE and BY statements in a DATA step
  • merge SAS data sets one-to-many based on a common variable using MERGE and BY statements in a DATA step
  • use the IN= option to control the observations in the output SAS data set
  • validate and clean data sets and combine them with an append operation and a concatenation
Base SAS 9 Programming: Creating Reports
  • start the course
  • create a basic report in SAS
  • create an enhanced report using SAS system options, and by adding titles and footnotes
  • add column headings to a report using LABEL statements
  • create formatted output by using the FORMAT statement
  • use the FORMAT procedure to create user-defined formats, and apply them to variables in reports
  • use the WHERE and BY statements to subset and group a report
  • use ODS statements to direct output to various ODS destinations
  • specify a style definition using a STYLE= option in the ODS destination statement in SAS
  • use the FREQ procedure to create one-way and two-way frequency tables in SAS
  • use various options to enhance frequency tables in SAS
  • use the MEANS procedure to create summary statistics and multilevel summaries in SAS
  • use the SUMMARY procedure to create summaries in SAS
  • use various options to enhance summary tables in SAS
  • use the TABULATE procedure to create one-dimensional, two-dimensional, and three-dimensional tabular reports
  • use the OUT= option in the TABULATE procedure to produce output data sets
  • describe the capabilities of the SAS/GRAPH statistical graphics procedures
  • create pie charts using the SAS/GRAPH statistical graphics procedures
  • create bar charts using the SAS/GRAPH statistical graphics procedures
  • create histogram charts SAS/GRAPH statistical graphics procedures
  • create scatter plots using SAS/GRAPH statistical graphics procedures
  • create and chart a summary report and a frequency table in SAS
Base SAS 9 Programming: Inputs and Outputs
  • start the course
  • control when SAS writes an observation to a data set using an OUTPUT statement
  • write to more than one SAS data set
  • control SAS variable input and output with DROP and KEEP
  • control SAS observation input and output with OBS and FIRSTOBS
  • use the RETAIN statement to create an accumulating variable in SAS
  • use the SUM statement to create an accumulating variable in SAS
  • summarize data by groups using BY-Group processing in SAS
  • summarize data by multiple groups using BY-Group processing in SAS
  • use column input to read input data that is arranged in columns or fixed fields in SAS
  • use formatted input to read both standard and nonstandard data that is arranged in fixed fields in SAS
  • use multiple INPUT statements to read a group of records in a raw data file as a single observation in a new data set in SAS
  • use a line-hold specifier to prevent the second INPUT statement in a DATA step from moving to the second line in a raw data file in SAS
  • using the MISSOVER and DSD options to control behavior with missing values in raw data in SAS
  • use various SAS functions to perform transforms or calculations on variables
  • use SAS functions to extract and transform character values, including SUBSTR, LEFT, RIGHT, CHAR, PROPCASE and LENGTH
  • create pie charts using the SAS/GRAPH Statistical Graphics Procedures
  • use SAS functions to find and modify character values, including FIND, SUBSTR, COMPRESS and TRAINED
  • use descriptive SAS statistical functions, such as SUM, MIN, MAX and MEAN
  • truncate numerical SAS values by using the ROUND, INT, FLOOR, and CEIL functions
  • convert between SAS data types using INPUT and PUT functions
  • debug SAS programs using the PUTLOG statement
  • debug logic errors in SAS programs
  • create a program that manipulates input data
Base SAS 9 Programming: Data Structures
  • start the course
  • create a simple DO loop in SAS
  • create a DO WHILE loop in SAS
  • create a DO UNTIL loop in SAS
  • create a nested DO loop in SAS
  • reduce redundant code in a SAS program by creating a DO loop
  • describe the characteristics of arrays in SAS
  • create an array in SAS
  • process all the elements of an array in a SAS program
  • create variables in an array in SAS
  • perform calculations using arrays and the keyword OF in SAS
  • assign initial values in an ARRAY statement in SAS
  • use the TRANSPOSE procedure to manipulate data sets in SAS
  • use the TRANSPOSE procedure to rotate data sets in SAS
  • perform a match-merge on SAS data sets
  • control a match-merge with OUTPUT, DROP, KEEP, FIRST and LAST
  • merge data sets with no common variable by using a series of separate DATA steps
  • use SAS/ACCESS LIBNAME to match-merge a SAS data set with an Excel workbook
  • use RENAME to match-merge data sets with same-named variables
  • describe PROC SQL and use it to connect to a data set
  • use PROC SQL to query a table in SAS
  • use PROC SQL to join tables in SAS
  • create and process an array and merge data sets in SAS
Reviews
Be the first to write a review about this course.
Write a Review

What is OEM Office Elearning Menu?
OEM Office Elearning Menu provides ICT training to businesses and individuals, for end users or ICT professionals of all skill levels. From Microsoft Office to Certified Ethical Hacker, with over 200 brands of training we are sure we can get you started. By responding to new technology, we can always keep our training offerings relevant. Plus, we employ our own instructors, all of whom are certified and have years of hands-on experience.

What does OEM Office Elearning Menu do?
We offer comprehensive, customized ICT training from a variety of major A-brands to certification. For Microsoft Office, we can provide training in five languages: Dutch, English, French, German and Spanish. For Microsoft Office, we also take the exams. In addition to Microsoft Office, we offer customized training for all kinds of other software. This makes us the one-stop shop for all ICT training. Our goal is to teach people how to work with software in a goal-oriented and efficient way. We find good communication very important. We offer short lines of contact. Our customers always have a fixed point of contact with us.

How does a training course at OEM Office Elearning Menu work? ...

View Complete Profile
Inquire to Request Schedule
View this Course
Online Live
EUR  369.00
Online
Training
#Information Technology
Office Application & Computer System Computer Hardware Basic Computer Skills
SHARE THIS COURSE

Location/Venue Map

Sending Message
Please wait...
Added to Calendar
This course was added to your SpeedyCourse calendar.
You can manage your calendar by clicking on the button below.
View my Calendar
Added to Calendar Failed
You have to be logged in before you can add this course to your SpeedyCourse calendar.

Or if you don't have an account you can sign up
as a Provider or as a Learner
Login
Select Schedule
Please select at least one (1) schedule to add.
Cancel
Select Schedule
Please select at least one (1) schedule to export.
Cancel
** To add the schedule/s, download and export the .ics file to your calendar. **
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.
Copyright © 2024 All Rights Reserved. SpeedyCourse.com is owned and operated by Optimum Innovatus, Corp.