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
- /
- Learn SAS
- /
- Analytics U
- /
- Code behind proc genmod

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

11-06-2014 05:31 AM

Is there a way of seeing the code behind proc genmod

The reason I ask is I'm trying to understand the iterative maximum likelihood algorithm behind this procedure. In the sas documentation, an example of a poisson ditribution is used to generate paramter values for car type and car size.

Basically I want to know the precise steps of how proc genmod takes the raw data to the point where it produces the paramter estimates e.g. how it goes through each iteration etc.

This would be really helpful for my understand.

Many thanks

Message was edited by: Matthew Brophy Here is the link to a very simple example of an application of the proc genmod procedure to claims and exposure data using two factors. http://support.sas.com/documentation/cdl/en/statug/63033/HTML/default/viewer.htm#statug_genmod_sect0... What I'm looking for is to be able to replicate this outside of sas (iterations and all) in excel so I can derive the paramter estimates of, for example, -1.7643 for a large car, -1.3199 for age 1, and so on..

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

11-06-2014 12:23 PM

I think the likelihood that SAS releases its code for you to examine is zero (or even lower)

You have much more of a chance of figuring out what they did by reading the paper referenced at that link

Aitkin, M., Anderson, D., Francis, B., and Hinde, J. (1989), *Statistical Modelling in GLIM*, Oxford: Oxford Science Publications.

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

11-13-2014 03:13 PM

You are not ever going to see the code. The algorithm is well known.

By the way, I strongly recommend against using Excel for any data analysis.It is has been documented MANY times that Excel is a terrible program for statistical analysis. (I am sure some will disagree with me).

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

11-13-2014 03:23 PM

brophymj wrote:

What I'm looking for is to be able to replicate this outside of sas (iterations and all) in excel so I can derive the paramter estimates of, for example, -1.7643 for a large car, -1.3199 for age 1, and so on..

Do you like torturing yourself?

As @lvm has mentioned using Excel for analytics is like digging a tunnel to China with a spoon.

However, that being said, if you have to do something like this go to a different language. Best case purchase SAS Microsoft Add-In.

Next best, get one of the Python packages that links up to excel and find the appropriate library/package to do the analysis.