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

DW Simpson Global Actuarial & Analytcs Recruitment
Download our 2016 Actuarial Salary Survey
now with state-by-state salary information!


Reply
 
Thread Tools Display Modes
  #1  
Old 12-18-2006, 07:07 AM
ACCtuary's Avatar
ACCtuary ACCtuary is offline
Member
SOA
 
Join Date: Oct 2001
Location: Montgomery County, PA (Phila area)
Studying for none
College: MIT
Favorite beer: Sam Adams
Posts: 6,498
Lightbulb Simple SAS Questions

Tom - can we make this a sticky?

I just wanted people to know where they can find some answers to simple
SAS questions. Not that I mind helping, but there are so many places to search for SAS answers.

One issue is that there's so much help that new users tend to get overwhelmed early.

Getting Started from Scratch

If you're not working for a company, and wish to learn SAS, I would suggest plunking down the $125 ($100 if you buy it on sale) and buying the SAS learning edition. It's full featured enough to learn from - data sets are limited to 1500 observations, yet the system includes some good add-ons (SAS/STAT, SAS/QC, SAS/ETS) so you can learn beyond the base package. It even comes with its own book.

Resources from the SAS Institute (needs updating, as they have reorganized. These links are not guaranteed to work, but I will update them in late May)

To get quick answers, I would try in this order:

Examples of SAS Code : Definitely check this out if you've read the documentation and you want to see how the code is actually used. You can cut and paste right into your own code.

SAS Documentation - In addition to being a reference manual, there is also a "Concepts" manual here that deserves a full reading.

http://support.sas.com - Main SAS Support Page

And don't forget live help. If your company has licensed SAS, support should be available.

Outside Resources

The SAS-L list (registration required to post, none to browse)

These should get you past most beginner issues.

Update! 7/22/08

There is an online forum that seems to be well populated at

http://support.sas.com/forums/index.jspa

There is not, however, any reef there.


Intermediate Questions

The websites from various SAS user groups have their proceedings online. Many SAS Questions concern the reading of data in various formats. The INPUT statement has many options, and requires some patience to master.

Here's a Beginner's Guide to the Input Statement

that answers many questions that have been asked on actuarialoutpost.

Do a search at SAS Global Forum Online Proceedings to find other topics of interest.

Of course, the SAS user community has a culture of being helpful, so you'll probably get your question answered even if you didn't RTFM (read the manual).

SAS Users Groups

If you use SAS reasonably frequently - or your SAS usage will extend across several projects, consider supporting your local and regional SAS Users Groups. A Google search of "SAS User Group" should turn up the ones appropriate for your area.

Finally....

Always include the version of SAS you are using with any question that you ask anybody in the broader SAS community. Even if it's the same one you asked about two weeks prior

Update! 1/1/08

www.lexjansen.com - Has links to many regional SAS papers
www.codecraftersinc.com - The website of an experienced SAS consultant.

Get a Date!

Q: Why is 1/1/60 the zero point for SAS Dates?
A: http://support.sas.com/community/new...der/dates.html

Some good resources for SAS Dates:

http://www2.sas.com/proceedings/forum2008/168-2008.pdf
__________________
Sticks and Stones may break my bones, but Markov Chains excite me.

Last edited by ACCtuary; 07-22-2008 at 10:16 AM..
Reply With Quote
  #2  
Old 12-19-2006, 02:43 PM
Tom's Avatar
Tom Tom is offline
Actuarial Outpost Administrator
Contact me: Send me a PM
or email me
tom.troceen@dwsimpson.com
CAS SOA COPA
 
Join Date: Jan 1987
Location: Sitting in front of a red button w/ your name on it
College: FSU ActSci Alumni
Favorite beer: Coors Light, PBR, New Castle, Root, Sapporo Reserve
Posts: 10,656
Blog Entries: 7
Default

Quote:
Originally Posted by ACCtuary View Post
Tom - can we make this a sticky?
You bet?

Thanks for the good info
__________________
Questions? Contact me at tom@actuarialoutpost.com or send me a PM here.
Reply With Quote
  #3  
Old 12-30-2006, 06:51 PM
1695814's Avatar
1695814 1695814 is offline
Member
SOA AAA
 
Join Date: Aug 2002
Studying for GED
Favorite beer: Root
Posts: 32,729
Default

Thanks, ACCtuary! TTIA!
Reply With Quote
  #4  
Old 03-04-2007, 01:23 AM
jandoval jandoval is offline
Member
 
