DATA Step, Macro, Functions and more

Problem with macro variable resolution in dataset name

Reply
Occasional Contributor
Posts: 5

Problem with macro variable resolution in dataset name

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; 
Super User
Super User
Posts: 7,955

Re: Problem with macro variable resolution in dataset name

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.

Contributor
Posts: 65

Re: Problem with macro variable resolution in dataset name

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;

Super User
Posts: 7,782

Re: Problem with macro variable resolution in dataset name

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 5

Re: Problem with macro variable resolution in dataset name

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.


Occasional Contributor
Posts: 5

Re: Problem with macro variable resolution in dataset name

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.
Super User
Posts: 11,343

Re: Problem with macro variable resolution in dataset name


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.

Occasional Contributor
Posts: 5

Re: Problem with macro variable resolution in dataset name

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):   ;













Occasional Contributor
Posts: 5

Re: Problem with macro variable resolution in dataset name

Well here is my problem:

 

import(work.name,file);

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

 

 

Super User
Super User
Posts: 7,955

Re: Problem with macro variable resolution in dataset name

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

Super User
Super User
Posts: 7,955

Re: Problem with macro variable resolution in dataset name

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.

Ask a Question
Discussion stats
  • 10 replies
  • 170 views
  • 0 likes
  • 5 in conversation