DFsas

DFsas — Prepare data set(s) and job file for processing by SAS®.

Synopsis

DFsas {jobfile} [-f] [-dbx] [ [ [-c] | [-C] ] study# ] [-p platelist] [-l [check] | [choice] ] [-d csjo] [-s #] [-t #] [-I pidlist] [-n cidlist] [-v visitlist] [-w] [-SAS #] [-a] [-A] [-r rundir] [-z]

Description

DFsas is an intermediary between DFdiscover and SAS®. It can be used to extract summary data files from a study database and to create the corresponding SAS® job file for subsequent processing by SAS®.

Complete reference documentation for DFsas can be found in DFsas: DFdiscover to SAS®.

Options

jobfile

DFsas job file, specifies details of the translation between DFdiscover and SAS® (required).

-f

force DFsas to include all specified plates, even those that have no data.

-dbx

debug; do not remove the data export script jobfile.dbx after program completion.

-c|C #

create mode; create a default DFsas jobfile for the argument study number. Specifying -c includes all user-defined data fields, while -C includes all user-defined data fields plus DFdiscover header and trailer fields.

-p platelist

in create mode, the list of plates to include.

-l check,choice

export labels instead of codes for check and/or choice fields.

-d csjo

output one or more date fields from each date variable using these specified formats:

  • c=calendar (imputation and 4 digit years)

  • s=convert date to a string field as is (no imputation)

  • j=convert date to a julian number (with imputation)

  • o=use original value and date informat (no imputation)

-s #

split string field data containing more than # characters into 2+ fields on word boundaries.

-t #

truncate string field data containing more than # characters at exactly # characters.

-I sidlist

include only records for the specified subject IDs.

-n cidlist

include only records for the specified site IDs.

-v visitlist

include only records for the specified visit/sequence numbers.

-w

suppress warning messages.

-SAS #

apply SAS® version # rules/limits.

-a

use the DFdiscover field alias, instead of field name, for SAS® variable names.

-A

output the subject alias, if defined, in place of the subject ID. If there is no subject alias, output the subject ID.

-r rundir

set RUNDIR, e.g. -r 'C:\mydir\mysas'

-z

use STUDYDIR/dfsas and do not overwrite existing DFsas job files

Exit Status

DFsas exits with one of the following statuses:

0

The command was successful.

1

The command was not successful.

Examples

Example 3.67. Create a default DFsas job file for study 11

% DFsas mytestjobfile -c 11

Example 3.68. Create a DFsas job file for study 11, include only a subset of plates and request labels for check fields

% DFsas mytestjobfile -c 11 -p 1-5 -l check