Transcription of 268-29: Introduction to PROC SQL
{{id}} {{{paragraph}}}
Example: tourism industry
268-29: Introduction to PROC SQL
1 Paper 268-29 Introduction to Proc SQLK atie Minten Ronk, Systems Seminar Consultants, Madison, WIABSTRACTPROC SQL is a powerful Base SAS Procedure that combines the functionality of DATA and PROC steps into a single SQL can sort, summarize, subset, join (merge), and concatenate datasets, create new variables, and print the resultsor create a new table or view all in one step!PROC SQL can be used to retrieve, update, and report on information from SAS data sets or other database products. Thispaper will concentrate on SQL s syntax and how to access information from existing SAS data sets. Some of the topicscovered in this brief Introduction include: Writing SQL code using various styles of the SELECT statement. Dynamically creating new variables on the SELECT statement. Using CASE/WHEN clauses for conditionally processing the data.
1 Paper 268-29 Introduction to Proc SQL Katie Minten Ronk, Systems Seminar Consultants, Madison, WI ABSTRACT PROC SQL is a powerful Base SAS Procedure that combines the functionality of DATA and PROC steps into a single step. PROC SQL can sort, summarize, subset, join (merge), and concatenate datasets, create new variables, and print the results
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
Related search queries
Introduction to Second Order Systems, Order, Second Order, Thinking About Second & Third Order Effects, INTRODUCTION, Introduction to Biological Aging Theory, Introduction to Biological Aging Theory Second, Earned Value Management Systems, Katie Minten Ronk, Steve First, David, Systems, INTRODUCTION TO SAVING AND SPENDING