Output to SAS

Support for export to SAS has been designed to be as open as possible. The data and question definitions are exported in plain text files, which are intended to be incorporated in a SAS program created by a SAS programmer. For further information, please contact Customer Support.

Selecting SAS as the output type will result in the creation of 5 text files, as shown below. If ShortCodes are being used, an additional QLU (Question Look Up) file is created.

When saving the output in the OUTPUT section, you are prompted to enter the name of the ResponseData SAS file.

The default name is StudyName_YYYYMMDD_SAS_Data.txt

Data Record

(1 per subject)

A tab delimited record of responses that corresponds to fields in StudyName_YYYYMMDD_SAS_Type.txt

The default name is StudyName_YYYYMMDD_SAS_Format.txt

Data Type Records

(1 per Question)

Shows the format of each date/time question in the query.

Dates containing 10 characters eg 29/07/2014 are represented by 'ddmmyy10' and dates containing 18 characters eg 29Jul2014:09:51:00 are represented by 'datetime19'.

Example:

Covfo1 ddmmyy10

dobirth ddmmyy10

DOB ddmmyy10

visit1 ddmmyy10

visit2 ddmmyy10

DOB1 ddmmyy10

DOB2 ddmmyy10

consent1 ddmmyy10

Certi2 datetime19

DOB3 ddmmyy10

preg_2 ddmmyy10

admind ddmmyy10

admint time

break1 datetime19

sched1 datetime19

acttime time

The default name is StudyName_YYYYMMDD_SAS_Label.txt

Data Type Records

(1 per Question)

Shows the Question Code and Question name/caption for each question in the query.

Example:

Covfo1="Covformdate"

subject="subject number"

initials="subject initials"

dobirth="date of birth"

sex="subject sex"

picture="subject picture"

clinn1="clinician surname"

clinn2="clinician first name"

Subje1="Subject number"

Subin1="Subject initials"

DOB="Date Of Birth"

The default name is StudyName_YYYYMMDD_SAS_Type.txt

Data Type Records

(1 per Question)

Each row defines a field in the ResponseData file, starting with the 7 identification fields:

Trial $9

Site $8

Label $50

PersonId 5

VisCycle 5

FrmCycle 5

RepeatNo 5

The following question fields are typed as follows:-

Text as $ + DataItemLength (upto maximum length of 200)

Date(time) as time

Date(date) as ddmmyy10 (fields as dd/mm/yyyy)

Date(date+time) as datetime19 (fields as ddMMMyyyy:hh:mm:ss)

Partial Date as $20

Category as $ + DataItemLength

Multimedia as $36

IntegerData as DataItemLength

Real as DataItemLength + "." + Number of Decimal Places

LabTest as DataItemLength + "." + Number of Decimal Places

The default name is StudyName_YYYYMMDD_SAS_Category.txt

Formatted text file

Example:-

Value Sex 1='Male'

2='Female'

3='Unkown';

Value Centre 1='London'

2='Liverpool'

3='Manchester'

The default name is StudyName_YYYYMMDD_SAS_QLU.txt

1 record per question

Provides Look Up for SASCodes in the format VisitCode/FormCode/QuestionCode TAB SASCode TAB Description TAB Type

Note that if Long Codes are in use the SASCode will be of the form VisitCode_FormCode_QuestionCode