Base SAS software program helps based question Language (SQL), the ANSI commonplace and ordinary language that allows you to create, retrieve, and replace database details. This name is your introductory, task-oriented source for SQL as carried out throughout the SAS SQL method. With this identify, you'll study the fundamentals of utilizing PROC SQL, together with retrieving information from unmarried and a number of tables, identifying particular information from tables, subsetting, ordering, and summarizing facts, updating tables, combining tables to create new tables and beneficial stories, acting queries on database administration method (DBMS) tables, utilizing PROC SQL with the SAS macro facility, and debugging and optimizing PROC SQL code. also, unique examples help you use PROC SQL to resolve real-world difficulties, similar to computing a weighted standard, increasing hierarchical facts in a desk, making a precis document, updating a desk with values from one other desk, and utilizing PROC SQL tables in different SAS courses. This identify is additionally to be had on-line. This name is meant for clients with a operating wisdom of SAS programming. No wisdom of SQL or relational databases is believed.
Supports releases 9.1 and better of SAS software.