Power of SAS SQL:
• SQL looks at datasets differently from SAS
– SAS looks at a dataset one record at a time, using an implied loop that moves from the first record to the last
– SQL looks at all the records, as a single object
• Because of this difference SQL can easily do few things that are more difficult to do in SAS
• There are a number of built in functions in SQL that can be used in a select statement
• Because of how SQL handles a dataset, these functions work over the entire dataset
• Functions:
– Count: Counts Values
– Sum: Sums Values
– Max: Identifies the largest value
– Min: Identifies the smallest value
– Mean: Averages the values
Read more at www.cognigencorp.com/perspective/tipsNtricks.pub/1/PROC%20SQL%20Talk_12_.ppt –
SAS SQL
Introduction to Proc SQL
AN INTRODUCTION TO PROC SQL®
PROC SQL: When and How to Use It?
Proc SQL – A Primer for SAS Programmers
Understanding PROC SQL
Creating Macro Variables with Proc SQL
DATA Step vs. PROC SQL: What’s a neophyte to do?
Effective Use of SQL in SAS Programming
Variable List Short-Cuts in PROC SQL
Ten Best PROC SQL Tips and Techniques
Undocumented and Hard-to-Find PROC SQL C2 AE_Features
Variable List Short-Cuts in PROC SQL
Exploring the World of PROC SQL® Joins
Using PROC SQL to Create Ad Hoc Reports
CREATING MACRO VARIABLES VIA PROC SQL
PROC SQL for DATA Step Die-hards
Calculating Changes and Differences Using PROC SQL —With Clinical Data Examples
Validating Data Via PROC SQL
2 comments:
hi..
the link for top ten tips and tricks is not working. please arrange the right one.
-Karthik
working.. now....
Post a Comment