Home

About

Services

CDISC Papers

SAS Papers

»

SAS PAPERS

Using a Picture Format to Create Visit Windows

Richann Watson

Often times people over look various functionalities of PROC FORMAT, in this paper I illustrate the use of the PICTURE format to build visit windows.

Automated or Manual Validation: Which One is for You?

Richann Watson and Patty Johnson

Validation is an essential part of the development process in clinical trial. It is common practice that derived data sets are validated using a more automated method. However, table and listing outputs typically use a manual approach. The manual method of checking the informational aspects of the output is a time consuming process and is subject to human error. This paper presents an automated approach for performing a 100% validation of the informational portion of summary table and listing outputs.

Generating Least Square Means, Standard Error, Observed Mean, Standard Deviation and Confidence Intervals for Treatment Differences using Proc Mixed

Richann Watson

The DOMIXED macro allows for the calculation of least square means, standard error, observed mean, standard deviation and confidence intervals for treatment difference. The macro will also calculate p-values.  It produces data sets in one of two layouts depending on desired layout.

‘V’ for … Variable Information Functions to the Rescue

Richann Watson; Karl Miller

There are times when we need to use the attributes of a variable within a data set.  With the use of the ‘V’ functions (e.g., VNAME, VVALUE, etc.), the various attributes can be obtained and used immediately within the data step.

Exploring HASH Tables vs. SORT/DATA Step vs. PROC SQL

Richann Watson; Lynn Mullins

This paper compares the use of Hash objects in a data step, the standard data step and PROC SQL with different data sets to determine if one method is more efficient in certain situations.

Let SAS® Do Your DIRty Work

Richann Watson

The use of command interpreter (CMD shell) or UNIX commands can help to automate the moving or archiving of files.

Check Please: An Automated Approach to Log Checking

Richann Watson

In this paper, the author discusses her approach to checking logs using a macro that she developed.

When ANY Function Will Just NOT Do

Richann Watson; Karl Miller

Often times we need to determine if a particular variable contains a specific type of value or character.  This can be done using a variety of functions that the author refers to as the ‘ANY’ and ‘NOT’ functions.  These functions look for the specific character or the lack of a specific character within a value.

Let’s Get FREQy with our Statistics: Data-Driven Approach to Determining Appropriate Test Statistic

Richann Watson; Lynn Mullins

As programmers, we are often asked to program statistical analysis procedures to run against the data.  Sometimes, the statistical procedures to use need to be data dependent.  To run these procedures based on the results of previous procedures' output requires a little more preplanning and programming.  A macro that will dynamically determine which statistical procedure to run based on previous procedure output is presented.

Automated Validation of Complex Clinical Trials Made Easy

Richann Watson; Josh Horstman

In this paper, the authors discuss various ways to approach validation of clinical trials with some of the approaches being manual.  In addition, they discuss the pros and cons of these approaches.  These pros and cons lead to the development of a macro that can be used to parse the Compare procedure output.

Animate your Data!

Kriss Harris; Richann Watson

The authors demonstrate how you can use animation in SAS® 9.4 to report your safety data. You will also learn how to use the EXPAND procedure to ensure that your animations are smooth.

Great Time to Learn GTL

Kriss Harris; Richann Watson

It’s a Great Time to Learn GTL! Do you want to be more confident when producing GTL graphs? Do you want to know how to layer your graphs using the OVERLAY layout and build upon your graphs using multiple LAYOUT statement? This paper guides you through the GTL fundamentals!

</code>

</code>

</code>

</code>

»

©2018 DataRich Consulting | Produced by Philip Gregory