Actuarial Outpost
 
Go Back   Actuarial Outpost > Search Forums
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions

DW Simpson
Actuarial Jobs

Visit our site for the most up to date jobs for actuaries.

Actuarial Salary Surveys
Property & Casualty, Health, Life, Pension and Non-Tradtional Jobs.

Actuarial Meeting Schedule
Browse this year's meetings and which recruiters will attend.

Contact DW Simpson
Have a question?
Let's talk.
You'll be glad you did.


Showing results 1 to 25 of 300
Search took 0.14 seconds.
Search: Posts Made By: rgreenlee
Forum: Group & Health Specialty Exam 05-17-2019, 10:53 AM
Replies: 172
Views: 14,544
Posted By rgreenlee
Exam posted: ...

Exam posted:

https://www.soa.org/education/exam-req/syllabus-study-materials/edu-multiple-choice-exam
Forum: Design and Accounting Exam 05-17-2019, 10:53 AM
Replies: 39
Views: 3,456
Posted By rgreenlee
:wave:

:wave:
Forum: Software & Technology 05-02-2019, 06:04 PM
Replies: 52
Views: 2,761
Posted By rgreenlee
Definitely like the pivot method, never used it...

Definitely like the pivot method, never used it before
Forum: Software & Technology 05-01-2019, 10:40 PM
Replies: 52
Views: 2,761
Posted By rgreenlee
The code I attempted to write earlier did not...

The code I attempted to write earlier did not work exactly as I thought it should. Below is what I meant to write and I finally had a second to run it in an actual instance of SQL Server. The top of...
Forum: Software & Technology 05-01-2019, 09:55 AM
Replies: 52
Views: 2,761
Posted By rgreenlee
How many unique mod codes are there? ...

How many unique mod codes are there?

Something like max(case when mod_code='59' then '59' else '' end) as mod_code1 could suffice if there are only a few unique mod_code s
Forum: Software & Technology 05-01-2019, 09:24 AM
Replies: 52
Views: 2,761
Posted By rgreenlee
I like the data in the format you already have...

I like the data in the format you already have because it is almost grouper model ready. I'm not sure what you will be doing with it side by side
Forum: Software & Technology 05-01-2019, 09:07 AM
Replies: 52
Views: 2,761
Posted By rgreenlee
I am going to stop editing, so the code as...

I am going to stop editing, so the code as written may not work because there might be some issue I didn't see.

But idea is:
get a list of diag1,diag2 where diag2 is the first one that comes...
Forum: Software & Technology 05-01-2019, 08:58 AM
Replies: 52
Views: 2,761
Posted By rgreenlee
Note that if you have lots of diagnosis codes,...

