SAS: Inputting Data and PROC SQL

Products

Resources

Specials

Summary:

This training course describes ways to create and manipulate SAS data sets, including an introduction to using the SQL procedure in SAS.

Objectives:

After completing this training course , students will be able to:

Describe various input styles used with the INPUT statement
Use the INPUT and INFILE statements to handle external files
Explain the basics of using SQL with SAS
Use PROC SQL to query data sets and generate reports

Outline:

Input Styles
Reading External Files
Introduction to SQL
Using PROC SQL

Features:

Exercises that allow users to practice the application
A file containing the text of the exercises
Simulations that allow users to practice training course skills, even if they don't have access to the application
A glossary
A Skill Assessment

Applicability:

This training course is for end users, programmers and business professionals who have an introductory level of experience with SAS.

Prerequisites:

SAS: IntroductionSAS: Using SASSAS: Data ManipulationSAS: DATA Step ProgrammingSAS: ResultsSAS: Display Manager SystemSAS: Data Libraries

Technical Requirements:

200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 95, 98, NT, 2000, or XP. Minimum Connection Speed: 28.8k. Internet Explorer 5.0 or higher required. Authorware and Macromedia Flash player recommended but not required. JavaScript must be enabled. Netscape and AOL browsers not supported.

Copyright Information:

SAS is a registered trademark of SAS Institute Inc.

Terms of Use:

None