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


Upload your resume securely at https://www.dwsimpson.com
to be contacted when new jobs meet your skills and objectives.


Reply
 
Thread Tools Search this Thread Display Modes
  #191  
Old 09-23-2014, 12:25 PM
Childish Gambino's Avatar
Childish Gambino Childish Gambino is offline
Member
SOA
 
Join Date: Jul 2014
Posts: 31,766
Default

Quote:
Originally Posted by LICENSED TO ILL View Post
do you own a personal sas license? I saw it costs like $8,700
if you are in school, I believe you can get an educational license on the cheap.

but yes, this program was not designed for individuals.
__________________
Quote:
Originally Posted by pete5383 View Post
if you supported Trump, you should be profoundly embarrassed by your poor decision making.
Reply With Quote
  #192  
Old 09-24-2014, 11:53 PM
Pujols4Prez's Avatar
Pujols4Prez Pujols4Prez is offline
Member
SOA AAA
 
Join Date: Jul 2008
Posts: 13,872
Default

Quote:
Originally Posted by LICENSED TO ILL View Post
do you own a personal sas license? I saw it costs like $8,700
Company has a license. They quoted us a mainframe price and it was way high.
__________________
Hardwork is the crutch of the talent-less.

Quote:
Originally Posted by Statatak View Post
what's a JAS
Reply With Quote
  #193  
Old 09-25-2014, 12:59 AM
SpaceActuary's Avatar
SpaceActuary SpaceActuary is offline
Member
 
Join Date: Apr 2010
College: Drake U
Posts: 602
Default

Quote:
Originally Posted by Childish Gambino View Post
but yes, this program was not designed for individuals.
IFYP.

SAS has the most broken, bolt-on syntax of any language I've used. It makes VBA look elegant.

But alas! That's what we've got.
__________________
And all this science, I don't understand; It's just my job five days a week...a rocket man, a rocket man...

"I'm from Iowa. I only work in space." - Adm. James T. Kirk
Reply With Quote
  #194  
Old 09-25-2014, 01:42 PM
Childish Gambino's Avatar
Childish Gambino Childish Gambino is offline
Member
SOA
 
Join Date: Jul 2014
Posts: 31,766
Default

Quote:
Originally Posted by SpaceActuary View Post
IFYP.

SAS has the most broken, bolt-on syntax of any language I've used. It makes VBA look elegant.

But alas! That's what we've got.
Interesting. I'm so used to it that I probably don't even see this. And I know several other languages.



Anyway, question for today. I have a column of numbers and I just want to add a second column that tells me what percentile that number is. so 250 should be ~90th percentile. I can think of a 4-step solution but I am assuming that SAS can just do this somehow.
__________________
Quote:
Originally Posted by pete5383 View Post
if you supported Trump, you should be profoundly embarrassed by your poor decision making.
Reply With Quote
  #195  
Old 09-25-2014, 02:35 PM
Ron Weasley's Avatar
Ron Weasley Ron Weasley is offline
Member
CAS AAA
 
Join Date: Oct 2001
Studying for naught.
Favorite beer: Butterbeer
Posts: 8,623
Default

Quote:
Originally Posted by SpaceActuary View Post
IFYP.

SAS has the most broken, bolt-on syntax of any language I've used. It makes VBA look elegant.

But alas! That's what we've got.
Yes, and it is the "best of class".

Quote:
Originally Posted by Childish Gambino View Post
Interesting. I'm so used to it that I probably don't even see this. And I know several other languages.



Anyway, question for today. I have a column of numbers and I just want to add a second column that tells me what percentile that number is. so 250 should be ~90th percentile. I can think of a 4-step solution but I am assuming that SAS can just do this somehow.
Look into proc rank with OUT= and PERCENT options.
__________________
“Fantasy is escapist, and that is its glory. If a soldier is imprisioned by the enemy, don't we consider it his duty to escape?. . .If we value the freedom of mind and soul, if we're partisans of liberty, then it's our plain duty to escape, and to take as many people with us as we can!”
― J.R.R. Tolkien
Reply With Quote
  #196  
