Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Options
- RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
🔒 This topic is solved and locked.
Need further help from the community? Please
sign in and ask a new question.
Obsidian | Level 7
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 07-02-2019 10:47 AM
(730 views)
I am using the program below to import data and convert to SAS datasets (code not written by me). When I run it and view the SAS datasets within the SAS study library in SAS 9.4, I can see all the decodes for the variables, e..g YES, NO, NA. But if I try to view any of these datasets from SAS Universal Viewer in Windows Explorer or export them out into Excel, all I get is the numeric codes, e.g. 1, 2, 9. How can I turn the datasets into being permanently decoded so they can be viewed in Windows Explorer decoded or exported in the same format?
*******************************************************************;
***** STUDY NAME HERE *****;
*******************************************************************;
** Author: **;
** Date: **;
** Study: **;
*******************************************************************;
*******************************************************************;
** -------- Edit input and output paths to match your installation --------**;
filename inpath 'FOLDER INPATH HERE';
%Let SAS_OUTPUT_PATH = FOLDER OUTPATH HERE;
** ----------------- Do Not Change anything below this line ---------------**;
libname studylib "&SAS_OUTPUT_PATH";
options fmtsearch=(studylib);
run;
%include inpath(HDR.FMT);
DATA studylib.HDR (LABEL= 'HDR');
INFILE inpath(HDR.DAT) LRECL=159;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 HDRINIT $CHAR3.
@143 HDRDATE $CHAR9.
@152 HDRBLANK 1.0
@153 HDRPGNUM 3.0
@156 HDRREADY 1.0
@157 HDRVNUM 3.0
;
LABEL HDRBLANK = 'Page is intentionally blank';
LABEL HDRDATE = 'Date on page header';
LABEL HDRINIT = 'Subject initials';
LABEL HDRPGNUM = 'Page number of repeating page';
LABEL HDRREADY = 'Page is ready (for EDC transmission)';
LABEL HDRVNUM = 'Visit Repeat Key';
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT HDRREADY CL_YESNO.;
run;
%include inpath(PANEL.FMT);
DATA studylib.PANEL (LABEL= 'PANEL');
INFILE inpath(PANEL.DAT) LRECL=140;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 PANELND 1.0
;
LABEL PANELND = 'Panel Not Done';
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT PANELND CL_ND.;
run;
%include inpath(AE.FMT);
DATA studylib.AE (LABEL= 'AE');
INFILE inpath(AE.DAT) LRECL=420;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 AETERM $CHAR255.
@395 AESTDAT $CHAR9.
@404 AEENDTC $CHAR9.
@413 AEONGO 1.0
@414 AESEV 1.0
@415 AEREL 1.0
@416 AEOUT 1.0
@417 AEACTION 1.0
@418 AESAE 1.0
@419 AETHERPY 1.0
@420 AEDISCON 1.0
;
LABEL AEACTION = 'Action required';
LABEL AEDISCON = 'Discontinued due to AE?';
LABEL AEENDTC = 'End date of AE';
LABEL AEONGO = 'AE Ongoing?';
LABEL AEOUT = 'AE outcome code';
LABEL AEREL = 'AE relationship';
LABEL AESAE = 'Serious Adverse Event?';
LABEL AESEV = 'Severity code';
LABEL AESTDAT = 'Start date of AE';
LABEL AETERM = 'Adverse event/Medical condition';
LABEL AETHERPY = 'Therapy required for AE?';
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT AEONGO CL_YESNO.;
FORMAT AESEV CL_AESEV.;
FORMAT AEREL CL_AEREL.;
FORMAT AEOUT CL_AEOUT.;
FORMAT AEACTION CL_AEACN.;
FORMAT AESAE CL_YESNO.;
FORMAT AETHERPY CL_YESNO.;
FORMAT AEDISCON CL_YESNO.;
run;
%include inpath(AE2.FMT);
DATA studylib.AE2 (LABEL= 'AE2');
INFILE inpath(AE2.DAT) LRECL=149;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 AENUM 2.0
@142 AESTATUS $CHAR8.
;
LABEL AENUM = 'AE Number';
LABEL AESTATUS = 'Status of this AE (active/deleted)';
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
run;
%include inpath(AIA.FMT);
DATA studylib.AIA (LABEL= 'AIA');
INFILE inpath(AIA.DAT) LRECL=143;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 AIAND 1.0
@141 AIASEQ 2.0
@143 AIARES $CHAR1.
;
LABEL AIAND = 'AIA Assessment not done';
LABEL AIARES = 'AIA Item res';
LABEL AIASEQ = 'AIA Item ID';
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT AIAND CL_ND.;
run;
%include inpath(AFHA.FMT);
DATA studylib.AFHA (LABEL= 'AFHA');
INFILE inpath(AFHA.DAT) LRECL=167;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 AFHAND 1.0
@141 AFHAEVAL $CHAR16.
@157 AFHAQ1ND 1.0
@158 AFHAQ1 1.0
@159 AFHAQ2ND 1.0
@160 AFHAQ2 1.0
@161 AFHAQ3ND 1.0
@162 AFHAQ3 1.0
@163 AFHAQ4ND 1.0
@164 AFHAQ4 1.0
@165 AFHAQ5ND 1.0
@166 AFHAQ5NA 1.0
@167 AFHAQ5 1.0
;
LABEL AFHAEVAL = 'AFHA Evaluator';
LABEL AFHAND = 'AFHA not done';
LABEL AFHAQ1 = 'Q1: Appearance of Left Eyebrow';
LABEL AFHAQ1ND = 'Q1 not done';
LABEL AFHAQ2 = 'Q2: Appearance of right eyebrow';
LABEL AFHAQ2ND = 'Q2 not done';
LABEL AFHAQ3 = 'Q3: Appearance of left eyelashes';
LABEL AFHAQ3ND = 'Q3 not done';
LABEL AFHAQ4 = 'Q4: Appearance of right eyelashes';
LABEL AFHAQ4ND = 'Q4 not done';
LABEL AFHAQ5 = 'Q5: Appearance of beard hair';
LABEL AFHAQ5NA = 'Q5 not applicable';
LABEL AFHAQ5ND = 'Q5 not done';
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT AFHAND CL_ND.;
FORMAT AFHAQ1ND CL_ND.;
FORMAT AFHAQ2ND CL_ND.;
FORMAT AFHAQ3ND CL_ND.;
FORMAT AFHAQ4ND CL_ND.;
FORMAT AFHAQ5ND CL_ND.;
FORMAT AFHAQ5NA CL_NA.;
run;
%include inpath(ASAA.FMT);
DATA studylib.ASAA (LABEL= 'ASAA');
INFILE inpath(ASAA.DAT) LRECL=159;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 ASAAND 1.0
@141 ASAAEVAL $CHAR16.
@157 ASAATPNA 1.0
@158 ASAATPA 1.0
@159 ASAAWSA 1.0
;
LABEL ASAAEVAL = 'Evaluator';
LABEL ASAAND = 'ASAA not done';
LABEL ASAATPA = 'Target Patch Assessment';
LABEL ASAATPNA = 'Target Patch assessment N/A';
LABEL ASAAWSA = 'Whole Scalp Assessment';
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT ASAAND CL_ND.;
FORMAT ASAATPNA CL_NA.;
run;
%include inpath(CBP.FMT);
DATA studylib.CBP (LABEL= 'CBP');
INFILE inpath(CBP.DAT) LRECL=207;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 CBPSTAT 1.0
@141 CBPPOSTM 1.0
@142 CBPSTERL 1.0
@143 CBPOTHER 1.0
@144 CBPOSPEC $CHAR64.
;
LABEL CBPOSPEC = 'CBP other specification';
LABEL CBPOTHER = 'Other reason for non-WOCBP';
LABEL CBPPOSTM = 'Subject is post-menopausal';
LABEL CBPSTAT = 'CBP status';
LABEL CBPSTERL = 'Subject is surgically sterile';
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT CBPSTAT CL_WOCBP.;
FORMAT CBPPOSTM CL_YESNO.;
FORMAT CBPSTERL CL_YESNO.;
FORMAT CBPOTHER CL_YESNO.;
run;
%include inpath(CM.FMT);
DATA studylib.CM (LABEL= 'CM');
INFILE inpath(CM.DAT) LRECL=538;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 CMNAME $CHAR128.
@268 CMINDC $CHAR128.
@396 CMSTDAT $CHAR9.
@405 CMENDAT $CHAR9.
@414 CMONGO 1.0
@415 CMDOSE $CHAR16.
@431 CMDOSU $CHAR2.
@433 CMDSUOTH $CHAR32.
@465 CMROUTE $CHAR2.
@467 CMRTOTH $CHAR32.
@499 CMDOSFRQ $CHAR2.
@501 CMFRQOTH $CHAR32.
@533 CMNONMED 1.0
@534 CMPV 1.0
@535 CMAE 1.0
@536 CMAEREF 3.0
;
LABEL CMAE = 'Associated with an AE?';
LABEL CMAEREF = 'AE number';
LABEL CMDOSE = 'Dose';
LABEL CMDOSFRQ = 'Dose Frequency';
LABEL CMDOSU = 'Dose units (from code list)';
LABEL CMDSUOTH = 'Dose other spec';
LABEL CMENDAT = 'End date';
LABEL CMFRQOTH = 'Frequency other spec';
LABEL CMINDC = 'Indication';
LABEL CMNAME = 'Medication name';
LABEL CMNONMED = 'Is non-medication therapy?';
LABEL CMONGO = 'Ongoing? (y/n)';
LABEL CMPV = 'Is therapy prohibited?';
LABEL CMROUTE = 'Route (from codelist)';
LABEL CMRTOTH = 'Route other spec';
LABEL CMSTDAT = 'Start date';
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT CMONGO CL_YESNO.;
FORMAT CMDOSU CL_DOSEU.;
FORMAT CMROUTE CL_CMRT.;
FORMAT CMDOSFRQ CL_CMFRQ.;
FORMAT CMNONMED CL_YESNO.;
FORMAT CMPV YESNOUNK.;
FORMAT CMAE CL_YESNO.;
run;
%include inpath(CO.FMT);
DATA studylib.CO (LABEL= 'CO');
INFILE inpath(CO.DAT) LRECL=451;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 COPGREF $CHAR8.
@148 COITREF $CHAR32.
@180 COINIT $CHAR8.
@188 CODTC $CHAR9.
@197 COVAL $CHAR255.
;
LABEL CODTC = 'Date of comment';
LABEL COINIT = 'Comments by';
LABEL COITREF = 'Item reference for comment';
LABEL COPGREF = 'Page reference for comment';
LABEL COVAL = 'Investigator comment';
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
run;
%include inpath(DA.FMT);
DATA studylib.DA (LABEL= 'DA');
INFILE inpath(DA.DAT) LRECL=228;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 DAND 1.0
@141 DASTDTC $CHAR9.
@150 DAENDTC $CHAR9.
@159 DACMNT $CHAR64.
@223 DAUSED 2.0
@225 DAUNUSED 2.0
@227 DAMISS 2.0
;
LABEL DACMNT = 'Comment';
LABEL DAENDTC = 'Date collected';
LABEL DAMISS = 'Number of missing bottles';
LABEL DAND = 'Bottle not used';
LABEL DASTDTC = 'Date dispensed';
LABEL DAUNUSED = 'Number of bottles not used';
LABEL DAUSED = 'Number of bottles used';
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT DAND CL_ND.;
run;
%include inpath(DLQI.FMT);
DATA studylib.DLQI (LABEL= 'DLQI');
INFILE inpath(DLQI.DAT) LRECL=143;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 DLQIND 1.0
@141 DLQISEQ $CHAR2.
@143 DLQIRES 1.0
;
LABEL DLQIND = 'Question not asked';
LABEL DLQIRES = 'DLQI Item result';
LABEL DLQISEQ = 'DLQI item ID';
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT DLQIND CL_ND.;
run;
%include inpath(DM.FMT);
DATA studylib.DM (LABEL= 'DM');
INFILE inpath(DM.DAT) LRECL=216;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 BRTHDTC $CHAR9.
@149 SEX 1.0
@150 RACE 1.0
@151 RACEOTH $CHAR64.
@215 ETHNIC 1.0
@216 SKINTYPE 1.0
;
LABEL BRTHDTC = 'Date of birth';
LABEL ETHNIC = 'Subject Ethnicity';
LABEL RACE = 'Subject Race';
LABEL RACEOTH = 'Race other, specify';
LABEL SEX = 'Subject gender';
LABEL SITEID = 'Site ID';
LABEL SKINTYPE = 'Skin Type';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT SEX CL_SEX.;
FORMAT RACE CL_RACE.;
FORMAT ETHNIC CL_ETHNC.;
run;
%include inpath(ECG.FMT);
DATA studylib.ECG (LABEL= 'ECG');
INFILE inpath(ECG.DAT) LRECL=215;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 ECGDONE 1.0
@141 ECGRES 1.0
@142 ECGSPEC $CHAR64.
@206 ECGDTC $CHAR9.
@215 ECGCS 1.0
;
LABEL ECGCS = 'Clincally significant abnormality?';
LABEL ECGDONE = 'ECG Done?';
LABEL ECGDTC = 'Date of ECG';
LABEL ECGRES = 'ECG Result (normal/abnormal)';
LABEL ECGSPEC = 'ECG specify if abnormal';
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT ECGDONE CL_YESNO.;
FORMAT ECGRES CL_NORM.;
FORMAT ECGCS CL_YESNO.;
run;
%include inpath(ELG.FMT);
DATA studylib.ELG (LABEL= 'ELG');
INFILE inpath(ELG.DAT) LRECL=140;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 ELGQ1 1.0
;
LABEL ELGQ1 = 'Subject complied with protocol restrictions and instructions';
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT ELGQ1 CL_YESNO.;
run;
%include inpath(EOS.FMT);
DATA studylib.EOS (LABEL= 'EOS');
INFILE inpath(EOS.DAT) LRECL=361;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 EOSELG 1.0
@141 EOSLVDAT $CHAR9.
@150 EOSCMPLT 1.0
@151 EOSDCRES 1.0
@152 EOSAEREF $CHAR8.
@160 EOSPV 1.0
@161 EOSPVRES 1.0
@162 EOSCMNT $CHAR200.
;
LABEL EOSAEREF = 'AE reference if applicable';
LABEL EOSCMNT = 'Comment to EOS status';
LABEL EOSCMPLT = 'Completed full course?';
LABEL EOSDCRES = 'D/Con reason code';
LABEL EOSELG = 'Was subject eligible for inclusion';
LABEL EOSLVDAT = 'Date of last visit';
LABEL EOSPV = 'Subject had Protocol Violation?';
LABEL EOSPVRES = 'PV Reason Code';
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT EOSELG CL_YESNO.;
FORMAT EOSCMPLT CL_YESNO.;
FORMAT EOSDCRES CL_DCRES.;
FORMAT EOSPV CL_YESNO.;
FORMAT EOSPVRES CL_PVRES.;
run;
%include inpath(ET.FMT);
DATA studylib.ET (LABEL= 'ET');
INFILE inpath(ET.DAT) LRECL=140;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 ETV9 1.0
;
LABEL ETV9 = 'Is Visit 9 an early term visit?';
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT ETV9 CL_YESNO.;
run;
%include inpath(EXC.FMT);
DATA studylib.EXC (LABEL= 'EXC');
INFILE inpath(EXC.DAT) LRECL=143;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 EXCID $CHAR3.
@143 EXCRES 1.0
;
LABEL EXCID = 'Exclusion Criterion ID';
LABEL EXCRES = 'Exclusion criterion result';
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT EXCRES CL_YNA.;
run;
%include inpath(GIC.FMT);
DATA studylib.GIC (LABEL= 'GIC');
INFILE inpath(GIC.DAT) LRECL=157;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 GICND 1.0
@141 GICEVAL $CHAR16.
@157 GICRES 1.0
;
LABEL GICEVAL = 'Evaluator';
LABEL GICND = 'Assessment not done';
LABEL GICRES = 'Assessment result';
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT GICND CL_ND.;
run;
%include inpath(GIS.FMT);
DATA studylib.GIS (LABEL= 'GIS');
INFILE inpath(GIS.DAT) LRECL=160;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 GISND 1.0
@141 GISEVAL $CHAR16.
@157 GISQ1NA 1.0
@158 GISQ1 1.0
@159 GISQ2NA 1.0
@160 GISQ2 1.0
;
LABEL GISEVAL = 'Evaluator';
LABEL GISND = 'GIS not done';
LABEL GISQ1 = 'Q1: Assessment for Patchy AA';
LABEL GISQ1NA = 'Q1 not applicable';
LABEL GISQ2 = 'Q2: Assessment for AU/AT';
LABEL GISQ2NA = 'Q2 not applicable';
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT GISND CL_ND.;
FORMAT GISQ1NA CL_NA.;
FORMAT GISQ2NA CL_NA.;
run;
%include inpath(HPT.FMT);
DATA studylib.HPT (LABEL= 'HPT');
INFILE inpath(HPT.DAT) LRECL=144;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 HPTND 1.0
@141 HPTNA 1.0
@142 HPTRES 1.0
@143 HPTBROK 1.0
@144 HPTBORDR 1.0
;
LABEL HPTBORDR = 'Broken hairs at alopecic border';
LABEL HPTBROK = 'Hairs broken? (Y/N)';
LABEL HPTNA = 'Not applicable for AU/AT';
LABEL HPTND = 'Test not done';
LABEL HPTRES = 'Test Result Normal/abnormal';
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT HPTND CL_ND.;
FORMAT HPTNA CL_NA.;
FORMAT HPTRES CL_NORM.;
FORMAT HPTBROK CL_YESNO.;
FORMAT HPTBORDR CL_YESNO.;
run;
%include inpath(HX.FMT);
DATA studylib.HX (LABEL= 'HX');
INFILE inpath(HX.DAT) LRECL=236;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 HXORGDTC $CHAR9.
@149 HXCURDTC $CHAR9.
@158 HXTYPE 1.0
@159 HXOPHIA 1.0
@160 HXTHERPY 1.0
@161 HXTHRP01 1.0
@162 HXTHRP02 1.0
@163 HXTHRP03 1.0
@164 HXTHRP04 1.0
@165 HXTHRP05 1.0
@166 HXTHRP06 1.0
@167 HXTHRP07 1.0
@168 HXTHRP08 1.0
@169 HXTHRP09 1.0
@170 HXTHRP10 1.0
@171 HXTHRP11 1.0
@172 HXTHRP99 1.0
@173 HXTHRPOT $CHAR64.
;
LABEL HXCURDTC = 'Onset date of cur episode of Patchy';
LABEL HXOPHIA = 'Does the subject have ophiasis pattern';
LABEL HXORGDTC = 'Onset date of alopecia';
LABEL HXTHERPY = 'Previous therapies?';
LABEL HXTHRP01 = '1) Topical Immunotherapy';
LABEL HXTHRP02 = '2) Corticosteroids';
LABEL HXTHRP03 = '3) Systemic steroids';
LABEL HXTHRP04 = '4) DMARDS';
LABEL HXTHRP05 = '5) Biologics/Immunosuppresants';
LABEL HXTHRP06 = '6) Plaqunil';
LABEL HXTHRP07 = '7) PDT';
LABEL HXTHRP08 = '8) JAK inhibitors';
LABEL HXTHRP09 = '9) Phototherapy';
LABEL HXTHRP10 = '10) Laser Therapy';
LABEL HXTHRP11 = '11) Narrow-band UVB';
LABEL HXTHRP99 = '99) Other therapy';
LABEL HXTHRPOT = 'Other specification';
LABEL HXTYPE = 'Alopecia Type';
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT HXTYPE CL_ATYPE.;
FORMAT HXTHERPY CL_YESNO.;
run;
%include inpath(ICF.FMT);
DATA studylib.ICF (LABEL= 'ICF');
INFILE inpath(ICF.DAT) LRECL=154;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 ICFSIGN 1.0
@141 ICFDATE $CHAR9.
@150 ICFTIME $CHAR4.
@154 ICFPROTO 1.0
;
LABEL ICFDATE = 'Date of ICF signature';
LABEL ICFPROTO = 'Protocol version';
LABEL ICFSIGN = 'Informed consent signed?';
LABEL ICFTIME = 'Time of informed consent';
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT ICFSIGN CL_YESNO.;
run;
%include inpath(INC.FMT);
DATA studylib.INC (LABEL= 'INC');
INFILE inpath(INC.DAT) LRECL=143;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 INCID $CHAR3.
@143 INCRES 1.0
;
LABEL INCID = 'Inclusion criterion ID';
LABEL INCRES = 'Inclusion criteria result';
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT INCRES CL_YNA.;
run;
%include inpath(INVSIG.FMT);
DATA studylib.INVSIG (LABEL= 'INVSIG');
INFILE inpath(INVSIG.DAT) LRECL=149;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 SIGNED 1.0
@141 SIGDATE $CHAR9.
;
LABEL SIGDATE = 'Date of sign-off';
LABEL SIGNED = 'Investigator sign-off';
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT SIGNED CL_YESNO.;
run;
%include inpath(LAB.FMT);
DATA studylib.LAB (LABEL= 'LAB');
INFILE inpath(LAB.DAT) LRECL=150;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 LABSAMP 1.0
@141 LABDTC $CHAR9.
@150 LABCS 1.0
;
LABEL LABCS = 'Are there Clin. Significant results';
LABEL LABDTC = 'Date of lab sample collevction';
LABEL LABSAMP = 'Lab Samples collected?';
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT LABSAMP CL_YESNO.;
FORMAT LABCS CL_YESNO.;
run;
%include inpath(MH.FMT);
DATA studylib.MH (LABEL= 'MH');
INFILE inpath(MH.DAT) LRECL=361;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 MHBODSYS $CHAR2.
@142 MHDIAG $CHAR200.
@342 MHSTDAT $CHAR9.
@351 MHENDAT $CHAR9.
@360 MHCONT 1.0
@361 MHCONMED 1.0
;
LABEL MHBODSYS = 'Body system code';
LABEL MHCONMED = 'Current concomitant therapies?';
LABEL MHCONT = 'Ongoing?';
LABEL MHDIAG = 'Diagnosis and/or preocedure';
LABEL MHENDAT = 'Resolution date';
LABEL MHSTDAT = 'Onset date';
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT MHBODSYS CL_BDSYS.;
FORMAT MHCONT CL_YESNO.;
FORMAT MHCONMED YESNOUNK.;
run;
%include inpath(NSHA.FMT);
DATA studylib.NSHA (LABEL= 'NSHA');
INFILE inpath(NSHA.DAT) LRECL=144;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 NSHAND 1.0
@141 NSHAQ1ND 1.0
@142 NSHAQ1 1.0
@143 NSHAQ2ND 1.0
@144 NSHAQ2 1.0
;
LABEL NSHAND = 'NSHA not done';
LABEL NSHAQ1 = 'NSHA Q1: Body Hair loss';
LABEL NSHAQ1ND = 'NSHA Q1 not done';
LABEL NSHAQ2 = 'NSHA Q2: Nasal Hair loss';
LABEL NSHAQ2ND = 'NSHA Q2 not done';
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT NSHAND CL_ND.;
FORMAT NSHAQ1ND CL_ND.;
FORMAT NSHAQ2ND CL_ND.;
run;
%include inpath(PE.FMT);
DATA studylib.PE (LABEL= 'PE');
INFILE inpath(PE.DAT) LRECL=221;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 PECAT $CHAR16.
@156 PEND 1.0
@157 PERES 1.0
@158 PECMNT $CHAR64.
;
LABEL PECAT = 'Examination Category';
LABEL PECMNT = 'Comment if abnormal';
LABEL PEND = 'Examination not done?';
LABEL PERES = 'Examination result';
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT PEND CL_ND.;
FORMAT PERES CL_PERES.;
run;
%include inpath(PHOTO.FMT);
DATA studylib.PHOTO (LABEL= 'PHOTO');
INFILE inpath(PHOTO.DAT) LRECL=140;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 PHOTOYN 1.0
;
LABEL PHOTOYN = 'Photo taken y/n';
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT PHOTOYN CL_YESNO.;
run;
%include inpath(RX.FMT);
DATA studylib.RX (LABEL= 'RX');
INFILE inpath(RX.DAT) LRECL=148;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 RXYN 1.0
@141 KITNUM $CHAR8.
;
LABEL KITNUM = 'Assigned kit number';
LABEL RXYN = 'Subject is eligible for randomization';
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT RXYN CL_YESNO.;
run;
%include inpath(SA.FMT);
DATA studylib.SA (LABEL= 'SA');
INFILE inpath(SA.DAT) LRECL=150;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 SALTND 1.0
@141 SALTRES 3.0
@144 ALODND 1.0
@145 ALODRES 3.0
@148 VIND 1.0
@149 VIQ1 1.0
@150 VIQ2 1.0
;
LABEL ALODND = 'ALODEX score not done';
LABEL ALODRES = 'ALODEX score';
LABEL SALTND = 'SALT score not done';
LABEL SALTRES = 'SALT score';
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL VIND = 'Vellus/Indeterminate question ND';
LABEL VIQ1 = 'Q1: vellus hair present';
LABEL VIQ2 = 'Q2: Indeterminate hair present?';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT SALTND CL_ND.;
FORMAT ALODND CL_ND.;
FORMAT VIND CL_ND.;
FORMAT VIQ1 CL_YESNO.;
FORMAT VIQ2 CL_YESNO.;
run;
%include inpath(SGITS.FMT);
DATA studylib.SGITS (LABEL= 'SGITS');
INFILE inpath(SGITS.DAT) LRECL=144;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 SGITSND 1.0
@141 SGITQ1NA 1.0
@142 SGITSQ1 1.0
@143 SGITQ2NA 1.0
@144 SGITSQ2 1.0
;
LABEL SGITQ1NA = 'Q1 not applicable';
LABEL SGITQ2NA = 'Q2 not applicable';
LABEL SGITSND = 'SGITS not done';
LABEL SGITSQ1 = 'Q1A: Assessment for Patchy AA';
LABEL SGITSQ2 = 'Q2: Assessment for AU/AT';
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT SGITSND CL_ND.;
FORMAT SGITQ1NA CL_NA.;
FORMAT SGITQ2NA CL_NA.;
run;
%include inpath(SGSHQ.FMT);
DATA studylib.SGSHQ (LABEL= 'SGSHQ');
INFILE inpath(SGSHQ.DAT) LRECL=145;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 SGSHQND 1.0
@141 SGSHQ1NA 1.0
@142 SGSHQ1A 1.0
@143 SGSHQ1B 1.0
@144 SGSHQ2NA 1.0
@145 SGSHQ2 1.0
;
LABEL SGSHQ1A = 'Q1A: Target assessment for Patchy AA';
LABEL SGSHQ1B = 'Q1B: Treated assessment for Patchy AA';
LABEL SGSHQ1NA = 'Q1 not applicable';
LABEL SGSHQ2 = 'Q2: Assessment for AU/AT';
LABEL SGSHQ2NA = 'Q2 not applicable';
LABEL SGSHQND = 'SGSHQ not done';
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT SGSHQND CL_ND.;
FORMAT SGSHQ1NA CL_NA.;
FORMAT SGSHQ2NA CL_NA.;
run;
%include inpath(SMU.FMT);
DATA studylib.SMU (LABEL= 'SMU');
INFILE inpath(SMU.DAT) LRECL=190;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 SMUSTART $CHAR9.
@149 SMUAPP 1.0
@150 SMUOTH $CHAR32.
@182 SMUEND $CHAR9.
;
LABEL SITEID = 'Site ID';
LABEL SMUAPP = 'Applications per day';
LABEL SMUEND = 'Date application frequency ended';
LABEL SMUOTH = 'Other Frequency';
LABEL SMUSTART = 'Date Application Frequency started';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT SMUAPP CL_APPFQ.;
run;
%include inpath(SPT.FMT);
DATA studylib.SPT (LABEL= 'SPT');
INFILE inpath(SPT.DAT) LRECL=141;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 SPTDONE 1.0
@141 SPTORRES 1.0
;
LABEL SITEID = 'Site ID';
LABEL SPTDONE = 'SPT done?';
LABEL SPTORRES = 'SPT Result';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT SPTDONE CL_YNA.;
FORMAT SPTORRES CL_PN.;
run;
%include inpath(TSPI.FMT);
DATA studylib.TSPI (LABEL= 'TSPI');
INFILE inpath(TSPI.DAT) LRECL=142;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 TSPIND 1.0
@141 TSPIRES 1.0
@142 TSPIDOC 1.0
;
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL TSPIDOC = 'Documented photographically?';
LABEL TSPIND = 'Identification not done';
LABEL TSPIRES = 'Identified by subject';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT TSPIND CL_ND.;
FORMAT TSPIRES CL_YNA.;
FORMAT TSPIDOC CL_YESNO.;
run;
%include inpath(UPT.FMT);
DATA studylib.UPT (LABEL= 'UPT');
INFILE inpath(UPT.DAT) LRECL=141;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 UPTDONE 1.0
@141 UPTORRES 1.0
;
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL UPTDONE = 'UPT done?';
LABEL UPTORRES = 'UPT Result';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT UPTDONE CL_YNA.;
FORMAT UPTORRES CL_PN.;
run;
%include inpath(UV.FMT);
DATA studylib.UV (LABEL= 'UV');
INFILE inpath(UV.DAT) LRECL=203;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 UVREAS $CHAR64.
;
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL UVREAS = 'Reason for unscheduled visit';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
run;
%include inpath(VS.FMT);
DATA studylib.VS (LABEL= 'VS');
INFILE inpath(VS.DAT) LRECL=166;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 VSDONE 1.0
@141 VSBPSYS 3.0
@144 VSBPDIA 3.0
@147 VSPULSE 3.0
@150 VSTEMP 5.0
@155 VSRESP 2.0
@157 VSWT 3.0
@160 VSHT 4.0
@164 VSQ1 1.0
@165 VSQ2 1.0
@166 VSQ3 1.0
;
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL VSBPDIA = 'Blood pressure diastolic';
LABEL VSBPSYS = 'Blood pressure systolic';
LABEL VSDONE = 'VS not done';
LABEL VSHT = 'Height (in)';
LABEL VSPULSE = 'Pulse rate (beats/min)';
LABEL VSQ1 = 'Relevance if systolic > 140mmHg';
LABEL VSQ2 = 'Relevance if diastolic > 90mmHG';
LABEL VSQ3 = 'Relevance if Weight > 300lbs';
LABEL VSRESP = 'Respiratory rate (breaths/min)';
LABEL VSTEMP = 'Body temperature deg F';
LABEL VSWT = 'Weight (lb)';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT VSDONE CL_YESNO.;
FORMAT VSQ1 CL_YESNO.;
FORMAT VSQ2 CL_YESNO.;
FORMAT VSQ3 CL_YESNO.;
run;
%include inpath(PK.FMT);
DATA studylib.PK (LABEL= 'PK');
INFILE inpath(PK.DAT) LRECL=143;
INPUT
#1
@1 _STUDY $CHAR24.
@25 _USUBJID $CHAR6.
@31 _VISNAME $CHAR16.
@47 _VISRPT $CHAR16.
@63 _PAGNAME $CHAR16.
@79 _PAGSEQ 3.0
@82 _RECNUM 3.0
@85 _STATUS $CHAR16.
@101 _RECDT $CHAR16.
@117 _RECTM $CHAR16.
@133 _RECND 1.0
@134 _PGBLANK 1.0
@135 SITEID $CHAR2.
@137 SUBJID $CHAR3.
@140 PKSAMP 1.0
@141 PDSAMP 1.0
@142 PKTELCAL 1.0
@143 PKTIMFRM 1.0
;
LABEL PDSAMP = 'PD sample collected';
LABEL PKSAMP = 'PK sample collected';
LABEL PKTELCAL = 'Was a telephone reminder given?';
LABEL PKTIMFRM = 'Were samples collected in correct timeframe?';
LABEL SITEID = 'Site ID';
LABEL SUBJID = 'Subject or Screening ID';
LABEL _PAGNAME = 'Page Name';
LABEL _PAGSEQ = 'Page sequence number';
LABEL _PGBLANK = 'Page is Blank';
LABEL _RECDT = 'Record Date';
LABEL _RECND = 'Record Not Done';
LABEL _RECNUM = 'Record Number on page';
LABEL _RECTM = 'Record Time';
LABEL _STATUS = 'Page status';
LABEL _STUDY = 'Study Identifier';
LABEL _USUBJID = 'Unique Subject Identifier';
LABEL _VISNAME = 'Visit Name';
LABEL _VISRPT = 'Visit repeat key';
FORMAT PKSAMP CL_YNA.;
FORMAT PDSAMP CL_YNA.;
FORMAT PKTELCAL CL_YESNO.;
FORMAT PKTIMFRM CL_YESNO.;
run;
proc copy in=work out=studylib;
select formats;
run;
1 ACCEPTED SOLUTION
Accepted Solutions
Super User
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Formats change how a variable is displayed, but not the underlying variable.
If you want the variable value to change you need to create a new variable with the format applied or export it to a format that will maintain the display, such as CSV or Excel file that doesn't have formats.
You can also try an XPORT formatted file to see if that keeps the formats, I'm not sure if it does or not.
To apply a format, use the PUT() statement.
VSQ1_formatted = put(VSQ1, CL_YESNO.);
Spoiler
@PSU_Sudzi wrote:
I am using the program below to import data and convert to SAS datasets (code not written by me). When I run it and view the SAS datasets within the SAS study library in SAS 9.4, I can see all the decodes for the variables, e..g YES, NO, NA. But if I try to view any of these datasets from SAS Universal Viewer in Windows Explorer or export them out into Excel, all I get is the numeric codes, e.g. 1, 2, 9. How can I turn the datasets into being permanently decoded so they can be viewed in Windows Explorer decoded or exported in the same format?
*******************************************************************; ***** STUDY NAME HERE *****; *******************************************************************; ** Author: **; ** Date: **; ** Study: **; *******************************************************************; *******************************************************************; ** -------- Edit input and output paths to match your installation --------**; filename inpath 'FOLDER INPATH HERE'; %Let SAS_OUTPUT_PATH = FOLDER OUTPATH HERE; ** ----------------- Do Not Change anything below this line ---------------**; libname studylib "&SAS_OUTPUT_PATH"; options fmtsearch=(studylib); run; %include inpath(HDR.FMT); DATA studylib.HDR (LABEL= 'HDR'); INFILE inpath(HDR.DAT) LRECL=159; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 HDRINIT $CHAR3. @143 HDRDATE $CHAR9. @152 HDRBLANK 1.0 @153 HDRPGNUM 3.0 @156 HDRREADY 1.0 @157 HDRVNUM 3.0 ; LABEL HDRBLANK = 'Page is intentionally blank'; LABEL HDRDATE = 'Date on page header'; LABEL HDRINIT = 'Subject initials'; LABEL HDRPGNUM = 'Page number of repeating page'; LABEL HDRREADY = 'Page is ready (for EDC transmission)'; LABEL HDRVNUM = 'Visit Repeat Key'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT HDRREADY CL_YESNO.; run; %include inpath(PANEL.FMT); DATA studylib.PANEL (LABEL= 'PANEL'); INFILE inpath(PANEL.DAT) LRECL=140; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 PANELND 1.0 ; LABEL PANELND = 'Panel Not Done'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT PANELND CL_ND.; run; %include inpath(AE.FMT); DATA studylib.AE (LABEL= 'AE'); INFILE inpath(AE.DAT) LRECL=420; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 AETERM $CHAR255. @395 AESTDAT $CHAR9. @404 AEENDTC $CHAR9. @413 AEONGO 1.0 @414 AESEV 1.0 @415 AEREL 1.0 @416 AEOUT 1.0 @417 AEACTION 1.0 @418 AESAE 1.0 @419 AETHERPY 1.0 @420 AEDISCON 1.0 ; LABEL AEACTION = 'Action required'; LABEL AEDISCON = 'Discontinued due to AE?'; LABEL AEENDTC = 'End date of AE'; LABEL AEONGO = 'AE Ongoing?'; LABEL AEOUT = 'AE outcome code'; LABEL AEREL = 'AE relationship'; LABEL AESAE = 'Serious Adverse Event?'; LABEL AESEV = 'Severity code'; LABEL AESTDAT = 'Start date of AE'; LABEL AETERM = 'Adverse event/Medical condition'; LABEL AETHERPY = 'Therapy required for AE?'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT AEONGO CL_YESNO.; FORMAT AESEV CL_AESEV.; FORMAT AEREL CL_AEREL.; FORMAT AEOUT CL_AEOUT.; FORMAT AEACTION CL_AEACN.; FORMAT AESAE CL_YESNO.; FORMAT AETHERPY CL_YESNO.; FORMAT AEDISCON CL_YESNO.; run; %include inpath(AE2.FMT); DATA studylib.AE2 (LABEL= 'AE2'); INFILE inpath(AE2.DAT) LRECL=149; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 AENUM 2.0 @142 AESTATUS $CHAR8. ; LABEL AENUM = 'AE Number'; LABEL AESTATUS = 'Status of this AE (active/deleted)'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; run; %include inpath(AIA.FMT); DATA studylib.AIA (LABEL= 'AIA'); INFILE inpath(AIA.DAT) LRECL=143; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 AIAND 1.0 @141 AIASEQ 2.0 @143 AIARES $CHAR1. ; LABEL AIAND = 'AIA Assessment not done'; LABEL AIARES = 'AIA Item res'; LABEL AIASEQ = 'AIA Item ID'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT AIAND CL_ND.; run; %include inpath(AFHA.FMT); DATA studylib.AFHA (LABEL= 'AFHA'); INFILE inpath(AFHA.DAT) LRECL=167; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 AFHAND 1.0 @141 AFHAEVAL $CHAR16. @157 AFHAQ1ND 1.0 @158 AFHAQ1 1.0 @159 AFHAQ2ND 1.0 @160 AFHAQ2 1.0 @161 AFHAQ3ND 1.0 @162 AFHAQ3 1.0 @163 AFHAQ4ND 1.0 @164 AFHAQ4 1.0 @165 AFHAQ5ND 1.0 @166 AFHAQ5NA 1.0 @167 AFHAQ5 1.0 ; LABEL AFHAEVAL = 'AFHA Evaluator'; LABEL AFHAND = 'AFHA not done'; LABEL AFHAQ1 = 'Q1: Appearance of Left Eyebrow'; LABEL AFHAQ1ND = 'Q1 not done'; LABEL AFHAQ2 = 'Q2: Appearance of right eyebrow'; LABEL AFHAQ2ND = 'Q2 not done'; LABEL AFHAQ3 = 'Q3: Appearance of left eyelashes'; LABEL AFHAQ3ND = 'Q3 not done'; LABEL AFHAQ4 = 'Q4: Appearance of right eyelashes'; LABEL AFHAQ4ND = 'Q4 not done'; LABEL AFHAQ5 = 'Q5: Appearance of beard hair'; LABEL AFHAQ5NA = 'Q5 not applicable'; LABEL AFHAQ5ND = 'Q5 not done'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT AFHAND CL_ND.; FORMAT AFHAQ1ND CL_ND.; FORMAT AFHAQ2ND CL_ND.; FORMAT AFHAQ3ND CL_ND.; FORMAT AFHAQ4ND CL_ND.; FORMAT AFHAQ5ND CL_ND.; FORMAT AFHAQ5NA CL_NA.; run; %include inpath(ASAA.FMT); DATA studylib.ASAA (LABEL= 'ASAA'); INFILE inpath(ASAA.DAT) LRECL=159; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 ASAAND 1.0 @141 ASAAEVAL $CHAR16. @157 ASAATPNA 1.0 @158 ASAATPA 1.0 @159 ASAAWSA 1.0 ; LABEL ASAAEVAL = 'Evaluator'; LABEL ASAAND = 'ASAA not done'; LABEL ASAATPA = 'Target Patch Assessment'; LABEL ASAATPNA = 'Target Patch assessment N/A'; LABEL ASAAWSA = 'Whole Scalp Assessment'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT ASAAND CL_ND.; FORMAT ASAATPNA CL_NA.; run; %include inpath(CBP.FMT); DATA studylib.CBP (LABEL= 'CBP'); INFILE inpath(CBP.DAT) LRECL=207; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 CBPSTAT 1.0 @141 CBPPOSTM 1.0 @142 CBPSTERL 1.0 @143 CBPOTHER 1.0 @144 CBPOSPEC $CHAR64. ; LABEL CBPOSPEC = 'CBP other specification'; LABEL CBPOTHER = 'Other reason for non-WOCBP'; LABEL CBPPOSTM = 'Subject is post-menopausal'; LABEL CBPSTAT = 'CBP status'; LABEL CBPSTERL = 'Subject is surgically sterile'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT CBPSTAT CL_WOCBP.; FORMAT CBPPOSTM CL_YESNO.; FORMAT CBPSTERL CL_YESNO.; FORMAT CBPOTHER CL_YESNO.; run; %include inpath(CM.FMT); DATA studylib.CM (LABEL= 'CM'); INFILE inpath(CM.DAT) LRECL=538; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 CMNAME $CHAR128. @268 CMINDC $CHAR128. @396 CMSTDAT $CHAR9. @405 CMENDAT $CHAR9. @414 CMONGO 1.0 @415 CMDOSE $CHAR16. @431 CMDOSU $CHAR2. @433 CMDSUOTH $CHAR32. @465 CMROUTE $CHAR2. @467 CMRTOTH $CHAR32. @499 CMDOSFRQ $CHAR2. @501 CMFRQOTH $CHAR32. @533 CMNONMED 1.0 @534 CMPV 1.0 @535 CMAE 1.0 @536 CMAEREF 3.0 ; LABEL CMAE = 'Associated with an AE?'; LABEL CMAEREF = 'AE number'; LABEL CMDOSE = 'Dose'; LABEL CMDOSFRQ = 'Dose Frequency'; LABEL CMDOSU = 'Dose units (from code list)'; LABEL CMDSUOTH = 'Dose other spec'; LABEL CMENDAT = 'End date'; LABEL CMFRQOTH = 'Frequency other spec'; LABEL CMINDC = 'Indication'; LABEL CMNAME = 'Medication name'; LABEL CMNONMED = 'Is non-medication therapy?'; LABEL CMONGO = 'Ongoing? (y/n)'; LABEL CMPV = 'Is therapy prohibited?'; LABEL CMROUTE = 'Route (from codelist)'; LABEL CMRTOTH = 'Route other spec'; LABEL CMSTDAT = 'Start date'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT CMONGO CL_YESNO.; FORMAT CMDOSU CL_DOSEU.; FORMAT CMROUTE CL_CMRT.; FORMAT CMDOSFRQ CL_CMFRQ.; FORMAT CMNONMED CL_YESNO.; FORMAT CMPV YESNOUNK.; FORMAT CMAE CL_YESNO.; run; %include inpath(CO.FMT); DATA studylib.CO (LABEL= 'CO'); INFILE inpath(CO.DAT) LRECL=451; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 COPGREF $CHAR8. @148 COITREF $CHAR32. @180 COINIT $CHAR8. @188 CODTC $CHAR9. @197 COVAL $CHAR255. ; LABEL CODTC = 'Date of comment'; LABEL COINIT = 'Comments by'; LABEL COITREF = 'Item reference for comment'; LABEL COPGREF = 'Page reference for comment'; LABEL COVAL = 'Investigator comment'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; run; %include inpath(DA.FMT); DATA studylib.DA (LABEL= 'DA'); INFILE inpath(DA.DAT) LRECL=228; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 DAND 1.0 @141 DASTDTC $CHAR9. @150 DAENDTC $CHAR9. @159 DACMNT $CHAR64. @223 DAUSED 2.0 @225 DAUNUSED 2.0 @227 DAMISS 2.0 ; LABEL DACMNT = 'Comment'; LABEL DAENDTC = 'Date collected'; LABEL DAMISS = 'Number of missing bottles'; LABEL DAND = 'Bottle not used'; LABEL DASTDTC = 'Date dispensed'; LABEL DAUNUSED = 'Number of bottles not used'; LABEL DAUSED = 'Number of bottles used'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT DAND CL_ND.; run; %include inpath(DLQI.FMT); DATA studylib.DLQI (LABEL= 'DLQI'); INFILE inpath(DLQI.DAT) LRECL=143; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 DLQIND 1.0 @141 DLQISEQ $CHAR2. @143 DLQIRES 1.0 ; LABEL DLQIND = 'Question not asked'; LABEL DLQIRES = 'DLQI Item result'; LABEL DLQISEQ = 'DLQI item ID'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT DLQIND CL_ND.; run; %include inpath(DM.FMT); DATA studylib.DM (LABEL= 'DM'); INFILE inpath(DM.DAT) LRECL=216; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 BRTHDTC $CHAR9. @149 SEX 1.0 @150 RACE 1.0 @151 RACEOTH $CHAR64. @215 ETHNIC 1.0 @216 SKINTYPE 1.0 ; LABEL BRTHDTC = 'Date of birth'; LABEL ETHNIC = 'Subject Ethnicity'; LABEL RACE = 'Subject Race'; LABEL RACEOTH = 'Race other, specify'; LABEL SEX = 'Subject gender'; LABEL SITEID = 'Site ID'; LABEL SKINTYPE = 'Skin Type'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT SEX CL_SEX.; FORMAT RACE CL_RACE.; FORMAT ETHNIC CL_ETHNC.; run; %include inpath(ECG.FMT); DATA studylib.ECG (LABEL= 'ECG'); INFILE inpath(ECG.DAT) LRECL=215; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 ECGDONE 1.0 @141 ECGRES 1.0 @142 ECGSPEC $CHAR64. @206 ECGDTC $CHAR9. @215 ECGCS 1.0 ; LABEL ECGCS = 'Clincally significant abnormality?'; LABEL ECGDONE = 'ECG Done?'; LABEL ECGDTC = 'Date of ECG'; LABEL ECGRES = 'ECG Result (normal/abnormal)'; LABEL ECGSPEC = 'ECG specify if abnormal'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT ECGDONE CL_YESNO.; FORMAT ECGRES CL_NORM.; FORMAT ECGCS CL_YESNO.; run; %include inpath(ELG.FMT); DATA studylib.ELG (LABEL= 'ELG'); INFILE inpath(ELG.DAT) LRECL=140; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 ELGQ1 1.0 ; LABEL ELGQ1 = 'Subject complied with protocol restrictions and instructions'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT ELGQ1 CL_YESNO.; run; %include inpath(EOS.FMT); DATA studylib.EOS (LABEL= 'EOS'); INFILE inpath(EOS.DAT) LRECL=361; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 EOSELG 1.0 @141 EOSLVDAT $CHAR9. @150 EOSCMPLT 1.0 @151 EOSDCRES 1.0 @152 EOSAEREF $CHAR8. @160 EOSPV 1.0 @161 EOSPVRES 1.0 @162 EOSCMNT $CHAR200. ; LABEL EOSAEREF = 'AE reference if applicable'; LABEL EOSCMNT = 'Comment to EOS status'; LABEL EOSCMPLT = 'Completed full course?'; LABEL EOSDCRES = 'D/Con reason code'; LABEL EOSELG = 'Was subject eligible for inclusion'; LABEL EOSLVDAT = 'Date of last visit'; LABEL EOSPV = 'Subject had Protocol Violation?'; LABEL EOSPVRES = 'PV Reason Code'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT EOSELG CL_YESNO.; FORMAT EOSCMPLT CL_YESNO.; FORMAT EOSDCRES CL_DCRES.; FORMAT EOSPV CL_YESNO.; FORMAT EOSPVRES CL_PVRES.; run; %include inpath(ET.FMT); DATA studylib.ET (LABEL= 'ET'); INFILE inpath(ET.DAT) LRECL=140; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 ETV9 1.0 ; LABEL ETV9 = 'Is Visit 9 an early term visit?'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT ETV9 CL_YESNO.; run; %include inpath(EXC.FMT); DATA studylib.EXC (LABEL= 'EXC'); INFILE inpath(EXC.DAT) LRECL=143; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 EXCID $CHAR3. @143 EXCRES 1.0 ; LABEL EXCID = 'Exclusion Criterion ID'; LABEL EXCRES = 'Exclusion criterion result'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT EXCRES CL_YNA.; run; %include inpath(GIC.FMT); DATA studylib.GIC (LABEL= 'GIC'); INFILE inpath(GIC.DAT) LRECL=157; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 GICND 1.0 @141 GICEVAL $CHAR16. @157 GICRES 1.0 ; LABEL GICEVAL = 'Evaluator'; LABEL GICND = 'Assessment not done'; LABEL GICRES = 'Assessment result'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT GICND CL_ND.; run; %include inpath(GIS.FMT); DATA studylib.GIS (LABEL= 'GIS'); INFILE inpath(GIS.DAT) LRECL=160; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 GISND 1.0 @141 GISEVAL $CHAR16. @157 GISQ1NA 1.0 @158 GISQ1 1.0 @159 GISQ2NA 1.0 @160 GISQ2 1.0 ; LABEL GISEVAL = 'Evaluator'; LABEL GISND = 'GIS not done'; LABEL GISQ1 = 'Q1: Assessment for Patchy AA'; LABEL GISQ1NA = 'Q1 not applicable'; LABEL GISQ2 = 'Q2: Assessment for AU/AT'; LABEL GISQ2NA = 'Q2 not applicable'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT GISND CL_ND.; FORMAT GISQ1NA CL_NA.; FORMAT GISQ2NA CL_NA.; run; %include inpath(HPT.FMT); DATA studylib.HPT (LABEL= 'HPT'); INFILE inpath(HPT.DAT) LRECL=144; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 HPTND 1.0 @141 HPTNA 1.0 @142 HPTRES 1.0 @143 HPTBROK 1.0 @144 HPTBORDR 1.0 ; LABEL HPTBORDR = 'Broken hairs at alopecic border'; LABEL HPTBROK = 'Hairs broken? (Y/N)'; LABEL HPTNA = 'Not applicable for AU/AT'; LABEL HPTND = 'Test not done'; LABEL HPTRES = 'Test Result Normal/abnormal'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT HPTND CL_ND.; FORMAT HPTNA CL_NA.; FORMAT HPTRES CL_NORM.; FORMAT HPTBROK CL_YESNO.; FORMAT HPTBORDR CL_YESNO.; run; %include inpath(HX.FMT); DATA studylib.HX (LABEL= 'HX'); INFILE inpath(HX.DAT) LRECL=236; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 HXORGDTC $CHAR9. @149 HXCURDTC $CHAR9. @158 HXTYPE 1.0 @159 HXOPHIA 1.0 @160 HXTHERPY 1.0 @161 HXTHRP01 1.0 @162 HXTHRP02 1.0 @163 HXTHRP03 1.0 @164 HXTHRP04 1.0 @165 HXTHRP05 1.0 @166 HXTHRP06 1.0 @167 HXTHRP07 1.0 @168 HXTHRP08 1.0 @169 HXTHRP09 1.0 @170 HXTHRP10 1.0 @171 HXTHRP11 1.0 @172 HXTHRP99 1.0 @173 HXTHRPOT $CHAR64. ; LABEL HXCURDTC = 'Onset date of cur episode of Patchy'; LABEL HXOPHIA = 'Does the subject have ophiasis pattern'; LABEL HXORGDTC = 'Onset date of alopecia'; LABEL HXTHERPY = 'Previous therapies?'; LABEL HXTHRP01 = '1) Topical Immunotherapy'; LABEL HXTHRP02 = '2) Corticosteroids'; LABEL HXTHRP03 = '3) Systemic steroids'; LABEL HXTHRP04 = '4) DMARDS'; LABEL HXTHRP05 = '5) Biologics/Immunosuppresants'; LABEL HXTHRP06 = '6) Plaqunil'; LABEL HXTHRP07 = '7) PDT'; LABEL HXTHRP08 = '8) JAK inhibitors'; LABEL HXTHRP09 = '9) Phototherapy'; LABEL HXTHRP10 = '10) Laser Therapy'; LABEL HXTHRP11 = '11) Narrow-band UVB'; LABEL HXTHRP99 = '99) Other therapy'; LABEL HXTHRPOT = 'Other specification'; LABEL HXTYPE = 'Alopecia Type'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT HXTYPE CL_ATYPE.; FORMAT HXTHERPY CL_YESNO.; run; %include inpath(ICF.FMT); DATA studylib.ICF (LABEL= 'ICF'); INFILE inpath(ICF.DAT) LRECL=154; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 ICFSIGN 1.0 @141 ICFDATE $CHAR9. @150 ICFTIME $CHAR4. @154 ICFPROTO 1.0 ; LABEL ICFDATE = 'Date of ICF signature'; LABEL ICFPROTO = 'Protocol version'; LABEL ICFSIGN = 'Informed consent signed?'; LABEL ICFTIME = 'Time of informed consent'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT ICFSIGN CL_YESNO.; run; %include inpath(INC.FMT); DATA studylib.INC (LABEL= 'INC'); INFILE inpath(INC.DAT) LRECL=143; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 INCID $CHAR3. @143 INCRES 1.0 ; LABEL INCID = 'Inclusion criterion ID'; LABEL INCRES = 'Inclusion criteria result'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT INCRES CL_YNA.; run; %include inpath(INVSIG.FMT); DATA studylib.INVSIG (LABEL= 'INVSIG'); INFILE inpath(INVSIG.DAT) LRECL=149; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 SIGNED 1.0 @141 SIGDATE $CHAR9. ; LABEL SIGDATE = 'Date of sign-off'; LABEL SIGNED = 'Investigator sign-off'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT SIGNED CL_YESNO.; run; %include inpath(LAB.FMT); DATA studylib.LAB (LABEL= 'LAB'); INFILE inpath(LAB.DAT) LRECL=150; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 LABSAMP 1.0 @141 LABDTC $CHAR9. @150 LABCS 1.0 ; LABEL LABCS = 'Are there Clin. Significant results'; LABEL LABDTC = 'Date of lab sample collevction'; LABEL LABSAMP = 'Lab Samples collected?'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT LABSAMP CL_YESNO.; FORMAT LABCS CL_YESNO.; run; %include inpath(MH.FMT); DATA studylib.MH (LABEL= 'MH'); INFILE inpath(MH.DAT) LRECL=361; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 MHBODSYS $CHAR2. @142 MHDIAG $CHAR200. @342 MHSTDAT $CHAR9. @351 MHENDAT $CHAR9. @360 MHCONT 1.0 @361 MHCONMED 1.0 ; LABEL MHBODSYS = 'Body system code'; LABEL MHCONMED = 'Current concomitant therapies?'; LABEL MHCONT = 'Ongoing?'; LABEL MHDIAG = 'Diagnosis and/or preocedure'; LABEL MHENDAT = 'Resolution date'; LABEL MHSTDAT = 'Onset date'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT MHBODSYS CL_BDSYS.; FORMAT MHCONT CL_YESNO.; FORMAT MHCONMED YESNOUNK.; run; %include inpath(NSHA.FMT); DATA studylib.NSHA (LABEL= 'NSHA'); INFILE inpath(NSHA.DAT) LRECL=144; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 NSHAND 1.0 @141 NSHAQ1ND 1.0 @142 NSHAQ1 1.0 @143 NSHAQ2ND 1.0 @144 NSHAQ2 1.0 ; LABEL NSHAND = 'NSHA not done'; LABEL NSHAQ1 = 'NSHA Q1: Body Hair loss'; LABEL NSHAQ1ND = 'NSHA Q1 not done'; LABEL NSHAQ2 = 'NSHA Q2: Nasal Hair loss'; LABEL NSHAQ2ND = 'NSHA Q2 not done'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT NSHAND CL_ND.; FORMAT NSHAQ1ND CL_ND.; FORMAT NSHAQ2ND CL_ND.; run; %include inpath(PE.FMT); DATA studylib.PE (LABEL= 'PE'); INFILE inpath(PE.DAT) LRECL=221; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 PECAT $CHAR16. @156 PEND 1.0 @157 PERES 1.0 @158 PECMNT $CHAR64. ; LABEL PECAT = 'Examination Category'; LABEL PECMNT = 'Comment if abnormal'; LABEL PEND = 'Examination not done?'; LABEL PERES = 'Examination result'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT PEND CL_ND.; FORMAT PERES CL_PERES.; run; %include inpath(PHOTO.FMT); DATA studylib.PHOTO (LABEL= 'PHOTO'); INFILE inpath(PHOTO.DAT) LRECL=140; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 PHOTOYN 1.0 ; LABEL PHOTOYN = 'Photo taken y/n'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT PHOTOYN CL_YESNO.; run; %include inpath(RX.FMT); DATA studylib.RX (LABEL= 'RX'); INFILE inpath(RX.DAT) LRECL=148; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 RXYN 1.0 @141 KITNUM $CHAR8. ; LABEL KITNUM = 'Assigned kit number'; LABEL RXYN = 'Subject is eligible for randomization'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT RXYN CL_YESNO.; run; %include inpath(SA.FMT); DATA studylib.SA (LABEL= 'SA'); INFILE inpath(SA.DAT) LRECL=150; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 SALTND 1.0 @141 SALTRES 3.0 @144 ALODND 1.0 @145 ALODRES 3.0 @148 VIND 1.0 @149 VIQ1 1.0 @150 VIQ2 1.0 ; LABEL ALODND = 'ALODEX score not done'; LABEL ALODRES = 'ALODEX score'; LABEL SALTND = 'SALT score not done'; LABEL SALTRES = 'SALT score'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL VIND = 'Vellus/Indeterminate question ND'; LABEL VIQ1 = 'Q1: vellus hair present'; LABEL VIQ2 = 'Q2: Indeterminate hair present?'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT SALTND CL_ND.; FORMAT ALODND CL_ND.; FORMAT VIND CL_ND.; FORMAT VIQ1 CL_YESNO.; FORMAT VIQ2 CL_YESNO.; run; %include inpath(SGITS.FMT); DATA studylib.SGITS (LABEL= 'SGITS'); INFILE inpath(SGITS.DAT) LRECL=144; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 SGITSND 1.0 @141 SGITQ1NA 1.0 @142 SGITSQ1 1.0 @143 SGITQ2NA 1.0 @144 SGITSQ2 1.0 ; LABEL SGITQ1NA = 'Q1 not applicable'; LABEL SGITQ2NA = 'Q2 not applicable'; LABEL SGITSND = 'SGITS not done'; LABEL SGITSQ1 = 'Q1A: Assessment for Patchy AA'; LABEL SGITSQ2 = 'Q2: Assessment for AU/AT'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT SGITSND CL_ND.; FORMAT SGITQ1NA CL_NA.; FORMAT SGITQ2NA CL_NA.; run; %include inpath(SGSHQ.FMT); DATA studylib.SGSHQ (LABEL= 'SGSHQ'); INFILE inpath(SGSHQ.DAT) LRECL=145; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 SGSHQND 1.0 @141 SGSHQ1NA 1.0 @142 SGSHQ1A 1.0 @143 SGSHQ1B 1.0 @144 SGSHQ2NA 1.0 @145 SGSHQ2 1.0 ; LABEL SGSHQ1A = 'Q1A: Target assessment for Patchy AA'; LABEL SGSHQ1B = 'Q1B: Treated assessment for Patchy AA'; LABEL SGSHQ1NA = 'Q1 not applicable'; LABEL SGSHQ2 = 'Q2: Assessment for AU/AT'; LABEL SGSHQ2NA = 'Q2 not applicable'; LABEL SGSHQND = 'SGSHQ not done'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT SGSHQND CL_ND.; FORMAT SGSHQ1NA CL_NA.; FORMAT SGSHQ2NA CL_NA.; run; %include inpath(SMU.FMT); DATA studylib.SMU (LABEL= 'SMU'); INFILE inpath(SMU.DAT) LRECL=190; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 SMUSTART $CHAR9. @149 SMUAPP 1.0 @150 SMUOTH $CHAR32. @182 SMUEND $CHAR9. ; LABEL SITEID = 'Site ID'; LABEL SMUAPP = 'Applications per day'; LABEL SMUEND = 'Date application frequency ended'; LABEL SMUOTH = 'Other Frequency'; LABEL SMUSTART = 'Date Application Frequency started'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT SMUAPP CL_APPFQ.; run; %include inpath(SPT.FMT); DATA studylib.SPT (LABEL= 'SPT'); INFILE inpath(SPT.DAT) LRECL=141; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 SPTDONE 1.0 @141 SPTORRES 1.0 ; LABEL SITEID = 'Site ID'; LABEL SPTDONE = 'SPT done?'; LABEL SPTORRES = 'SPT Result'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT SPTDONE CL_YNA.; FORMAT SPTORRES CL_PN.; run; %include inpath(TSPI.FMT); DATA studylib.TSPI (LABEL= 'TSPI'); INFILE inpath(TSPI.DAT) LRECL=142; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 TSPIND 1.0 @141 TSPIRES 1.0 @142 TSPIDOC 1.0 ; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL TSPIDOC = 'Documented photographically?'; LABEL TSPIND = 'Identification not done'; LABEL TSPIRES = 'Identified by subject'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT TSPIND CL_ND.; FORMAT TSPIRES CL_YNA.; FORMAT TSPIDOC CL_YESNO.; run; %include inpath(UPT.FMT); DATA studylib.UPT (LABEL= 'UPT'); INFILE inpath(UPT.DAT) LRECL=141; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 UPTDONE 1.0 @141 UPTORRES 1.0 ; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL UPTDONE = 'UPT done?'; LABEL UPTORRES = 'UPT Result'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT UPTDONE CL_YNA.; FORMAT UPTORRES CL_PN.; run; %include inpath(UV.FMT); DATA studylib.UV (LABEL= 'UV'); INFILE inpath(UV.DAT) LRECL=203; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 UVREAS $CHAR64. ; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL UVREAS = 'Reason for unscheduled visit'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; run; %include inpath(VS.FMT); DATA studylib.VS (LABEL= 'VS'); INFILE inpath(VS.DAT) LRECL=166; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 VSDONE 1.0 @141 VSBPSYS 3.0 @144 VSBPDIA 3.0 @147 VSPULSE 3.0 @150 VSTEMP 5.0 @155 VSRESP 2.0 @157 VSWT 3.0 @160 VSHT 4.0 @164 VSQ1 1.0 @165 VSQ2 1.0 @166 VSQ3 1.0 ; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL VSBPDIA = 'Blood pressure diastolic'; LABEL VSBPSYS = 'Blood pressure systolic'; LABEL VSDONE = 'VS not done'; LABEL VSHT = 'Height (in)'; LABEL VSPULSE = 'Pulse rate (beats/min)'; LABEL VSQ1 = 'Relevance if systolic > 140mmHg'; LABEL VSQ2 = 'Relevance if diastolic > 90mmHG'; LABEL VSQ3 = 'Relevance if Weight > 300lbs'; LABEL VSRESP = 'Respiratory rate (breaths/min)'; LABEL VSTEMP = 'Body temperature deg F'; LABEL VSWT = 'Weight (lb)'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT VSDONE CL_YESNO.; FORMAT VSQ1 CL_YESNO.; FORMAT VSQ2 CL_YESNO.; FORMAT VSQ3 CL_YESNO.; run; %include inpath(PK.FMT); DATA studylib.PK (LABEL= 'PK'); INFILE inpath(PK.DAT) LRECL=143; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 PKSAMP 1.0 @141 PDSAMP 1.0 @142 PKTELCAL 1.0 @143 PKTIMFRM 1.0 ; LABEL PDSAMP = 'PD sample collected'; LABEL PKSAMP = 'PK sample collected'; LABEL PKTELCAL = 'Was a telephone reminder given?'; LABEL PKTIMFRM = 'Were samples collected in correct timeframe?'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT PKSAMP CL_YNA.; FORMAT PDSAMP CL_YNA.; FORMAT PKTELCAL CL_YESNO.; FORMAT PKTIMFRM CL_YESNO.; run; proc copy in=work out=studylib; select formats; run;
5 REPLIES 5
Super User
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Formats change how a variable is displayed, but not the underlying variable.
If you want the variable value to change you need to create a new variable with the format applied or export it to a format that will maintain the display, such as CSV or Excel file that doesn't have formats.
You can also try an XPORT formatted file to see if that keeps the formats, I'm not sure if it does or not.
To apply a format, use the PUT() statement.
VSQ1_formatted = put(VSQ1, CL_YESNO.);
Spoiler
@PSU_Sudzi wrote:
I am using the program below to import data and convert to SAS datasets (code not written by me). When I run it and view the SAS datasets within the SAS study library in SAS 9.4, I can see all the decodes for the variables, e..g YES, NO, NA. But if I try to view any of these datasets from SAS Universal Viewer in Windows Explorer or export them out into Excel, all I get is the numeric codes, e.g. 1, 2, 9. How can I turn the datasets into being permanently decoded so they can be viewed in Windows Explorer decoded or exported in the same format?
*******************************************************************; ***** STUDY NAME HERE *****; *******************************************************************; ** Author: **; ** Date: **; ** Study: **; *******************************************************************; *******************************************************************; ** -------- Edit input and output paths to match your installation --------**; filename inpath 'FOLDER INPATH HERE'; %Let SAS_OUTPUT_PATH = FOLDER OUTPATH HERE; ** ----------------- Do Not Change anything below this line ---------------**; libname studylib "&SAS_OUTPUT_PATH"; options fmtsearch=(studylib); run; %include inpath(HDR.FMT); DATA studylib.HDR (LABEL= 'HDR'); INFILE inpath(HDR.DAT) LRECL=159; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 HDRINIT $CHAR3. @143 HDRDATE $CHAR9. @152 HDRBLANK 1.0 @153 HDRPGNUM 3.0 @156 HDRREADY 1.0 @157 HDRVNUM 3.0 ; LABEL HDRBLANK = 'Page is intentionally blank'; LABEL HDRDATE = 'Date on page header'; LABEL HDRINIT = 'Subject initials'; LABEL HDRPGNUM = 'Page number of repeating page'; LABEL HDRREADY = 'Page is ready (for EDC transmission)'; LABEL HDRVNUM = 'Visit Repeat Key'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT HDRREADY CL_YESNO.; run; %include inpath(PANEL.FMT); DATA studylib.PANEL (LABEL= 'PANEL'); INFILE inpath(PANEL.DAT) LRECL=140; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 PANELND 1.0 ; LABEL PANELND = 'Panel Not Done'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT PANELND CL_ND.; run; %include inpath(AE.FMT); DATA studylib.AE (LABEL= 'AE'); INFILE inpath(AE.DAT) LRECL=420; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 AETERM $CHAR255. @395 AESTDAT $CHAR9. @404 AEENDTC $CHAR9. @413 AEONGO 1.0 @414 AESEV 1.0 @415 AEREL 1.0 @416 AEOUT 1.0 @417 AEACTION 1.0 @418 AESAE 1.0 @419 AETHERPY 1.0 @420 AEDISCON 1.0 ; LABEL AEACTION = 'Action required'; LABEL AEDISCON = 'Discontinued due to AE?'; LABEL AEENDTC = 'End date of AE'; LABEL AEONGO = 'AE Ongoing?'; LABEL AEOUT = 'AE outcome code'; LABEL AEREL = 'AE relationship'; LABEL AESAE = 'Serious Adverse Event?'; LABEL AESEV = 'Severity code'; LABEL AESTDAT = 'Start date of AE'; LABEL AETERM = 'Adverse event/Medical condition'; LABEL AETHERPY = 'Therapy required for AE?'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT AEONGO CL_YESNO.; FORMAT AESEV CL_AESEV.; FORMAT AEREL CL_AEREL.; FORMAT AEOUT CL_AEOUT.; FORMAT AEACTION CL_AEACN.; FORMAT AESAE CL_YESNO.; FORMAT AETHERPY CL_YESNO.; FORMAT AEDISCON CL_YESNO.; run; %include inpath(AE2.FMT); DATA studylib.AE2 (LABEL= 'AE2'); INFILE inpath(AE2.DAT) LRECL=149; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 AENUM 2.0 @142 AESTATUS $CHAR8. ; LABEL AENUM = 'AE Number'; LABEL AESTATUS = 'Status of this AE (active/deleted)'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; run; %include inpath(AIA.FMT); DATA studylib.AIA (LABEL= 'AIA'); INFILE inpath(AIA.DAT) LRECL=143; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 AIAND 1.0 @141 AIASEQ 2.0 @143 AIARES $CHAR1. ; LABEL AIAND = 'AIA Assessment not done'; LABEL AIARES = 'AIA Item res'; LABEL AIASEQ = 'AIA Item ID'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT AIAND CL_ND.; run; %include inpath(AFHA.FMT); DATA studylib.AFHA (LABEL= 'AFHA'); INFILE inpath(AFHA.DAT) LRECL=167; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 AFHAND 1.0 @141 AFHAEVAL $CHAR16. @157 AFHAQ1ND 1.0 @158 AFHAQ1 1.0 @159 AFHAQ2ND 1.0 @160 AFHAQ2 1.0 @161 AFHAQ3ND 1.0 @162 AFHAQ3 1.0 @163 AFHAQ4ND 1.0 @164 AFHAQ4 1.0 @165 AFHAQ5ND 1.0 @166 AFHAQ5NA 1.0 @167 AFHAQ5 1.0 ; LABEL AFHAEVAL = 'AFHA Evaluator'; LABEL AFHAND = 'AFHA not done'; LABEL AFHAQ1 = 'Q1: Appearance of Left Eyebrow'; LABEL AFHAQ1ND = 'Q1 not done'; LABEL AFHAQ2 = 'Q2: Appearance of right eyebrow'; LABEL AFHAQ2ND = 'Q2 not done'; LABEL AFHAQ3 = 'Q3: Appearance of left eyelashes'; LABEL AFHAQ3ND = 'Q3 not done'; LABEL AFHAQ4 = 'Q4: Appearance of right eyelashes'; LABEL AFHAQ4ND = 'Q4 not done'; LABEL AFHAQ5 = 'Q5: Appearance of beard hair'; LABEL AFHAQ5NA = 'Q5 not applicable'; LABEL AFHAQ5ND = 'Q5 not done'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT AFHAND CL_ND.; FORMAT AFHAQ1ND CL_ND.; FORMAT AFHAQ2ND CL_ND.; FORMAT AFHAQ3ND CL_ND.; FORMAT AFHAQ4ND CL_ND.; FORMAT AFHAQ5ND CL_ND.; FORMAT AFHAQ5NA CL_NA.; run; %include inpath(ASAA.FMT); DATA studylib.ASAA (LABEL= 'ASAA'); INFILE inpath(ASAA.DAT) LRECL=159; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 ASAAND 1.0 @141 ASAAEVAL $CHAR16. @157 ASAATPNA 1.0 @158 ASAATPA 1.0 @159 ASAAWSA 1.0 ; LABEL ASAAEVAL = 'Evaluator'; LABEL ASAAND = 'ASAA not done'; LABEL ASAATPA = 'Target Patch Assessment'; LABEL ASAATPNA = 'Target Patch assessment N/A'; LABEL ASAAWSA = 'Whole Scalp Assessment'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT ASAAND CL_ND.; FORMAT ASAATPNA CL_NA.; run; %include inpath(CBP.FMT); DATA studylib.CBP (LABEL= 'CBP'); INFILE inpath(CBP.DAT) LRECL=207; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 CBPSTAT 1.0 @141 CBPPOSTM 1.0 @142 CBPSTERL 1.0 @143 CBPOTHER 1.0 @144 CBPOSPEC $CHAR64. ; LABEL CBPOSPEC = 'CBP other specification'; LABEL CBPOTHER = 'Other reason for non-WOCBP'; LABEL CBPPOSTM = 'Subject is post-menopausal'; LABEL CBPSTAT = 'CBP status'; LABEL CBPSTERL = 'Subject is surgically sterile'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT CBPSTAT CL_WOCBP.; FORMAT CBPPOSTM CL_YESNO.; FORMAT CBPSTERL CL_YESNO.; FORMAT CBPOTHER CL_YESNO.; run; %include inpath(CM.FMT); DATA studylib.CM (LABEL= 'CM'); INFILE inpath(CM.DAT) LRECL=538; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 CMNAME $CHAR128. @268 CMINDC $CHAR128. @396 CMSTDAT $CHAR9. @405 CMENDAT $CHAR9. @414 CMONGO 1.0 @415 CMDOSE $CHAR16. @431 CMDOSU $CHAR2. @433 CMDSUOTH $CHAR32. @465 CMROUTE $CHAR2. @467 CMRTOTH $CHAR32. @499 CMDOSFRQ $CHAR2. @501 CMFRQOTH $CHAR32. @533 CMNONMED 1.0 @534 CMPV 1.0 @535 CMAE 1.0 @536 CMAEREF 3.0 ; LABEL CMAE = 'Associated with an AE?'; LABEL CMAEREF = 'AE number'; LABEL CMDOSE = 'Dose'; LABEL CMDOSFRQ = 'Dose Frequency'; LABEL CMDOSU = 'Dose units (from code list)'; LABEL CMDSUOTH = 'Dose other spec'; LABEL CMENDAT = 'End date'; LABEL CMFRQOTH = 'Frequency other spec'; LABEL CMINDC = 'Indication'; LABEL CMNAME = 'Medication name'; LABEL CMNONMED = 'Is non-medication therapy?'; LABEL CMONGO = 'Ongoing? (y/n)'; LABEL CMPV = 'Is therapy prohibited?'; LABEL CMROUTE = 'Route (from codelist)'; LABEL CMRTOTH = 'Route other spec'; LABEL CMSTDAT = 'Start date'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT CMONGO CL_YESNO.; FORMAT CMDOSU CL_DOSEU.; FORMAT CMROUTE CL_CMRT.; FORMAT CMDOSFRQ CL_CMFRQ.; FORMAT CMNONMED CL_YESNO.; FORMAT CMPV YESNOUNK.; FORMAT CMAE CL_YESNO.; run; %include inpath(CO.FMT); DATA studylib.CO (LABEL= 'CO'); INFILE inpath(CO.DAT) LRECL=451; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 COPGREF $CHAR8. @148 COITREF $CHAR32. @180 COINIT $CHAR8. @188 CODTC $CHAR9. @197 COVAL $CHAR255. ; LABEL CODTC = 'Date of comment'; LABEL COINIT = 'Comments by'; LABEL COITREF = 'Item reference for comment'; LABEL COPGREF = 'Page reference for comment'; LABEL COVAL = 'Investigator comment'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; run; %include inpath(DA.FMT); DATA studylib.DA (LABEL= 'DA'); INFILE inpath(DA.DAT) LRECL=228; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 DAND 1.0 @141 DASTDTC $CHAR9. @150 DAENDTC $CHAR9. @159 DACMNT $CHAR64. @223 DAUSED 2.0 @225 DAUNUSED 2.0 @227 DAMISS 2.0 ; LABEL DACMNT = 'Comment'; LABEL DAENDTC = 'Date collected'; LABEL DAMISS = 'Number of missing bottles'; LABEL DAND = 'Bottle not used'; LABEL DASTDTC = 'Date dispensed'; LABEL DAUNUSED = 'Number of bottles not used'; LABEL DAUSED = 'Number of bottles used'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT DAND CL_ND.; run; %include inpath(DLQI.FMT); DATA studylib.DLQI (LABEL= 'DLQI'); INFILE inpath(DLQI.DAT) LRECL=143; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 DLQIND 1.0 @141 DLQISEQ $CHAR2. @143 DLQIRES 1.0 ; LABEL DLQIND = 'Question not asked'; LABEL DLQIRES = 'DLQI Item result'; LABEL DLQISEQ = 'DLQI item ID'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT DLQIND CL_ND.; run; %include inpath(DM.FMT); DATA studylib.DM (LABEL= 'DM'); INFILE inpath(DM.DAT) LRECL=216; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 BRTHDTC $CHAR9. @149 SEX 1.0 @150 RACE 1.0 @151 RACEOTH $CHAR64. @215 ETHNIC 1.0 @216 SKINTYPE 1.0 ; LABEL BRTHDTC = 'Date of birth'; LABEL ETHNIC = 'Subject Ethnicity'; LABEL RACE = 'Subject Race'; LABEL RACEOTH = 'Race other, specify'; LABEL SEX = 'Subject gender'; LABEL SITEID = 'Site ID'; LABEL SKINTYPE = 'Skin Type'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT SEX CL_SEX.; FORMAT RACE CL_RACE.; FORMAT ETHNIC CL_ETHNC.; run; %include inpath(ECG.FMT); DATA studylib.ECG (LABEL= 'ECG'); INFILE inpath(ECG.DAT) LRECL=215; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 ECGDONE 1.0 @141 ECGRES 1.0 @142 ECGSPEC $CHAR64. @206 ECGDTC $CHAR9. @215 ECGCS 1.0 ; LABEL ECGCS = 'Clincally significant abnormality?'; LABEL ECGDONE = 'ECG Done?'; LABEL ECGDTC = 'Date of ECG'; LABEL ECGRES = 'ECG Result (normal/abnormal)'; LABEL ECGSPEC = 'ECG specify if abnormal'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT ECGDONE CL_YESNO.; FORMAT ECGRES CL_NORM.; FORMAT ECGCS CL_YESNO.; run; %include inpath(ELG.FMT); DATA studylib.ELG (LABEL= 'ELG'); INFILE inpath(ELG.DAT) LRECL=140; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 ELGQ1 1.0 ; LABEL ELGQ1 = 'Subject complied with protocol restrictions and instructions'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT ELGQ1 CL_YESNO.; run; %include inpath(EOS.FMT); DATA studylib.EOS (LABEL= 'EOS'); INFILE inpath(EOS.DAT) LRECL=361; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 EOSELG 1.0 @141 EOSLVDAT $CHAR9. @150 EOSCMPLT 1.0 @151 EOSDCRES 1.0 @152 EOSAEREF $CHAR8. @160 EOSPV 1.0 @161 EOSPVRES 1.0 @162 EOSCMNT $CHAR200. ; LABEL EOSAEREF = 'AE reference if applicable'; LABEL EOSCMNT = 'Comment to EOS status'; LABEL EOSCMPLT = 'Completed full course?'; LABEL EOSDCRES = 'D/Con reason code'; LABEL EOSELG = 'Was subject eligible for inclusion'; LABEL EOSLVDAT = 'Date of last visit'; LABEL EOSPV = 'Subject had Protocol Violation?'; LABEL EOSPVRES = 'PV Reason Code'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT EOSELG CL_YESNO.; FORMAT EOSCMPLT CL_YESNO.; FORMAT EOSDCRES CL_DCRES.; FORMAT EOSPV CL_YESNO.; FORMAT EOSPVRES CL_PVRES.; run; %include inpath(ET.FMT); DATA studylib.ET (LABEL= 'ET'); INFILE inpath(ET.DAT) LRECL=140; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 ETV9 1.0 ; LABEL ETV9 = 'Is Visit 9 an early term visit?'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT ETV9 CL_YESNO.; run; %include inpath(EXC.FMT); DATA studylib.EXC (LABEL= 'EXC'); INFILE inpath(EXC.DAT) LRECL=143; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 EXCID $CHAR3. @143 EXCRES 1.0 ; LABEL EXCID = 'Exclusion Criterion ID'; LABEL EXCRES = 'Exclusion criterion result'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT EXCRES CL_YNA.; run; %include inpath(GIC.FMT); DATA studylib.GIC (LABEL= 'GIC'); INFILE inpath(GIC.DAT) LRECL=157; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 GICND 1.0 @141 GICEVAL $CHAR16. @157 GICRES 1.0 ; LABEL GICEVAL = 'Evaluator'; LABEL GICND = 'Assessment not done'; LABEL GICRES = 'Assessment result'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT GICND CL_ND.; run; %include inpath(GIS.FMT); DATA studylib.GIS (LABEL= 'GIS'); INFILE inpath(GIS.DAT) LRECL=160; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 GISND 1.0 @141 GISEVAL $CHAR16. @157 GISQ1NA 1.0 @158 GISQ1 1.0 @159 GISQ2NA 1.0 @160 GISQ2 1.0 ; LABEL GISEVAL = 'Evaluator'; LABEL GISND = 'GIS not done'; LABEL GISQ1 = 'Q1: Assessment for Patchy AA'; LABEL GISQ1NA = 'Q1 not applicable'; LABEL GISQ2 = 'Q2: Assessment for AU/AT'; LABEL GISQ2NA = 'Q2 not applicable'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT GISND CL_ND.; FORMAT GISQ1NA CL_NA.; FORMAT GISQ2NA CL_NA.; run; %include inpath(HPT.FMT); DATA studylib.HPT (LABEL= 'HPT'); INFILE inpath(HPT.DAT) LRECL=144; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 HPTND 1.0 @141 HPTNA 1.0 @142 HPTRES 1.0 @143 HPTBROK 1.0 @144 HPTBORDR 1.0 ; LABEL HPTBORDR = 'Broken hairs at alopecic border'; LABEL HPTBROK = 'Hairs broken? (Y/N)'; LABEL HPTNA = 'Not applicable for AU/AT'; LABEL HPTND = 'Test not done'; LABEL HPTRES = 'Test Result Normal/abnormal'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT HPTND CL_ND.; FORMAT HPTNA CL_NA.; FORMAT HPTRES CL_NORM.; FORMAT HPTBROK CL_YESNO.; FORMAT HPTBORDR CL_YESNO.; run; %include inpath(HX.FMT); DATA studylib.HX (LABEL= 'HX'); INFILE inpath(HX.DAT) LRECL=236; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 HXORGDTC $CHAR9. @149 HXCURDTC $CHAR9. @158 HXTYPE 1.0 @159 HXOPHIA 1.0 @160 HXTHERPY 1.0 @161 HXTHRP01 1.0 @162 HXTHRP02 1.0 @163 HXTHRP03 1.0 @164 HXTHRP04 1.0 @165 HXTHRP05 1.0 @166 HXTHRP06 1.0 @167 HXTHRP07 1.0 @168 HXTHRP08 1.0 @169 HXTHRP09 1.0 @170 HXTHRP10 1.0 @171 HXTHRP11 1.0 @172 HXTHRP99 1.0 @173 HXTHRPOT $CHAR64. ; LABEL HXCURDTC = 'Onset date of cur episode of Patchy'; LABEL HXOPHIA = 'Does the subject have ophiasis pattern'; LABEL HXORGDTC = 'Onset date of alopecia'; LABEL HXTHERPY = 'Previous therapies?'; LABEL HXTHRP01 = '1) Topical Immunotherapy'; LABEL HXTHRP02 = '2) Corticosteroids'; LABEL HXTHRP03 = '3) Systemic steroids'; LABEL HXTHRP04 = '4) DMARDS'; LABEL HXTHRP05 = '5) Biologics/Immunosuppresants'; LABEL HXTHRP06 = '6) Plaqunil'; LABEL HXTHRP07 = '7) PDT'; LABEL HXTHRP08 = '8) JAK inhibitors'; LABEL HXTHRP09 = '9) Phototherapy'; LABEL HXTHRP10 = '10) Laser Therapy'; LABEL HXTHRP11 = '11) Narrow-band UVB'; LABEL HXTHRP99 = '99) Other therapy'; LABEL HXTHRPOT = 'Other specification'; LABEL HXTYPE = 'Alopecia Type'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT HXTYPE CL_ATYPE.; FORMAT HXTHERPY CL_YESNO.; run; %include inpath(ICF.FMT); DATA studylib.ICF (LABEL= 'ICF'); INFILE inpath(ICF.DAT) LRECL=154; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 ICFSIGN 1.0 @141 ICFDATE $CHAR9. @150 ICFTIME $CHAR4. @154 ICFPROTO 1.0 ; LABEL ICFDATE = 'Date of ICF signature'; LABEL ICFPROTO = 'Protocol version'; LABEL ICFSIGN = 'Informed consent signed?'; LABEL ICFTIME = 'Time of informed consent'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT ICFSIGN CL_YESNO.; run; %include inpath(INC.FMT); DATA studylib.INC (LABEL= 'INC'); INFILE inpath(INC.DAT) LRECL=143; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 INCID $CHAR3. @143 INCRES 1.0 ; LABEL INCID = 'Inclusion criterion ID'; LABEL INCRES = 'Inclusion criteria result'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT INCRES CL_YNA.; run; %include inpath(INVSIG.FMT); DATA studylib.INVSIG (LABEL= 'INVSIG'); INFILE inpath(INVSIG.DAT) LRECL=149; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 SIGNED 1.0 @141 SIGDATE $CHAR9. ; LABEL SIGDATE = 'Date of sign-off'; LABEL SIGNED = 'Investigator sign-off'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT SIGNED CL_YESNO.; run; %include inpath(LAB.FMT); DATA studylib.LAB (LABEL= 'LAB'); INFILE inpath(LAB.DAT) LRECL=150; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 LABSAMP 1.0 @141 LABDTC $CHAR9. @150 LABCS 1.0 ; LABEL LABCS = 'Are there Clin. Significant results'; LABEL LABDTC = 'Date of lab sample collevction'; LABEL LABSAMP = 'Lab Samples collected?'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT LABSAMP CL_YESNO.; FORMAT LABCS CL_YESNO.; run; %include inpath(MH.FMT); DATA studylib.MH (LABEL= 'MH'); INFILE inpath(MH.DAT) LRECL=361; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 MHBODSYS $CHAR2. @142 MHDIAG $CHAR200. @342 MHSTDAT $CHAR9. @351 MHENDAT $CHAR9. @360 MHCONT 1.0 @361 MHCONMED 1.0 ; LABEL MHBODSYS = 'Body system code'; LABEL MHCONMED = 'Current concomitant therapies?'; LABEL MHCONT = 'Ongoing?'; LABEL MHDIAG = 'Diagnosis and/or preocedure'; LABEL MHENDAT = 'Resolution date'; LABEL MHSTDAT = 'Onset date'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT MHBODSYS CL_BDSYS.; FORMAT MHCONT CL_YESNO.; FORMAT MHCONMED YESNOUNK.; run; %include inpath(NSHA.FMT); DATA studylib.NSHA (LABEL= 'NSHA'); INFILE inpath(NSHA.DAT) LRECL=144; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 NSHAND 1.0 @141 NSHAQ1ND 1.0 @142 NSHAQ1 1.0 @143 NSHAQ2ND 1.0 @144 NSHAQ2 1.0 ; LABEL NSHAND = 'NSHA not done'; LABEL NSHAQ1 = 'NSHA Q1: Body Hair loss'; LABEL NSHAQ1ND = 'NSHA Q1 not done'; LABEL NSHAQ2 = 'NSHA Q2: Nasal Hair loss'; LABEL NSHAQ2ND = 'NSHA Q2 not done'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT NSHAND CL_ND.; FORMAT NSHAQ1ND CL_ND.; FORMAT NSHAQ2ND CL_ND.; run; %include inpath(PE.FMT); DATA studylib.PE (LABEL= 'PE'); INFILE inpath(PE.DAT) LRECL=221; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 PECAT $CHAR16. @156 PEND 1.0 @157 PERES 1.0 @158 PECMNT $CHAR64. ; LABEL PECAT = 'Examination Category'; LABEL PECMNT = 'Comment if abnormal'; LABEL PEND = 'Examination not done?'; LABEL PERES = 'Examination result'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT PEND CL_ND.; FORMAT PERES CL_PERES.; run; %include inpath(PHOTO.FMT); DATA studylib.PHOTO (LABEL= 'PHOTO'); INFILE inpath(PHOTO.DAT) LRECL=140; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 PHOTOYN 1.0 ; LABEL PHOTOYN = 'Photo taken y/n'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT PHOTOYN CL_YESNO.; run; %include inpath(RX.FMT); DATA studylib.RX (LABEL= 'RX'); INFILE inpath(RX.DAT) LRECL=148; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 RXYN 1.0 @141 KITNUM $CHAR8. ; LABEL KITNUM = 'Assigned kit number'; LABEL RXYN = 'Subject is eligible for randomization'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT RXYN CL_YESNO.; run; %include inpath(SA.FMT); DATA studylib.SA (LABEL= 'SA'); INFILE inpath(SA.DAT) LRECL=150; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 SALTND 1.0 @141 SALTRES 3.0 @144 ALODND 1.0 @145 ALODRES 3.0 @148 VIND 1.0 @149 VIQ1 1.0 @150 VIQ2 1.0 ; LABEL ALODND = 'ALODEX score not done'; LABEL ALODRES = 'ALODEX score'; LABEL SALTND = 'SALT score not done'; LABEL SALTRES = 'SALT score'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL VIND = 'Vellus/Indeterminate question ND'; LABEL VIQ1 = 'Q1: vellus hair present'; LABEL VIQ2 = 'Q2: Indeterminate hair present?'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT SALTND CL_ND.; FORMAT ALODND CL_ND.; FORMAT VIND CL_ND.; FORMAT VIQ1 CL_YESNO.; FORMAT VIQ2 CL_YESNO.; run; %include inpath(SGITS.FMT); DATA studylib.SGITS (LABEL= 'SGITS'); INFILE inpath(SGITS.DAT) LRECL=144; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 SGITSND 1.0 @141 SGITQ1NA 1.0 @142 SGITSQ1 1.0 @143 SGITQ2NA 1.0 @144 SGITSQ2 1.0 ; LABEL SGITQ1NA = 'Q1 not applicable'; LABEL SGITQ2NA = 'Q2 not applicable'; LABEL SGITSND = 'SGITS not done'; LABEL SGITSQ1 = 'Q1A: Assessment for Patchy AA'; LABEL SGITSQ2 = 'Q2: Assessment for AU/AT'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT SGITSND CL_ND.; FORMAT SGITQ1NA CL_NA.; FORMAT SGITQ2NA CL_NA.; run; %include inpath(SGSHQ.FMT); DATA studylib.SGSHQ (LABEL= 'SGSHQ'); INFILE inpath(SGSHQ.DAT) LRECL=145; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 SGSHQND 1.0 @141 SGSHQ1NA 1.0 @142 SGSHQ1A 1.0 @143 SGSHQ1B 1.0 @144 SGSHQ2NA 1.0 @145 SGSHQ2 1.0 ; LABEL SGSHQ1A = 'Q1A: Target assessment for Patchy AA'; LABEL SGSHQ1B = 'Q1B: Treated assessment for Patchy AA'; LABEL SGSHQ1NA = 'Q1 not applicable'; LABEL SGSHQ2 = 'Q2: Assessment for AU/AT'; LABEL SGSHQ2NA = 'Q2 not applicable'; LABEL SGSHQND = 'SGSHQ not done'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT SGSHQND CL_ND.; FORMAT SGSHQ1NA CL_NA.; FORMAT SGSHQ2NA CL_NA.; run; %include inpath(SMU.FMT); DATA studylib.SMU (LABEL= 'SMU'); INFILE inpath(SMU.DAT) LRECL=190; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 SMUSTART $CHAR9. @149 SMUAPP 1.0 @150 SMUOTH $CHAR32. @182 SMUEND $CHAR9. ; LABEL SITEID = 'Site ID'; LABEL SMUAPP = 'Applications per day'; LABEL SMUEND = 'Date application frequency ended'; LABEL SMUOTH = 'Other Frequency'; LABEL SMUSTART = 'Date Application Frequency started'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT SMUAPP CL_APPFQ.; run; %include inpath(SPT.FMT); DATA studylib.SPT (LABEL= 'SPT'); INFILE inpath(SPT.DAT) LRECL=141; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 SPTDONE 1.0 @141 SPTORRES 1.0 ; LABEL SITEID = 'Site ID'; LABEL SPTDONE = 'SPT done?'; LABEL SPTORRES = 'SPT Result'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT SPTDONE CL_YNA.; FORMAT SPTORRES CL_PN.; run; %include inpath(TSPI.FMT); DATA studylib.TSPI (LABEL= 'TSPI'); INFILE inpath(TSPI.DAT) LRECL=142; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 TSPIND 1.0 @141 TSPIRES 1.0 @142 TSPIDOC 1.0 ; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL TSPIDOC = 'Documented photographically?'; LABEL TSPIND = 'Identification not done'; LABEL TSPIRES = 'Identified by subject'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT TSPIND CL_ND.; FORMAT TSPIRES CL_YNA.; FORMAT TSPIDOC CL_YESNO.; run; %include inpath(UPT.FMT); DATA studylib.UPT (LABEL= 'UPT'); INFILE inpath(UPT.DAT) LRECL=141; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 UPTDONE 1.0 @141 UPTORRES 1.0 ; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL UPTDONE = 'UPT done?'; LABEL UPTORRES = 'UPT Result'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT UPTDONE CL_YNA.; FORMAT UPTORRES CL_PN.; run; %include inpath(UV.FMT); DATA studylib.UV (LABEL= 'UV'); INFILE inpath(UV.DAT) LRECL=203; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 UVREAS $CHAR64. ; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL UVREAS = 'Reason for unscheduled visit'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; run; %include inpath(VS.FMT); DATA studylib.VS (LABEL= 'VS'); INFILE inpath(VS.DAT) LRECL=166; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 VSDONE 1.0 @141 VSBPSYS 3.0 @144 VSBPDIA 3.0 @147 VSPULSE 3.0 @150 VSTEMP 5.0 @155 VSRESP 2.0 @157 VSWT 3.0 @160 VSHT 4.0 @164 VSQ1 1.0 @165 VSQ2 1.0 @166 VSQ3 1.0 ; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL VSBPDIA = 'Blood pressure diastolic'; LABEL VSBPSYS = 'Blood pressure systolic'; LABEL VSDONE = 'VS not done'; LABEL VSHT = 'Height (in)'; LABEL VSPULSE = 'Pulse rate (beats/min)'; LABEL VSQ1 = 'Relevance if systolic > 140mmHg'; LABEL VSQ2 = 'Relevance if diastolic > 90mmHG'; LABEL VSQ3 = 'Relevance if Weight > 300lbs'; LABEL VSRESP = 'Respiratory rate (breaths/min)'; LABEL VSTEMP = 'Body temperature deg F'; LABEL VSWT = 'Weight (lb)'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT VSDONE CL_YESNO.; FORMAT VSQ1 CL_YESNO.; FORMAT VSQ2 CL_YESNO.; FORMAT VSQ3 CL_YESNO.; run; %include inpath(PK.FMT); DATA studylib.PK (LABEL= 'PK'); INFILE inpath(PK.DAT) LRECL=143; INPUT #1 @1 _STUDY $CHAR24. @25 _USUBJID $CHAR6. @31 _VISNAME $CHAR16. @47 _VISRPT $CHAR16. @63 _PAGNAME $CHAR16. @79 _PAGSEQ 3.0 @82 _RECNUM 3.0 @85 _STATUS $CHAR16. @101 _RECDT $CHAR16. @117 _RECTM $CHAR16. @133 _RECND 1.0 @134 _PGBLANK 1.0 @135 SITEID $CHAR2. @137 SUBJID $CHAR3. @140 PKSAMP 1.0 @141 PDSAMP 1.0 @142 PKTELCAL 1.0 @143 PKTIMFRM 1.0 ; LABEL PDSAMP = 'PD sample collected'; LABEL PKSAMP = 'PK sample collected'; LABEL PKTELCAL = 'Was a telephone reminder given?'; LABEL PKTIMFRM = 'Were samples collected in correct timeframe?'; LABEL SITEID = 'Site ID'; LABEL SUBJID = 'Subject or Screening ID'; LABEL _PAGNAME = 'Page Name'; LABEL _PAGSEQ = 'Page sequence number'; LABEL _PGBLANK = 'Page is Blank'; LABEL _RECDT = 'Record Date'; LABEL _RECND = 'Record Not Done'; LABEL _RECNUM = 'Record Number on page'; LABEL _RECTM = 'Record Time'; LABEL _STATUS = 'Page status'; LABEL _STUDY = 'Study Identifier'; LABEL _USUBJID = 'Unique Subject Identifier'; LABEL _VISNAME = 'Visit Name'; LABEL _VISRPT = 'Visit repeat key'; FORMAT PKSAMP CL_YNA.; FORMAT PDSAMP CL_YNA.; FORMAT PKTELCAL CL_YESNO.; FORMAT PKTIMFRM CL_YESNO.; run; proc copy in=work out=studylib; select formats; run;
Obsidian | Level 7
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
OK, thanks for the tip. Would you add these new variables at the end of the import for each dataset, then rename them back and drop the old variable?
Super User
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
It is probably easier to just give those people a report instead of a copy of the data.
You can use ODS EXCEL to make the report in the form of an XLSX file.
ods excel file='for_review.xlsx';
ods excel option (sheet_name='HDR');
proc print data=studylib.hdr;
run;
ods excel option (sheet_name='VS');
proc print data=studylib.vs;
run;
....
ods excel close;
Super User
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
It depends. For long term storage at the end of a project I'd always end up storing both values so that it was available for future researchers who may need the data sets. If they OP can use a different format, that's definitely the easiest solution. If the researcher wants both values (usually) then they need to do those transformations.
Obsidian | Level 7
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Reeza, this is for my own use but also will be exporting things for folks to review so decoding them at the beginning seems the best approach rather than doing it piecemeal along the way for exports.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Upcoming Events
- DCSUG Virtual Meeting with Kirk Paul Lafler | 26-Jun-2024
- Wie kann ich SAS Visual Analytics effizient einsetzen, um die Ergebnisse meiner analytischen Modelle | 27-Jun-2024
- Ask the Expert: How Can I Use SAS® Optimization From Python? | 09-Jul-2024
- WUSS Virtual: Mastering Oncology Studies: A Comprehensive Guide for Programmers & Biostatisticians | 12-Jul-2024
- Ask the Expert: Jupyter Notebook: Your Coding Canvas | 16-Jul-2024
- MinnSUG Annual SAS Conference | 17-Jul-2024
- RTSUG presents a virtual webinar: Unlock Your Data with Python and SAS Viya | 18-Jul-2024
Mastering the WHERE Clause in PROC SQL
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.
Discussion stats
-
5 replies
-
07-02-2019 10:47 AM
-
731 views
-
4 likes
-
3 in conversation
-
