Replace "data_range" with the data range from column A. Replace "frequency_range" with the ranges you specified in column B. In the example, enter "=FREQUENCY(A1:A3,B1:B5)" in cell C1.

By default, PROC FREQ lists the variable values in alphabetical order. Because Eyes*Hair requests a crosstabulation table, the table rows are eye color and the table columns are hair color. A zero ...