Old 09-25-2014, 05:08 PM
Childish Gambino's Avatar
Childish Gambino Childish Gambino is offline
Member
SOA
 
Join Date: Jul 2014
Posts: 31,766
Default

Quote:
Originally Posted by Ron Weasley View Post
Yes, and it is the "best of class".



Look into proc rank with OUT= and PERCENT options.
Perfect! Thanks!
__________________
Quote:
Originally Posted by pete5383 View Post
if you supported Trump, you should be profoundly embarrassed by your poor decision making.
Reply With Quote
  #197  
Old 03-03-2015, 11:17 AM
sweetiepie sweetiepie is offline
Member
SOA
 
Join Date: Apr 2007
Location: 666 desdemona
Favorite beer: porters
Posts: 8,619
Blog Entries: 81
Red face

:
Quote:
Originally Posted by SpaceActuary View Post
IFYP.

SAS has the most broken, bolt-on syntax of any language I've used. It makes VBA look elegant.

But alas! That's what we've got.
Proc; data;(drop=),,;/options;,,tables;formchar;vars; format((informat(date.7.2)))qntldef=2:Out=Outest=; Run;run;quit;Endrsubmit;

Last edited by sweetiepie; 03-03-2015 at 11:22 AM..
Reply With Quote
  #198  
Old 03-03-2015, 11:27 AM
BassFreq's Avatar
BassFreq BassFreq is offline
Member
CAS
 
Join Date: Jun 2003
Location: Chicago
Studying for all eternity
Favorite beer: Duff
Posts: 1,716
Blog Entries: 2
Default

Quote:
Originally Posted by sweetiepie View Post
:
Proc; data;(drop=),,;/options;,,tables;formchar;vars; format((informat(date.7.2)))Out=Outest=;Run;run;qu it;Endrsubmit;
Code:
Proc;
    -
    10
ERROR 10-205: Expecting the name of the procedure to be executed.
ERROR: Undeclared array referenced: format.
ERROR 180-322: Statement is not valid or it is used out of proper order.
ERROR 68-185: The function INFORMAT is unknown, or cannot be accessed.
ERROR 386-185: Expecting an arithmetic expression.
ERROR sweetiepie: All your base SAS are belong to us.
ERROR 201-322: The option is not recognized and will be ignored.
ERROR 76-322: Syntax error, statement will be ignored.
WARNING 14-169: Assuming the symbol QUIT was misspelled as qui.
ERROR 180-322: Statement is not valid or it is used out of proper order.
__________________
If at first you don't succeed, you have one data point.
Res ipsa loquitur, sed quid in infernos dicet?
Reply With Quote
  #199  
Old 05-19-2015, 12:55 PM
Pujols4Prez's Avatar
Pujols4Prez Pujols4Prez is offline
Member
SOA AAA
 
Join Date: Jul 2008
Posts: 13,872
Default

Alright, this is probably a simple question but I am getting stumped. I am using the Univariate procedure to fit some distributions. The distribution is actually just a stream of cashflows so when I am fitting a distribution, I wan to display the cashflow and the different distributions in a plot. The histogram option, however, sets the x-axis as the cashflow values and the y-axis you can set to count or percent. Does anyone know how I could set up the histogram to have the cashflow values on the y-axis and the years (these are annual cashflows) on the x-axis? TIA.
__________________
Hardwork is the crutch of the talent-less.

Quote:
Originally Posted by Statatak View Post
what's a JAS
Reply With Quote
  #200  
Old 05-19-2015, 01:36 PM
BassFreq's Avatar
BassFreq BassFreq is offline
Member
CAS
 
Join Date: Jun 2003
Location: Chicago
Studying for all eternity
Favorite beer: Duff
Posts: 1,716
Blog Entries: 2
Default

I think that cannot be done in proc univariate. To get years in the x-axis, you would have to say "histogram years;". Then the only way to get the cashflows in would be to use them as a weight or frequency, but then you would have to ignore all negative cash flows.

Is a histogram of cash flows really what you're looking for?
__________________
If at first you don't succeed, you have one data point.
Res ipsa loquitur, sed quid in infernos dicet?
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 06:33 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.52707 seconds with 10 queries