Dear SAS User,
One of our favorite things to do at SSC is to talk to SAS users about how they can leverage SAS software for increased functionality and productivity. The newest way that we are doing this is with our new monthly Lunch and Learn Sessions. Our first session was a resounding success, with several hundred attendees. If you missed it, you can view it here. Our next session will be on Principles of Good System Design on August 16th.
Not only are we holding public Lunch and Learn sessions, but we can also offer complimentary, private sessions for your organization. If you are local, we can do it onsite, or we can do it is a web session. We have dozens of topics that you can choose from. This is a great way to get free SAS training for your group. If you are interested, please email me directly, and we can set up your own free session.
Thanks for Reading!
Jennifer First Director of Operations
|
Dear Miss SASsy:
Dear Miss SASsy,
I frequently upload spreadsheets from MS Excel. I use a SAS program to format, transform the data as needed, and map the data to a flat file.The first few rows contain text column headings. The column headings are useful but cause format errors during the INPUT statement. I can read the input, omit heading rows, and write data rows to a TEMP file; then read in the TEMP file with list input and formatted variables. Is there a better way? Can it be done with a single pass of the input file? The spreadsheets can be very large, pushing Excel to the limit.
Kevin F.
Send your SAS questions to Miss Sassy! Email: admin@sys-seminar.com, if your question is featured in a newsletter, we will send you a free gift! |
Automating Projects
When we do project work, especially when doing conversions, we are often doing the same operation over and over again. Quite often these tasks are done manually and take a lot of time and resources. But these repetitive tasks can typically be automated.
|
|
The SAS SQL Procedure
Lunch & Learn Webinar
On July 12th, SSC had our first Lunch & Learn webinar featuring Steven First, President of SSC. For those of you that were unable to attend this event, or had trouble logging into GotoWebinar, we have included the recorded session and link to the presentation for you to see. The next Lunch & Learn, Principles of Good System Design, is scheduled for August 16th. You can register here.
Presentation Slides
SQL Webinar
|
 | Click to Read More |
|
Receive discounts, instant updates,
SAS tips and upcoming events! (And a chance to win a FREE training class!)
|
News
Check us out at MWSUG!
September 16-18, 2012
Minneapolis, MN
Using Enterprise Guide Effectively
Thomas Miron
|
|