Limit analysis to the following subsection of rows....

[NKormanik]

I'm working with Proc Freq, but this question can extend beyond that.

How best to subset the data for the analysis one wants to do?

For instance, say there is a column of data called "Quality", and it extends from 0 to 10.  And I would like to only focus on the rows of data with Quality >= 8.0.

So in Proc Freq, ONLY focus on that subset of data.

How best to do this?

Thanks,

Nicholas Kormanik

[Kurt_Bremser · Accepted solution]

Use a WHERE Statement or a WHERE= Data Set Option.

[NKormanik]

---

@Kurt_Bremser wrote:

Use a WHERE Statement or a WHERE= Data Set Option.

---

In PROC Steps

You can use the WHERE statement with any SAS procedure that reads a SAS data set. The WHERE statement is useful in order to subset the original data set for processing by the procedure.

Odd no example was provided with a Proc.  Only Data.

Would indeed be useful to easily run Proc Freq on various sub-parts of a data set.

Thanks @Kurt_Bremser