Date:         Thu, 18 Dec 2008 12:56:39 -0500
Reply-To:     Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Subject:      Re: Median of column

what does "throw out" mean? Delete the obs? If that is the case (and if
you don't need the median), you might use:

data test;
infile cards missover;
input id $ value;
cards;
A 5
B 100
C 0
D 6
G 7
H 8
Y 9
U 11
;
run;

proc sort;
  by value;
run;

data new;
  set test end=fin;
  if _n_=1 or fin then delete;
run;

Gerhard




On Thu, 18 Dec 2008 11:41:13 -0600, Mary <mlhoward@AVALON.NET> wrote:

>Proc univariate will show the median value (50% quartile) and also will
>show you the extreme values:
>
>data test;
>infile cards missover;
>input id $ value;
>cards;
>A 5
>B 100
>C 0
>D 6
>G 7
>H 8
>Y 9
>U 11
>;
>run;
>
>proc univariate data=test;
>var value;
>run;
>
>-Mary
>
>
>----- Original Message -----
>From: sdlenter
>To: SAS-L@LISTSERV.UGA.EDU
>Sent: Thursday, December 18, 2008 11:30 AM
>Subject: Median of column
>
>
>I am trying to claculate the meadian of the column not each row...
>example
>A   5
>B   100
>C   0
>D   6
>G   7
>H    8
>Y   9
>U   11
>
>Maybe it's not median that i need to calculate but I need to throw out
>highest values and lowest values...
>
>Thanks