Monday, January 9, 2012

Sign Up Newsletter

You can sign up our newsletter here.

Wednesday, January 4, 2012

Contact Information

I can be contacted at sasdataguru@gmail.com.

Thank you!

Sign up our newsletter



Free Google Analytics Consulting Services

Google Analytics Consulting Service
We are pleased to announce that SAS Data Guru has started to offer Google Analytics Services to the public. It is free!

Services include:

1. Set up Google Analytics
2. Tutorial on Report Utlization
3. Search Engine Optimization
4. Channel Marketing Campaign
5. HTML Customization for Advanced Features

Click here to contact us.




Saturday, October 22, 2011

Wednesday, October 19, 2011

Google Analytics Consulting Service

We are pleased to announce that SAS Data Guru has started to offer Google Analytics Services to the public.

Services include:

1. Set up Google Analytics
2. Tutorial on Report Utlization
3. Search Engine Optimization
4. Channel Marketing Campaign
5. HTML Customization for Advanced Features

Click here to contact us.

Please contact us at sasdataguru@gmail.com for more details.






Saturday, October 8, 2011

Key Steps for Doing Multiple Regression

1. Build Model Using R2 or Forwarding Method
2. Check Residual Plot
3. Check Multicollinearity

Sunday, October 2, 2011

Busting Loose From The Money Game

Dear readers, if you learn SAS because you want to make more money in your life, please pause and take a look at this book:

Busting Loose From the Money Game: Mind-Blowing Strategies for Changing the Rules of a Game You Can't Win by Robert Scheinfeld

Saturday, October 1, 2011

What is Longitudinal Study?

"Longitudinal studies are defined as studies in which the outcome variable is repeatedly measured; i.e. the outcome variable is measured in the same individual on several different occasions. In longitudinal studies the observations of one individual over time are not independent of each other, and therefore it is necessary to apply special statistical techniques, which take into account the fact that the repeated observations of each individual are correlated. The definition of longitudinal studies(used in this book) implicates that statistical techniques like survival analyses are beyond the scope of this book. Those techniques basically are not longitudinal data analysis techniques because (in general) the outcome variable is an irreversible endpoint and therefore strictly speaking is only measured at one occasion. After the occurrence of an event no more observations are carried out on that particular subject."

Excerpt from Applied Longitudinal Data Analysis for Epidemiology, A Practical Guide by Jos W. R. Twisk

Friday, September 9, 2011

How to Memorize p-value

When it comes to test hypotheses, nothing is more important than p-value. If you have hard time to understand or memorize the use of p-value. Here is a simple way to remember it. P-value is the probability that the null hypothesis is true. When this value is too small and below a pre-set threshold, we can confidently reject the null hypothesis. This threshold is called the significant level. This value is set by the investigator and normally is 0.05 or 0.01.

Tuesday, August 16, 2011

PROC SQL Like Statement Case Problem


proc sql;
  create table a1 as
  select *
 from a
where customer like '%Jane%'
; quit;

proc sql;
  create table a2 as
select *
from a
where customer like '%Jane%'
and visit_dte between '01jan2001:00:00:00'dt and '31jan2001:00:00:00'
; quit;

A String with Quote - Like Statement




proc sql;
  create table a1 as
  select *
  from retail
  where store_name like '%MAC''Y%'
; quit;