BookmarkSubscribeRSS Feed
kryden
Calcite | Level 5

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; 
10 REPLIES 10
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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.

atul_desh
Quartz | Level 8

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;

Kurt_Bremser
Super User

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.

kryden
Calcite | Level 5
Sorry for being unclear. The .csv is part of the file variable.

This works fine.

I run into trouble when I change

"Out = &name"

To

"Out = td5.&name"

Td5 is an established library. &name will not resolve.

I'll post the log once I get back to my computer.


kryden
Calcite | Level 5

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.
ballardw
Super User

@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.

kryden
Calcite | Level 5
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):   ;













kryden
Calcite | Level 5

Well here is my problem:

 

import(work.name,file);

For some reason I had "work.name" instead of just "name".

 

 

RW9
Diamond | Level 26 RW9
Diamond | Level 26

Thats not in the code you posted?  Are we talking about totally different things here?

RW9
Diamond | Level 26 RW9
Diamond | Level 26

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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 10 replies
  • 2286 views
  • 0 likes
  • 5 in conversation