Newsletter Header 12-2-10

                                                                                                July 2013

News and Technical Information
From the NorthEast SAS Users Group
In This Issue
Opening Session Dinner and Keynote
PROC TRIVIA!
Spotlight on SAS
Dinner Cruise
Dinner on the Town
KickBack Party
Fantastic Presentations
Free Wi-Fi
Technical Tip
Stay Connected with NESUG!
Quick Links


  
Join Our Mailing List

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

 

Diane Hatcher 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

 

Ethan Allen 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 A House On Fire 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

 

Workshop 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