Note that if you have lots of diagnosis codes, you can do this process with as many left outer joins
Forum: Software & Technology 05-01-2019, 08:53 AM
Replies: 52
Views: 2,761
Posted By rgreenlee
WITH MyOrderedPairs AS ( SELECT ...

WITH MyOrderedPairs AS
(
SELECT
A.claim_sk, A.proc_code
,A.mod_code as mod_code1
,Min(ISNULL(B.mod_code,'')) as mod_code2
FROM
NeverToldMeTableName as A
LEFT OUTER JOIN...
Forum: Life Risk Management Exam 03-28-2019, 07:10 AM
Replies: 12
Views: 1,334
Posted By rgreenlee
Sorry for the necro. I found this thread...

Sorry for the necro. I found this thread searching for the thoughts of others about this topic.

I love those pens. I was wondering how they work, so I did an experiment. I wrote on a piece of...
Forum: General Actuarial 03-22-2019, 12:53 PM
Replies: 2
Views: 673
Posted By rgreenlee
What CSPAN said is true, but absent MLR, in the...

What CSPAN said is true, but absent MLR, in the scenario you describe, the actuaries would also be pricing up front for some claims to be out of network and the rest to be in network. And if there...
Forum: Group & Health Specialty Exam 03-20-2019, 05:59 PM
Replies: 1
Views: 335
Posted By rgreenlee
Spring 2007 CSP-GH #9

Exam: https://www.soa.org/files/edu/edu-mc-exam-cspgh-0507.pdf

Solution: https://www.soa.org/files/edu/edu-2007-05-csp-gh-sol.pdf

In the solution, the "Investor's target cost of capital" is...
Forum: Long-Term Actuarial Math 03-10-2019, 11:14 PM
Replies: 6
Views: 1,731
Posted By rgreenlee
I used Coaching Actuaries for MLC, and I thought...

I used Coaching Actuaries for MLC, and I thought it was excellent. I did find ADAPT useful. I first met a goal of earned level 7 for the multiple choice, and then I used the remainder of my...
Forum: Non-Actuarial Topics 03-01-2019, 10:48 AM
Replies: 24
Views: 539
Posted By rgreenlee
My vote would be for this =(

My vote would be for this =(
Forum: Non-Actuarial Topics 02-28-2019, 11:40 AM
Replies: 38
Views: 682
Posted By rgreenlee
Or, Timmy and Susan are mayflies.

Or, Timmy and Susan are mayflies.
Forum: Non-Actuarial Topics 02-28-2019, 11:39 AM
Replies: 38
Views: 682
Posted By rgreenlee
Both born on a Thursday?

Both born on a Thursday?
Forum: Careers - Employment 02-21-2019, 10:09 AM
Replies: 41
Views: 2,011
Posted By rgreenlee
If a variety of sugary fountain beverages are...

If a variety of sugary fountain beverages are provided for you, and you don't want sugar or caffeine, your options might be limited. However, you can purchase Mio (or other) water flavorings to add...
Forum: Software & Technology 02-11-2019, 10:44 PM
Replies: 20
Views: 1,160
Posted By rgreenlee
If you load your dataset into SQL table called...

If you load your dataset into SQL table called "MyDataSet" this becomes simple:

SELECT
A.AccountNumber,A.ColumnB as ColumnB1,ISNULL(B.ColumnB,'') as ColumnB2
FROM
MyDataSet AS A
LEFT OUTER...
Forum: Non-Actuarial Topics 02-11-2019, 10:22 PM
Replies: 38
Poll: Soylent
Views: 2,462
Posted By rgreenlee
PM Sent

PM Sent
Forum: Non-Actuarial Topics 02-08-2019, 05:12 PM
Replies: 38
Poll: Soylent
Views: 2,462
Posted By rgreenlee
After you try it, please post what you think...

After you try it, please post what you think about it and how long it took to receive.
Forum: Group & Health Specialty Exam 02-06-2019, 11:37 AM
Replies: 5
Views: 910
Posted By rgreenlee
I am using this study program and want to offer a...

I am using this study program and want to offer a positive review; the instructor is helpful & responsive in the discussion forum, and the documents/flash card applications are well maintained and up...
Forum: Group & Health Specialty Exam 01-28-2019, 09:36 PM
Replies: 5
Views: 910
Posted By rgreenlee
A colleague mentioned that the volume of...

A colleague mentioned that the volume of specialty material felt greater than 40% of the volume in either core or advanced.
Forum: Group & Health Specialty Exam 01-26-2019, 11:33 PM
Replies: 172
Views: 14,544
Posted By rgreenlee
This is my first fellowship exam sitting too - I...

This is my first fellowship exam sitting too - I didn't want to get in a half credit situation by taking core or advanced. A friend of mine recently passed all of the fellowship exams with TIA. So I...
Forum: Non-Actuarial Topics 01-26-2019, 04:41 PM
Replies: 43
Views: 1,239
Posted By rgreenlee
That reminds me of making the tribe a stand-in...

That reminds me of making the tribe a stand-in for God
Forum: Non-Actuarial Topics 01-26-2019, 04:35 PM
Replies: 38
Poll: Soylent
Views: 2,462
Posted By rgreenlee
:bump: because that is what we do around here....

:bump: because that is what we do around here. Bump oldass threads.

Saw them at Albertson's and picked up the vanilla cafe. I didn't really like the taste at first, but by the end of the bottle it...
Showing results 1 to 25 of 300

 

All times are GMT -4. The time now is 06:48 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, 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.39269 seconds with 7 queries