I just put all my data together in the same folder. Just run below and still got no observations in final output. %do year = 2015 %to 2017;
%do;
libname read_in "D:\data\&type";
%if &type=Int %then %let file=&type._s_;
%else;
%if &type=Out %then %let file=&type._s_prime_;
%end; Log says: NOTE: The file WORK.ALL_OUT_OTHER (memtype=DATA) was not found, but appears on a DELETE statement. NOTE: Libref READ_IN was successfully assigned as follows: Engine: V9 Physical Name: D:\\Out NOTE: PROCEDURE DATASETS used (Total process time): real time 1.44 seconds cpu time 0.34 seconds NOTE: There were 67986 observations read from the data set READ_IN.OUT_2015. WHERE (patient_state='NY') and ('2015'<=SUBSTR(LEFT(patient_birth_date), 1, 4)) and patient_county_code in (2, 4, 6, 14, 18, 26, 29, 33, 34, 37, 39, 55, 56, 58) and (SUBSTR(LEFT(patient_birth_date), 1, 4)<='2017'); NOTE: The data set WORK.TEMP has 0 observations and 11 variables. NOTE: DATA statement used (Total process time): real time 1:57.57 cpu time 34.01 seconds NOTE: Appending WORK.TEMP to WORK.ALL_OUT_OTHER. NOTE: BASE data set does not exist. DATA file is being copied to BASE file. NOTE: There were 0 observations read from the data set WORK.TEMP. NOTE: The data set WORK.ALL_OUT_OTHER has 0 observations and 11 variables. NOTE: PROCEDURE APPEND used (Total process time): real time 0.06 seconds cpu time 0.01 seconds NOTE: Libref READ_IN was successfully assigned as follows: Engine: V9 Physical Name: D:\..\Out WARNING: Apparent symbolic reference CONDITION not resolved. NOTE: There were 184448 observations read from the data set READ_IN.OUT_2016. WHERE (patient_state='NY') and ('2015'<=SUBSTR(LEFT(patient_birth_date), 1, 4)) and patient_county_code in (2, 4, 6, 14, 18, 26, 29, 33, 34, 37, 39, 55, 56, 58) and (SUBSTR(LEFT(patient_birth_date), 1, 4)<='2017'); NOTE: The data set WORK.TEMP has 0 observations and 11 variables. NOTE: DATA statement used (Total process time): real time 2:33.67 cpu time 46.76 seconds NOTE: Appending WORK.TEMP to WORK.ALL_OUT_OTHER. NOTE: There were 0 observations read from the data set WORK.TEMP. NOTE: 0 observations added. NOTE: The data set WORK.ALL_OUT_OTHER has 0 observations and 11 variables. NOTE: PROCEDURE APPEND used (Total process time): real time 0.04 seconds cpu time 0.01 seconds NOTE: Libref READ_IN was successfully assigned as follows: Engine: V9 Physical Name: D:\sparcsdoh\task3\task3data\SPARCSdeidentified\Outpatient WARNING: Apparent symbolic reference CONDITION not resolved. NOTE: There were 64071 observations read from the data set READ_IN.OUT_S_PRIME_2017. WHERE (patient_state='NY') and ('2015'<=SUBSTR(LEFT(patient_birth_date), 1, 4)) and patient_county_code in (2, 4, 6, 14, 18, 26, 29, 33, 34, 37, 39, 55, 56, 58) and (SUBSTR(LEFT(patient_birth_date), 1, 4)<='2017'); NOTE: The data set WORK.TEMP has 0 observations and 11 variables. NOTE: DATA statement used (Total process time): real time 39.43 seconds cpu time 9.90 seconds NOTE: Appending WORK.TEMP to WORK.ALL_OUT_OTHER. NOTE: There were 0 observations read from the data set WORK.TEMP. NOTE: 0 observations added. NOTE: The data set WORK.ALL_OUT_OTHER has 0 observations and 11 variables. NOTE: PROCEDURE APPEND used (Total process time): real time 0.01 seconds cpu time 0.01 seconds Any idea? Thanks
... View more