Hi all,
I have a macro that imports a bunch of csv. It works great until I add a library:
PROC IMPORT OUT= &name DATAFILE= "\\path\&file.csv" DBMS=CSV REPLACE; GETNAMES=YES; DATAROW=2;
But when I add a library, it does not work. How do I get &name to resolve in the following?
PROC IMPORT OUT= TD5.&name DATAFILE= "\\path\&file" DBMS=CSV REPLACE; GETNAMES=YES; DATAROW=2;
In your first code block:
PROC IMPORT OUT= &name DATAFILE= "\\path\&file.csv" DBMS=CSV REPLACE; GETNAMES=YES; DATAROW=2;
The datafile statement is wrong. If file=ABC, then you get \\path\ABCcsv, which is an invalid file. Macro variables end with a dot, so &file..csv should be it.
In this one:
PROC IMPORT OUT= TD5.&name DATAFILE= "\\path\&file" DBMS=CSV REPLACE; GETNAMES=YES; DATAROW=2;
You don't mention the .csv at all. If you want further help, please post exact code including the file assignment, and what the log looks like.
It is working fine, what error you're getting ?
%let name =chk;
libname TD5 "L:\user\desktop";
PROC IMPORT OUT= &name
DATAFILE= "L:\user\desktop\book1.csv"
DBMS=CSV REPLACE;
GETNAMES=YES;
DATAROW=2;
run;
PROC IMPORT OUT= TD5.&name
DATAFILE= "L:\user\desktop\book1.csv"
DBMS=CSV REPLACE;
GETNAMES=YES;
DATAROW=2;
run;
How do you create the macro variable name?
Also post the log that you get when the step fails. Use the {i} button for posting, so that the text formatting of the log is preserved.
So it turns out that my macro IS working however I do get the following error:
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.
@kryden wrote:
So it turns out that my macro IS working however I do get the following error:
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.
Which again brings up the question How are you building the macro variable name?
Run your code with
Options mprint;
Proc import <etc>
run;
and post the log with the code and error into a codebox to preserve the formatting of the error messages in relation to the code.
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): ;
Well here is my problem:
import(work.name,file);
For some reason I had "work.name" instead of just "name".
Thats not in the code you posted? Are we talking about totally different things here?
Mmm, well to start with your macro invocation is incorrect You can't have brackets like that as this part:
%import(demo,-Data Extract (Tides)
Means demo is the first paramter and -Data Extract (Tides) is the second paramter ) closes the call.
Also, you only need to post the log of one of the macro invocations (not the 60 pages!). And put:
options mlogic symbolgen mprint;
Before you run the code so you can see what is being generated - though I suspect it is the call as above.
As always, it is advised to not have - spaces, special characters, or other nonsense in filenames as filenames are not the place for this type of data.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.