[下载]Lecture Notes: SAS Proc SQL

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

11450.rar (32.62 KB) 本附件包括：

• Seminar.Proc SQL.pdf

2005-4-5 11:58:00 上传

[下载]Lecture Notes: SAS Proc SQL

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏1 回帖

关键词：proc sql Lecture notes note ect SAS proc notes Lecture sql

Lecture Notes: SAS Proc SQL
http://www.pauldickman.com/teaching/sas/proc_sql_code_20041026.pdf

<H3>SAS Learning Module
Collapsing across observations using proc sql</H3>http://www.ats.ucla.edu/stat/sas/modules/sqlcollapse.htm

<H3>SAS Learning Module
Match merging data files using proc sql</H3>http://www.ats.ucla.edu/stat/sas/modules/sqlmerge.htm

<a href="http://www2.sas.com/proceedings/sugi29/042-29.pdf" target="_blank" ><FONT color=#551a8b>042-29: Top Ten Reasons to Use </FONT><FONT color=#cc0033>PROC</FONT><FONT color=#551a8b> </FONT><FONT color=#cc0033>SQL</FONT></A>

<a href="http://www.kellogg.northwestern.edu/researchcomputing/workshops/sql.pdf" target="_blank" ><FONT color=#cc0033>PROC</FONT><FONT color=#551a8b> </FONT><FONT color=#cc0033>SQL</FONT></A>

<P><a href="http://www.geocities.com/siliconvalley/campus/4460/knowledge/sasprog/sql.html" target="_blank" >http://www.geocities.com/siliconvalley/campus/4460/knowledge/sasprog/sql.html</A></P>
<P>Tips and Tricks about Proc SQL</P>

[此贴子已经被作者于2005-4-5 12:17:57编辑过]

<P>楼主财大的？</P>

I am in North American and can be reached at <a href="mailthanszhuchen@hotmail.com" target="_blank" >hanszhuchen@hotmail.com</A> or (204)254-2589.

<P><b><FONT color=#2b4dd5>PROC SQL
Beyond the Basics Using SAS</FONT></b></P><P>Author: Kirk Paul Lafler
Publisher: SAS Publishing
Year: 2004 Pages: 365
ISBN: 1-59047-534-8 Our price: 48.95 A thoroughgoing reference for the issues a SAS user is likely to encounter when using SQL in the SAS environment for database applications. The book covers differences between SAS SQL and ANSI SQL and includes advanced techniques that involve macro language interfaces and performance tuning options. </P><P>Contents
1. Designing Database Tables
2. Working with Data in PROC SQL
3. Formatting Output
4. Coding PROC SQL Logic
5. Creating, Populating, and Deleting Tables
6. Modifying and Updating Tables and Indexes
7. Coding Complex Queries
8. Working with Views
9. Troubleshooting and Debugging
10. Tuning for Performance and Efficiency
Glossary
From the back cover
Master the language of PROC SQL!</P><P>Get faster and better results when you use the SQL procedure with this step-by-step, example-driven guide in your hands. You will find information about implementing both American National Standards Institute (ANSI) and non-ANSI features. A broad range of SAS users including applications programmers, database designers and administrators, statisticians, and systems analysts will find techniques to enhance their data access, manipulation, and presentation prowess.</P><P>Topics examined include</P><P>Database design
An introduction to SQL, dictionary tables, and tables
Coding PROC SQL logic as well as complex queries
Working with views
Troubleshooting and debugging SQL code
Tuning for performance
With the growing popularity of databases, PROC SQL is becoming the language of choice for SAS users around the world. Intermediate and advanced users will appreciate the straightforward explanations and numerous examples. Achieve expert results with the techniques and strategies detailed in PROC SQL: Beyond the Basics Using SAS!
</P>