turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- SAS Programming
- /
- Base SAS Programming
- /
- How to Calculate Median and Minimum Value based on...

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

04-17-2016 11:09 AM

I have summary data.

i need to caclulate median and minimum value for those summary data.

I have other statistics values - standard deviation, variance, average.

so, how we can caclulate median and minimum value using this statistics values ?

let me know, if any questions.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to nirav351

04-17-2016 12:08 PM - edited 04-17-2016 02:51 PM

Hi @nirav351,

So, you don't have access to the original data and the only available information is standard deviation, variance (redundant) and average?

This would render the calculation impossible, except for the trivial case that variance=0. With a little more information such as the number of non-missing values (N) and a distributional assumption about the data, at best, you could obtain (possibly very rough) *estimates*.

~~Also, how does your post relate to text mining (see forum title)?~~ [Edit: In the meantime an administrator or super user has moved the thread to a more appropriate forum. Thanks!]

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to FreelanceReinhard

04-17-2016 02:53 PM

No I do not have any othet data.

##- Please type your reply above this line. Simple formatting, no

attachments. -##

##- Please type your reply above this line. Simple formatting, no

attachments. -##

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to nirav351

04-17-2016 03:44 PM

Without more info we can't help.

Given the current provided info it doesn't appear possible.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to nirav351

04-17-2016 03:48 PM

Here is an example:

```
data test;
input x @@;
dataset=ceil(_n_/5);
cards;
1 10 12 13 14
6 7 8 10 19
;
proc print data=test;
run;
proc means data=test var std mean median min;
by dataset;
run;
```

The two "datasets" (combined into one dataset TEST just to simplify the code) have 5 observations each. They have the same variance, standard deviation and mean (average), but their medians (12 vs. 8) and minimum values (1 vs. 6) differ considerably.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to nirav351

04-17-2016 09:24 PM

An important thing is what distribution your data conform to? Normal , Poisson ?