How to count quartiles (Q1 and Q3)

[PatrykSAS]

Hello,

I need to find outliers using the Interquartile Range(IQR) but first I have to count first and the third quartile. How can I achieve this in easly way? Also I want to group my calculation. Let's say I have example data like below:

data HAVE;
input FRUIT $ COUNT;
datalines;
Apple 2
Apple 5
Apple 7
Apple 9 
Apple 19
Banana 1
Banana 3
Banana 3
Banana 5
Banana 8
;

What I've done is:

PROC MEANS data=HAVE q1 q3 ;
BY FRUIT;
VAR COUNT;
RUN;

But what I got is a proc means report, I need results in table to refer to them further like:

data WANT;
input FRUIT $ Q1 Q3;
datalines;
Apple 5 9
Banana 3 5
;

[AMSAS]

A few pointers to help you get an answer faster

1. Provide the "have" data in code form. That way we can cut/paste it into SAS and not spend time writing the code to generate the "have" data
2. Provide the "want" data i.e. what you want the output data to look like
3. Provide what you have tried so far

The description of what you want might be obvious to you, but it is unclear to me (and probably others)

Thanks

[PatrykSAS]

You are right, my post was chaotic. I corrected it on your advice. My result is in the form of a report and I would like to have it listed in the table because I want to refer to these results from quartiles 1 and 3.

[PatrykSAS · Accepted solution]

I've found solution myself. It's possible to add output function to proc means procedure.

PROC MEANS data=HAVE;
BY FRUIT;
VAR COUNT;
output out=FRUIT_CALC Q1= Q3= /autoname;
RUN;

[Ksharp]

You could get " Interquartile Range(IQR) " directly.

proc summary data=sashelp.heart nway;
class status;
VAR height;
output out=FRUIT_CALC qrange= /autoname;
RUN;