|
From the NESUG Conference Team
We're putting the finishing touches on the conference and looking forward to September 8-11 in Burlington. If you haven't registered yet, do it now before the early discount ends on July 23 and you'll save.
Attendees consistently praise the NESUG conference for helping them solve problems and providing practical information they put to use at work. Attending just one presentation can save you hundreds of hours of time.You'll meet other users of SAS who are willing and eager to help by sharing their experiences and tips. You'll leave the conference with dozens of ideas to make your job easier and more productive. Check the NESUG Web site for more detailed information and updates.
When you register, it is a good idea to book your hotel room
 | The Burlington Hilton |
at the same time. Staying in the conference hotel helps keep our registration rates low and you'll be where all the action is, so book now.
Get ready for the conference by reviewing all the presentations and workshops. To review the abstracts click here.
You can set up your schedule using the mobile app so be sure to download it. It is available for iPhone/iPod Touch, Android, Torch, Blackberry and more. With this app/mobile website, you will have the always-up-to-date schedule in hand, an attendee list on the go, and a virtual message board. You will be able to create your own schedule, map your way around the meeting space, watch the conference Twitter feeds, and find out about our sponsors.
Burlington is a great vacation spot so plan to spend some time seeing the beautiful scenery and visiting the points of interest.
We are looking forward to all the presentations and workshops we have planned and to seeing all our old friends and meeting some new ones too.
See you in Burlington!
|
Opening Session Dinner and Keynote
Meet new people and see old friends at the Opening Session Dinner on Sunday night, featuring a keynote address by Diane Hatcher, Systems Engineering Manager at SAS, who will speak on the "Evolution of SAS."
Dinner is included in the registration fee.
|
|
PROC TRIVIA!
After the Opening Session, come on over to the NESUG Game Show. This NESUG favorite is back again with promises of more fun and excitement as MCs George Hurley and Daphne Ewing lead this outrageous audience participation event. This Jeopardy-style contest has all sorts of SAS trivia questions, so whether you have just started tinkering with SAS or are a seasoned SAS veteran, come out and test your SAS wits and share a few laughs. For those of you who are a little shy, don't worry, you can sit back, relax, and enjoy the show!
|
Spotlight on SAS
On Monday morning, join us for "Spotlight on SAS" to hear what's new and exciting at SAS. We'll hear some of the SAS managers and developers talk about the interesting projects they are working on. This is a great chance to talk to them as they develop new features in SAS. There will be a Q&A at the end of the session.
|
Monday Dinner Cruise
On Monday evening there will be a dinner cruise on Lake Champlain aboard the Spirit of Ethan Allen III. The boat is just a short walking distance from the hotel. This cruise offers the ultimate evening of scenic views, sumptuous food, and time for relaxation and fellowship among fellow SAS users. (There is an additional fee for this event.)
|
Dinner on the Town
We'll have sign-up sheets so that you can connect with like-minded attendees to have dinner on Tuesday at area restaurants This is a great opportunity for dinner and conversation with old and new friends. (Dinner will be at your own expense.)
|
Tuesday Night KickBack Party
Gather with everyone you have met throughout the conference to relax and enjoy music, dancing, and NESUG camaraderie. Music will be provided by A House on Fire, a six-piece ensemble providing a wide variety of music. The group will deliver all styles from jam to reggae, pop, R & B, country, and rock, as well as acoustic music.
|
Fantastic Presentations
Of course the main reason we all come to the NESUG conference is for the wide variety of fascinating and thought-provoking presentations taught by some of the top SAS experts anywhere. Here's a very short list of some that you might want to catch:
What You're Missing About Missing Values Christopher Bost, MDRC
Alternative Methods for Sorting Large Files without Leaving a Big Disk Space Footprint Rita Volya, Harvard Medical School
Making Sense of PROC TABULATE Jonas Bilenas, Barclays UK&E RBB
A Quick View of SAS Views Elizabeth Axelrod, Abt Associates Inc.
A Many to Many Merge, Without SQL? David Franklin, TheProgrammersCabin.com
A Tutorial on the SASŪ Macro Language John Cohen, Advanced Data Concepts, LLC
Panel Discussion - As the World Turns: Aspects of Managing in a SASŪ Shop Vincent Amoruccio, Todd Case, Margaret Coughlin Alexion Pharmaceuticals, Biogen Idec, Accenture @ Merck
Pooling Strategy for Clinical Data Abraham Yeh, ShinRu Wang, Xiaohong Zhang, Novartis
OUT= is on the Way Out. Use ODS OUTPUT Instead Stanley Fogleman, Harvard Clinical Research Institute
Behind the Scenes with SASŪ: Using Custom Graphics in SASŪ Output Louise Hadden, Abt Associates Inc.
Click here for detailed abstracts and a full list of the over 125 presentations and workshops.
|
Free Wi-Fi at NESUG 2013
While you're learning about all of these topics, you can stay connected to your office and colleagues. Attendees will have access to free wireless internet service in hotel rooms and the conference area. In addition, we'll be setting aside a room in the conference area with tables and chairs so you can comfortably communicate. So you'll always be able to stay in touch while at the conference.
|
Technical Tip
Here is a Technical Tip from Dr Jennifer Waller with just a taste of what she will be presenting in her Hands-on Workshop "How to Use ARRAYs and DO Loops: Do I DO OVER or Do I DO i?"
Jennifer is an Associate Professor of Biostatistics at Georgia Regents University in Augusta, GA where she has worked since 1997. She teaches, consults, and does collaborative research. She has been using SAS since 1989 (you do the math).
DO OVER!
The DO OVER loop is one of the most useful DO loops I have discovered in SASŪ. It can be used with an array when indexing of the array is not needed. If an operation needs to be performed on all elements and there is no need to keep track of what element of the array is being referenced, then there may be no reason to define the array with an index and no need to created an iterative DO loop. For example, for surveys with questions that indicate the respondent should check all that apply, many times the items that are not checked (meaning they don't apply) are not entered and the data are missing for those variables. However, the response isn't really missing, rather it is "no". So you want to change the missing values to some non-missing value. If there are tons of these items (variables) but you don't know how many there are you can set up a non-indexed array and use a DO OVER loop. While there are ways to determine the dimension of an array, sometimes you just don't need to.
The key to using the DO OVER loop is that the operations between the DO OVER and END statements will be performed over ALL elements in the array. One advantage is that the number of array elements does not need to be known. A second advantage is that when referencing the arrayname in the operations to perform within the DO OVER loop, no index is needed. You reference the array like you would a variable name but you use the arrayname. The syntax for the DO OVER loop is
ARRAY arrayname list_of_array_elements;
DO OVER arrayname;
operations;
END;
Ex: Three questions on a questionnaire are check-all-that-apply questions. The first question has items q1_1-q1_6, the second question has four items q2_1-q2_7, and the third question has seven items q3_1-q3_13. The data look like this:
ID
|
Q1_1
|
Q1_2
|
...
|
Q1_6
|
Q2_1
|
...
|
Q2_7
|
Q3_1
|
Q3_2
|
...
|
Q3_13
|
1
|
1
|
1
|
|
|
1
|
|
|
1
|
|
|
1
|
2
|
|
1
|
|
1
|
|
|
1
|
1
|
1
|
|
|
3
|
1
|
1
|
|
1
|
1
|
|
1
|
1
|
1
|
|
1
|
4
|
1
|
|
|
|
1
|
|
|
1
|
|
|
|
...
|
|
|
|
|
|
|
|
|
|
|
|
While you could count up the number of variables and use an indexed array and iterative DO loop, you don't want to. So instead, you set up the ARRAY and DO OVER loop and change the missing values to 0 using the SAS code below. data one; array amisszero q1_1-q1_6 q2_1-q2_7 q3_1-q3_13; doover amisszero; if amisszero=.then amisszero=0; end; run; The resulting data are as follows:
ID
|
Q1_1
|
Q1_2
|
...
|
Q1_6
|
Q2_1
|
...
|
Q2_7
|
Q3_1
|
Q3_2
|
...
|
Q3_13
|
1
|
1
|
1
|
|
0
|
1
|
|
0
|
1
|
0
|
|
1
|
2
|
0
|
1
|
|
1
|
0
|
|
1
|
1
|
1
|
|
0
|
3
|
1
|
1
|
|
1
|
1
|
|
1
|
1
|
1
|
|
1
|
4
|
1
|
0
|
|
0
|
1
|
|
0
|
1
|
0
|
|
0
|
...
|
|
|
|
|
|
|
|
|
|
|
|
Try it yourself and see that using the DO OVER allows you to perform a set of operations on an array without having to index the array in the operations. |
Stay Connected with NESUG!
Now it's easier than ever to stay in touch with NESUG throughout the year. Follow the latest developments as we plan for the conference, find out about upcoming local meetings in your area, and much more.
Also, NESUG wants to hear from you. Become a fan of NESUG on Facebook and add to our wall and join our group on LinkedIn. Simply click on any of the links below for more information. See you online!
|
|
|
NorthEast SAS Users Group
|
|
|