topic Re: Enterprise Guide proc sql find 3 min values in SAS Enterprise Guide

Enterprise Guide proc sql find 3 min values

lyna123 — Mon, 15 Oct 2018 16:02:41 GMT

Hi,

I have a table with 45 stores and their total sales. I need to find the stores with the 3 worst sales.

I know I can sort the values ascending and then deduct the last 3 but I wonder if there is a way to find the last 3 directly. when I use de min, its only for one value, how do we do to find the 3 min?

Thank you,

Lyna

Re: Enterprise Guide proc sql find 3 min values

novinosrin — Mon, 15 Oct 2018 16:05:56 GMT

How about proc rank?

You could filter the ranked variable to your needs.

Re: Enterprise Guide proc sql find 3 min values

ballardw — Mon, 15 Oct 2018 20:06:40 GMT

Any particular reason why Proc SQL must be used? Almost anything that involves order is more difficult in SQL. Did you mean to say sort ASCENDING and keep the first three results (obs=3)?

Proc Means can do this depending on how many other variables need to be in the output in a single step.

Re: Enterprise Guide proc sql find 3 min values

SASKiwi — Mon, 15 Oct 2018 23:26:38 GMT

PROC UNIVARIATE does this too:

https://documentation.sas.com/?docsetId=procstat&docsetTarget=procstat_univariate_examples03.htm&docsetVersion=9.4&locale=en