BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Ferdz
Fluorite | Level 6

Hi!

I'm just wondering if there is any other way of extracting "robust means" and "robust sigmas" of multiple units/rows, other than from individual Distribution >> Summary Statistics.

I'm looking on a tabulated form similar to Cols >> Columns viewer >> Summary statistics

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Ferdz
Fluorite | Level 6

Thanks @PaigeMiller 

I figured there is no other way but to do the computation.

1.  Quartiles can be enabled in Summary Statistics;  Columns View >>> Show Quartiles

      Will Show MEDIAN, LOWER QUARTILE and UPPER QUARTILE

2. From here;

      Robust mean = Median

      Robust Std Dev = (Upper Quartile - Lower Quartile)/1.35

View solution in original post

4 REPLIES 4
Ferdz
Fluorite | Level 6

Sample from Columns Viewer

Columns viewer Mean SDColumns viewer Mean SD

PaigeMiller
Diamond | Level 26

PROC UNIVARIATE can compute trimmed means and robust estimates of scale for columns (variables) in a SAS data step.

 

I am not aware of a way to do this for "multiple units/rows", but you could transpose your rows into columns and then run PROC UNIVARIATE.

--
Paige Miller
Ferdz
Fluorite | Level 6

Thanks @PaigeMiller 

I figured there is no other way but to do the computation.

1.  Quartiles can be enabled in Summary Statistics;  Columns View >>> Show Quartiles

      Will Show MEDIAN, LOWER QUARTILE and UPPER QUARTILE

2. From here;

      Robust mean = Median

      Robust Std Dev = (Upper Quartile - Lower Quartile)/1.35

PaigeMiller
Diamond | Level 26

@Ferdz said:

there is no other way...

But there are other ways to do this in SAS. PROC UNIVARIATE can compute robust means and robust variances, which are different than what you explain.

--
Paige Miller

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 2651 views
  • 2 likes
  • 2 in conversation