Wednesday, May 7, 2014

Proc SQL and equievlent in Data Step, Fuzzy match

1. TOP 10 FUNCTIONS FOR THE SQL PROCEDURE IN SAS

http://www.sasanalysis.com/2011/01/top-10-most-powerful-functions-for-proc.html


2. Fuzzy match
http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000245949.htm
http://www2.sas.com/proceedings/sugi25/25/cc/25p086.pdf
http://www.nesug.org/Proceedings/nesug11/ap/ap07.pdf

3. PROC SQL for DATA Step Die-hards
http://www2.sas.com/proceedings/forum2008/185-2008.pdf

4. PROC SQL: From SELECT to Pass-Through SQL
http://www.scsug.org/SCSUGProceedings/2010/Schacherer_2/PROC_SQL_%20From_SELECT_to_Pass-Through_SQL.pdf

5. 集合操作:inner join、left join、right join、full outer join、union、union all
http://blog.diyiye.com/?post=10

6. Queries, Joins, and WHERE Clauses, Oh My!! Demystifying PROC SQL
http://analytics.ncsu.edu/sesug/2012/HW-06.pdf

7. 临床研究SAS高级编程--SAS SQL
http://www.math.pku.edu.cn/teachers/lidf/course/gradsas/09.0%20SQL.pdf

8. Intermediate PROC SQL
http://www2.sas.com/proceedings/sugi23/Advtutor/p35.pdf

No comments:

Post a Comment