topic Limit analysis to the following subsection of rows.... in SAS Programming

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

NKormanik — Sat, 23 May 2020 07:25:40 GMT

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

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

Kurt_Bremser — Sat, 23 May 2020 08:03:29 GMT

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

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

NKormanik — Sat, 23 May 2020 09:05:55 GMT

@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