Using PROC FREQ to Export Descriptive Statistics

Using PROC FREQ to Export Descriptive Statistics 

PROC FREQ can be used to export frequencies of categorical data simply by specifying the OUT= option in the TABLES statement like this  

The resulting freqs data set contains the BY variable trt, a, b, and the cell frequency count and percentage percent variables. Row and column percentages can be added to the output data set by specifying the OUTPCT option. If you also want the totals row and column that you see in your PROC FREQ listing output, you can use ODS to export that to a data set called freqs  

Remember that if you do not want to exclude missing values from your counts or from the denominators of your percentage calculations, you need to specify the MISSING option in your TABLES statement. 

---