Exporting Study System Views and Audit Trails

[Greg Wagner]

Any system data view can be exported using the SAS Export module. This includes study level audit trail files listed below.

• ATTRIBUTELOG - contains changes that are made to clinical data structures
• DATALOG - contains data changes to all study clinical data sets done through data entry
• FORMATLOG

...

[Greg Wagner]

MedDRA 19.0 Build Error

With the release of the MedDRA 19.0 dictionary it was found that an error may occur when building the dictionary using the SQL Server MedDRA build script in ClinPlus Coding v3.x. The error is thrown on the bulk import process when reading the file ‘intl_ord.asc’...

[Greg Wagner]

ClinPlus Data Management Study Archive Process

The ClinPlus Data Management study archive process provides a way to archive all global and source level study data items that are linked to a project. This provides a means for restoring a study to the same or different instance of CPDM. It...

[Greg Wagner]

User Site Access Report

The user site access report display a listing of users and which studies and sites they have access to. The report can be subset by user or run on all users.

Required Macros:
This report uses the macro CPWHERESEL which can be found here if you...

[Greg Wagner]

The attached macro can be used to protect or un-protect all screen fields / objects when a single checkbox is ticked or un-ticked. This may be useful when a field such as a No Data flag is used to indicate a form has no data present. All the other fields can be protected to prevent entry.
...

[Greg Wagner]

The macro sclGetValue is designed for use within data entry screen code to fetch a value from another table. This value can then be used to perform logic checks within the current screen or in whatever way it is needed.

In order to use the macro it must be added to a macro library. This...

[Greg Wagner]

Hi Thomas,

This sounds like there may be an issue with the data or perhaps an issue in the code. Are you able to review the SAS log for errors?

Regards,
Greg-

[Greg Wagner]

Macro updated to support numeric variables

The CPWHERESEL macro has been updated to support the use of numeric variables. It will check if the variable is formatted. If so, it will check if an informat has been sepcified attempt to use that informat to decode the selected value. Otherwise,...

[Greg Wagner]

Correct index issue when moving CPDM 3.2.1(SR-3) from SAS 9.1.3 to SAS 9.2

To migrate the ClinPlus Data Management system 3.x to SAS version 9.2 the global system, study system and clinical tables must be re indexed under SAS 9.2. This is due to an issue deleting integrity constraints....

[Greg Wagner]

Hi Jason,

I will see if I can look at this sometime this week.

Greg-

[Greg Wagner]

The attached dictionary specifications were used in creation of the individual dictionary scripts. These documents reference the specifications provided by each dictionary authority and specify the conventions that we have used....

[Greg Wagner]

Hi Thomas,

In the case of a dropdown box, you would need to use the the SelectedItem or SelectedIndex attribute. SelectedItem will return the text of the selected item. SelectedIndex returns the indexed position of the selection.

Try this...

if ethnic.selectedItem...

[Greg Wagner]

Hi Anthony,

To populate the selection boxes, the system must find the unique values in the table specified for the variable specified. The selection boxes should be populated by the table with the fewest records possible.

For example, although the query details may have the...

[Greg Wagner]

External Data Views

When accessing data from the data management system through an outside process, such as a base sas program or from the ClinPlus Report tool, the data must be accessed through the SAS Share Service that is in use by the Data Management system. Although this can be done...

[Greg Wagner]

The following example explains how to provide and use a site selection list on a Report Requester screen for an EDC project. This is intended for users who have access to all sites. This could be refined further to subset the selection just to the users sites by utilizing the method described in the...