As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.
Here are some tips for How to share your SAS knowledge with your professional network.
Alaska SAS Users Group
Welcome to the Home Page for the Alaska SAS Users Group.
We hold informal brown bag lunch meetings approximately once a month in Anchorage, AK. Meetings are also available as webinars as a courtesy of the State of Alaska through GoToMeeting (R). E-mail Art Carpenter for more information or to be placed on the e-mail list for announcements about meetings.
GoToMeeting® Information ☎
AKSUG meetings are open to all SAS users via GoToMeeting
Contact Charles Utermohle at Charles.Utermohle @ alaska.gov for the current call-in information.
NEXT MEETING
November 27, 2017
- When: Monday, November 27, 2017 9:00 AM - 1:00 PM Alaska
- Where: Suite 515, Frontier Building, 3601 C Street, Anchorage AK
- When: Monday, December 4, 11, 18, 2017 9:00 AM - 1:00 PM Alaska
- Where: Suite 515, Frontier Building, 3601 C Street, Anchorage AK
- Presentation: Stump the Programmer
- Presenter: Art Carpenter
- SAS Paper: Stump the Programmer
- Presentation: Stump the Programmer
- Presenter: Art Carpenter
- SAS Paper: Stump the Programmer
- Presentation: Building and Using User Defined Formats
- Presenter: Art Carpenter
- SAS Paper: Building and Using User Defined Formats
- Presentation: Utilizing Macros to analyze data from multiple datasets
- Presenter: Diana Tersteeg, Division of Sport Fish, Alaska Department of Fish & Game
- SAS Paper: Utilizing Macros to analyze data from multiple datasets V2
- Output example: Output (Excel)
- Presentation: Stump the Programmer
- Presenter: Art Carpenter
- SAS Paper: ---
- Presentation: Using Arrays to Quickly Perform Fuzzy Merge Look-ups:Case Studies in Efficiency
- Presenter: Art Carpenter
- SAS Paper: Using Arrays to Quickly Perform Fuzzy Merge Look-ups:Case Studies in Efficiency by Art Carpenter
- Are flexible and are easily adaptable to changing data structures, data table names, and variable (field) attributes
- Reduce maintenance requirements by removing data dependencies from within the programs
- Provide significant resource savings during program/application development cycles
- Gives the end-user extensive control over program execution by using tables such as SAS data dictionaries, SAS data sets, and Excel tables
- Reduce program validation efforts by providing reusable and generalized code that can be applied to many different applications
- Establish controlled data environments, thus insuring data integrity throughout your organization
- Manual to Automatic: Changing Your Program’s Transmission
- Using_Lists_of_Macro_Variables
- Macro Array Using Arrays of Macro Variables
- Wednesday, September 17, 2014 12:00 PM - 1:30 PM (GTM-09:00) Alaska
- Presentation: Building Dynamic Applications: Part 3b
- Materials to Review: List Processing Basics: Creating and Using Lists of Macro Variables
- Presenter: Art Carpenter
- Presentation: Building Dynamic Applications: Part 3a
- Presenter: Art Carpenter
- Presentation: Building Dynamic Applications: Part 2
- Presenter: Art Carpenter
- SAS Paper:
- Presentation: Building Dynamic Applications: Part 1
- Presenter: Art Carpenter
- Presentation: Manual to Automatic: Changing Your Program’s Transmission
- Presenter: Charles J. Utermohle, PhD
- SAS Paper: Manual to Automatic: Changing Your Program’s Transmission by Art Carpenter
- Presentation: Macros and SAS/ACCESS use to streamline repetitive data analysis
- Presenters: Art Carpenter, Charles J. Utermohle, PhD, and Kate Oliver, Research Analyst III
- SAS Paper: ---
- Presentation: Before You Get Started: A Macro Language Preview in Three Parts
- Presenter: Art Carpenter
- SAS Paper: Before You Get Started: A Macro Language Preview in Three Parts
- Presentation1: Macro Functions: How to Make Them - How to Use Them
- Presenter: Art Carpenter
- SAS Paper: Macro Functions: How to Make Them - How to Use Them
- Presentation2: Quotes within Quotes: When Single (') and Double (") Quotes are not Enough
- Presenter: Art Carpenter
- SAS Paper: Quotes within Quotes: When Single (') and Double (") Quotes are not Enough
- Presentation: DATA Step Merging Techniques: From Basic to Innovative
- Presenter: Art Carpenter
- SAS Paper: DATA Step Merging Techniques: From Basic to Innovative
- Presentation: Are You Missing Out? Working with Missing Values to Make the Most of What is not There
- Presenter: Art Carpenter
- SAS Paper: Are You Missing Out? Working with Missing Values to Make the Most of What is not There
- Presentation1: Just Shoot Me An Email: Sending Emails with the SAS Datastep
- Presenter: Jesse Metzger, PhD, MSPH
- SAS Paper: ---
- Presentation2: Macro Quoting to the Rescue: Passing Special Characters
- Presenter: Art Carpenter
- SAS Paper: Macro Quoting to the Rescue: Passing Special Characters
- Presentation: Doing More with the SAS® Display Manager: From Editor to ViewTable - Options and Tools You Should Know
- Presenter: Art Carpenter
- SAS Paper: Doing More with the SAS® Display Manager: From Editor to ViewTable - Options and Tools You Should Know
- Presentation: Programming With CLASS: Keeping Your Options Open
- Presenter: Art Carpenter
- SAS Paper: Programming With CLASS: Keeping Your Options Open
- Presentation: Not All Equals are Created Equal: Nonstandard Statement Structures in the DATA Step
- Presenter: Art Carpenter
- SAS Paper: Not All Equals are Created Equal: Nonstandard Statement Structures in the DATA Step
- Presentation: Using PROC FCMP to the Fullest: Getting Started and Doing More
- Presenter: Art Carpenter
- SAS Paper: Using PROC FCMP to the Fullest: Getting Started and Doing More
- Presentation: "How Do I . . .?" There is more than one way to solve that problem; Why continuing to learn is so important
- Presenter: Art Carpenter
° Presentation: PROC REPORT from Beginning to ODS
-
Abstract:
This class will be based on the presentations found [Presentations:ArtCarpenter_Papers_and_Presentations#REPORT_Procedure_Presentations|here]].
° Presenter: Art Carpenter
Anchorage, AK
December 4, 11, 18, 2017
° Presentation: SAS Macro Language
-
Abstract:
This class will cover the SAS Macro Language from the most basic (December 4), to intermediate (December 11) to advanced topics and examples (December 18) [Presentations:ArtCarpenter_Papers_and_Presentations#REPORT_Procedure_Presentations|here]].
° Presenter: Art Carpenter
Anchorage, AK
⛳ We would like to have a live problem solving session.
Do you have a common problem for which you would like to have a solution? Have you inherited some code and would like to have it parsed and discussed?
Let Art Carpenter know you thoughts.
⛳ If you have a topic that you would either like to present or would like to have presented please let Art Carpenter know.
PAST MEETINGS
Wednesday, May 24, 2017 12:00 PM - 1:30 PM (GTM-09:00) Alaska
° Presentation: A Few of My Most Frequent Codie Snippets (by Ella H.)
° Presenter: Ella Holland
Anchorage, AK
° Sample Code: You can down load the sample programs and code snippets here.
-
Wednesday, April 19, 2017 12:00 PM - 1:30 PM (GTM-09:00) Alaska
° Presentation: Stump the Programmer and problem solving
° Presenter: Art Carpenter
Wednesday, March 15, 2017 12:00 PM - 1:30 PM (GTM-09:00) Alaska
° Presentation: Driving a Variable Parameter System with Metadata
° Presenter: Art Carpenter
° Paper: A draft of this paper and related code examples can be found here
Wednesday, February 15, 2017 12:00 PM - 1:30 PM (GTM-09:00) Alaska
° Presentation: PROC DATASETS; The Swiss Army Knife of SAS® Procedures
° Presenter: Michael A. Raithel
° Paper: [1]
Wednesday, January 25, 2017 12:00 PM - 1:30 PM (GTM-09:00) Alaska
° Presentation: Building Intelligent Macros: Using Metadata Functions with the SAS Macro Language
° Presenter: Art Carpenter
° Paper: Building Intelligent Macros: Using Metadata Functions with the SAS® Macro Language
Wednesday, December 21, 2016 12:00 PM - 1:30 PM (GTM-09:00) Alaska
° Presentation: A dummy goes up against HI-IQ
° Presenter: Charles J. Utermohle, PhD
Wednesday, October 26, 2016 12:00 PM - 1:30 PM (GTM-09:00) Alaska
° Presentation: I’ve Got to Hand It to You; Portable Programming Techniques
° Presenter: Art Carpenter
° Paper: I’ve Got to Hand It to You; Portable Programming Techniques
Wednesday, September 21, 2016 12:00 PM - 1:30 PM (GTM-09:00) Alaska
° Presentation: Name that Function:Punny Function Names with Multiple MEANings and Why You Do Not Want to be MISSING Out
° Presenter: Art Carpenter
Wednesday, May 18, 2016 12:00 PM - 1:30 PM (GTM-09:00) Alaska
° Presentation: Advanced PROC REPORT: Getting Your Tables Connected Using Links
° Presenter: Art Carpenter
° Paper: Advanced PROC REPORT: Getting Your Tables Connected Using Links
Wednesday, April 13, 2016 12:00 PM - 1:30 PM (GTM-09:00) Alaska
° Presentation: Advanced PROC REPORT: Traffic Lighting - Controlling Cell Attributes With Your Data
° Presenter: Art Carpenter
° Paper: Advanced PROC REPORT: Traffic Lighting - Controlling Cell Attributes With Your Data
Wednesday, March 17, 2016 12:00 PM - 1:30 PM (GTM-09:00) Alaska
° Presentation: Advanced PROC REPORT: Doing More in the Compute Block
° Presenter: Art Carpenter
° Paper: Advanced PROC REPORT: Doing More in the Compute Block
Wednesday, February 17, 2016 12:00 PM - 1:30 PM (GTM-09:00) Alaska
° Presentation: PROC REPORT: Compute Block Basics
° Presenter: Art Carpenter
° Paper: PROC REPORT: Compute Block Basics
Wednesday, January 20, 2016 12:00 PM - 1:30 PM (GTM-09:00) Alaska
° Presentation: PROC REPORT Basics: Getting Started with the Primary Statements
° Presenter: Art Carpenter
° Paper: PROC REPORT Basics: Getting Started with the Primary Statements
Wednesday, December 16, 2015 12:00 PM - 1:30 PM (GTM-09:00) Alaska
° Presentation: Color, Rank, Count, Name; Controlling it all in PROC REPORT
° Presenter: Art Carpenter
° Paper: Color, Rank, Count, Name; Controlling it all in PROC REPORT
Wednesday, November 18, 2015 12:00 PM - 1:30 PM (GTM-09:00) Alaska
° Presentation: Controlling Colors by Name; Selecting, Ordering, and Using Colors for Your Viewing Pleasure
° Presenter: Art Carpenter
° Paper: Controlling Colors by Name; Selecting, Ordering, and Using Colors for Your Viewing Pleasure
Wednesday, May 27, 2015 12:00 PM - 1:30 PM (GTM-09:00) Alaska
° Presentation: Stump the Programmer #4
° Presenter: Art Carpenter
° Paper: Stump the Programmer
Wednesday, April 15, 2015 12:00 PM - 1:30 PM (GTM-09:00) Alaska
Wednesday, March 18, 2015 12:00 PM - 1:30 PM (GTM-09:00) Alaska
Wednesday, February 18, 2015 12:00 PM - 1:30 PM (GTM-09:00) Alaska
Wednesday, January 21, 2015 12:00 PM - 1:30 PM (GTM-09:00) Alaska
Wednesday, December 17 2014, 12:00 PM - 1:30 PM (GTM-09:00) Alaska
Wednesday, October 29 2014, 12:00 PM - 1:30 PM (GTM-09:00) Alaska
May, June, July, August, and September 2014
For the next four meetings we will be conducting a series on the use of the Macro Language to build and run dynamic applications. We laid the first foundations by providing the motivations at our April 2014 meeting. The May meeting will be the introduction to the topic, and then the next three meetings (June, July, and August) will by taken from Art Carpenter's half day course on Building Dynamic Applications.
This series of presentations will show you how to take advantage of SAS Macro Language capabilities that enable you to write dynamic programs and applications. By mastering the concepts and techniques presented in these presentations your programs will become free of hard-coded data dependencies, thus eliminating the need to re-write the code every time a data set name, variable name, or other data attribute, changes. Let “them” change the project's specifications as often as “they” want; your code is ready!
The dynamic programming techniques that you will learn about during this seminar:
This course makes extensive use of example macros that have been gathered from real world applications, and it concentrates on the techniques necessary to make effective use of these tools.
The techniques discussed make extensive use of macro list processing. Prepare by reading the following papers (listed in recommended reading order):
Wednesday, August 20, 2014 12:00 PM - 1:30 PM (GTM-09:00) Alaska
Wednesday, July 16, 2014 12:00 PM - 1:30 PM (GTM-09:00) Alaska
Wednesday, June 18, 2014 12:00 PM - 1:30 PM (GTM-09:00) Alaska
Wednesday, May 21, 2014 12:00 PM - 1:30 PM (GTM-09:00) Alaska
Wednesday, April 16, 2014 12:00 PM - 1:30 PM (GTM-09:00) Alaska
Wednesday, March 19, 2014 12:00 PM - 1:30 PM (GTM-09:00) Alaska
Wednesday, January 22, 2014 12:00 PM - 1:30 PM (GTM-09:00) Alaska
Wednesday, December 18, 2013 12:00 PM - 1:30 PM (GTM-09:00) Alaska
Wednesday, November 20, 2013 12:00 PM - 1:30 PM (GTM-09:00) Alaska
Wednesday, October 23, 2013 12:00 PM - 1:30 PM (GTM-09:00) Alaska
Wednesday, September 18, 2013 12:00 PM - 1:30 PM (GTM-09:00) Alaska
Wednesday, August 28, 2013 12:00 PM - 1:30 PM (GTM-09:00) Alaska
Wednesday, July 24, 2013 12:00 PM - 1:30 PM (GTM-09:00) Alaska
Wednesday, June 19, 2013 12:00 PM - 1:30 PM (GTM-09:00) Alaska
Wednesday, May 22, 2013 12:00 PM - 1:30 PM (GTM-09:00) Alaska
Once every other year or so we hold a one day conference.
Past one day conferences