topic Re: How to count quartiles (Q1 and Q3) in SAS Programming

How to count quartiles (Q1 and Q3)

PatrykSAS — Tue, 23 Nov 2021 11:27:48 GMT

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
;

Re: How to count quartiles (Q1 and Q3)

AMSAS — Tue, 23 Nov 2021 11:16:18 GMT

A few pointers to help you get an answer faster

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
Provide the "want" data i.e. what you want the output data to look like
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

Re: How to count quartiles (Q1 and Q3)

PatrykSAS — Tue, 23 Nov 2021 11:30:14 GMT

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.

Re: How to count quartiles (Q1 and Q3)

PatrykSAS — Tue, 23 Nov 2021 11:37:24 GMT

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;

Re: How to count quartiles (Q1 and Q3)

Ksharp — Tue, 23 Nov 2021 12:35:47 GMT

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

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