DOB=DOB-21916;

## Excel string functions

=CONCATENATE("Q",K12,"",C12)

=LEFT(L12,32)

## How to filter Excel data

Put the whole data into TABLE:

## Excel function that produces "True" or "False"

https://exceljet.net/excel-functions/excel-true-function

I tried this myself and it worked. If column C2 and D2 contain the identical values, this will return "TRUE."

=IF(C2=D2,TRUE())

## SAS PROC EXPORT

## Excel function to replicate t-test off SAS PROCs (e.g., GLIMMIX)

Phil of SAS helped me identify this function. Thank you.

T-test conducted in PROC GLIMMIX (or most likely other regression procedures) is expressed in Excel function as:

=2*(1-T.DIST( T_VALUE , DEG_OF_FREEDOM ,TRUE))

where T_value must be an absolute value of the original t-value (e.g., if -2 then 2).

This expresses CDF (cumulative distribution function), not PDF (probability density function). I will explicitly discuss what these are in the near future.

I wanted to know how much of statistical results (off PROC GLIMMIX in this case) comes from SAS's internal computation (i.e., I can't replicate results outside SAS) and how much of it can be done in Excel given what I get from SAS output.

## Excel function for statistical significance

=IF(ABS($G3)<0.001,"***",IF(ABS($G3)<0.01,"**",IF(ABS($G3)<0.05,"*",IF(ABS($G3)<0.1,"",IF(ABS($G3)>=0.1,"")))))