Query module

 

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 InferMed technical support at support@infermed.com.

 

Selecting SAS as the output type will result in the creation of 3 text files, as shown below. If ShortCodes are being used an additional QLU (Question Look Up) file is created. The maximum string-length which SAS can accept is 200 characters which is less than the standard of 255 characters.

Response Data file

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.

Questions file

The name of the Questions file is derived from the ResponseData filename, replacing the suffix _Data with _Type

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

Category Codes file

The name of the Category Codes file is derived from the ResponseData filename, replacing the suffix _Data with _Category

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'

Question Look Up file

The name of the Question Look Up file is derived from the ResponseData filename, replacing the suffix _Data with _QLU

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

 

 

Related Topics

Using OUTPUT

Output Options