Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Software & Technology
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions



Reply
 
Thread Tools Search this Thread Display Modes
  #31  
Old 03-08-2018, 06:02 PM
Maphisto's Sidekick's Avatar
Maphisto's Sidekick Maphisto's Sidekick is offline
Member
CAS
 
Join Date: Nov 2001
Location: South Park Genetics Lab
College: Ardnox
Favorite beer: The kind with alcohol
Posts: 2,752
Default

This is written from the perspective of P&C medium-sized commercial lines pricing:

Most used application: Citrix
2nd most used application: Excel
Next tier: Outlook, web browser
Next tier: SQL, MetaRisk, R

Some of our staff are using R in lieu of Excel for some pricing work, since the line between predictive modeling and pricing is starting to blur. My focus has been more on large accounts, so I've been abusing MetaRisk instead.
Reply With Quote
  #32  
Old 03-09-2018, 04:18 AM
furiouslugaw furiouslugaw is offline
Member
SOA
 
Join Date: Dec 2017
Studying for (???) IFM/LTAM/CorpFin
Posts: 127
Default

R/RStudio
__________________
FM P SRM IFM LTAM STAM PA
Econ CorpFin Stat

Reply With Quote
  #33  
Old 03-09-2018, 09:49 AM
BG5150's Avatar
BG5150 BG5150 is offline
Member
Non-Actuary
 
Join Date: Jan 2009
Favorite beer: the one you're buying me
Posts: 20,900
Default

the pornhub app, GTA Online (I play during lunch)
Reply With Quote
  #34  
Old 03-09-2018, 10:32 AM
Tacoactuary's Avatar
Tacoactuary Tacoactuary is offline
Member
CAS Non-Actuary
 
Join Date: Nov 2014
Location: Des Moines, IA
College: Vanderbilt, UIUC
Favorite beer: Yazoo Sue
Posts: 1,135
Default

SSMS / RStudio
__________________
ACAS 7 8 9
Reply With Quote
  #35  
Old 03-09-2018, 10:46 AM
ALivelySedative's Avatar
ALivelySedative ALivelySedative is offline
Member
CAS
 
Join Date: Dec 2013
Location: Land of the Pine
College: UNC-Chapel Hill Alum
Favorite beer: Red Oak
Posts: 2,771
Default

SAS primarily for data acquisition. We don't even have a license for the STAT package so I can't run a GLM there. Also coding in z/OS is . Thus teaching myself R in the meantime because I don't have much choice. If I knew how to get R to gain access to our internal data directly I'd definitely do that. Often find myself using SAS to produce a CSV that I can FTP via CMD to use in R.

I've mentioned this before, but my company is full of old ppl who don't know squat about what modern pricing has become. It's a super weird dynamic to have knowledge gaps going both ways. Not sure it's a great place to be professionally, but they've recently started paying me well...so there's that.
__________________
Stuff | 6 | ACAS | FCAS stuff
Reply With Quote
  #36  
Old 03-09-2018, 01:23 PM
umich umich is offline
Member
SOA AAA
 
Join Date: Mar 2016
Location: Detroit, MI
College: University of Michigan Alum
Posts: 144
Default

U.S. life company. I use GGY AXIS every day.
__________________
P FM MLC C MFE FAP APC ILA-LP
Reply With Quote
  #37  
Old 03-09-2018, 03:33 PM
AMedActuary AMedActuary is offline
Member
SOA
 
Join Date: May 2007
College: UCLA Alumni
Posts: 392
Default

Quote:
Originally Posted by panther View Post
do you have any suggestions or resources that you used to learn R?
Yes, for tidyverse (dplyr, ggplot2, etc.), you're best option is the R for Data Science book. That's the link to the online version or you can buy a physical copy from Amazon for ~$20.

There are also plenty of online vignettes like this one for dplyr. Just search "dplyr vignette" or "ggplot2 vignette" to find them. They are also listed on each package's page. Like this is dplyr's package page which lists several vignettes.

See this link for how to write SQL (and other languages) in R.

This link explains how to work with databases in RStudio.

Here
is a general introduction to Markdown which can help you author reports or presentations in RStudio.

Last edited by AMedActuary; 03-09-2018 at 03:37 PM..
Reply With Quote
  #38  
Old 03-09-2018, 03:56 PM
AMedActuary AMedActuary is offline
Member
SOA
 
Join Date: May 2007
College: UCLA Alumni
Posts: 392
Default

Quote:
Originally Posted by redearedslider View Post
This workflow intrigues me.
With that workflow, it can be chronological. I think for many people on my team, their workflow consists of the following:

1. Download data using SAS/Teradata/etc. from the data warehouse. Perhaps do some SQL manipulation afterwards.
2. Get data into Excel and add formulas for new variables, vlookups to join with other tables, etc.
3. Produce graphs in Excel.
4. Perhaps create a report in Word or presentation in PowerPoint to present to someone else.

This can all be done in R/RStudio if desired using the workflow I described. The nice thing about doing it this way is it's easy to go back and change something. Did you find a weird population that you want to exclude but didn't find it until the end? Well that's easy, just filter them out and re-run the same script on the remaining people.

The only limitation is if someone really wants an Excel file where they can change a number and immediately see the result, then I have to do a lot of the work in Excel. Also, sometimes someone may really want a PowerPoint presentation in which case I have to copy/paste graphs into PowerPoint.
Reply With Quote
  #39  
Old 03-09-2018, 04:33 PM
panther panther is offline
Member
 
Join Date: Feb 2009
Posts: 4,357
Default

Quote:
Originally Posted by AMedActuary View Post
Yes, for tidyverse (dplyr, ggplot2, etc.), you're best option is the R for Data Science book. That's the link to the online version or you can buy a physical copy from Amazon for ~$20.

There are also plenty of online vignettes like this one for dplyr. Just search "dplyr vignette" or "ggplot2 vignette" to find them. They are also listed on each package's page. Like this is dplyr's package page which lists several vignettes.

See this link for how to write SQL (and other languages) in R.

This link explains how to work with databases in RStudio.

Here
is a general introduction to Markdown which can help you author reports or presentations in RStudio.
thank you!
Reply With Quote
  #40  
Old 03-09-2018, 05:58 PM
PeppermintPatty's Avatar
PeppermintPatty PeppermintPatty is offline
Member
CAS
 
Join Date: Sep 2001
Posts: 39,311
Default

Quote:
Originally Posted by Childish Gambino View Post
Outlook and it's not even close.

Along the lines you are looking, SAS is what we use.
Yeah, Outlook, then Chrome, Internet Explorer (yes, I use both) and then Word and Adobe Acrobat.

But along the lines you are looking, I use SAS. Truth be told, since hiring an analyst, I've barely opened SAS, though.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT -4. The time now is 09:02 PM.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.25522 seconds with 11 queries