Nov 13,2019 at RTI International

Our next RTSUG meeting will be held Nov 13,2019 at RTI International

WHY:       Join us for an afternoon of networking and learning!

WHEN:    Nov 13th from 2:30 PM to 5:00 PM

WHERE:   RTI International 3040 Cornwallis Rd., RTP, NC 27709

ROOM:     Cox Multipurpose Room, Cox Building


We look forward to seeing you at the meeting,
please reserve your seat at this event RSVP


2:30 - 3:00PM Refreshments and Networking
3:00 - 3:05PM Welcome and Announcements
3:05 - 3:50PM David Hartman, UCB Biosciences, Pranjali Dafe
3:50 - 4:00PM Break
4:00 - 4:20PM Jennifer Lindquist, Department of Veterans Affairs
4:30 - 4:55PM Merry Rabb, SAS user group discussion


David Hartman, UCB Biosciences, Pranjali Dafe

PDL – From Document to Code to Deliverable: a streamlined process of combining documentation and SAS code to produce a pooled database

The combining of 2 or more studies into a single database is very difficult and labor intensive. While it is virtually impossible to eliminate human intervention, a process has been created where documentation containing everything from what studies are to be pooled to the mapping rules that are to be used to convert data from multiple studies into a common structure. This information (in the form of spreadsheets) is then executed via a tool called PDL (Pooled Database Loader) to produce the pooled database. This process is completely data independent and can pool data from multiple studies together regardless of the structure of the “original” data. The purpose of this paper is to illustrate how a user of PDL goes from individual study data to a final pooled dataset. Included in this paper will be examples of the information contained in the spreadsheets as well as the various calls to PDL that will create the pooled dataset.

BIO: David Hartman is a statistical programmer at UCB Biosciences where he has been for 7 years. His responsibilities have ranged from leading programmers on a submission package to the Japanese regulatory authorities to the building of tools used in the support of a variety of pooled databases as well as the output of deliverables for everything from adhoc analysis to clinical study reports. David has been using SAS for more than 10 years.

Jennifer Lindquist

You ought to be in pictures! Dressing up output with the picture format

SAS-provided and user-defined formats improve the appearance, interpretability, and readability of data. Using formats can eliminate creating additional text variables and inadvertent discrepancies between ‘parallel’ character strings and numeric values. An under-utilized format option is the picture format. Picture formats allow output to be stylized by instructing SAS to present numeric values in a specified pattern. A few tasks the picture format can do (without creating additional variables!) are: adding units and symbols; rescaling by a multiplication factor; and rounding and truncation. Create user defined customized output with the SAS picture format. Come explore how to dress up your output and get into pictures!

BIO: Jennifer Lindquist is a statistician/data manager with the Department of Veterans Affairs. She has been in Health Services Research at the VA for 22 years and a SAS user for 28 years. Prior to her time at the VA, she was first a high school and then college math teacher

Merry Rabb

SAS User Group Discussion

Merry will provide some information that was presented and discussed at the recent SESUG meeting regarding SAS user groups. We will also have a general discussion among those attending this presentation in regards to RTSUG.

BIO: Merry Rabb, a research programmer/analyst at RTI International, is a detail-oriented technical professional and is skilled in programming, data management, problem identification, and troubleshooting. She has more than 25 years of experience in applications systems analysis, design, and programming, as well as extensive experience with SAS software, including Base SAS, Macro language, and SQL. She specializes in constructing analytic files from primary and secondary data sources and has excelled in performing complex file construction through merging multiple databases, cleansing data, and aggregating and analyzing data. A skilled mentor and team leader, she is experienced in project management and is adept at team facilitation, training, and technical documentation.

We look forward to seeing you there!


    Directions to RTI: Note meeting takes place in the Cox Multipurpose Room – Cox Building (Note, this is a different building than we met at last time. It is labelled as “Q” on the map linked here).

    From Chapel Hill ~12 miles via I-40 E Take Exit 280. Turn right onto Davis Drive. Turn left onto East Cornwallis Road (Traffic Light) Turn left onto West Institute Drive (2nd Traffic Light)

    From Durham ~8 miles via NC-147 S (Durham Freeway) Take Exit 6. Turn left onto East Cornwallis Road. Turn right onto West Institute Drive (Traffic Light)

    From Raleigh ~18 miles via I-40 W Take Exit 280. Turn right onto Davis Drive. Turn left onto East Cornwallis Road. Turn left onto West Institute Drive (2nd Traffic Light).

    Directions to the Haynes Building from West Institute Drive: • Once you have turned onto West Institute Drive (there is a stop light at this entrance and the RTI corporate sign). • Go through the gated entrance (visitors must use the call box and inform security that they are here to visit Annette Green in the Dreyfus Auditorium Haynes Building to attend the RTSUG Meeting) • Once through the gate, take the second left, then the first left to park in the parking deck in front of the Haynes Building (labeled T on the map). • Go to the front entrance of the Haynes Building and someone will let you into the building where you will sign-in and pick up your name tag. The conference room is located to the right of the entry way. Thanks and look forward to seeing everyone there.

Next Meeting

Nov 13,2019
at RTI International