Can We Use Where in Proc Freq?

2 Answers. If you mean an output dataset, you can put a where clause directly in the output dataset options. I'm not aware of how you can accomplish this only using proc freq but you can redirect the output to a data set and then print the results.

Can you use where in Proc print?

The where statement allows us to run procedures on a subset of records. For example, instead of printing all records in the file, the following program prints only cars where the value for rep78 is 3 or greater. PROC PRINT DATA=auto; WHERE rep78 >= 3; VAR make rep78; RUN; Here is the output from the proc print.

Where do you use proc means over proc freq?

PROC MEANS is used to calculate summary statistics such as mean, count etc of numeric variables. It requires at least one numeric variable whereas Proc Freq does not have such limitation. In other words, if you have only one character variable to analyse, PROC FREQ is your friend and procedure to use.