Thursday, May 8, 2014

Association Test: Proc Freq , Chi-Square Tests

1. Guido’s Guide to PROC FREQ – A Tutorial for Beginners
http://www.nesug.org/proceedings/nesug07/ff/ff07.pdf

2. Glenn Walker book “Common Statistical Methods for Clinical Research with SAS® Examples
http://www.sas.com/storefront/aux/en/spcommonstat/62004_excerpt.pdf

3. Answering the Right Question with the Right PROC

4. Statistics I: Introduction to ANOVA, Regression, and Logistic Regression
http://gendocs.ru/docs/18/17094/conv_1/file1.pdf

5. 统计检验之——卡方检验; 北京宏志中学 徐德前
http://education.ti.com/sites/CHINA/downloads/pdf/chi_square_tests_xudeqian.pdf

6. PROC FREQ IS MORE THAN JUST SIMPLY GENERATING A 2-BY-2 TABLE
http://www.lexjansen.com/wuss/2012/52.pdf

7. THE POWER OF PROC FORMAT
http://www.ats.ucla.edu/stat/sas/library/nesug00/bt3001.pdf

8.PROC FORMAT in Action
http://www2.sas.com/proceedings/sugi27/p056-27.pdf


9. PROC FORMAT – Not Just Another Pretty Face
http://www2.sas.com/proceedings/sugi30/001-30.pdf

Wednesday, May 7, 2014

Building Business Intelligence with SAS® and Google Analytics

http://support.sas.com/resources/papers/proceedings12/010-2012.pdf

http://support.sas.com/resources/papers/proceedings10/049-2010.pdf

Forecast

1. Proc Forecast

http://www.okstate.edu/sas/v8/saspdf/ets/chap12.pdf
Syntax: pg 18
STEPAR Method: not optimal but close to, and computational inexpensive

TREND=2=linear model
NLAGS>=3, 13
SLENTRY= option=significant at the level=0.20
SLSTAY=0.05=significance level 
 OUT= data set
Missing values are tolerated in the series
METHOD=EXPO


SAS functions

1. WORKING WITH SAS DATE AND TIME FUNCTIONS
http://www.ats.ucla.edu/stat/sas/library/nesug00/bt3007.pdf

2. SAS functions by example
http://www.sas.com/storefront/aux/en/spfunctionxexample/62857_excerpt.pdf

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

Friday, May 2, 2014

SAS forecast methods - Churn Management

1. Use SAS EG automatic churn management
http://www.analysisdatabase.com/descargas/ANALISIS%20DE%20ABANDONOS%20RETENCION.pdf


2.  SAS forecast methods
http://www.sascommunity.org/sugi/SUGI93/Sugi-93-67%20Little.pdf

http://www.iasri.res.in/sscnars/sas_manual/5-ts_sas_lecture.pdf
http://www.sascommunity.org/sugi/SUGI93/Sugi-93-67%20Little.pdf
http://www.nesug.org/Proceedings/nesug11/sa/sa10.pdf
http://support.sas.com/resources/papers/proceedings12/333-2012.pdf


SAS DateTime

http://analytics.ncsu.edu/sesug/2008/HOW-063.pdf

http://www.caloxy.com/papers/57-255-30.pdf

https://ciser.cornell.edu/sasdoc/saspdf/lrcon/c13.pdf