68
21969
21970 %macro refreshtides;
21971 Options mprint;
21972 libname tides "S:\Data Management\Tides\SAS Data\&date_f";
21973 %macro import(work.name,file);
21974
21975 PROC IMPORT OUT= tides.&name
21976 DATAFILE= "S:\Data Management\Tides\Data Extracts\&file"
21977 DBMS=CSV REPLACE;
21978 GETNAMES=YES;
21979 DATAROW=2;
21980 RUN;
21981 %mend;
21982
21983 %import(demo,-Data Extract (Tides) - 01 - Demographics (De-Identified)-.csv);
21984 %import(case,-Data Extract (Tides) - 02 - Case-.csv);
21985 %import(ICEC,-Data Extract (Tides) - 03 - Inclusion Exclusion-.csv);
21986 %import(MedHist,-Data Extract (Tides) - 04 - Medical Hx-.csv);
21987 %import(baseline,-Data Extract (Tides) - 05 - Tx-.csv);
21988 %import(weekly,-Data Extract (Tides) - 06 - Weekly Tx-.csv);
21989 %import(eq5d,-Data Extract (Tides) - 07 - EQ5D-.csv);
21990 %import(pd,-Data Extract (Tides) - 08 - Protocol Deviation Log-.csv);
21991 %import(Meds,-Data Extract (Tides) - 09 - Medication Log-.csv);
21992 %import(EoT,-Data Extract (Tides) - 10 - End of Treatment-.csv);
21993 %import(EoS,-Data Extract (Tides) - 11 - End of Study-.csv);
21994 %import(AE,-Data Extract (Tides) - 12 - Adverse Events-.csv);
21995
21996 %mend;
21997
21998 %refreshtides;
MPRINT(REFRESHTIDES): libname tides "S:\Data Management\Tides\SAS Data\2017-05-25";
NOTE: Libref TIDES was successfully assigned as follows:
Engine: V9
Physical Name: S:\Data Management\Tides\SAS Data\2017-05-25
ERROR: Symbolic variable name WORK.NAME must contain only letters, digits, and underscores.
ERROR: Invalid macro parameter name WORK.NAME. It should be a valid SAS identifier no longer than
32 characters.
ERROR: A dummy macro will be compiled.
MPRINT(IMPORT): PROC IMPORT OUT= demo DATAFILE= "S:\Data Management\Tides\Data Extracts\-Data
Extract (Tides) - 01 - Demographics (De-Identified)-.csv" DBMS=CSV REPLACE;
MPRINT(IMPORT): ADLM;
MPRINT(IMPORT): GETNAMES=YES;
MPRINT(IMPORT): DATAROW=2;
MPRINT(IMPORT): RUN;
21999 /**********************************************************************
22000 * PRODUCT: SAS
22001 * VERSION: 9.4
22002 * CREATOR: External File Interface
22003 * DATE: 22MAY17
22004 * DESC: Generated SAS Datastep Code
22005 * TEMPLATE SOURCE: (None Specified.)
22006 ***********************************************************************/
22007 data WORK.DEMO ;
MPRINT(IMPORT): data WORK.DEMO ;
22008 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */
22009 infile 'S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 01 - Demographics
22009! (De-Identified)-.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;
MPRINT(IMPORT): infile 'S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 01 -
Demographics (De-Identified)-.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;
22010 informat Study_ID $8. ;
MPRINT(IMPORT): informat Study_ID $8. ;
22011 informat YOB $6. ;
MPRINT(IMPORT): informat YOB $6. ;
22012 informat Gender_ID $3. ;
MPRINT(IMPORT): informat Gender_ID $3. ;
22013 informat Gender_Name $8. ;
MPRINT(IMPORT): informat Gender_Name $8. ;
22014 informat Ethnicity_ID $3. ;
MPRINT(IMPORT): informat Ethnicity_ID $3. ;
22015 informat Ethnicity_Name $25. ;
MPRINT(IMPORT): informat Ethnicity_Name $25. ;
22016 informat Race_ID $3. ;
MPRINT(IMPORT): informat Race_ID $3. ;
22017 informat Race_Name $7. ;
MPRINT(IMPORT): informat Race_Name $7. ;
22018 informat Race_Other $2. ;
MPRINT(IMPORT): informat Race_Other $2. ;
22019 informat IsConsent_ID $3. ;
MPRINT(IMPORT): informat IsConsent_ID $3. ;
22020 informat IsConsent_Name $5. ;
MPRINT(IMPORT): informat IsConsent_Name $5. ;
22021 informat ConsentDate $24. ;
MPRINT(IMPORT): informat ConsentDate $24. ;
22022 informat SignedBy_ID $2. ;
MPRINT(IMPORT): informat SignedBy_ID $2. ;
22023 informat SignedBy_Name $2. ;
MPRINT(IMPORT): informat SignedBy_Name $2. ;
22024 informat Date_of_Signature $2. ;
MPRINT(IMPORT): informat Date_of_Signature $2. ;
22025 informat Date_of_Entry $23. ;
MPRINT(IMPORT): informat Date_of_Entry $23. ;
22026 format Study_ID $8. ;
MPRINT(IMPORT): format Study_ID $8. ;
22027 format YOB $6. ;
MPRINT(IMPORT): format YOB $6. ;
22028 format Gender_ID $3. ;
MPRINT(IMPORT): format Gender_ID $3. ;
22029 format Gender_Name $8. ;
MPRINT(IMPORT): format Gender_Name $8. ;
22030 format Ethnicity_ID $3. ;
MPRINT(IMPORT): format Ethnicity_ID $3. ;
22031 format Ethnicity_Name $25. ;
MPRINT(IMPORT): format Ethnicity_Name $25. ;
22032 format Race_ID $3. ;
MPRINT(IMPORT): format Race_ID $3. ;
22033 format Race_Name $7. ;
MPRINT(IMPORT): format Race_Name $7. ;
22034 format Race_Other $2. ;
MPRINT(IMPORT): format Race_Other $2. ;
22035 format IsConsent_ID $3. ;
MPRINT(IMPORT): format IsConsent_ID $3. ;
22036 format IsConsent_Name $5. ;
MPRINT(IMPORT): format IsConsent_Name $5. ;
22037 format ConsentDate $24. ;
MPRINT(IMPORT): format ConsentDate $24. ;
22038 format SignedBy_ID $2. ;
MPRINT(IMPORT): format SignedBy_ID $2. ;
22039 format SignedBy_Name $2. ;
MPRINT(IMPORT): format SignedBy_Name $2. ;
22040 format Date_of_Signature $2. ;
MPRINT(IMPORT): format Date_of_Signature $2. ;
22041 format Date_of_Entry $23. ;
MPRINT(IMPORT): format Date_of_Entry $23. ;
22042 input
22043 Study_ID $
22044 YOB $
22045 Gender_ID $
22046 Gender_Name $
22047 Ethnicity_ID $
22048 Ethnicity_Name $
22049 Race_ID $
22050 Race_Name $
22051 Race_Other $
22052 IsConsent_ID $
22053 IsConsent_Name $
22054 ConsentDate $
22055 SignedBy_ID $
22056 SignedBy_Name $
22057 Date_of_Signature $
22058 Date_of_Entry $
22059 ;
MPRINT(IMPORT): input Study_ID $ YOB $ Gender_ID $ Gender_Name $ Ethnicity_ID $ Ethnicity_Name $
Race_ID $ Race_Name $ Race_Other $ IsConsent_ID $ IsConsent_Name $ ConsentDate $ SignedBy_ID $
SignedBy_Name $ Date_of_Signature $ Date_of_Entry $ ;
22060 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */
MPRINT(IMPORT): if _ERROR_ then call symputx('_EFIERR_',1);
22061 run;
MPRINT(IMPORT): run;
NOTE: The infile 'S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 01 - Demographics
(De-Identified)-.csv' is:
Filename=S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 01 - Demographics
(De-Identified)-.csv,
RECFM=V,LRECL=32767,File Size (bytes)=1418,
Last Modified=24May2017:17:21:06,
Create Time=24May2017:17:21:25
NOTE: 9 records were read from the infile 'S:\Data Management\Tides\Data Extracts\-Data Extract
(Tides) - 01 - Demographics (De-Identified)-.csv'.
The minimum record length was 114.
The maximum record length was 139.
NOTE: The data set WORK.DEMO has 9 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 0.25 seconds
cpu time 0.04 seconds
9 rows created in WORK.DEMO from S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 01
- Demographics (De-Identified)-.csv.
NOTE: WORK.DEMO data set was successfully created.
NOTE: The data set WORK.DEMO has 9 observations and 16 variables.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 1.08 seconds
cpu time 0.32 seconds
MPRINT(IMPORT): ;
MPRINT(REFRESHTIDES): ;
MPRINT(IMPORT): PROC IMPORT OUT= case DATAFILE= "S:\Data Management\Tides\Data Extracts\-Data
Extract (Tides) - 02 - Case-.csv" DBMS=CSV REPLACE;
MPRINT(IMPORT): ADLM;
MPRINT(IMPORT): GETNAMES=YES;
MPRINT(IMPORT): DATAROW=2;
MPRINT(IMPORT): RUN;
22062 /**********************************************************************
22063 * PRODUCT: SAS
22064 * VERSION: 9.4
22065 * CREATOR: External File Interface
22066 * DATE: 22MAY17
22067 * DESC: Generated SAS Datastep Code
22068 * TEMPLATE SOURCE: (None Specified.)
22069 ***********************************************************************/
22070 data WORK.CASE ;
MPRINT(IMPORT): data WORK.CASE ;
22071 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */
22072 infile 'S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 02 - Case-.csv'
22072! delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;
MPRINT(IMPORT): infile 'S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 02 -
Case-.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;
22073 informat Case_ID $8. ;
MPRINT(IMPORT): informat Case_ID $8. ;
22074 informat Study_ID $8. ;
MPRINT(IMPORT): informat Study_ID $8. ;
22075 informat Side_ID $3. ;
MPRINT(IMPORT): informat Side_ID $3. ;
22076 informat Side_Name $7. ;
MPRINT(IMPORT): informat Side_Name $7. ;
22077 informat Institution_ID $5. ;
MPRINT(IMPORT): informat Institution_ID $5. ;
22078 informat Institution_Name $36. ;
MPRINT(IMPORT): informat Institution_Name $36. ;
22079 informat CareProvider_ID $5. ;
MPRINT(IMPORT): informat CareProvider_ID $5. ;
22080 informat CareProvider_Name $20. ;
MPRINT(IMPORT): informat CareProvider_Name $20. ;
22081 informat Date_of_Assessment $24. ;
MPRINT(IMPORT): informat Date_of_Assessment $24. ;
22082 informat Age_at_Case $4. ;
MPRINT(IMPORT): informat Age_at_Case $4. ;
22083 informat AdditionalNote $2. ;
MPRINT(IMPORT): informat AdditionalNote $2. ;
22084 informat Height_cm $2. ;
MPRINT(IMPORT): informat Height_cm $2. ;
22085 informat Height_in $2. ;
MPRINT(IMPORT): informat Height_in $2. ;
22086 informat Weight_kg $2. ;
MPRINT(IMPORT): informat Weight_kg $2. ;
22087 informat Weight_lbs $2. ;
MPRINT(IMPORT): informat Weight_lbs $2. ;
22088 informat BMI $2. ;
MPRINT(IMPORT): informat BMI $2. ;
22089 informat SignedBy_ID $2. ;
MPRINT(IMPORT): informat SignedBy_ID $2. ;
22090 informat SignedBy_Name $2. ;
MPRINT(IMPORT): informat SignedBy_Name $2. ;
22091 informat Date_of_Signature $2. ;
MPRINT(IMPORT): informat Date_of_Signature $2. ;
22092 informat Date_of_Entry $23. ;
MPRINT(IMPORT): informat Date_of_Entry $23. ;
22093 format Case_ID $8. ;
MPRINT(IMPORT): format Case_ID $8. ;
22094 format Study_ID $8. ;
MPRINT(IMPORT): format Study_ID $8. ;
22095 format Side_ID $3. ;
MPRINT(IMPORT): format Side_ID $3. ;
22096 format Side_Name $7. ;
MPRINT(IMPORT): format Side_Name $7. ;
22097 format Institution_ID $5. ;
MPRINT(IMPORT): format Institution_ID $5. ;
22098 format Institution_Name $36. ;
MPRINT(IMPORT): format Institution_Name $36. ;
22099 format CareProvider_ID $5. ;
MPRINT(IMPORT): format CareProvider_ID $5. ;
22100 format CareProvider_Name $20. ;
MPRINT(IMPORT): format CareProvider_Name $20. ;
22101 format Date_of_Assessment $24. ;
MPRINT(IMPORT): format Date_of_Assessment $24. ;
22102 format Age_at_Case $4. ;
MPRINT(IMPORT): format Age_at_Case $4. ;
22103 format AdditionalNote $2. ;
MPRINT(IMPORT): format AdditionalNote $2. ;
22104 format Height_cm $2. ;
MPRINT(IMPORT): format Height_cm $2. ;
22105 format Height_in $2. ;
MPRINT(IMPORT): format Height_in $2. ;
22106 format Weight_kg $2. ;
MPRINT(IMPORT): format Weight_kg $2. ;
22107 format Weight_lbs $2. ;
MPRINT(IMPORT): format Weight_lbs $2. ;
22108 format BMI $2. ;
MPRINT(IMPORT): format BMI $2. ;
22109 format SignedBy_ID $2. ;
MPRINT(IMPORT): format SignedBy_ID $2. ;
22110 format SignedBy_Name $2. ;
MPRINT(IMPORT): format SignedBy_Name $2. ;
22111 format Date_of_Signature $2. ;
MPRINT(IMPORT): format Date_of_Signature $2. ;
22112 format Date_of_Entry $23. ;
MPRINT(IMPORT): format Date_of_Entry $23. ;
22113 input
22114 Case_ID $
22115 Study_ID $
22116 Side_ID $
22117 Side_Name $
22118 Institution_ID $
22119 Institution_Name $
22120 CareProvider_ID $
22121 CareProvider_Name $
22122 Date_of_Assessment $
22123 Age_at_Case $
22124 AdditionalNote $
22125 Height_cm $
22126 Height_in $
22127 Weight_kg $
22128 Weight_lbs $
22129 BMI $
22130 SignedBy_ID $
22131 SignedBy_Name $
22132 Date_of_Signature $
22133 Date_of_Entry $
22134 ;
MPRINT(IMPORT): input Case_ID $ Study_ID $ Side_ID $ Side_Name $ Institution_ID $
Institution_Name $ CareProvider_ID $ CareProvider_Name $ Date_of_Assessment $ Age_at_Case $
AdditionalNote $ Height_cm $ Height_in $ Weight_kg $ Weight_lbs $ BMI $ SignedBy_ID $ SignedBy_Name
$ Date_of_Signature $ Date_of_Entry $ ;
22135 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */
MPRINT(IMPORT): if _ERROR_ then call symputx('_EFIERR_',1);
22136 run;
MPRINT(IMPORT): run;
NOTE: The infile 'S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 02 - Case-.csv' is:
Filename=S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 02 - Case-.csv,
RECFM=V,LRECL=32767,File Size (bytes)=1856,
Last Modified=24May2017:17:21:42,
Create Time=24May2017:17:21:49
NOTE: 9 records were read from the infile 'S:\Data Management\Tides\Data Extracts\-Data Extract
(Tides) - 02 - Case-.csv'.
The minimum record length was 174.
The maximum record length was 179.
NOTE: The data set WORK.CASE has 9 observations and 20 variables.
NOTE: DATA statement used (Total process time):
real time 0.22 seconds
cpu time 0.04 seconds
9 rows created in WORK.CASE from S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 02
- Case-.csv.
NOTE: WORK.CASE data set was successfully created.
NOTE: The data set WORK.CASE has 9 observations and 20 variables.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 1.05 seconds
cpu time 0.34 seconds
MPRINT(IMPORT): ;
MPRINT(REFRESHTIDES): ;
MPRINT(IMPORT): PROC IMPORT OUT= ICEC DATAFILE= "S:\Data Management\Tides\Data Extracts\-Data
Extract (Tides) - 03 - Inclusion Exclusion-.csv" DBMS=CSV REPLACE;
MPRINT(IMPORT): ADLM;
MPRINT(IMPORT): GETNAMES=YES;
MPRINT(IMPORT): DATAROW=2;
MPRINT(IMPORT): RUN;
Name InclusionExclusionCriteriaType_ID truncated to InclusionExclusionCriteriaType_I.
Name InclusionExclusionCriteriaType_Name truncated to InclusionExclusionCriteriaType_N.
Problems were detected with provided names. See LOG.
22137 /**********************************************************************
22138 * PRODUCT: SAS
22139 * VERSION: 9.4
22140 * CREATOR: External File Interface
22141 * DATE: 22MAY17
22142 * DESC: Generated SAS Datastep Code
22143 * TEMPLATE SOURCE: (None Specified.)
22144 ***********************************************************************/
22145 data WORK.ICEC ;
MPRINT(IMPORT): data WORK.ICEC ;
22146 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */
22147 infile 'S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 03 - Inclusion
22147! Exclusion-.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;
MPRINT(IMPORT): infile 'S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 03 -
Inclusion Exclusion-.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;
22148 informat Case_ID $8. ;
MPRINT(IMPORT): informat Case_ID $8. ;
22149 informat Study_ID $8. ;
MPRINT(IMPORT): informat Study_ID $8. ;
22150 informat Date_of_Evaluation $23. ;
MPRINT(IMPORT): informat Date_of_Evaluation $23. ;
22151 informat InclusionExclusionCriteriaType_I $3. ;
MPRINT(IMPORT): informat InclusionExclusionCriteriaType_I $3. ;
22152 informat InclusionExclusionCriteriaType_N $11. ;
MPRINT(IMPORT): informat InclusionExclusionCriteriaType_N $11. ;
22153 informat InclusionExclusion_ID $4. ;
MPRINT(IMPORT): informat InclusionExclusion_ID $4. ;
22154 informat InclusionExclusion_Value $287. ;
MPRINT(IMPORT): informat InclusionExclusion_Value $287. ;
22155 informat YesNo_ID $3. ;
MPRINT(IMPORT): informat YesNo_ID $3. ;
22156 informat YesNo_Value $5. ;
MPRINT(IMPORT): informat YesNo_Value $5. ;
22157 informat SignedBy_ID $2. ;
MPRINT(IMPORT): informat SignedBy_ID $2. ;
22158 informat SignedBy_Value $2. ;
MPRINT(IMPORT): informat SignedBy_Value $2. ;
22159 informat Date_of_Signature $2. ;
MPRINT(IMPORT): informat Date_of_Signature $2. ;
22160 format Case_ID $8. ;
MPRINT(IMPORT): format Case_ID $8. ;
22161 format Study_ID $8. ;
MPRINT(IMPORT): format Study_ID $8. ;
22162 format Date_of_Evaluation $23. ;
MPRINT(IMPORT): format Date_of_Evaluation $23. ;
22163 format InclusionExclusionCriteriaType_I $3. ;
MPRINT(IMPORT): format InclusionExclusionCriteriaType_I $3. ;
22164 format InclusionExclusionCriteriaType_N $11. ;
MPRINT(IMPORT): format InclusionExclusionCriteriaType_N $11. ;
22165 format InclusionExclusion_ID $4. ;
MPRINT(IMPORT): format InclusionExclusion_ID $4. ;
22166 format InclusionExclusion_Value $287. ;
MPRINT(IMPORT): format InclusionExclusion_Value $287. ;
22167 format YesNo_ID $3. ;
MPRINT(IMPORT): format YesNo_ID $3. ;
22168 format YesNo_Value $5. ;
MPRINT(IMPORT): format YesNo_Value $5. ;
22169 format SignedBy_ID $2. ;
MPRINT(IMPORT): format SignedBy_ID $2. ;
22170 format SignedBy_Value $2. ;
MPRINT(IMPORT): format SignedBy_Value $2. ;
22171 format Date_of_Signature $2. ;
MPRINT(IMPORT): format Date_of_Signature $2. ;
22172 input
22173 Case_ID $
22174 Study_ID $
22175 Date_of_Evaluation $
22176 InclusionExclusionCriteriaType_I $
22177 InclusionExclusionCriteriaType_N $
22178 InclusionExclusion_ID $
22179 InclusionExclusion_Value $
22180 YesNo_ID $
22181 YesNo_Value $
22182 SignedBy_ID $
22183 SignedBy_Value $
22184 Date_of_Signature $
22185 ;
MPRINT(IMPORT): input Case_ID $ Study_ID $ Date_of_Evaluation $ InclusionExclusionCriteriaType_I
$ InclusionExclusionCriteriaType_N $ InclusionExclusion_ID $ InclusionExclusion_Value $ YesNo_ID $
YesNo_Value $ SignedBy_ID $ SignedBy_Value $ Date_of_Signature $ ;
22186 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */
MPRINT(IMPORT): if _ERROR_ then call symputx('_EFIERR_',1);
22187 run;
MPRINT(IMPORT): run;
NOTE: The infile 'S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 03 - Inclusion
Exclusion-.csv' is:
Filename=S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 03 - Inclusion
Exclusion-.csv,
RECFM=V,LRECL=32767,File Size (bytes)=25301,
Last Modified=24May2017:17:21:57,
Create Time=24May2017:17:22:52
NOTE: 159 records were read from the infile 'S:\Data Management\Tides\Data Extracts\-Data Extract
(Tides) - 03 - Inclusion Exclusion-.csv'.
The minimum record length was 103.
The maximum record length was 369.
NOTE: The data set WORK.ICEC has 159 observations and 12 variables.
NOTE: DATA statement used (Total process time):
real time 0.22 seconds
cpu time 0.04 seconds
159 rows created in WORK.ICEC from S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) -
03 - Inclusion Exclusion-.csv.
NOTE: WORK.ICEC data set was successfully created.
NOTE: The data set WORK.ICEC has 159 observations and 12 variables.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 1.07 seconds
cpu time 0.37 seconds
MPRINT(IMPORT): ;
MPRINT(REFRESHTIDES): ;
MPRINT(IMPORT): PROC IMPORT OUT= MedHist DATAFILE= "S:\Data Management\Tides\Data Extracts\-Data
Extract (Tides) - 04 - Medical Hx-.csv" DBMS=CSV REPLACE;
MPRINT(IMPORT): ADLM;
MPRINT(IMPORT): GETNAMES=YES;
MPRINT(IMPORT): DATAROW=2;
MPRINT(IMPORT): RUN;
Name Comorbidity_CancerNeoplasm_Detail truncated to Comorbidity_CancerNeoplasm_Detai.
Name Comorbidity_Cardiovascular_Detail truncated to Comorbidity_Cardiovascular_Detai.
Name Comorbidity_EndocrineMetabolic_Detail truncated to Comorbidity_EndocrineMetabolic_D.
Name Comorbidity_Gastrointestinal_Detail truncated to Comorbidity_Gastrointestinal_Det.
Name Comorbidity_SkinOrSubcutaneous_Detail truncated to Comorbidity_SkinOrSubcutaneous_D.
Name Comorbidity_Musculoskeletal_Detail truncated to Comorbidity_Musculoskeletal_Deta.
Name Comorbidity_AlcoholSubstanceAbuse truncated to Comorbidity_AlcoholSubstanceAbus.
Name Comorbidity_AlcoholSubstanceAbuse_Detail truncated to Comorbidity_AlcoholSubstanceAbus.
Name Comorbidity_AlcoholSubstanceAbus is a duplicate.
Problems were detected with provided names. See LOG.
22188 /**********************************************************************
22189 * PRODUCT: SAS
22190 * VERSION: 9.4
22191 * CREATOR: External File Interface
22192 * DATE: 22MAY17
22193 * DESC: Generated SAS Datastep Code
22194 * TEMPLATE SOURCE: (None Specified.)
22195 ***********************************************************************/
22196 data WORK.MEDHIST ;
MPRINT(IMPORT): data WORK.MEDHIST ;
22197 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */
22198 infile 'S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 04 - Medical
22198! Hx-.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;
MPRINT(IMPORT): infile 'S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 04 -
Medical Hx-.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;
22199 informat Case_ID $19. ;
MPRINT(IMPORT): informat Case_ID $19. ;
22200 informat Study_ID $8. ;
MPRINT(IMPORT): informat Study_ID $8. ;
22201 informat SmokingStatus_ID $3. ;
MPRINT(IMPORT): informat SmokingStatus_ID $3. ;
22202 informat SmokingStatus_Value $9. ;
MPRINT(IMPORT): informat SmokingStatus_Value $9. ;
22203 informat Smoking_PacksPerDay $6. ;
MPRINT(IMPORT): informat Smoking_PacksPerDay $6. ;
22204 informat Comorbidity_None $10. ;
MPRINT(IMPORT): informat Comorbidity_None $10. ;
22205 informat Comorbidity_CancerNeoplasm $3. ;
MPRINT(IMPORT): informat Comorbidity_CancerNeoplasm $3. ;
22206 informat Comorbidity_CancerNeoplasm_Detai $16. ;
MPRINT(IMPORT): informat Comorbidity_CancerNeoplasm_Detai $16. ;
22207 informat Comorbidity_Cardiovascular $3. ;
MPRINT(IMPORT): informat Comorbidity_Cardiovascular $3. ;
22208 informat Comorbidity_Cardiovascular_Detai $39. ;
MPRINT(IMPORT): informat Comorbidity_Cardiovascular_Detai $39. ;
22209 informat Comorbidity_Hematological $6. ;
MPRINT(IMPORT): informat Comorbidity_Hematological $6. ;
22210 informat Comorbidity_Hematological_Detail $20. ;
MPRINT(IMPORT): informat Comorbidity_Hematological_Detail $20. ;
22211 informat Comorbidity_EENT $6. ;
MPRINT(IMPORT): informat Comorbidity_EENT $6. ;
22212 informat Comorbidity_EENT_Detail $22. ;
MPRINT(IMPORT): informat Comorbidity_EENT_Detail $22. ;
22213 informat Comorbidity_EndocrineMetabolic $6. ;
MPRINT(IMPORT): informat Comorbidity_EndocrineMetabolic $6. ;
22214 informat Comorbidity_EndocrineMetabolic_D $23. ;
MPRINT(IMPORT): informat Comorbidity_EndocrineMetabolic_D $23. ;
22215 informat Comorbidity_Gastrointestinal $3. ;
MPRINT(IMPORT): informat Comorbidity_Gastrointestinal $3. ;
22216 informat Comorbidity_Gastrointestinal_Det $6. ;
MPRINT(IMPORT): informat Comorbidity_Gastrointestinal_Det $6. ;
22217 informat Comorbidity_Genitourinary $3. ;
MPRINT(IMPORT): informat Comorbidity_Genitourinary $3. ;
22218 informat Comorbidity_Genitourinary_Detail $24. ;
MPRINT(IMPORT): informat Comorbidity_Genitourinary_Detail $24. ;
22219 informat Comorbidity_Respiratory $23. ;
MPRINT(IMPORT): informat Comorbidity_Respiratory $23. ;
22220 informat Comorbidity_Respiratory_Detail $32. ;
MPRINT(IMPORT): informat Comorbidity_Respiratory_Detail $32. ;
22221 informat Comorbidity_SkinOrSubcutaneous $3. ;
MPRINT(IMPORT): informat Comorbidity_SkinOrSubcutaneous $3. ;
22222 informat Comorbidity_SkinOrSubcutaneous_D $32. ;
MPRINT(IMPORT): informat Comorbidity_SkinOrSubcutaneous_D $32. ;
22223 informat Comorbidity_Neurological $6. ;
MPRINT(IMPORT): informat Comorbidity_Neurological $6. ;
22224 informat Comorbidity_Neurological_Detail $21. ;
MPRINT(IMPORT): informat Comorbidity_Neurological_Detail $21. ;
22225 informat Comorbidity_Musculoskeletal $3. ;
MPRINT(IMPORT): informat Comorbidity_Musculoskeletal $3. ;
22226 informat Comorbidity_Musculoskeletal_Deta $29. ;
MPRINT(IMPORT): informat Comorbidity_Musculoskeletal_Deta $29. ;
22227 informat Comorbidity_Psychological $6. ;
MPRINT(IMPORT): informat Comorbidity_Psychological $6. ;
22228 informat Comorbidity_Psychological_Detail $20. ;
MPRINT(IMPORT): informat Comorbidity_Psychological_Detail $20. ;
22229 informat Comorbidity_AlcoholSubstanceAbus $6. ;
MPRINT(IMPORT): informat Comorbidity_AlcoholSubstanceAbus $6. ;
22230 informat VAR32 $3. ;
MPRINT(IMPORT): informat VAR32 $3. ;
22231 informat Comorbidity_Other $7. ;
MPRINT(IMPORT): informat Comorbidity_Other $7. ;
22232 informat Comorbidity_Other_Detail $10. ;
MPRINT(IMPORT): informat Comorbidity_Other_Detail $10. ;
22233 informat IsWeightBearingStatus_ID $49. ;
MPRINT(IMPORT): informat IsWeightBearingStatus_ID $49. ;
22234 informat IsWeightBearingStatus_Value $34. ;
MPRINT(IMPORT): informat IsWeightBearingStatus_Value $34. ;
22235 informat EmploymentStatus_ID $4. ;
MPRINT(IMPORT): informat EmploymentStatus_ID $4. ;
22236 informat EmploymentStatus_Value $66. ;
MPRINT(IMPORT): informat EmploymentStatus_Value $66. ;
22237 informat Ulcer1_Length_cm $22. ;
MPRINT(IMPORT): informat Ulcer1_Length_cm $22. ;
22238 informat Ulcer1_Width_cm $6. ;
MPRINT(IMPORT): informat Ulcer1_Width_cm $6. ;
22239 informat Ulcer1_Area_cm $6. ;
MPRINT(IMPORT): informat Ulcer1_Area_cm $6. ;
22240 informat Ulcer2_Length_cm $32. ;
MPRINT(IMPORT): informat Ulcer2_Length_cm $32. ;
22241 informat Ulcer2_Width_cm $6. ;
MPRINT(IMPORT): informat Ulcer2_Width_cm $6. ;
22242 informat Ulcer2_Area_cm $6. ;
MPRINT(IMPORT): informat Ulcer2_Area_cm $6. ;
22243 informat Ulcer3_Length_cm $6. ;
MPRINT(IMPORT): informat Ulcer3_Length_cm $6. ;
22244 informat Ulcer3_Width_cm $6. ;
MPRINT(IMPORT): informat Ulcer3_Width_cm $6. ;
22245 informat Ulcer3_Area_cm $3. ;
MPRINT(IMPORT): informat Ulcer3_Area_cm $3. ;
22246 informat Date_of_InitialUlcerDiagnosis $24. ;
MPRINT(IMPORT): informat Date_of_InitialUlcerDiagnosis $24. ;
22247 informat Date_of_EstimatedUlcerStart $24. ;
MPRINT(IMPORT): informat Date_of_EstimatedUlcerStart $24. ;
22248 informat RunInTx_Days $5. ;
MPRINT(IMPORT): informat RunInTx_Days $5. ;
22249 informat UlcerType_ID $12. ;
MPRINT(IMPORT): informat UlcerType_ID $12. ;
22250 informat UlcerType_Value $32. ;
MPRINT(IMPORT): informat UlcerType_Value $32. ;
22251 informat RunInTx_UlcerLength_cm $26. ;
MPRINT(IMPORT): informat RunInTx_UlcerLength_cm $26. ;
22252 informat RunInTx_UlcerWidth_cm $11. ;
MPRINT(IMPORT): informat RunInTx_UlcerWidth_cm $11. ;
22253 informat RunInTx_UlcerDepth_cm $6. ;
MPRINT(IMPORT): informat RunInTx_UlcerDepth_cm $6. ;
22254 informat RunInTx_UlcerArea_cm $7. ;
MPRINT(IMPORT): informat RunInTx_UlcerArea_cm $7. ;
22255 informat UlcerLocation_ID $3. ;
MPRINT(IMPORT): informat UlcerLocation_ID $3. ;
22256 informat UlcerLocation_Value $15. ;
MPRINT(IMPORT): informat UlcerLocation_Value $15. ;
22257 informat UlcerLocation_Other $16. ;
MPRINT(IMPORT): informat UlcerLocation_Other $16. ;
22258 informat PatientVisitsSinceDiag_ID $3. ;
MPRINT(IMPORT): informat PatientVisitsSinceDiag_ID $3. ;
22259 informat PatientVisitsSinceDiag_Value $12. ;
MPRINT(IMPORT): informat PatientVisitsSinceDiag_Value $12. ;
22260 informat PatientVisitsSinceDiag_Days $4. ;
MPRINT(IMPORT): informat PatientVisitsSinceDiag_Days $4. ;
22261 informat RunIn_Diagnosis_ICD10 $96. ;
MPRINT(IMPORT): informat RunIn_Diagnosis_ICD10 $96. ;
22262 informat RunIn_Procedures_CPT___Uses_ $99. ;
MPRINT(IMPORT): informat RunIn_Procedures_CPT___Uses_ $99. ;
22263 format Case_ID $19. ;
MPRINT(IMPORT): format Case_ID $19. ;
22264 format Study_ID $8. ;
MPRINT(IMPORT): format Study_ID $8. ;
22265 format SmokingStatus_ID $3. ;
MPRINT(IMPORT): format SmokingStatus_ID $3. ;
22266 format SmokingStatus_Value $9. ;
MPRINT(IMPORT): format SmokingStatus_Value $9. ;
22267 format Smoking_PacksPerDay $6. ;
MPRINT(IMPORT): format Smoking_PacksPerDay $6. ;
22268 format Comorbidity_None $10. ;
MPRINT(IMPORT): format Comorbidity_None $10. ;
22269 format Comorbidity_CancerNeoplasm $3. ;
MPRINT(IMPORT): format Comorbidity_CancerNeoplasm $3. ;
22270 format Comorbidity_CancerNeoplasm_Detai $16. ;
MPRINT(IMPORT): format Comorbidity_CancerNeoplasm_Detai $16. ;
22271 format Comorbidity_Cardiovascular $3. ;
MPRINT(IMPORT): format Comorbidity_Cardiovascular $3. ;
22272 format Comorbidity_Cardiovascular_Detai $39. ;
MPRINT(IMPORT): format Comorbidity_Cardiovascular_Detai $39. ;
22273 format Comorbidity_Hematological $6. ;
MPRINT(IMPORT): format Comorbidity_Hematological $6. ;
22274 format Comorbidity_Hematological_Detail $20. ;
MPRINT(IMPORT): format Comorbidity_Hematological_Detail $20. ;
22275 format Comorbidity_EENT $6. ;
MPRINT(IMPORT): format Comorbidity_EENT $6. ;
22276 format Comorbidity_EENT_Detail $22. ;
MPRINT(IMPORT): format Comorbidity_EENT_Detail $22. ;
22277 format Comorbidity_EndocrineMetabolic $6. ;
MPRINT(IMPORT): format Comorbidity_EndocrineMetabolic $6. ;
22278 format Comorbidity_EndocrineMetabolic_D $23. ;
MPRINT(IMPORT): format Comorbidity_EndocrineMetabolic_D $23. ;
22279 format Comorbidity_Gastrointestinal $3. ;
MPRINT(IMPORT): format Comorbidity_Gastrointestinal $3. ;
22280 format Comorbidity_Gastrointestinal_Det $6. ;
MPRINT(IMPORT): format Comorbidity_Gastrointestinal_Det $6. ;
22281 format Comorbidity_Genitourinary $3. ;
MPRINT(IMPORT): format Comorbidity_Genitourinary $3. ;
22282 format Comorbidity_Genitourinary_Detail $24. ;
MPRINT(IMPORT): format Comorbidity_Genitourinary_Detail $24. ;
22283 format Comorbidity_Respiratory $23. ;
MPRINT(IMPORT): format Comorbidity_Respiratory $23. ;
22284 format Comorbidity_Respiratory_Detail $32. ;
MPRINT(IMPORT): format Comorbidity_Respiratory_Detail $32. ;
22285 format Comorbidity_SkinOrSubcutaneous $3. ;
MPRINT(IMPORT): format Comorbidity_SkinOrSubcutaneous $3. ;
22286 format Comorbidity_SkinOrSubcutaneous_D $32. ;
MPRINT(IMPORT): format Comorbidity_SkinOrSubcutaneous_D $32. ;
22287 format Comorbidity_Neurological $6. ;
MPRINT(IMPORT): format Comorbidity_Neurological $6. ;
22288 format Comorbidity_Neurological_Detail $21. ;
MPRINT(IMPORT): format Comorbidity_Neurological_Detail $21. ;
22289 format Comorbidity_Musculoskeletal $3. ;
MPRINT(IMPORT): format Comorbidity_Musculoskeletal $3. ;
22290 format Comorbidity_Musculoskeletal_Deta $29. ;
MPRINT(IMPORT): format Comorbidity_Musculoskeletal_Deta $29. ;
22291 format Comorbidity_Psychological $6. ;
MPRINT(IMPORT): format Comorbidity_Psychological $6. ;
22292 format Comorbidity_Psychological_Detail $20. ;
MPRINT(IMPORT): format Comorbidity_Psychological_Detail $20. ;
22293 format Comorbidity_AlcoholSubstanceAbus $6. ;
MPRINT(IMPORT): format Comorbidity_AlcoholSubstanceAbus $6. ;
22294 format VAR32 $3. ;
MPRINT(IMPORT): format VAR32 $3. ;
22295 format Comorbidity_Other $7. ;
MPRINT(IMPORT): format Comorbidity_Other $7. ;
22296 format Comorbidity_Other_Detail $10. ;
MPRINT(IMPORT): format Comorbidity_Other_Detail $10. ;
22297 format IsWeightBearingStatus_ID $49. ;
MPRINT(IMPORT): format IsWeightBearingStatus_ID $49. ;
22298 format IsWeightBearingStatus_Value $34. ;
MPRINT(IMPORT): format IsWeightBearingStatus_Value $34. ;
22299 format EmploymentStatus_ID $4. ;
MPRINT(IMPORT): format EmploymentStatus_ID $4. ;
22300 format EmploymentStatus_Value $66. ;
MPRINT(IMPORT): format EmploymentStatus_Value $66. ;
22301 format Ulcer1_Length_cm $22. ;
MPRINT(IMPORT): format Ulcer1_Length_cm $22. ;
22302 format Ulcer1_Width_cm $6. ;
MPRINT(IMPORT): format Ulcer1_Width_cm $6. ;
22303 format Ulcer1_Area_cm $6. ;
MPRINT(IMPORT): format Ulcer1_Area_cm $6. ;
22304 format Ulcer2_Length_cm $32. ;
MPRINT(IMPORT): format Ulcer2_Length_cm $32. ;
22305 format Ulcer2_Width_cm $6. ;
MPRINT(IMPORT): format Ulcer2_Width_cm $6. ;
22306 format Ulcer2_Area_cm $6. ;
MPRINT(IMPORT): format Ulcer2_Area_cm $6. ;
22307 format Ulcer3_Length_cm $6. ;
MPRINT(IMPORT): format Ulcer3_Length_cm $6. ;
22308 format Ulcer3_Width_cm $6. ;
MPRINT(IMPORT): format Ulcer3_Width_cm $6. ;
22309 format Ulcer3_Area_cm $3. ;
MPRINT(IMPORT): format Ulcer3_Area_cm $3. ;
22310 format Date_of_InitialUlcerDiagnosis $24. ;
MPRINT(IMPORT): format Date_of_InitialUlcerDiagnosis $24. ;
22311 format Date_of_EstimatedUlcerStart $24. ;
MPRINT(IMPORT): format Date_of_EstimatedUlcerStart $24. ;
22312 format RunInTx_Days $5. ;
MPRINT(IMPORT): format RunInTx_Days $5. ;
22313 format UlcerType_ID $12. ;
MPRINT(IMPORT): format UlcerType_ID $12. ;
22314 format UlcerType_Value $32. ;
MPRINT(IMPORT): format UlcerType_Value $32. ;
22315 format RunInTx_UlcerLength_cm $26. ;
MPRINT(IMPORT): format RunInTx_UlcerLength_cm $26. ;
22316 format RunInTx_UlcerWidth_cm $11. ;
MPRINT(IMPORT): format RunInTx_UlcerWidth_cm $11. ;
22317 format RunInTx_UlcerDepth_cm $6. ;
MPRINT(IMPORT): format RunInTx_UlcerDepth_cm $6. ;
22318 format RunInTx_UlcerArea_cm $7. ;
MPRINT(IMPORT): format RunInTx_UlcerArea_cm $7. ;
22319 format UlcerLocation_ID $3. ;
MPRINT(IMPORT): format UlcerLocation_ID $3. ;
22320 format UlcerLocation_Value $15. ;
MPRINT(IMPORT): format UlcerLocation_Value $15. ;
22321 format UlcerLocation_Other $16. ;
MPRINT(IMPORT): format UlcerLocation_Other $16. ;
22322 format PatientVisitsSinceDiag_ID $3. ;
MPRINT(IMPORT): format PatientVisitsSinceDiag_ID $3. ;
22323 format PatientVisitsSinceDiag_Value $12. ;
MPRINT(IMPORT): format PatientVisitsSinceDiag_Value $12. ;
22324 format PatientVisitsSinceDiag_Days $4. ;
MPRINT(IMPORT): format PatientVisitsSinceDiag_Days $4. ;
22325 format RunIn_Diagnosis_ICD10 $96. ;
MPRINT(IMPORT): format RunIn_Diagnosis_ICD10 $96. ;
22326 format RunIn_Procedures_CPT___Uses_ $99. ;
MPRINT(IMPORT): format RunIn_Procedures_CPT___Uses_ $99. ;
22327 input
22328 Case_ID $
22329 Study_ID $
22330 SmokingStatus_ID $
22331 SmokingStatus_Value $
22332 Smoking_PacksPerDay $
22333 Comorbidity_None $
22334 Comorbidity_CancerNeoplasm $
22335 Comorbidity_CancerNeoplasm_Detai $
22336 Comorbidity_Cardiovascular $
22337 Comorbidity_Cardiovascular_Detai $
22338 Comorbidity_Hematological $
22339 Comorbidity_Hematological_Detail $
22340 Comorbidity_EENT $
22341 Comorbidity_EENT_Detail $
22342 Comorbidity_EndocrineMetabolic $
22343 Comorbidity_EndocrineMetabolic_D $
22344 Comorbidity_Gastrointestinal $
22345 Comorbidity_Gastrointestinal_Det $
22346 Comorbidity_Genitourinary $
22347 Comorbidity_Genitourinary_Detail $
22348 Comorbidity_Respiratory $
22349 Comorbidity_Respiratory_Detail $
22350 Comorbidity_SkinOrSubcutaneous $
22351 Comorbidity_SkinOrSubcutaneous_D $
22352 Comorbidity_Neurological $
22353 Comorbidity_Neurological_Detail $
22354 Comorbidity_Musculoskeletal $
22355 Comorbidity_Musculoskeletal_Deta $
22356 Comorbidity_Psychological $
22357 Comorbidity_Psychological_Detail $
22358 Comorbidity_AlcoholSubstanceAbus $
22359 VAR32 $
22360 Comorbidity_Other $
22361 Comorbidity_Other_Detail $
22362 IsWeightBearingStatus_ID $
22363 IsWeightBearingStatus_Value $
22364 EmploymentStatus_ID $
22365 EmploymentStatus_Value $
22366 Ulcer1_Length_cm $
22367 Ulcer1_Width_cm $
22368 Ulcer1_Area_cm $
22369 Ulcer2_Length_cm $
22370 Ulcer2_Width_cm $
22371 Ulcer2_Area_cm $
22372 Ulcer3_Length_cm $
22373 Ulcer3_Width_cm $
22374 Ulcer3_Area_cm $
22375 Date_of_InitialUlcerDiagnosis $
22376 Date_of_EstimatedUlcerStart $
22377 RunInTx_Days $
22378 UlcerType_ID $
22379 UlcerType_Value $
22380 RunInTx_UlcerLength_cm $
22381 RunInTx_UlcerWidth_cm $
22382 RunInTx_UlcerDepth_cm $
22383 RunInTx_UlcerArea_cm $
22384 UlcerLocation_ID $
22385 UlcerLocation_Value $
22386 UlcerLocation_Other $
22387 PatientVisitsSinceDiag_ID $
22388 PatientVisitsSinceDiag_Value $
22389 PatientVisitsSinceDiag_Days $
22390 RunIn_Diagnosis_ICD10 $
22391 RunIn_Procedures_CPT___Uses_ $
22392 ;
MPRINT(IMPORT): input Case_ID $ Study_ID $ SmokingStatus_ID $ SmokingStatus_Value $
Smoking_PacksPerDay $ Comorbidity_None $ Comorbidity_CancerNeoplasm $
Comorbidity_CancerNeoplasm_Detai $ Comorbidity_Cardiovascular $ Comorbidity_Cardiovascular_Detai $
Comorbidity_Hematological $ Comorbidity_Hematological_Detail $ Comorbidity_EENT $
Comorbidity_EENT_Detail $ Comorbidity_EndocrineMetabolic $ Comorbidity_EndocrineMetabolic_D $
Comorbidity_Gastrointestinal $ Comorbidity_Gastrointestinal_Det $ Comorbidity_Genitourinary $
Comorbidity_Genitourinary_Detail $ Comorbidity_Respiratory $ Comorbidity_Respiratory_Detail $
Comorbidity_SkinOrSubcutaneous $ Comorbidity_SkinOrSubcutaneous_D $ Comorbidity_Neurological $
Comorbidity_Neurological_Detail $ Comorbidity_Musculoskeletal $ Comorbidity_Musculoskeletal_Deta $
Comorbidity_Psychological $ Comorbidity_Psychological_Detail $ Comorbidity_AlcoholSubstanceAbus $
VAR32 $ Comorbidity_Other $ Comorbidity_Other_Detail $ IsWeightBearingStatus_ID $
IsWeightBearingStatus_Value $ EmploymentStatus_ID $ EmploymentStatus_Value $ Ulcer1_Length_cm $
Ulcer1_Width_cm $ Ulcer1_Area_cm $ Ulcer2_Length_cm $ Ulcer2_Width_cm $ Ulcer2_Area_cm $
Ulcer3_Length_cm $ Ulcer3_Width_cm $ Ulcer3_Area_cm $ Date_of_InitialUlcerDiagnosis $
Date_of_EstimatedUlcerStart $ RunInTx_Days $ UlcerType_ID $ UlcerType_Value $
RunInTx_UlcerLength_cm $ RunInTx_UlcerWidth_cm $ RunInTx_UlcerDepth_cm $ RunInTx_UlcerArea_cm $
UlcerLocation_ID $ UlcerLocation_Value $ UlcerLocation_Other $ PatientVisitsSinceDiag_ID $
PatientVisitsSinceDiag_Value $ PatientVisitsSinceDiag_Days $ RunIn_Diagnosis_ICD10 $
RunIn_Procedures_CPT___Uses_ $ ;
22393 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */
MPRINT(IMPORT): if _ERROR_ then call symputx('_EFIERR_',1);
22394 run;
MPRINT(IMPORT): run;
NOTE: The infile 'S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 04 - Medical
Hx-.csv' is:
Filename=S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 04 - Medical Hx-.csv,
RECFM=V,LRECL=32767,File Size (bytes)=6455,
Last Modified=24May2017:17:22:00,
Create Time=24May2017:17:22:53
NOTE: 11 records were read from the infile 'S:\Data Management\Tides\Data Extracts\-Data Extract
(Tides) - 04 - Medical Hx-.csv'.
The minimum record length was 61.
The maximum record length was 785.
NOTE: The data set WORK.MEDHIST has 11 observations and 64 variables.
NOTE: DATA statement used (Total process time):
real time 0.26 seconds
cpu time 0.06 seconds
11 rows created in WORK.MEDHIST from S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) -
04 - Medical Hx-.csv.
NOTE: WORK.MEDHIST data set was successfully created.
NOTE: The data set WORK.MEDHIST has 11 observations and 64 variables.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 1.16 seconds
cpu time 0.42 seconds
MPRINT(IMPORT): ;
MPRINT(REFRESHTIDES): ;
MPRINT(IMPORT): PROC IMPORT OUT= baseline DATAFILE= "S:\Data Management\Tides\Data Extracts\-Data
Extract (Tides) - 05 - Tx-.csv" DBMS=CSV REPLACE;
MPRINT(IMPORT): ADLM;
MPRINT(IMPORT): GETNAMES=YES;
MPRINT(IMPORT): DATAROW=2;
MPRINT(IMPORT): RUN;
22395 /**********************************************************************
22396 * PRODUCT: SAS
22397 * VERSION: 9.4
22398 * CREATOR: External File Interface
22399 * DATE: 22MAY17
22400 * DESC: Generated SAS Datastep Code
22401 * TEMPLATE SOURCE: (None Specified.)
22402 ***********************************************************************/
22403 data WORK.BASELINE ;
MPRINT(IMPORT): data WORK.BASELINE ;
22404 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */
22405 infile 'S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 05 - Tx-.csv'
22405! delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;
MPRINT(IMPORT): infile 'S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 05 -
Tx-.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;
22406 informat Case_ID $8. ;
MPRINT(IMPORT): informat Case_ID $8. ;
22407 informat Study_ID $8. ;
MPRINT(IMPORT): informat Study_ID $8. ;
22408 informat Date_of_Treatment $24. ;
MPRINT(IMPORT): informat Date_of_Treatment $24. ;
22409 informat IsConsent_ID $3. ;
MPRINT(IMPORT): informat IsConsent_ID $3. ;
22410 informat IsConsent_Value $5. ;
MPRINT(IMPORT): informat IsConsent_Value $5. ;
22411 informat Date_of_Consent $24. ;
MPRINT(IMPORT): informat Date_of_Consent $24. ;
22412 informat BaselineTx_UlcerLength_cm $6. ;
MPRINT(IMPORT): informat BaselineTx_UlcerLength_cm $6. ;
22413 informat BaselineTx_UlcerWidth_cm $6. ;
MPRINT(IMPORT): informat BaselineTx_UlcerWidth_cm $6. ;
22414 informat BaselineTx_UlcerDepth_cm $6. ;
MPRINT(IMPORT): informat BaselineTx_UlcerDepth_cm $6. ;
22415 informat BaselineTx_UlcerArea_cm2 $6. ;
MPRINT(IMPORT): informat BaselineTx_UlcerArea_cm2 $6. ;
22416 informat IsUlcerReduced_ID $3. ;
MPRINT(IMPORT): informat IsUlcerReduced_ID $3. ;
22417 informat IsUlcerReduced_Value $5. ;
MPRINT(IMPORT): informat IsUlcerReduced_Value $5. ;
22418 informat TxGroup $41. ;
MPRINT(IMPORT): informat TxGroup $41. ;
22419 informat Randomization_Envelope_Number $6. ;
MPRINT(IMPORT): informat Randomization_Envelope_Number $6. ;
22420 informat Grafts $13. ;
MPRINT(IMPORT): informat Grafts $13. ;
22421 informat HemoglobinA1c__ $6. ;
MPRINT(IMPORT): informat HemoglobinA1c__ $6. ;
22422 informat HemoglobinA1c_Date $24. ;
MPRINT(IMPORT): informat HemoglobinA1c_Date $24. ;
22423 informat Creatinine_mg_dl $6. ;
MPRINT(IMPORT): informat Creatinine_mg_dl $6. ;
22424 informat Creatinine_Date $24. ;
MPRINT(IMPORT): informat Creatinine_Date $24. ;
22425 informat Albumin_g_dl $5. ;
MPRINT(IMPORT): informat Albumin_g_dl $5. ;
22426 informat Albumin_Date $24. ;
MPRINT(IMPORT): informat Albumin_Date $24. ;
22427 informat IsPalpablePedalPulse $3. ;
MPRINT(IMPORT): informat IsPalpablePedalPulse $3. ;
22428 informat IsAnkleBrachialIndexNotDone $3. ;
MPRINT(IMPORT): informat IsAnkleBrachialIndexNotDone $3. ;
22429 informat AnkleBrachialIndex $5. ;
MPRINT(IMPORT): informat AnkleBrachialIndex $5. ;
22430 informat Date_of_AnkleBrachialIndex $23. ;
MPRINT(IMPORT): informat Date_of_AnkleBrachialIndex $23. ;
22431 informat IsPhasicArterialWaveform_ID $3. ;
MPRINT(IMPORT): informat IsPhasicArterialWaveform_ID $3. ;
22432 informat IsPhasicArterialWaveform_Value $5. ;
MPRINT(IMPORT): informat IsPhasicArterialWaveform_Value $5. ;
22433 informat Date_of_PhasicArterialWaveform $23. ;
MPRINT(IMPORT): informat Date_of_PhasicArterialWaveform $23. ;
22434 informat IsImmuneSystemModMeds_ID $3. ;
MPRINT(IMPORT): informat IsImmuneSystemModMeds_ID $3. ;
22435 informat IsImmuneSystemModMeds_Value $4. ;
MPRINT(IMPORT): informat IsImmuneSystemModMeds_Value $4. ;
22436 informat IsAnyMeds_ID $3. ;
MPRINT(IMPORT): informat IsAnyMeds_ID $3. ;
22437 informat IsAnyMeds_Value $5. ;
MPRINT(IMPORT): informat IsAnyMeds_Value $5. ;
22438 informat IsAnyEventsPostTx_ID $3. ;
MPRINT(IMPORT): informat IsAnyEventsPostTx_ID $3. ;
22439 informat IsAnyEventsPostTx_Value $4. ;
MPRINT(IMPORT): informat IsAnyEventsPostTx_Value $4. ;
22440 informat IsAnyProtocolDeviations_ID $3. ;
MPRINT(IMPORT): informat IsAnyProtocolDeviations_ID $3. ;
22441 informat IsAnyProtocolDeviations_Value $5. ;
MPRINT(IMPORT): informat IsAnyProtocolDeviations_Value $5. ;
22442 informat Baseline_Diagnosis_ICD10 $49. ;
MPRINT(IMPORT): informat Baseline_Diagnosis_ICD10 $49. ;
22443 informat Baseline_Procedures_CPT $14. ;
MPRINT(IMPORT): informat Baseline_Procedures_CPT $14. ;
22444 informat SignedBy_ID $2. ;
MPRINT(IMPORT): informat SignedBy_ID $2. ;
22445 informat SignedBy_Name $2. ;
MPRINT(IMPORT): informat SignedBy_Name $2. ;
22446 informat Date_of_Signature $2. ;
MPRINT(IMPORT): informat Date_of_Signature $2. ;
22447 format Case_ID $8. ;
MPRINT(IMPORT): format Case_ID $8. ;
22448 format Study_ID $8. ;
MPRINT(IMPORT): format Study_ID $8. ;
22449 format Date_of_Treatment $24. ;
MPRINT(IMPORT): format Date_of_Treatment $24. ;
22450 format IsConsent_ID $3. ;
MPRINT(IMPORT): format IsConsent_ID $3. ;
22451 format IsConsent_Value $5. ;
MPRINT(IMPORT): format IsConsent_Value $5. ;
22452 format Date_of_Consent $24. ;
MPRINT(IMPORT): format Date_of_Consent $24. ;
22453 format BaselineTx_UlcerLength_cm $6. ;
MPRINT(IMPORT): format BaselineTx_UlcerLength_cm $6. ;
22454 format BaselineTx_UlcerWidth_cm $6. ;
MPRINT(IMPORT): format BaselineTx_UlcerWidth_cm $6. ;
22455 format BaselineTx_UlcerDepth_cm $6. ;
MPRINT(IMPORT): format BaselineTx_UlcerDepth_cm $6. ;
22456 format BaselineTx_UlcerArea_cm2 $6. ;
MPRINT(IMPORT): format BaselineTx_UlcerArea_cm2 $6. ;
22457 format IsUlcerReduced_ID $3. ;
MPRINT(IMPORT): format IsUlcerReduced_ID $3. ;
22458 format IsUlcerReduced_Value $5. ;
MPRINT(IMPORT): format IsUlcerReduced_Value $5. ;
22459 format TxGroup $41. ;
MPRINT(IMPORT): format TxGroup $41. ;
22460 format Randomization_Envelope_Number $6. ;
MPRINT(IMPORT): format Randomization_Envelope_Number $6. ;
22461 format Grafts $13. ;
MPRINT(IMPORT): format Grafts $13. ;
22462 format HemoglobinA1c__ $6. ;
MPRINT(IMPORT): format HemoglobinA1c__ $6. ;
22463 format HemoglobinA1c_Date $24. ;
MPRINT(IMPORT): format HemoglobinA1c_Date $24. ;
22464 format Creatinine_mg_dl $6. ;
MPRINT(IMPORT): format Creatinine_mg_dl $6. ;
22465 format Creatinine_Date $24. ;
MPRINT(IMPORT): format Creatinine_Date $24. ;
22466 format Albumin_g_dl $5. ;
MPRINT(IMPORT): format Albumin_g_dl $5. ;
22467 format Albumin_Date $24. ;
MPRINT(IMPORT): format Albumin_Date $24. ;
22468 format IsPalpablePedalPulse $3. ;
MPRINT(IMPORT): format IsPalpablePedalPulse $3. ;
22469 format IsAnkleBrachialIndexNotDone $3. ;
MPRINT(IMPORT): format IsAnkleBrachialIndexNotDone $3. ;
22470 format AnkleBrachialIndex $5. ;
MPRINT(IMPORT): format AnkleBrachialIndex $5. ;
22471 format Date_of_AnkleBrachialIndex $23. ;
MPRINT(IMPORT): format Date_of_AnkleBrachialIndex $23. ;
22472 format IsPhasicArterialWaveform_ID $3. ;
MPRINT(IMPORT): format IsPhasicArterialWaveform_ID $3. ;
22473 format IsPhasicArterialWaveform_Value $5. ;
MPRINT(IMPORT): format IsPhasicArterialWaveform_Value $5. ;
22474 format Date_of_PhasicArterialWaveform $23. ;
MPRINT(IMPORT): format Date_of_PhasicArterialWaveform $23. ;
22475 format IsImmuneSystemModMeds_ID $3. ;
MPRINT(IMPORT): format IsImmuneSystemModMeds_ID $3. ;
22476 format IsImmuneSystemModMeds_Value $4. ;
MPRINT(IMPORT): format IsImmuneSystemModMeds_Value $4. ;
22477 format IsAnyMeds_ID $3. ;
MPRINT(IMPORT): format IsAnyMeds_ID $3. ;
22478 format IsAnyMeds_Value $5. ;
MPRINT(IMPORT): format IsAnyMeds_Value $5. ;
22479 format IsAnyEventsPostTx_ID $3. ;
MPRINT(IMPORT): format IsAnyEventsPostTx_ID $3. ;
22480 format IsAnyEventsPostTx_Value $4. ;
MPRINT(IMPORT): format IsAnyEventsPostTx_Value $4. ;
22481 format IsAnyProtocolDeviations_ID $3. ;
MPRINT(IMPORT): format IsAnyProtocolDeviations_ID $3. ;
22482 format IsAnyProtocolDeviations_Value $5. ;
MPRINT(IMPORT): format IsAnyProtocolDeviations_Value $5. ;
22483 format Baseline_Diagnosis_ICD10 $49. ;
MPRINT(IMPORT): format Baseline_Diagnosis_ICD10 $49. ;
22484 format Baseline_Procedures_CPT $14. ;
MPRINT(IMPORT): format Baseline_Procedures_CPT $14. ;
22485 format SignedBy_ID $2. ;
MPRINT(IMPORT): format SignedBy_ID $2. ;
22486 format SignedBy_Name $2. ;
MPRINT(IMPORT): format SignedBy_Name $2. ;
22487 format Date_of_Signature $2. ;
MPRINT(IMPORT): format Date_of_Signature $2. ;
22488 input
22489 Case_ID $
22490 Study_ID $
22491 Date_of_Treatment $
22492 IsConsent_ID $
22493 IsConsent_Value $
22494 Date_of_Consent $
22495 BaselineTx_UlcerLength_cm $
22496 BaselineTx_UlcerWidth_cm $
22497 BaselineTx_UlcerDepth_cm $
22498 BaselineTx_UlcerArea_cm2 $
22499 IsUlcerReduced_ID $
22500 IsUlcerReduced_Value $
22501 TxGroup $
22502 Randomization_Envelope_Number $
22503 Grafts $
22504 HemoglobinA1c__ $
22505 HemoglobinA1c_Date $
22506 Creatinine_mg_dl $
22507 Creatinine_Date $
22508 Albumin_g_dl $
22509 Albumin_Date $
22510 IsPalpablePedalPulse $
22511 IsAnkleBrachialIndexNotDone $
22512 AnkleBrachialIndex $
22513 Date_of_AnkleBrachialIndex $
22514 IsPhasicArterialWaveform_ID $
22515 IsPhasicArterialWaveform_Value $
22516 Date_of_PhasicArterialWaveform $
22517 IsImmuneSystemModMeds_ID $
22518 IsImmuneSystemModMeds_Value $
22519 IsAnyMeds_ID $
22520 IsAnyMeds_Value $
22521 IsAnyEventsPostTx_ID $
22522 IsAnyEventsPostTx_Value $
22523 IsAnyProtocolDeviations_ID $
22524 IsAnyProtocolDeviations_Value $
22525 Baseline_Diagnosis_ICD10 $
22526 Baseline_Procedures_CPT $
22527 SignedBy_ID $
22528 SignedBy_Name $
22529 Date_of_Signature $
22530 ;
MPRINT(IMPORT): input Case_ID $ Study_ID $ Date_of_Treatment $ IsConsent_ID $ IsConsent_Value $
Date_of_Consent $ BaselineTx_UlcerLength_cm $ BaselineTx_UlcerWidth_cm $ BaselineTx_UlcerDepth_cm $
BaselineTx_UlcerArea_cm2 $ IsUlcerReduced_ID $ IsUlcerReduced_Value $ TxGroup $
Randomization_Envelope_Number $ Grafts $ HemoglobinA1c__ $ HemoglobinA1c_Date $ Creatinine_mg_dl $
Creatinine_Date $ Albumin_g_dl $ Albumin_Date $ IsPalpablePedalPulse $ IsAnkleBrachialIndexNotDone
$ AnkleBrachialIndex $ Date_of_AnkleBrachialIndex $ IsPhasicArterialWaveform_ID $
IsPhasicArterialWaveform_Value $ Date_of_PhasicArterialWaveform $ IsImmuneSystemModMeds_ID $
IsImmuneSystemModMeds_Value $ IsAnyMeds_ID $ IsAnyMeds_Value $ IsAnyEventsPostTx_ID $
IsAnyEventsPostTx_Value $ IsAnyProtocolDeviations_ID $ IsAnyProtocolDeviations_Value $
Baseline_Diagnosis_ICD10 $ Baseline_Procedures_CPT $ SignedBy_ID $ SignedBy_Name $
Date_of_Signature $ ;
22531 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */
MPRINT(IMPORT): if _ERROR_ then call symputx('_EFIERR_',1);
22532 run;
MPRINT(IMPORT): run;
NOTE: The infile 'S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 05 - Tx-.csv' is:
Filename=S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 05 - Tx-.csv,
RECFM=V,LRECL=32767,File Size (bytes)=4064,
Last Modified=24May2017:17:22:06,
Create Time=24May2017:17:22:53
NOTE: 9 records were read from the infile 'S:\Data Management\Tides\Data Extracts\-Data Extract
(Tides) - 05 - Tx-.csv'.
The minimum record length was 327.
The maximum record length was 421.
NOTE: The data set WORK.BASELINE has 9 observations and 41 variables.
NOTE: DATA statement used (Total process time):
real time 0.24 seconds
cpu time 0.04 seconds
9 rows created in WORK.BASELINE from S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) -
05 - Tx-.csv.
NOTE: WORK.BASELINE data set was successfully created.
NOTE: The data set WORK.BASELINE has 9 observations and 41 variables.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 1.17 seconds
cpu time 0.39 seconds
MPRINT(IMPORT): ;
MPRINT(REFRESHTIDES): ;
MPRINT(IMPORT): PROC IMPORT OUT= weekly DATAFILE= "S:\Data Management\Tides\Data Extracts\-Data
Extract (Tides) - 06 - Weekly Tx-.csv" DBMS=CSV REPLACE;
MPRINT(IMPORT): ADLM;
MPRINT(IMPORT): GETNAMES=YES;
MPRINT(IMPORT): DATAROW=2;
MPRINT(IMPORT): RUN;
22533 /**********************************************************************
22534 * PRODUCT: SAS
22535 * VERSION: 9.4
22536 * CREATOR: External File Interface
22537 * DATE: 22MAY17
22538 * DESC: Generated SAS Datastep Code
22539 * TEMPLATE SOURCE: (None Specified.)
22540 ***********************************************************************/
22541 data WORK.WEEKLY ;
MPRINT(IMPORT): data WORK.WEEKLY ;
22542 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */
22543 infile 'S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 06 - Weekly
22543! Tx-.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;
MPRINT(IMPORT): infile 'S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 06 -
Weekly Tx-.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;
22544 informat Outcomes_UlcerWklyRx_ID $5. ;
MPRINT(IMPORT): informat Outcomes_UlcerWklyRx_ID $5. ;
22545 informat Study_ID $8. ;
MPRINT(IMPORT): informat Study_ID $8. ;
22546 informat Case_ID $8. ;
MPRINT(IMPORT): informat Case_ID $8. ;
22547 informat Date_of_Evaluation $24. ;
MPRINT(IMPORT): informat Date_of_Evaluation $24. ;
22548 informat Followup_ID $6. ;
MPRINT(IMPORT): informat Followup_ID $6. ;
22549 informat Followup_Name $9. ;
MPRINT(IMPORT): informat Followup_Name $9. ;
22550 informat Comments $69. ;
MPRINT(IMPORT): informat Comments $69. ;
22551 informat IsUlcerHealed_ID $3. ;
MPRINT(IMPORT): informat IsUlcerHealed_ID $3. ;
22552 informat IsUlcerHealed_Value $5. ;
MPRINT(IMPORT): informat IsUlcerHealed_Value $5. ;
22553 informat UlcerLength_cm $6. ;
MPRINT(IMPORT): informat UlcerLength_cm $6. ;
22554 informat UlcerWidth_cm $6. ;
MPRINT(IMPORT): informat UlcerWidth_cm $6. ;
22555 informat UlcerArea_cm $6. ;
MPRINT(IMPORT): informat UlcerArea_cm $6. ;
22556 informat UlcerDepth_cm $6. ;
MPRINT(IMPORT): informat UlcerDepth_cm $6. ;
22557 informat GraftsUsed $4. ;
MPRINT(IMPORT): informat GraftsUsed $4. ;
22558 informat Grafts $13. ;
MPRINT(IMPORT): informat Grafts $13. ;
22559 informat IsMedChanges_ID $5. ;
MPRINT(IMPORT): informat IsMedChanges_ID $5. ;
22560 informat IsMedChanges_Value $5. ;
MPRINT(IMPORT): informat IsMedChanges_Value $5. ;
22561 informat IsNewAdverseEvent_ID $3. ;
MPRINT(IMPORT): informat IsNewAdverseEvent_ID $3. ;
22562 informat IsNewAdverseEvent_Value $5. ;
MPRINT(IMPORT): informat IsNewAdverseEvent_Value $5. ;
22563 informat IsAdverseEventChange_ID $13. ;
MPRINT(IMPORT): informat IsAdverseEventChange_ID $13. ;
22564 informat IsAdverseEventChange_Value $4. ;
MPRINT(IMPORT): informat IsAdverseEventChange_Value $4. ;
22565 informat IsProtocolDeviation_ID $11. ;
MPRINT(IMPORT): informat IsProtocolDeviation_ID $11. ;
22566 informat IsProtocolDeviation_Value $27. ;
MPRINT(IMPORT): informat IsProtocolDeviation_Value $27. ;
22567 informat SignedBy_ID $2. ;
MPRINT(IMPORT): informat SignedBy_ID $2. ;
22568 informat Date_of_Signature $22. ;
MPRINT(IMPORT): informat Date_of_Signature $22. ;
22569 informat WeightBearingStatus_ID $3. ;
MPRINT(IMPORT): informat WeightBearingStatus_ID $3. ;
22570 informat WeightBearingStatus_Value $16. ;
MPRINT(IMPORT): informat WeightBearingStatus_Value $16. ;
22571 informat EmploymentStatus_ID $4. ;
MPRINT(IMPORT): informat EmploymentStatus_ID $4. ;
22572 informat EmploymentStatus_Value $66. ;
MPRINT(IMPORT): informat EmploymentStatus_Value $66. ;
22573 informat Diagnosis_Codes $35. ;
MPRINT(IMPORT): informat Diagnosis_Codes $35. ;
22574 informat Procedure_Codes $28. ;
MPRINT(IMPORT): informat Procedure_Codes $28. ;
22575 informat Date_of_Entry $24. ;
MPRINT(IMPORT): informat Date_of_Entry $24. ;
22576 informat MissingQualifier_ID $2. ;
MPRINT(IMPORT): informat MissingQualifier_ID $2. ;
22577 informat MissingQualifier_Name $2. ;
MPRINT(IMPORT): informat MissingQualifier_Name $2. ;
22578 format Outcomes_UlcerWklyRx_ID $5. ;
MPRINT(IMPORT): format Outcomes_UlcerWklyRx_ID $5. ;
22579 format Study_ID $8. ;
MPRINT(IMPORT): format Study_ID $8. ;
22580 format Case_ID $8. ;
MPRINT(IMPORT): format Case_ID $8. ;
22581 format Date_of_Evaluation $24. ;
MPRINT(IMPORT): format Date_of_Evaluation $24. ;
22582 format Followup_ID $6. ;
MPRINT(IMPORT): format Followup_ID $6. ;
22583 format Followup_Name $9. ;
MPRINT(IMPORT): format Followup_Name $9. ;
22584 format Comments $69. ;
MPRINT(IMPORT): format Comments $69. ;
22585 format IsUlcerHealed_ID $3. ;
MPRINT(IMPORT): format IsUlcerHealed_ID $3. ;
22586 format IsUlcerHealed_Value $5. ;
MPRINT(IMPORT): format IsUlcerHealed_Value $5. ;
22587 format UlcerLength_cm $6. ;
MPRINT(IMPORT): format UlcerLength_cm $6. ;
22588 format UlcerWidth_cm $6. ;
MPRINT(IMPORT): format UlcerWidth_cm $6. ;
22589 format UlcerArea_cm $6. ;
MPRINT(IMPORT): format UlcerArea_cm $6. ;
22590 format UlcerDepth_cm $6. ;
MPRINT(IMPORT): format UlcerDepth_cm $6. ;
22591 format GraftsUsed $4. ;
MPRINT(IMPORT): format GraftsUsed $4. ;
22592 format Grafts $13. ;
MPRINT(IMPORT): format Grafts $13. ;
22593 format IsMedChanges_ID $5. ;
MPRINT(IMPORT): format IsMedChanges_ID $5. ;
22594 format IsMedChanges_Value $5. ;
MPRINT(IMPORT): format IsMedChanges_Value $5. ;
22595 format IsNewAdverseEvent_ID $3. ;
MPRINT(IMPORT): format IsNewAdverseEvent_ID $3. ;
22596 format IsNewAdverseEvent_Value $5. ;
MPRINT(IMPORT): format IsNewAdverseEvent_Value $5. ;
22597 format IsAdverseEventChange_ID $13. ;
MPRINT(IMPORT): format IsAdverseEventChange_ID $13. ;
22598 format IsAdverseEventChange_Value $4. ;
MPRINT(IMPORT): format IsAdverseEventChange_Value $4. ;
22599 format IsProtocolDeviation_ID $11. ;
MPRINT(IMPORT): format IsProtocolDeviation_ID $11. ;
22600 format IsProtocolDeviation_Value $27. ;
MPRINT(IMPORT): format IsProtocolDeviation_Value $27. ;
22601 format SignedBy_ID $2. ;
MPRINT(IMPORT): format SignedBy_ID $2. ;
22602 format Date_of_Signature $22. ;
MPRINT(IMPORT): format Date_of_Signature $22. ;
22603 format WeightBearingStatus_ID $3. ;
MPRINT(IMPORT): format WeightBearingStatus_ID $3. ;
22604 format WeightBearingStatus_Value $16. ;
MPRINT(IMPORT): format WeightBearingStatus_Value $16. ;
22605 format EmploymentStatus_ID $4. ;
MPRINT(IMPORT): format EmploymentStatus_ID $4. ;
22606 format EmploymentStatus_Value $66. ;
MPRINT(IMPORT): format EmploymentStatus_Value $66. ;
22607 format Diagnosis_Codes $35. ;
MPRINT(IMPORT): format Diagnosis_Codes $35. ;
22608 format Procedure_Codes $28. ;
MPRINT(IMPORT): format Procedure_Codes $28. ;
22609 format Date_of_Entry $24. ;
MPRINT(IMPORT): format Date_of_Entry $24. ;
22610 format MissingQualifier_ID $2. ;
MPRINT(IMPORT): format MissingQualifier_ID $2. ;
22611 format MissingQualifier_Name $2. ;
MPRINT(IMPORT): format MissingQualifier_Name $2. ;
22612 input
22613 Outcomes_UlcerWklyRx_ID $
22614 Study_ID $
22615 Case_ID $
22616 Date_of_Evaluation $
22617 Followup_ID $
22618 Followup_Name $
22619 Comments $
22620 IsUlcerHealed_ID $
22621 IsUlcerHealed_Value $
22622 UlcerLength_cm $
22623 UlcerWidth_cm $
22624 UlcerArea_cm $
22625 UlcerDepth_cm $
22626 GraftsUsed $
22627 Grafts $
22628 IsMedChanges_ID $
22629 IsMedChanges_Value $
22630 IsNewAdverseEvent_ID $
22631 IsNewAdverseEvent_Value $
22632 IsAdverseEventChange_ID $
22633 IsAdverseEventChange_Value $
22634 IsProtocolDeviation_ID $
22635 IsProtocolDeviation_Value $
22636 SignedBy_ID $
22637 Date_of_Signature $
22638 WeightBearingStatus_ID $
22639 WeightBearingStatus_Value $
22640 EmploymentStatus_ID $
22641 EmploymentStatus_Value $
22642 Diagnosis_Codes $
22643 Procedure_Codes $
22644 Date_of_Entry $
22645 MissingQualifier_ID $
22646 MissingQualifier_Name $
22647 ;
MPRINT(IMPORT): input Outcomes_UlcerWklyRx_ID $ Study_ID $ Case_ID $ Date_of_Evaluation $
Followup_ID $ Followup_Name $ Comments $ IsUlcerHealed_ID $ IsUlcerHealed_Value $ UlcerLength_cm $
UlcerWidth_cm $ UlcerArea_cm $ UlcerDepth_cm $ GraftsUsed $ Grafts $ IsMedChanges_ID $
IsMedChanges_Value $ IsNewAdverseEvent_ID $ IsNewAdverseEvent_Value $ IsAdverseEventChange_ID $
IsAdverseEventChange_Value $ IsProtocolDeviation_ID $ IsProtocolDeviation_Value $ SignedBy_ID $
Date_of_Signature $ WeightBearingStatus_ID $ WeightBearingStatus_Value $ EmploymentStatus_ID $
EmploymentStatus_Value $ Diagnosis_Codes $ Procedure_Codes $ Date_of_Entry $ MissingQualifier_ID $
MissingQualifier_Name $ ;
22648 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */
MPRINT(IMPORT): if _ERROR_ then call symputx('_EFIERR_',1);
22649 run;
MPRINT(IMPORT): run;
NOTE: The infile 'S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 06 - Weekly
Tx-.csv' is:
Filename=S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 06 - Weekly Tx-.csv,
RECFM=V,LRECL=32767,File Size (bytes)=8164,
Last Modified=24May2017:17:22:13,
Create Time=24May2017:17:22:53
NOTE: 29 records were read from the infile 'S:\Data Management\Tides\Data Extracts\-Data Extract
(Tides) - 06 - Weekly Tx-.csv'.
The minimum record length was 127.
The maximum record length was 356.
NOTE: The data set WORK.WEEKLY has 29 observations and 34 variables.
NOTE: DATA statement used (Total process time):
real time 0.23 seconds
cpu time 0.06 seconds
29 rows created in WORK.WEEKLY from S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) -
06 - Weekly Tx-.csv.
NOTE: WORK.WEEKLY data set was successfully created.
NOTE: The data set WORK.WEEKLY has 29 observations and 34 variables.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 1.08 seconds
cpu time 0.42 seconds
MPRINT(IMPORT): ;
MPRINT(REFRESHTIDES): ;
MPRINT(IMPORT): PROC IMPORT OUT= eq5d DATAFILE= "S:\Data Management\Tides\Data Extracts\-Data
Extract (Tides) - 07 - EQ5D-.csv" DBMS=CSV REPLACE;
MPRINT(IMPORT): ADLM;
MPRINT(IMPORT): GETNAMES=YES;
MPRINT(IMPORT): DATAROW=2;
MPRINT(IMPORT): RUN;
22650 /**********************************************************************
22651 * PRODUCT: SAS
22652 * VERSION: 9.4
22653 * CREATOR: External File Interface
22654 * DATE: 22MAY17
22655 * DESC: Generated SAS Datastep Code
22656 * TEMPLATE SOURCE: (None Specified.)
22657 ***********************************************************************/
22658 data WORK.EQ5D ;
MPRINT(IMPORT): data WORK.EQ5D ;
22659 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */
22660 infile 'S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 07 - EQ5D-.csv'
22660! delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;
MPRINT(IMPORT): infile 'S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 07 -
EQ5D-.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;
22661 informat EQ5D_ID $7. ;
MPRINT(IMPORT): informat EQ5D_ID $7. ;
22662 informat Study_ID $8. ;
MPRINT(IMPORT): informat Study_ID $8. ;
22663 informat Case_ID $8. ;
MPRINT(IMPORT): informat Case_ID $8. ;
22664 informat Date_of_Evaluation $24. ;
MPRINT(IMPORT): informat Date_of_Evaluation $24. ;
22665 informat Followup_ID $4. ;
MPRINT(IMPORT): informat Followup_ID $4. ;
22666 informat Followup_Name $19. ;
MPRINT(IMPORT): informat Followup_Name $19. ;
22667 informat Comments $127. ;
MPRINT(IMPORT): informat Comments $127. ;
22668 informat Q1 $3. ;
MPRINT(IMPORT): informat Q1 $3. ;
22669 informat Q2 $3. ;
MPRINT(IMPORT): informat Q2 $3. ;
22670 informat Q3 $3. ;
MPRINT(IMPORT): informat Q3 $3. ;
22671 informat Q4 $3. ;
MPRINT(IMPORT): informat Q4 $3. ;
22672 informat Q5 $3. ;
MPRINT(IMPORT): informat Q5 $3. ;
22673 informat Q6 $4. ;
MPRINT(IMPORT): informat Q6 $4. ;
22674 informat Date_of_Entry $23. ;
MPRINT(IMPORT): informat Date_of_Entry $23. ;
22675 informat MissingQualifier_ID $2. ;
MPRINT(IMPORT): informat MissingQualifier_ID $2. ;
22676 informat MissingQualifier_Name $2. ;
MPRINT(IMPORT): informat MissingQualifier_Name $2. ;
22677 format EQ5D_ID $7. ;
MPRINT(IMPORT): format EQ5D_ID $7. ;
22678 format Study_ID $8. ;
MPRINT(IMPORT): format Study_ID $8. ;
22679 format Case_ID $8. ;
MPRINT(IMPORT): format Case_ID $8. ;
22680 format Date_of_Evaluation $24. ;
MPRINT(IMPORT): format Date_of_Evaluation $24. ;
22681 format Followup_ID $4. ;
MPRINT(IMPORT): format Followup_ID $4. ;
22682 format Followup_Name $19. ;
MPRINT(IMPORT): format Followup_Name $19. ;
22683 format Comments $127. ;
MPRINT(IMPORT): format Comments $127. ;
22684 format Q1 $3. ;
MPRINT(IMPORT): format Q1 $3. ;
22685 format Q2 $3. ;
MPRINT(IMPORT): format Q2 $3. ;
22686 format Q3 $3. ;
MPRINT(IMPORT): format Q3 $3. ;
22687 format Q4 $3. ;
MPRINT(IMPORT): format Q4 $3. ;
22688 format Q5 $3. ;
MPRINT(IMPORT): format Q5 $3. ;
22689 format Q6 $4. ;
MPRINT(IMPORT): format Q6 $4. ;
22690 format Date_of_Entry $23. ;
MPRINT(IMPORT): format Date_of_Entry $23. ;
22691 format MissingQualifier_ID $2. ;
MPRINT(IMPORT): format MissingQualifier_ID $2. ;
22692 format MissingQualifier_Name $2. ;
MPRINT(IMPORT): format MissingQualifier_Name $2. ;
22693 input
22694 EQ5D_ID $
22695 Study_ID $
22696 Case_ID $
22697 Date_of_Evaluation $
22698 Followup_ID $
22699 Followup_Name $
22700 Comments $
22701 Q1 $
22702 Q2 $
22703 Q3 $
22704 Q4 $
22705 Q5 $
22706 Q6 $
22707 Date_of_Entry $
22708 MissingQualifier_ID $
22709 MissingQualifier_Name $
22710 ;
MPRINT(IMPORT): input EQ5D_ID $ Study_ID $ Case_ID $ Date_of_Evaluation $ Followup_ID $
Followup_Name $ Comments $ Q1 $ Q2 $ Q3 $ Q4 $ Q5 $ Q6 $ Date_of_Entry $ MissingQualifier_ID $
MissingQualifier_Name $ ;
22711 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */
MPRINT(IMPORT): if _ERROR_ then call symputx('_EFIERR_',1);
22712 run;
MPRINT(IMPORT): run;
NOTE: The infile 'S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 07 - EQ5D-.csv' is:
Filename=S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 07 - EQ5D-.csv,
RECFM=V,LRECL=32767,File Size (bytes)=1756,
Last Modified=24May2017:17:22:18,
Create Time=24May2017:17:22:51
NOTE: 11 records were read from the infile 'S:\Data Management\Tides\Data Extracts\-Data Extract
(Tides) - 07 - EQ5D-.csv'.
The minimum record length was 114.
The maximum record length was 245.
NOTE: The data set WORK.EQ5D has 11 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 0.21 seconds
cpu time 0.03 seconds
11 rows created in WORK.EQ5D from S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 07
- EQ5D-.csv.
NOTE: WORK.EQ5D data set was successfully created.
NOTE: The data set WORK.EQ5D has 11 observations and 16 variables.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 1.05 seconds
cpu time 0.39 seconds
MPRINT(IMPORT): ;
MPRINT(REFRESHTIDES): ;
MPRINT(IMPORT): PROC IMPORT OUT= pd DATAFILE= "S:\Data Management\Tides\Data Extracts\-Data
Extract (Tides) - 08 - Protocol Deviation Log-.csv" DBMS=CSV REPLACE;
MPRINT(IMPORT): ADLM;
MPRINT(IMPORT): GETNAMES=YES;
MPRINT(IMPORT): DATAROW=2;
MPRINT(IMPORT): RUN;
ERROR: Import cancelled. The dataset WORK.PD is being used and cannot be replaced.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds
MPRINT(IMPORT): ;
MPRINT(REFRESHTIDES): ;
MPRINT(IMPORT): PROC IMPORT OUT= Meds DATAFILE= "S:\Data Management\Tides\Data Extracts\-Data
Extract (Tides) - 09 - Medication Log-.csv" DBMS=CSV REPLACE;
MPRINT(IMPORT): ADLM;
MPRINT(IMPORT): GETNAMES=YES;
MPRINT(IMPORT): DATAROW=2;
MPRINT(IMPORT): RUN;
22713 /**********************************************************************
22714 * PRODUCT: SAS
22715 * VERSION: 9.4
22716 * CREATOR: External File Interface
22717 * DATE: 22MAY17
22718 * DESC: Generated SAS Datastep Code
22719 * TEMPLATE SOURCE: (None Specified.)
22720 ***********************************************************************/
22721 data WORK.MEDS ;
MPRINT(IMPORT): data WORK.MEDS ;
22722 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */
22723 infile 'S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 09 - Medication
22723! Log-.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;
MPRINT(IMPORT): infile 'S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 09 -
Medication Log-.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;
22724 informat CaseMedication_ID $6. ;
MPRINT(IMPORT): informat CaseMedication_ID $6. ;
22725 informat Study_ID $8. ;
MPRINT(IMPORT): informat Study_ID $8. ;
22726 informat Case_ID $8. ;
MPRINT(IMPORT): informat Case_ID $8. ;
22727 informat CasePeriod_ID $2. ;
MPRINT(IMPORT): informat CasePeriod_ID $2. ;
22728 informat CasePeriod_Value $2. ;
MPRINT(IMPORT): informat CasePeriod_Value $2. ;
22729 informat MedicationGroup_ID $2. ;
MPRINT(IMPORT): informat MedicationGroup_ID $2. ;
22730 informat MedicationGroup_Value $2. ;
MPRINT(IMPORT): informat MedicationGroup_Value $2. ;
22731 informat MedicationGroup_UserDefined $20. ;
MPRINT(IMPORT): informat MedicationGroup_UserDefined $20. ;
22732 informat MedicationGeneric_ID $6. ;
MPRINT(IMPORT): informat MedicationGeneric_ID $6. ;
22733 informat MedicationGeneric_Value $35. ;
MPRINT(IMPORT): informat MedicationGeneric_Value $35. ;
22734 informat MedicationBrand_ID $2. ;
MPRINT(IMPORT): informat MedicationBrand_ID $2. ;
22735 informat MedicationBrand_Value $2. ;
MPRINT(IMPORT): informat MedicationBrand_Value $2. ;
22736 informat Start_Date $24. ;
MPRINT(IMPORT): informat Start_Date $24. ;
22737 informat Stop_Date $23. ;
MPRINT(IMPORT): informat Stop_Date $23. ;
22738 informat StopReason_ID $3. ;
MPRINT(IMPORT): informat StopReason_ID $3. ;
22739 informat StopReason_Value $7. ;
MPRINT(IMPORT): informat StopReason_Value $7. ;
22740 informat StopReason_Other $20. ;
MPRINT(IMPORT): informat StopReason_Other $20. ;
22741 informat MedicationValue $6. ;
MPRINT(IMPORT): informat MedicationValue $6. ;
22742 informat IsDoseUnknown $3. ;
MPRINT(IMPORT): informat IsDoseUnknown $3. ;
22743 informat MedicationUnit_ID $3. ;
MPRINT(IMPORT): informat MedicationUnit_ID $3. ;
22744 informat MedicationUnit_Value $7. ;
MPRINT(IMPORT): informat MedicationUnit_Value $7. ;
22745 informat MedicationUnit_Other $7. ;
MPRINT(IMPORT): informat MedicationUnit_Other $7. ;
22746 informat MedicationFrequency_ID $3. ;
MPRINT(IMPORT): informat MedicationFrequency_ID $3. ;
22747 informat MedicationFrequency_Value $19. ;
MPRINT(IMPORT): informat MedicationFrequency_Value $19. ;
22748 informat MedicationRoute_ID $3. ;
MPRINT(IMPORT): informat MedicationRoute_ID $3. ;
22749 informat MedicationRoute_Value $14. ;
MPRINT(IMPORT): informat MedicationRoute_Value $14. ;
22750 informat MedicationRoute_Other $2. ;
MPRINT(IMPORT): informat MedicationRoute_Other $2. ;
22751 informat MedicationIndication_ID $4. ;
MPRINT(IMPORT): informat MedicationIndication_ID $4. ;
22752 informat MedicationIndication_Value $29. ;
MPRINT(IMPORT): informat MedicationIndication_Value $29. ;
22753 informat MedicationIndication_Other $25. ;
MPRINT(IMPORT): informat MedicationIndication_Other $25. ;
22754 informat IsOngoing $2. ;
MPRINT(IMPORT): informat IsOngoing $2. ;
22755 informat Date_of_Entry $23. ;
MPRINT(IMPORT): informat Date_of_Entry $23. ;
22756 format CaseMedication_ID $6. ;
MPRINT(IMPORT): format CaseMedication_ID $6. ;
22757 format Study_ID $8. ;
MPRINT(IMPORT): format Study_ID $8. ;
22758 format Case_ID $8. ;
MPRINT(IMPORT): format Case_ID $8. ;
22759 format CasePeriod_ID $2. ;
MPRINT(IMPORT): format CasePeriod_ID $2. ;
22760 format CasePeriod_Value $2. ;
MPRINT(IMPORT): format CasePeriod_Value $2. ;
22761 format MedicationGroup_ID $2. ;
MPRINT(IMPORT): format MedicationGroup_ID $2. ;
22762 format MedicationGroup_Value $2. ;
MPRINT(IMPORT): format MedicationGroup_Value $2. ;
22763 format MedicationGroup_UserDefined $20. ;
MPRINT(IMPORT): format MedicationGroup_UserDefined $20. ;
22764 format MedicationGeneric_ID $6. ;
MPRINT(IMPORT): format MedicationGeneric_ID $6. ;
22765 format MedicationGeneric_Value $35. ;
MPRINT(IMPORT): format MedicationGeneric_Value $35. ;
22766 format MedicationBrand_ID $2. ;
MPRINT(IMPORT): format MedicationBrand_ID $2. ;
22767 format MedicationBrand_Value $2. ;
MPRINT(IMPORT): format MedicationBrand_Value $2. ;
22768 format Start_Date $24. ;
MPRINT(IMPORT): format Start_Date $24. ;
22769 format Stop_Date $23. ;
MPRINT(IMPORT): format Stop_Date $23. ;
22770 format StopReason_ID $3. ;
MPRINT(IMPORT): format StopReason_ID $3. ;
22771 format StopReason_Value $7. ;
MPRINT(IMPORT): format StopReason_Value $7. ;
22772 format StopReason_Other $20. ;
MPRINT(IMPORT): format StopReason_Other $20. ;
22773 format MedicationValue $6. ;
MPRINT(IMPORT): format MedicationValue $6. ;
22774 format IsDoseUnknown $3. ;
MPRINT(IMPORT): format IsDoseUnknown $3. ;
22775 format MedicationUnit_ID $3. ;
MPRINT(IMPORT): format MedicationUnit_ID $3. ;
22776 format MedicationUnit_Value $7. ;
MPRINT(IMPORT): format MedicationUnit_Value $7. ;
22777 format MedicationUnit_Other $7. ;
MPRINT(IMPORT): format MedicationUnit_Other $7. ;
22778 format MedicationFrequency_ID $3. ;
MPRINT(IMPORT): format MedicationFrequency_ID $3. ;
22779 format MedicationFrequency_Value $19. ;
MPRINT(IMPORT): format MedicationFrequency_Value $19. ;
22780 format MedicationRoute_ID $3. ;
MPRINT(IMPORT): format MedicationRoute_ID $3. ;
22781 format MedicationRoute_Value $14. ;
MPRINT(IMPORT): format MedicationRoute_Value $14. ;
22782 format MedicationRoute_Other $2. ;
MPRINT(IMPORT): format MedicationRoute_Other $2. ;
22783 format MedicationIndication_ID $4. ;
MPRINT(IMPORT): format MedicationIndication_ID $4. ;
22784 format MedicationIndication_Value $29. ;
MPRINT(IMPORT): format MedicationIndication_Value $29. ;
22785 format MedicationIndication_Other $25. ;
MPRINT(IMPORT): format MedicationIndication_Other $25. ;
22786 format IsOngoing $2. ;
MPRINT(IMPORT): format IsOngoing $2. ;
22787 format Date_of_Entry $23. ;
MPRINT(IMPORT): format Date_of_Entry $23. ;
22788 input
22789 CaseMedication_ID $
22790 Study_ID $
22791 Case_ID $
22792 CasePeriod_ID $
22793 CasePeriod_Value $
22794 MedicationGroup_ID $
22795 MedicationGroup_Value $
22796 MedicationGroup_UserDefined $
22797 MedicationGeneric_ID $
22798 MedicationGeneric_Value $
22799 MedicationBrand_ID $
22800 MedicationBrand_Value $
22801 Start_Date $
22802 Stop_Date $
22803 StopReason_ID $
22804 StopReason_Value $
22805 StopReason_Other $
22806 MedicationValue $
22807 IsDoseUnknown $
22808 MedicationUnit_ID $
22809 MedicationUnit_Value $
22810 MedicationUnit_Other $
22811 MedicationFrequency_ID $
22812 MedicationFrequency_Value $
22813 MedicationRoute_ID $
22814 MedicationRoute_Value $
22815 MedicationRoute_Other $
22816 MedicationIndication_ID $
22817 MedicationIndication_Value $
22818 MedicationIndication_Other $
22819 IsOngoing $
22820 Date_of_Entry $
22821 ;
MPRINT(IMPORT): input CaseMedication_ID $ Study_ID $ Case_ID $ CasePeriod_ID $ CasePeriod_Value $
MedicationGroup_ID $ MedicationGroup_Value $ MedicationGroup_UserDefined $ MedicationGeneric_ID $
MedicationGeneric_Value $ MedicationBrand_ID $ MedicationBrand_Value $ Start_Date $ Stop_Date $
StopReason_ID $ StopReason_Value $ StopReason_Other $ MedicationValue $ IsDoseUnknown $
MedicationUnit_ID $ MedicationUnit_Value $ MedicationUnit_Other $ MedicationFrequency_ID $
MedicationFrequency_Value $ MedicationRoute_ID $ MedicationRoute_Value $ MedicationRoute_Other $
MedicationIndication_ID $ MedicationIndication_Value $ MedicationIndication_Other $ IsOngoing $
Date_of_Entry $ ;
22822 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */
MPRINT(IMPORT): if _ERROR_ then call symputx('_EFIERR_',1);
22823 run;
MPRINT(IMPORT): run;
NOTE: The infile 'S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 09 - Medication
Log-.csv' is:
Filename=S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 09 - Medication
Log-.csv,
RECFM=V,LRECL=32767,File Size (bytes)=14397,
Last Modified=24May2017:17:22:25,
Create Time=24May2017:17:22:51
NOTE: 64 records were read from the infile 'S:\Data Management\Tides\Data Extracts\-Data Extract
(Tides) - 09 - Medication Log-.csv'.
The minimum record length was 187.
The maximum record length was 269.
NOTE: The data set WORK.MEDS has 64 observations and 32 variables.
NOTE: DATA statement used (Total process time):
real time 0.23 seconds
cpu time 0.03 seconds
64 rows created in WORK.MEDS from S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 09
- Medication Log-.csv.
NOTE: WORK.MEDS data set was successfully created.
NOTE: The data set WORK.MEDS has 64 observations and 32 variables.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 1.13 seconds
cpu time 0.42 seconds
MPRINT(IMPORT): ;
MPRINT(REFRESHTIDES): ;
MPRINT(IMPORT): PROC IMPORT OUT= EoT DATAFILE= "S:\Data Management\Tides\Data Extracts\-Data
Extract (Tides) - 10 - End of Treatment-.csv" DBMS=CSV REPLACE;
MPRINT(IMPORT): ADLM;
MPRINT(IMPORT): GETNAMES=YES;
MPRINT(IMPORT): DATAROW=2;
MPRINT(IMPORT): RUN;
Name DidPatientCompleteTreatment_Value truncated to DidPatientCompleteTreatment_Valu.
Problems were detected with provided names. See LOG.
22824 /**********************************************************************
22825 * PRODUCT: SAS
22826 * VERSION: 9.4
22827 * CREATOR: External File Interface
22828 * DATE: 22MAY17
22829 * DESC: Generated SAS Datastep Code
22830 * TEMPLATE SOURCE: (None Specified.)
22831 ***********************************************************************/
22832 data WORK.EOT ;
MPRINT(IMPORT): data WORK.EOT ;
22833 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */
22834 infile 'S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 10 - End of
22834! Treatment-.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;
MPRINT(IMPORT): infile 'S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 10 - End
of Treatment-.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;
22835 informat Case_EndofTreatment_ID $4. ;
MPRINT(IMPORT): informat Case_EndofTreatment_ID $4. ;
22836 informat Study_ID $8. ;
MPRINT(IMPORT): informat Study_ID $8. ;
22837 informat Case_ID $8. ;
MPRINT(IMPORT): informat Case_ID $8. ;
22838 informat Date_of_Evaluation $24. ;
MPRINT(IMPORT): informat Date_of_Evaluation $24. ;
22839 informat DidPatientCompleteTreatment_ID $3. ;
MPRINT(IMPORT): informat DidPatientCompleteTreatment_ID $3. ;
22840 informat DidPatientCompleteTreatment_Valu $5. ;
MPRINT(IMPORT): informat DidPatientCompleteTreatment_Valu $5. ;
22841 informat IsPatientHealed_ID $3. ;
MPRINT(IMPORT): informat IsPatientHealed_ID $3. ;
22842 informat IsPatientHealed_Value $67. ;
MPRINT(IMPORT): informat IsPatientHealed_Value $67. ;
22843 informat Followup_ID_Wound_Healed $4. ;
MPRINT(IMPORT): informat Followup_ID_Wound_Healed $4. ;
22844 informat Followup_Name_Wound_Healed $9. ;
MPRINT(IMPORT): informat Followup_Name_Wound_Healed $9. ;
22845 informat SignedBy_ID $2. ;
MPRINT(IMPORT): informat SignedBy_ID $2. ;
22846 informat SignedBy_Name $2. ;
MPRINT(IMPORT): informat SignedBy_Name $2. ;
22847 informat Date_of_Signature $2. ;
MPRINT(IMPORT): informat Date_of_Signature $2. ;
22848 informat Date_of_Entry $22. ;
MPRINT(IMPORT): informat Date_of_Entry $22. ;
22849 format Case_EndofTreatment_ID $4. ;
MPRINT(IMPORT): format Case_EndofTreatment_ID $4. ;
22850 format Study_ID $8. ;
MPRINT(IMPORT): format Study_ID $8. ;
22851 format Case_ID $8. ;
MPRINT(IMPORT): format Case_ID $8. ;
22852 format Date_of_Evaluation $24. ;
MPRINT(IMPORT): format Date_of_Evaluation $24. ;
22853 format DidPatientCompleteTreatment_ID $3. ;
MPRINT(IMPORT): format DidPatientCompleteTreatment_ID $3. ;
22854 format DidPatientCompleteTreatment_Valu $5. ;
MPRINT(IMPORT): format DidPatientCompleteTreatment_Valu $5. ;
22855 format IsPatientHealed_ID $3. ;
MPRINT(IMPORT): format IsPatientHealed_ID $3. ;
22856 format IsPatientHealed_Value $67. ;
MPRINT(IMPORT): format IsPatientHealed_Value $67. ;
22857 format Followup_ID_Wound_Healed $4. ;
MPRINT(IMPORT): format Followup_ID_Wound_Healed $4. ;
22858 format Followup_Name_Wound_Healed $9. ;
MPRINT(IMPORT): format Followup_Name_Wound_Healed $9. ;
22859 format SignedBy_ID $2. ;
MPRINT(IMPORT): format SignedBy_ID $2. ;
22860 format SignedBy_Name $2. ;
MPRINT(IMPORT): format SignedBy_Name $2. ;
22861 format Date_of_Signature $2. ;
MPRINT(IMPORT): format Date_of_Signature $2. ;
22862 format Date_of_Entry $22. ;
MPRINT(IMPORT): format Date_of_Entry $22. ;
22863 input
22864 Case_EndofTreatment_ID $
22865 Study_ID $
22866 Case_ID $
22867 Date_of_Evaluation $
22868 DidPatientCompleteTreatment_ID $
22869 DidPatientCompleteTreatment_Valu $
22870 IsPatientHealed_ID $
22871 IsPatientHealed_Value $
22872 Followup_ID_Wound_Healed $
22873 Followup_Name_Wound_Healed $
22874 SignedBy_ID $
22875 SignedBy_Name $
22876 Date_of_Signature $
22877 Date_of_Entry $
22878 ;
MPRINT(IMPORT): input Case_EndofTreatment_ID $ Study_ID $ Case_ID $ Date_of_Evaluation $
DidPatientCompleteTreatment_ID $ DidPatientCompleteTreatment_Valu $ IsPatientHealed_ID $
IsPatientHealed_Value $ Followup_ID_Wound_Healed $ Followup_Name_Wound_Healed $ SignedBy_ID $
SignedBy_Name $ Date_of_Signature $ Date_of_Entry $ ;
22879 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */
MPRINT(IMPORT): if _ERROR_ then call symputx('_EFIERR_',1);
22880 run;
MPRINT(IMPORT): run;
NOTE: The infile 'S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 10 - End of
Treatment-.csv' is:
Filename=S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 10 - End of
Treatment-.csv,
RECFM=V,LRECL=32767,File Size (bytes)=828,
Last Modified=24May2017:17:22:29,
Create Time=24May2017:17:22:51
NOTE: 4 records were read from the infile 'S:\Data Management\Tides\Data Extracts\-Data Extract
(Tides) - 10 - End of Treatment-.csv'.
The minimum record length was 98.
The maximum record length was 174.
NOTE: The data set WORK.EOT has 4 observations and 14 variables.
NOTE: DATA statement used (Total process time):
real time 0.23 seconds
cpu time 0.03 seconds
4 rows created in WORK.EOT from S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 10 -
End of Treatment-.csv.
NOTE: WORK.EOT data set was successfully created.
NOTE: The data set WORK.EOT has 4 observations and 14 variables.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 1.06 seconds
cpu time 0.42 seconds
MPRINT(IMPORT): ;
MPRINT(REFRESHTIDES): ;
MPRINT(IMPORT): PROC IMPORT OUT= EoS DATAFILE= "S:\Data Management\Tides\Data Extracts\-Data
Extract (Tides) - 11 - End of Study-.csv" DBMS=CSV REPLACE;
MPRINT(IMPORT): ADLM;
MPRINT(IMPORT): GETNAMES=YES;
MPRINT(IMPORT): DATAROW=2;
MPRINT(IMPORT): RUN;
Name IsPatientReceiveArtacentTreatment_ID truncated to IsPatientReceiveArtacentTreatmen.
Name IsPatientReceiveArtacentTreatment_Value truncated to IsPatientReceiveArtacentTreatmen.
Name IsPatientReceiveArtacentTreatmen is a duplicate.
Name IsPatientContact24WeekSurvey_Value truncated to IsPatientContact24WeekSurvey_Val.
Problems were detected with provided names. See LOG.
22881 /**********************************************************************
22882 * PRODUCT: SAS
22883 * VERSION: 9.4
22884 * CREATOR: External File Interface
22885 * DATE: 22MAY17
22886 * DESC: Generated SAS Datastep Code
22887 * TEMPLATE SOURCE: (None Specified.)
22888 ***********************************************************************/
22889 data WORK.EOS ;
MPRINT(IMPORT): data WORK.EOS ;
22890 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */
22891 infile 'S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 11 - End of
22891! Study-.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;
MPRINT(IMPORT): infile 'S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 11 - End
of Study-.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;
22892 informat Case_EndofStudy_ID $5. ;
MPRINT(IMPORT): informat Case_EndofStudy_ID $5. ;
22893 informat Study_ID $8. ;
MPRINT(IMPORT): informat Study_ID $8. ;
22894 informat Case_ID $8. ;
MPRINT(IMPORT): informat Case_ID $8. ;
22895 informat Date_of_Evaluation $24. ;
MPRINT(IMPORT): informat Date_of_Evaluation $24. ;
22896 informat Followup_ID $4. ;
MPRINT(IMPORT): informat Followup_ID $4. ;
22897 informat Followup_Name $9. ;
MPRINT(IMPORT): informat Followup_Name $9. ;
22898 informat DidPatientCompleteStudy_ID $3. ;
MPRINT(IMPORT): informat DidPatientCompleteStudy_ID $3. ;
22899 informat DidPatientCompleteStudy_Value $5. ;
MPRINT(IMPORT): informat DidPatientCompleteStudy_Value $5. ;
22900 informat IsPatientHealed_ID $3. ;
MPRINT(IMPORT): informat IsPatientHealed_ID $3. ;
22901 informat IsPatientHealed_Value $5. ;
MPRINT(IMPORT): informat IsPatientHealed_Value $5. ;
22902 informat IsPatientReceiveArtacentTreatmen $2. ;
MPRINT(IMPORT): informat IsPatientReceiveArtacentTreatmen $2. ;
22903 informat VAR12 $2. ;
MPRINT(IMPORT): informat VAR12 $2. ;
22904 informat NotCompleteStudyReason_ID $3. ;
MPRINT(IMPORT): informat NotCompleteStudyReason_ID $3. ;
22905 informat NotCompleteStudyReason_Value $38. ;
MPRINT(IMPORT): informat NotCompleteStudyReason_Value $38. ;
22906 informat NotCompleteStudyOther $59. ;
MPRINT(IMPORT): informat NotCompleteStudyOther $59. ;
22907 informat NumberOfAttemptsToContact $2. ;
MPRINT(IMPORT): informat NumberOfAttemptsToContact $2. ;
22908 informat WithdrewConsentReason $2. ;
MPRINT(IMPORT): informat WithdrewConsentReason $2. ;
22909 informat DiscontinuedByInvestigatorReason $43. ;
MPRINT(IMPORT): informat DiscontinuedByInvestigatorReason $43. ;
22910 informat AdverseEvent_IsAmputation $3. ;
MPRINT(IMPORT): informat AdverseEvent_IsAmputation $3. ;
22911 informat AdverseEvent_IsAmputationReason $2. ;
MPRINT(IMPORT): informat AdverseEvent_IsAmputationReason $2. ;
22912 informat AdverseEvent_IsDeath $3. ;
MPRINT(IMPORT): informat AdverseEvent_IsDeath $3. ;
22913 informat AdverseEvent_IsDeathReason $2. ;
MPRINT(IMPORT): informat AdverseEvent_IsDeathReason $2. ;
22914 informat AdverseEvent_IsOther $3. ;
MPRINT(IMPORT): informat AdverseEvent_IsOther $3. ;
22915 informat AdverseEvent_IsOtherReason $2. ;
MPRINT(IMPORT): informat AdverseEvent_IsOtherReason $2. ;
22916 informat IsPatientContact24WeekSurvey_ID $3. ;
MPRINT(IMPORT): informat IsPatientContact24WeekSurvey_ID $3. ;
22917 informat IsPatientContact24WeekSurvey_Val $5. ;
MPRINT(IMPORT): informat IsPatientContact24WeekSurvey_Val $5. ;
22918 informat PhoneContactAttemptsMade $2. ;
MPRINT(IMPORT): informat PhoneContactAttemptsMade $2. ;
22919 informat DateLetterSent $2. ;
MPRINT(IMPORT): informat DateLetterSent $2. ;
22920 informat DateLetterReturned $2. ;
MPRINT(IMPORT): informat DateLetterReturned $2. ;
22921 informat ReccurenceOfUlcer $4. ;
MPRINT(IMPORT): informat ReccurenceOfUlcer $4. ;
22922 informat BeenToDoctorsOffice $5. ;
MPRINT(IMPORT): informat BeenToDoctorsOffice $5. ;
22923 informat SoughtTreatment $5. ;
MPRINT(IMPORT): informat SoughtTreatment $5. ;
22924 informat TypeOfTreatment $172. ;
MPRINT(IMPORT): informat TypeOfTreatment $172. ;
22925 informat DevelopedNewUlcers $18. ;
MPRINT(IMPORT): informat DevelopedNewUlcers $18. ;
22926 informat WoundStillPresent $15. ;
MPRINT(IMPORT): informat WoundStillPresent $15. ;
22927 informat SignedBy_ID $2. ;
MPRINT(IMPORT): informat SignedBy_ID $2. ;
22928 informat SignedBy_Name $2. ;
MPRINT(IMPORT): informat SignedBy_Name $2. ;
22929 informat Date_of_Signature $2. ;
MPRINT(IMPORT): informat Date_of_Signature $2. ;
22930 informat Date_of_Entry $24. ;
MPRINT(IMPORT): informat Date_of_Entry $24. ;
22931 format Case_EndofStudy_ID $5. ;
MPRINT(IMPORT): format Case_EndofStudy_ID $5. ;
22932 format Study_ID $8. ;
MPRINT(IMPORT): format Study_ID $8. ;
22933 format Case_ID $8. ;
MPRINT(IMPORT): format Case_ID $8. ;
22934 format Date_of_Evaluation $24. ;
MPRINT(IMPORT): format Date_of_Evaluation $24. ;
22935 format Followup_ID $4. ;
MPRINT(IMPORT): format Followup_ID $4. ;
22936 format Followup_Name $9. ;
MPRINT(IMPORT): format Followup_Name $9. ;
22937 format DidPatientCompleteStudy_ID $3. ;
MPRINT(IMPORT): format DidPatientCompleteStudy_ID $3. ;
22938 format DidPatientCompleteStudy_Value $5. ;
MPRINT(IMPORT): format DidPatientCompleteStudy_Value $5. ;
22939 format IsPatientHealed_ID $3. ;
MPRINT(IMPORT): format IsPatientHealed_ID $3. ;
22940 format IsPatientHealed_Value $5. ;
MPRINT(IMPORT): format IsPatientHealed_Value $5. ;
22941 format IsPatientReceiveArtacentTreatmen $2. ;
MPRINT(IMPORT): format IsPatientReceiveArtacentTreatmen $2. ;
22942 format VAR12 $2. ;
MPRINT(IMPORT): format VAR12 $2. ;
22943 format NotCompleteStudyReason_ID $3. ;
MPRINT(IMPORT): format NotCompleteStudyReason_ID $3. ;
22944 format NotCompleteStudyReason_Value $38. ;
MPRINT(IMPORT): format NotCompleteStudyReason_Value $38. ;
22945 format NotCompleteStudyOther $59. ;
MPRINT(IMPORT): format NotCompleteStudyOther $59. ;
22946 format NumberOfAttemptsToContact $2. ;
MPRINT(IMPORT): format NumberOfAttemptsToContact $2. ;
22947 format WithdrewConsentReason $2. ;
MPRINT(IMPORT): format WithdrewConsentReason $2. ;
22948 format DiscontinuedByInvestigatorReason $43. ;
MPRINT(IMPORT): format DiscontinuedByInvestigatorReason $43. ;
22949 format AdverseEvent_IsAmputation $3. ;
MPRINT(IMPORT): format AdverseEvent_IsAmputation $3. ;
22950 format AdverseEvent_IsAmputationReason $2. ;
MPRINT(IMPORT): format AdverseEvent_IsAmputationReason $2. ;
22951 format AdverseEvent_IsDeath $3. ;
MPRINT(IMPORT): format AdverseEvent_IsDeath $3. ;
22952 format AdverseEvent_IsDeathReason $2. ;
MPRINT(IMPORT): format AdverseEvent_IsDeathReason $2. ;
22953 format AdverseEvent_IsOther $3. ;
MPRINT(IMPORT): format AdverseEvent_IsOther $3. ;
22954 format AdverseEvent_IsOtherReason $2. ;
MPRINT(IMPORT): format AdverseEvent_IsOtherReason $2. ;
22955 format IsPatientContact24WeekSurvey_ID $3. ;
MPRINT(IMPORT): format IsPatientContact24WeekSurvey_ID $3. ;
22956 format IsPatientContact24WeekSurvey_Val $5. ;
MPRINT(IMPORT): format IsPatientContact24WeekSurvey_Val $5. ;
22957 format PhoneContactAttemptsMade $2. ;
MPRINT(IMPORT): format PhoneContactAttemptsMade $2. ;
22958 format DateLetterSent $2. ;
MPRINT(IMPORT): format DateLetterSent $2. ;
22959 format DateLetterReturned $2. ;
MPRINT(IMPORT): format DateLetterReturned $2. ;
22960 format ReccurenceOfUlcer $4. ;
MPRINT(IMPORT): format ReccurenceOfUlcer $4. ;
22961 format BeenToDoctorsOffice $5. ;
MPRINT(IMPORT): format BeenToDoctorsOffice $5. ;
22962 format SoughtTreatment $5. ;
MPRINT(IMPORT): format SoughtTreatment $5. ;
22963 format TypeOfTreatment $172. ;
MPRINT(IMPORT): format TypeOfTreatment $172. ;
22964 format DevelopedNewUlcers $18. ;
MPRINT(IMPORT): format DevelopedNewUlcers $18. ;
22965 format WoundStillPresent $15. ;
MPRINT(IMPORT): format WoundStillPresent $15. ;
22966 format SignedBy_ID $2. ;
MPRINT(IMPORT): format SignedBy_ID $2. ;
22967 format SignedBy_Name $2. ;
MPRINT(IMPORT): format SignedBy_Name $2. ;
22968 format Date_of_Signature $2. ;
MPRINT(IMPORT): format Date_of_Signature $2. ;
22969 format Date_of_Entry $24. ;
MPRINT(IMPORT): format Date_of_Entry $24. ;
22970 input
22971 Case_EndofStudy_ID $
22972 Study_ID $
22973 Case_ID $
22974 Date_of_Evaluation $
22975 Followup_ID $
22976 Followup_Name $
22977 DidPatientCompleteStudy_ID $
22978 DidPatientCompleteStudy_Value $
22979 IsPatientHealed_ID $
22980 IsPatientHealed_Value $
22981 IsPatientReceiveArtacentTreatmen $
22982 VAR12 $
22983 NotCompleteStudyReason_ID $
22984 NotCompleteStudyReason_Value $
22985 NotCompleteStudyOther $
22986 NumberOfAttemptsToContact $
22987 WithdrewConsentReason $
22988 DiscontinuedByInvestigatorReason $
22989 AdverseEvent_IsAmputation $
22990 AdverseEvent_IsAmputationReason $
22991 AdverseEvent_IsDeath $
22992 AdverseEvent_IsDeathReason $
22993 AdverseEvent_IsOther $
22994 AdverseEvent_IsOtherReason $
22995 IsPatientContact24WeekSurvey_ID $
22996 IsPatientContact24WeekSurvey_Val $
22997 PhoneContactAttemptsMade $
22998 DateLetterSent $
22999 DateLetterReturned $
23000 ReccurenceOfUlcer $
23001 BeenToDoctorsOffice $
23002 SoughtTreatment $
23003 TypeOfTreatment $
23004 DevelopedNewUlcers $
23005 WoundStillPresent $
23006 SignedBy_ID $
23007 SignedBy_Name $
23008 Date_of_Signature $
23009 Date_of_Entry $
23010 ;
MPRINT(IMPORT): input Case_EndofStudy_ID $ Study_ID $ Case_ID $ Date_of_Evaluation $ Followup_ID
$ Followup_Name $ DidPatientCompleteStudy_ID $ DidPatientCompleteStudy_Value $ IsPatientHealed_ID $
IsPatientHealed_Value $ IsPatientReceiveArtacentTreatmen $ VAR12 $ NotCompleteStudyReason_ID $
NotCompleteStudyReason_Value $ NotCompleteStudyOther $ NumberOfAttemptsToContact $
WithdrewConsentReason $ DiscontinuedByInvestigatorReason $ AdverseEvent_IsAmputation $
AdverseEvent_IsAmputationReason $ AdverseEvent_IsDeath $ AdverseEvent_IsDeathReason $
AdverseEvent_IsOther $ AdverseEvent_IsOtherReason $ IsPatientContact24WeekSurvey_ID $
IsPatientContact24WeekSurvey_Val $ PhoneContactAttemptsMade $ DateLetterSent $ DateLetterReturned $
ReccurenceOfUlcer $ BeenToDoctorsOffice $ SoughtTreatment $ TypeOfTreatment $ DevelopedNewUlcers $
WoundStillPresent $ SignedBy_ID $ SignedBy_Name $ Date_of_Signature $ Date_of_Entry $ ;
23011 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */
MPRINT(IMPORT): if _ERROR_ then call symputx('_EFIERR_',1);
23012 run;
MPRINT(IMPORT): run;
NOTE: The infile 'S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 11 - End of
Study-.csv' is:
Filename=S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 11 - End of
Study-.csv,
RECFM=V,LRECL=32767,File Size (bytes)=2570,
Last Modified=24May2017:17:22:32,
Create Time=24May2017:17:22:52
NOTE: 7 records were read from the infile 'S:\Data Management\Tides\Data Extracts\-Data Extract
(Tides) - 11 - End of Study-.csv'.
The minimum record length was 190.
The maximum record length was 386.
NOTE: The data set WORK.EOS has 7 observations and 39 variables.
NOTE: DATA statement used (Total process time):
real time 0.46 seconds
cpu time 0.06 seconds
7 rows created in WORK.EOS from S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 11 -
End of Study-.csv.
NOTE: WORK.EOS data set was successfully created.
NOTE: The data set WORK.EOS has 7 observations and 39 variables.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 1.49 seconds
cpu time 0.39 seconds
MPRINT(IMPORT): ;
MPRINT(REFRESHTIDES): ;
MPRINT(IMPORT): PROC IMPORT OUT= AE DATAFILE= "S:\Data Management\Tides\Data Extracts\-Data
Extract (Tides) - 12 - Adverse Events-.csv" DBMS=CSV REPLACE;
MPRINT(IMPORT): ADLM;
MPRINT(IMPORT): GETNAMES=YES;
MPRINT(IMPORT): DATAROW=2;
MPRINT(IMPORT): RUN;
Name Visit at which Event was reported truncated to Visit_at_which_Event_was_reporte.
Problems were detected with provided names. See LOG.
23013 /**********************************************************************
23014 * PRODUCT: SAS
23015 * VERSION: 9.4
23016 * CREATOR: External File Interface
23017 * DATE: 22MAY17
23018 * DESC: Generated SAS Datastep Code
23019 * TEMPLATE SOURCE: (None Specified.)
23020 ***********************************************************************/
23021 data WORK.AE ;
MPRINT(IMPORT): data WORK.AE ;
23022 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */
23023 infile 'S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 12 - Adverse
23023! Events-.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;
MPRINT(IMPORT): infile 'S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 12 -
Adverse Events-.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;
23024 informat Event_ID $7. ;
MPRINT(IMPORT): informat Event_ID $7. ;
23025 informat Study_ID $8. ;
MPRINT(IMPORT): informat Study_ID $8. ;
23026 informat Case_ID $2. ;
MPRINT(IMPORT): informat Case_ID $2. ;
23027 informat PatientEventNumber $3. ;
MPRINT(IMPORT): informat PatientEventNumber $3. ;
23028 informat Visit_Date $24. ;
MPRINT(IMPORT): informat Visit_Date $24. ;
23029 informat Followup_ID $4. ;
MPRINT(IMPORT): informat Followup_ID $4. ;
23030 informat Visit_at_which_Event_was_reporte $9. ;
MPRINT(IMPORT): informat Visit_at_which_Event_was_reporte $9. ;
23031 informat Onset_Date $24. ;
MPRINT(IMPORT): informat Onset_Date $24. ;
23032 informat IsOngoing_ID $3. ;
MPRINT(IMPORT): informat IsOngoing_ID $3. ;
23033 informat Ongoing_Value $5. ;
MPRINT(IMPORT): informat Ongoing_Value $5. ;
23034 informat Date_of_Resolution $24. ;
MPRINT(IMPORT): informat Date_of_Resolution $24. ;
23035 informat Severity_ID $3. ;
MPRINT(IMPORT): informat Severity_ID $3. ;
23036 informat Severity_Value $10. ;
MPRINT(IMPORT): informat Severity_Value $10. ;
23037 informat Relation2Treatment_ID $3. ;
MPRINT(IMPORT): informat Relation2Treatment_ID $3. ;
23038 informat Relation2Treatment_Value $13. ;
MPRINT(IMPORT): informat Relation2Treatment_Value $13. ;
23039 informat EventType_ID $5. ;
MPRINT(IMPORT): informat EventType_ID $5. ;
23040 informat EventType_Value $13. ;
MPRINT(IMPORT): informat EventType_Value $13. ;
23041 informat EventType_Other $25. ;
MPRINT(IMPORT): informat EventType_Other $25. ;
23042 informat Event_Description $117. ;
MPRINT(IMPORT): informat Event_Description $117. ;
23043 informat Action_ID $4. ;
MPRINT(IMPORT): informat Action_ID $4. ;
23044 informat Action_Value $18. ;
MPRINT(IMPORT): informat Action_Value $18. ;
23045 informat Action_Other $28. ;
MPRINT(IMPORT): informat Action_Other $28. ;
23046 informat Treatment_Description $154. ;
MPRINT(IMPORT): informat Treatment_Description $154. ;
23047 informat Date_of_Action $2. ;
MPRINT(IMPORT): informat Date_of_Action $2. ;
23048 informat IsSAEUADE_ID $3. ;
MPRINT(IMPORT): informat IsSAEUADE_ID $3. ;
23049 informat IsSAEUADE_Value $5. ;
MPRINT(IMPORT): informat IsSAEUADE_Value $5. ;
23050 informat Date_of_Entry $23. ;
MPRINT(IMPORT): informat Date_of_Entry $23. ;
23051 format Event_ID $7. ;
MPRINT(IMPORT): format Event_ID $7. ;
23052 format Study_ID $8. ;
MPRINT(IMPORT): format Study_ID $8. ;
23053 format Case_ID $2. ;
MPRINT(IMPORT): format Case_ID $2. ;
23054 format PatientEventNumber $3. ;
MPRINT(IMPORT): format PatientEventNumber $3. ;
23055 format Visit_Date $24. ;
MPRINT(IMPORT): format Visit_Date $24. ;
23056 format Followup_ID $4. ;
MPRINT(IMPORT): format Followup_ID $4. ;
23057 format Visit_at_which_Event_was_reporte $9. ;
MPRINT(IMPORT): format Visit_at_which_Event_was_reporte $9. ;
23058 format Onset_Date $24. ;
MPRINT(IMPORT): format Onset_Date $24. ;
23059 format IsOngoing_ID $3. ;
MPRINT(IMPORT): format IsOngoing_ID $3. ;
23060 format Ongoing_Value $5. ;
MPRINT(IMPORT): format Ongoing_Value $5. ;
23061 format Date_of_Resolution $24. ;
MPRINT(IMPORT): format Date_of_Resolution $24. ;
23062 format Severity_ID $3. ;
MPRINT(IMPORT): format Severity_ID $3. ;
23063 format Severity_Value $10. ;
MPRINT(IMPORT): format Severity_Value $10. ;
23064 format Relation2Treatment_ID $3. ;
MPRINT(IMPORT): format Relation2Treatment_ID $3. ;
23065 format Relation2Treatment_Value $13. ;
MPRINT(IMPORT): format Relation2Treatment_Value $13. ;
23066 format EventType_ID $5. ;
MPRINT(IMPORT): format EventType_ID $5. ;
23067 format EventType_Value $13. ;
MPRINT(IMPORT): format EventType_Value $13. ;
23068 format EventType_Other $25. ;
MPRINT(IMPORT): format EventType_Other $25. ;
23069 format Event_Description $117. ;
MPRINT(IMPORT): format Event_Description $117. ;
23070 format Action_ID $4. ;
MPRINT(IMPORT): format Action_ID $4. ;
23071 format Action_Value $18. ;
MPRINT(IMPORT): format Action_Value $18. ;
23072 format Action_Other $28. ;
MPRINT(IMPORT): format Action_Other $28. ;
23073 format Treatment_Description $154. ;
MPRINT(IMPORT): format Treatment_Description $154. ;
23074 format Date_of_Action $2. ;
MPRINT(IMPORT): format Date_of_Action $2. ;
23075 format IsSAEUADE_ID $3. ;
MPRINT(IMPORT): format IsSAEUADE_ID $3. ;
23076 format IsSAEUADE_Value $5. ;
MPRINT(IMPORT): format IsSAEUADE_Value $5. ;
23077 format Date_of_Entry $23. ;
MPRINT(IMPORT): format Date_of_Entry $23. ;
23078 input
23079 Event_ID $
23080 Study_ID $
23081 Case_ID $
23082 PatientEventNumber $
23083 Visit_Date $
23084 Followup_ID $
23085 Visit_at_which_Event_was_reporte $
23086 Onset_Date $
23087 IsOngoing_ID $
23088 Ongoing_Value $
23089 Date_of_Resolution $
23090 Severity_ID $
23091 Severity_Value $
23092 Relation2Treatment_ID $
23093 Relation2Treatment_Value $
23094 EventType_ID $
23095 EventType_Value $
23096 EventType_Other $
23097 Event_Description $
23098 Action_ID $
23099 Action_Value $
23100 Action_Other $
23101 Treatment_Description $
23102 Date_of_Action $
23103 IsSAEUADE_ID $
23104 IsSAEUADE_Value $
23105 Date_of_Entry $
23106 ;
MPRINT(IMPORT): input Event_ID $ Study_ID $ Case_ID $ PatientEventNumber $ Visit_Date $
Followup_ID $ Visit_at_which_Event_was_reporte $ Onset_Date $ IsOngoing_ID $ Ongoing_Value $
Date_of_Resolution $ Severity_ID $ Severity_Value $ Relation2Treatment_ID $
Relation2Treatment_Value $ EventType_ID $ EventType_Value $ EventType_Other $ Event_Description $
Action_ID $ Action_Value $ Action_Other $ Treatment_Description $ Date_of_Action $ IsSAEUADE_ID $
IsSAEUADE_Value $ Date_of_Entry $ ;
23107 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */
MPRINT(IMPORT): if _ERROR_ then call symputx('_EFIERR_',1);
23108 run;
MPRINT(IMPORT): run;
NOTE: The infile 'S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 12 - Adverse
Events-.csv' is:
Filename=S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 12 - Adverse
Events-.csv,
RECFM=V,LRECL=32767,File Size (bytes)=1620,
Last Modified=24May2017:17:22:36,
Create Time=24May2017:17:22:52
NOTE: 3 records were read from the infile 'S:\Data Management\Tides\Data Extracts\-Data Extract
(Tides) - 12 - Adverse Events-.csv'.
The minimum record length was 343.
The maximum record length was 482.
NOTE: The data set WORK.AE has 3 observations and 27 variables.
NOTE: DATA statement used (Total process time):
real time 0.40 seconds
cpu time 0.03 seconds
3 rows created in WORK.AE from S:\Data Management\Tides\Data Extracts\-Data Extract (Tides) - 12 -
Adverse Events-.csv.
NOTE: WORK.AE data set was successfully created.
NOTE: The data set WORK.AE has 3 observations and 27 variables.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 1.60 seconds
cpu time 0.40 seconds
MPRINT(IMPORT): ;
MPRINT(REFRESHTIDES): ;
... View more