Read XLS with data starts on 3rd row, and column names on 2nd row

proc import file='C:\Users\procx\sample.xls'

        out=test dbms=xls replace;

        sheet=disposition;

        namerow=2;

        startrow=3;

        getnames=yes;

run;

Get around ‘WARNING: Fisher's exact test is not computed when the total sample size exceeds 32767.’

Fisher's Exact test can be memory and computation extensive when the sample size is large. For the large sample size problem, you can use Monte-Carlo estimates of the exact p-value to get around the issue. For example,

exact fisher /mc;

More details of the MC option can be found here -

http://support.sas.com/documentation/cdl/en/statug/67523/HTML/default/viewer.htm#statug_freq_syntax03.htm#statug.freq.freqexfisher

Apply color to PROC REPORT

Highlight a row:

 

compute __stresc;

  if index(__stresc,'>') then call define(_row_,"style","style={backgroundcolor=red}");

endcomp;

Highlight a cell:

 

compute __stresc;

   if index(__stresc,'>') then call define(_col_,"style","style={color=red}");

endcomp;

Color a row:

compute __stresc;

   if index(__stresc,'>') then call define(_row_,"style","style={color=red}");

endcomp;

Dixon's Q test for outlier identification

Click Here
And Here
Here

Learn PK/PD

This is a good blog!

How to perform a fuzzy match using SAS functions

Click Here