Transcription of 268-29: Introduction to PROC SQL - SAS
{{id}} {{{paragraph}}}
Example: bankruptcy
268-29: Introduction to PROC SQL - SAS
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. Joining data from two or more data sets (like a MERGE!). Concatenating query results LEARN proc sql ?
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.
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
Related search queries
Without PROC SQL and, WITHOUT PROC SQL AND THE MACRO LANGUAGE, Proc SQL, Become Really Productive, Become Really Productive Using PROC SQL, Queries, Joins, and WHERE Clauses, Advanced Subqueries In PROC SQL, PROC TRANSPOSE FOR MULTIPLE VALUES, PROC TRANSPOSE FOR MULTIPLE VALUES KANHAIYA, PROC, A Primer for SAS Programmers, Structured Query Language, Big data in R, Columbia University, Microsoft SharePoint Server 2013, SharePoint Server 2013