Transcription of Proc SQL – A Primer for SAS Programmers
{{id}} {{{paragraph}}}
Example: bankruptcy
Proc SQL – A Primer for SAS Programmers
proc sql A Primer for SAS Programmers Jimmy DeFoor Citi Card Irving, Texas The Structured Query Language (SQL) has a very different syntax and, often, a very different method of creating the desired results than the SAS Data Step and the SAS procedures. Only a very thorough manual, such as the SAS Guide to the proc sql Procedure, could even begin to describe well the complete syntax and the full capabilities of proc sql . Still, there is value in presenting some of the simpler capabilities of proc sql , especially those that are more efficient or easier to code than the SAS Data Step.
The Match-Merge Syntax of Proc SQL Compared to the Data Step Proc SQL; Create Table Joined as Select a.City, b.State, b.Store, b.Year, b.Month, b.Sales,
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: