Turn on suggestions

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

Showing results for

- Home
- /
- Analytics
- /
- Stat Procs
- /
- The mean excess plot in SAS

Options

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

🔒 This topic is **solved** and **locked**.
Need further help from the community? Please
sign in and ask a **new** question.

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

Posted 04-16-2018 11:13 AM
(1916 views)

How could we create a mean excess plot (Hill estimator, etc.) in SAS ?

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

If you already know how to generate the X and Y variables in the plot from the data and the location of the dashed line, then you can create the plot as follows:

```
title "Mean excess plot";
proc sgplot data=Have;
scatter x=X y=Y;
refline 20 / axis=x lineattrs=(pattern=dash);
run;
```

If your question is not about how to CREATE the plot but how to COMPUTE the values for the plot, then we'll need a reference and an explanation of the two quantities in the graph. A "reference" mensa a link to a paper or web site that explains the details that are required to understand how to generate the plot.

3 REPLIES 3

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

Please provide a link to the plot and some context about where it is encountered or what it shows.

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

I mean this plot :

(mean excess plot form extreme value theory)

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

If you already know how to generate the X and Y variables in the plot from the data and the location of the dashed line, then you can create the plot as follows:

```
title "Mean excess plot";
proc sgplot data=Have;
scatter x=X y=Y;
refline 20 / axis=x lineattrs=(pattern=dash);
run;
```

If your question is not about how to CREATE the plot but how to COMPUTE the values for the plot, then we'll need a reference and an explanation of the two quantities in the graph. A "reference" mensa a link to a paper or web site that explains the details that are required to understand how to generate the plot.

**Don't miss out on SAS Innovate - Register now for the FREE Livestream!**

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

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.