Join Date: Aug 2005
Posts: 237
Default

This whole site is pretty good for people starting out with sas:

http://www.ats.ucla.edu/stat/sas/


This portion is especially good for absolute beginners:

http://www.ats.ucla.edu/stat/sas/modules/default.htm
Reply With Quote
  #5  
Old 06-08-2007, 01:30 PM
ACCtuary's Avatar
ACCtuary ACCtuary is offline
Member
SOA
 
Join Date: Oct 2001
Location: Montgomery County, PA (Phila area)
Studying for none
College: MIT
Favorite beer: Sam Adams
Posts: 6,498
Default

I need to have a section on importing to and exporting from Excel. The issue is that this area is changing really fast. It varies greatly depending on what SAS products you have licensed. At the most recent SAS Global Forum, somebody outlined a .NET based approach to Excel that seems promising.

I'm not sure how far along it is in development, but soon you will be able to talk to SAS via pull down menus in Excel, again assuming your company isn't cheap and buys the requried licenses.
__________________
Sticks and Stones may break my bones, but Markov Chains excite me.
Reply With Quote
  #6  
Old 01-28-2008, 11:25 AM
Actuarialsuck Actuarialsuck is offline
Member
 
Join Date: Sep 2007
Posts: 6,078
Default SAS Question

I'm not sure if this question makes sense but here goes.

Assuming I have a dataset that lists Member ID as well as 2 columns for Member Start Date and Member End Date, however those 2 columns are not really the Start and End dates. For every month the Member is active, it will list the starting and end date of that month. So for example (eliminating days), for a member active for the first 3 months in 2007 it would say:

Member Start Date End Date
1 200701 200701
1 200702 200702
1 200703 200703

What I want to create is a table with the "true" start and end dates so for that Member, the output should be

Member Start Date End Date
1 200701 200703

Thank you for any help
Reply With Quote
  #7  
Old 01-28-2008, 11:44 AM
Esteban's Avatar
Esteban Esteban is offline
Member
CAS
 
Join Date: Dec 2006
Location: Québec, Canada
Studying for wine puchases!
Favorite beer: Leffe Brune, Duvel, St-Ambroise
Posts: 33
Default

It is a fairly easy thing do. Other variations would certainly do the trick.

Code:
proc sort data=...;
by Member_ID Start_Date;

data ...;
set ...;
by Member_ID Start_Date;

retain True_Start_Date;  *to keep first Start_Date;
if first.Member_ID then True_Start_Date=Start_Date; 

if last.Member_ID;   *to keep only the last record for each member_id;
True_End_Sate=End_Date;
drop Start_Date End_Date;
run;
Reply With Quote
  #8  
Old 01-28-2008, 04:22 PM
Actuarialsuck Actuarialsuck is offline
Member
 
Join Date: Sep 2007
Posts: 6,078
Default

Thank you very much Esteban
Reply With Quote
  #9  
Old 01-28-2008, 04:54 PM
T-roy's Avatar
T-roy T-roy is offline
Member
SOA
 
Join Date: May 2002
Favorite beer: Lagunitas Sucks
Posts: 8,534
Blog Entries: 1
Default

I also have "The Little SAS Book" by Delwiche and Slaughter. It is nice to have this as a reference, although it is kinda vague and pretty basic.
__________________
Spoiler:
Quote:
Originally Posted by win diesel View Post
No one wants to work anymore. So anyone that does, I say give them the right. /thread
Quote:
Originally Posted by ShebaPoe View Post
You are the activities you do. If you do boring, monotonous, unchallenging work, then, well, that's what you become.
Quote:
Originally Posted by ORLYLOL View Post
Beer is ****ing amazing
Quote:
Originally Posted by win diesel View Post
I'd rather talk to peons. That's why I hang out here imo
Reply With Quote
  #10  
Old 04-21-2008, 08:18 AM
Reflection's Avatar
Reflection Reflection is offline
Member
SOA
 
Join Date: Mar 2005
Location: here. in my head
Studying for Nothing!!!
Posts: 807
Default

I have what should be a simple question...

In the past, I've always had a version of SAS running locally on my PC. So if I needed to transfer a file from my hard drive, that was simple, I could even use the drop-down menus. Now I am running SAS on a server. I'd like to transfer a table in Access over to the server - is there any good way to do this in SAS?

TIA!
Reply With Quote
Reply

Thread Tools
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 10:26 AM.


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