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

Search Actuarial Jobs by State @ DWSimpson.com:
AL AK AR AZ CA CO CT DE FL GA HI ID IL IN IA KS KY LA
ME MD MA MI MN MS MO MT NE NH NJ NM NY NV NC ND
OH OK OR PA RI SC SD TN TX UT VT VA WA WV WI WY

View Poll Results: Which programs do you use day to day?
SAS 10 43.48%
Python 5 21.74%
R 8 34.78%
None of them because I have 42 other things to do 5 21.74%
Multiple Choice Poll. Voters: 23. You may not vote on this poll

Reply
 
Thread Tools Search this Thread Display Modes
  #11  
Old 09-12-2019, 03:04 PM
DjPim's Avatar
DjPim DjPim is offline
Member
SOA
 
Join Date: Nov 2015
Location: SoCal
Posts: 595
Default

Quote:
Originally Posted by NormalDan View Post
Or SQL or SAS, just not access
At first I was excited to find the 'sqldf' package in R to write SQL queries, then realized with 'dplyr' I could do all the same things but a lot faster and a lot more customizeable. That was a very happy day.
__________________
Quote:
Originally Posted by Dr T Non-Fan View Post
"Cali" SMH.
Reply With Quote
  #12  
Old 09-19-2019, 01:49 AM
Sheffey Sheffey is offline
Member
SOA
 
Join Date: Jun 2014
Posts: 356
Default

Can sqldf in R do queries that are as complex as a SAS proc sql?
Reply With Quote
  #13  
Old 09-19-2019, 03:04 AM
Marcie's Avatar
Marcie Marcie is offline
Member
CAS
 
Join Date: Feb 2015
Posts: 9,692
Default

Quote:
Originally Posted by Sheffey View Post
Can sqldf in R do queries that are as complex as a SAS proc sql?
Both of those are just ways of implementing SQL in another language, so I don't see why it couldn't, but there are other (better) approaches than sqldf in R.

Interestingly, some years ago folks where I work ran tests to show that PROC SQL runs faster than some native SAS DATA steps.

In contrast, I've seen benchmarking tests that show sqldf is one of the slowest ways of working with data in R. By a lot.
Reply With Quote
  #14  
Old 09-19-2019, 03:05 AM
Marcie's Avatar
Marcie Marcie is offline
Member
CAS
 
Join Date: Feb 2015
Posts: 9,692
Default

Quote:
Originally Posted by DjPim View Post
At first I was excited to find the 'sqldf' package in R to write SQL queries, then realized with 'dplyr' I could do all the same things but a lot faster and a lot more customizeable. That was a very happy day.
I'm wondering if I should tell you about 'data.table' ... [emoji848]
Reply With Quote
  #15  
Old 09-19-2019, 11:06 AM
DjPim's Avatar
DjPim DjPim is offline
Member
SOA
 
Join Date: Nov 2015
Location: SoCal
Posts: 595
Default

Oh, I know about and use data.table all the time. My reference to sqldf was from when I first started with R, and I would never, ever recommend anyone use that now. I think the only exception was something I was reading about writing pass-through queries with ODBC connections, but I didn't look into it enough to test anything or see other methods.
__________________
Quote:
Originally Posted by Dr T Non-Fan View Post
"Cali" SMH.
Reply With Quote
  #16  
Old 09-19-2019, 11:26 AM
BG5150's Avatar
BG5150 BG5150 is offline
Member
Non-Actuary
 
Join Date: Jan 2009
Favorite beer: the one you're buying me
Posts: 22,300
Default

I just do everything in Turbo Pascal on my IBM PS/2.

On 3.5" floppies. No hard drives for this guy...
Reply With Quote
  #17  
Old 09-19-2019, 07:50 PM
Sheffey Sheffey is offline
Member
SOA
 
Join Date: Jun 2014
Posts: 356
Default

Quote:
Originally Posted by Marcie View Post
Both of those are just ways of implementing SQL in another language, so I don't see why it couldn't, but there are other (better) approaches than sqldf in R.

Interestingly, some years ago folks where I work ran tests to show that PROC SQL runs faster than some native SAS DATA steps.

In contrast, I've seen benchmarking tests that show sqldf is one of the slowest ways of working with data in R. By a lot.
This is a pity because it makes transferability of code from SAS to R a tad harder, I would guess. Going from proc sqls in SAS to sqldf in R is no big deal. But from proc sqls in SAS to whatever else there is...
Reply With Quote
  #18  
Old 09-19-2019, 07:51 PM
Sheffey Sheffey is offline
Member
SOA
 
Join Date: Jun 2014
Posts: 356
Default

Quote:
Originally Posted by BG5150 View Post
I just do everything in Turbo Pascal on my IBM PS/2.

On 3.5" floppies. No hard drives for this guy...
Why not COBOL and Univac?
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 11:47 PM.


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.26796 seconds with 10 queries