Dear manojinpec, based on your program, i noted an error message as bold below: but the output is still produced. you have any clue? thanks meiy log: libname CRSP 'path'; 115 proc sql noprint; 116 117 select memname into : names separated by ' ' 118 119 from dictionary.tables 120 121 where upcase(memname) like "DAILYRTN_20%" and libname=CRSP; ERROR: The following columns were not found in the contributing tables: CRSP. 122 123 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.05 seconds cpu time 0.01 seconds 124 125 %put &names; CRSP.DAILYRTN_2002_01 CRSP.DAILYRTN_2002_02 CRSP.DAILYRTN_2002_03 CRSP.DAILYRTN_2002_04_06 CRSP.DAILYRTN_2002_07 CRSP.DAILYRTN_2002_08_09 CRSP.DAILYRTN_2002_10_12 CRSP.DAILYRTN_2003_01 CRSP.DAILYRTN_2003_02 CRSP.DAILYRTN_2003_03 CRSP.DAILYRTN_2003_04 CRSP.DAILYRTN_2003_05 CRSP.DAILYRTN_2003_06 CRSP.DAILYRTN_2003_07_09 CRSP.DAILYRTN_2003_10_12 CRSP.DAILYRTN_2004_01_03 CRSP.DAILYRTN_2004_04_06 CRSP.DAILYRTN_2004_07_09 CRSP.DAILYRTN_2004_10_12 CRSP.DAILYRTN_2005_01_03 CRSP.DAILYRTN_2005_04_06 CRSP.DAILYRTN_2005_07_09 CRSP.DAILYRTN_2005_10_12 CRSP.DAILYRTN_2006_01_03 CRSP.DAILYRTN_2006_04_06 CRSP.DAILYRTN_2006_07_09 CRSP.DAILYRTN_2006_10_12 CRSP.DAILYRTN_2007_01_03 CRSP.DAILYRTN_2007_04_06 CRSP.DAILYRTN_2007_07_09 CRSP.DAILYRTN_2007_10_12 CRSP.DAILYRTN_2008_01_03 CRSP.DAILYRTN_2008_04_06 CRSP.DAILYRTN_2008_07_09 CRSP.DAILYRTN_2008_10 CRSP.DAILYRTN_2008_11_12 CRSP.DAILYRTN_2009_01_03 CRSP.DAILYRTN_2009_04_06 CRSP.DAILYRTN_2009_07_09 CRSP.DAILYRTN_2009_10_12 CRSP.DAILYRTN_2010_01_03 CRSP.DAILYRTN_2010_04_06 CRSP.DAILYRTN_2010_07_09 CRSP.DAILYRTN_2010_10_12 CRSP.DAILYRTN_2011_01_03 CRSP.DAILYRTN_2011_04_06 CRSP.DAILYRTN_2011_07_09 CRSP.DAILYRTN_2011_10_12 126 127 128 129 130 131 data want2; 132 133 set &names; NOTE: Data file CRSP.DAILYRTN_2002_02.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: Data file CRSP.DAILYRTN_2002_03.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: Data file CRSP.DAILYRTN_2002_04_06.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: Data file CRSP.DAILYRTN_2002_07.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: Data file CRSP.DAILYRTN_2002_08_09.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: Data file CRSP.DAILYRTN_2002_10_12.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. 134 135 run; WARNING: Multiple lengths were specified for the variable DATE by input data set(s). This may cause truncation of data. WARNING: Multiple lengths were specified for the variable NEXTDT by input data set(s). This may cause truncation of data. WARNING: Multiple lengths were specified for the variable DLPDT by input data set(s). This may cause truncation of data. WARNING: Multiple lengths were specified for the variable RCRDDT by input data set(s). This may cause truncation of data. WARNING: Multiple lengths were specified for the variable PAYDT by input data set(s). This may cause truncation of data. WARNING: Multiple lengths were specified for the variable VWRETD by input data set(s). This may cause truncation of data. WARNING: Multiple lengths were specified for the variable VWRETX by input data set(s). This may cause truncation of data. WARNING: Multiple lengths were specified for the variable EWRETD by input data set(s). This may cause truncation of data. WARNING: Multiple lengths were specified for the variable EWRETX by input data set(s). This may cause truncation of data. WARNING: Multiple lengths were specified for the variable SPRTRN by input data set(s). This may cause truncation of data. NOTE: There were 159035 observations read from the data set CRSP.DAILYRTN_2002_01. NOTE: There were 143067 observations read from the data set CRSP.DAILYRTN_2002_02. NOTE: There were 149804 observations read from the data set CRSP.DAILYRTN_2002_03. NOTE: There were 474570 observations read from the data set CRSP.DAILYRTN_2002_04_06. NOTE: There were 161829 observations read from the data set CRSP.DAILYRTN_2002_07. NOTE: There were 306133 observations read from the data set CRSP.DAILYRTN_2002_08_09. NOTE: There were 462178 observations read from the data set CRSP.DAILYRTN_2002_10_12. NOTE: There were 150397 observations read from the data set CRSP.DAILYRTN_2003_01. NOTE: There were 135381 observations read from the data set CRSP.DAILYRTN_2003_02. NOTE: There were 148643 observations read from the data set CRSP.DAILYRTN_2003_03. NOTE: There were 147568 observations read from the data set CRSP.DAILYRTN_2003_04. NOTE: There were 146879 observations read from the data set CRSP.DAILYRTN_2003_05. NOTE: There were 146244 observations read from the data set CRSP.DAILYRTN_2003_06. NOTE: There were 441909 observations read from the data set CRSP.DAILYRTN_2003_07_09. NOTE: There were 439730 observations read from the data set CRSP.DAILYRTN_2003_10_12. NOTE: There were 425097 observations read from the data set CRSP.DAILYRTN_2004_01_03. NOTE: There were 424541 observations read from the data set CRSP.DAILYRTN_2004_04_06. NOTE: There were 437966 observations read from the data set CRSP.DAILYRTN_2004_07_09. NOTE: There were 438980 observations read from the data set CRSP.DAILYRTN_2004_10_12. NOTE: There were 418163 observations read from the data set CRSP.DAILYRTN_2005_01_03. NOTE: There were 438524 observations read from the data set CRSP.DAILYRTN_2005_04_06. NOTE: There were 439167 observations read from the data set CRSP.DAILYRTN_2005_07_09. NOTE: There were 431892 observations read from the data set CRSP.DAILYRTN_2005_10_12. NOTE: There were 423364 observations read from the data set CRSP.DAILYRTN_2006_01_03. NOTE: There were 430474 observations read from the data set CRSP.DAILYRTN_2006_04_06. NOTE: There were 433051 observations read from the data set CRSP.DAILYRTN_2006_07_09. NOTE: There were 435870 observations read from the data set CRSP.DAILYRTN_2006_10_12. NOTE: There were 424165 observations read from the data set CRSP.DAILYRTN_2007_01_03. NOTE: There were 441145 observations read from the data set CRSP.DAILYRTN_2007_04_06. NOTE: There were 442105 observations read from the data set CRSP.DAILYRTN_2007_07_09. NOTE: There were 450231 observations read from the data set CRSP.DAILYRTN_2007_10_12. NOTE: There were 429142 observations read from the data set CRSP.DAILYRTN_2008_01_03. NOTE: There were 447544 observations read from the data set CRSP.DAILYRTN_2008_04_06. NOTE: There were 445165 observations read from the data set CRSP.DAILYRTN_2008_07_09. NOTE: There were 158441 observations read from the data set CRSP.DAILYRTN_2008_10. NOTE: There were 281067 observations read from the data set CRSP.DAILYRTN_2008_11_12. NOTE: There were 412231 observations read from the data set CRSP.DAILYRTN_2009_01_03. NOTE: There were 419137 observations read from the data set CRSP.DAILYRTN_2009_04_06. NOTE: There were 421586 observations read from the data set CRSP.DAILYRTN_2009_07_09. NOTE: There were 421584 observations read from the data set CRSP.DAILYRTN_2009_10_12. NOTE: There were 401639 observations read from the data set CRSP.DAILYRTN_2010_01_03. NOTE: There were 415637 observations read from the data set CRSP.DAILYRTN_2010_04_06. NOTE: There were 422590 observations read from the data set CRSP.DAILYRTN_2010_07_09. NOTE: There were 422837 observations read from the data set CRSP.DAILYRTN_2010_10_12. NOTE: There were 411505 observations read from the data set CRSP.DAILYRTN_2011_01_03. NOTE: There were 420917 observations read from the data set CRSP.DAILYRTN_2011_04_06. NOTE: There were 429510 observations read from the data set CRSP.DAILYRTN_2011_07_09. NOTE: There were 423344 observations read from the data set CRSP.DAILYRTN_2011_10_12. NOTE: The data set WORK.WANT2 has 17331978 observations and 58 variables. NOTE: DATA statement used (Total process time): real time 4:36.54 cpu time 43.47 seconds
... View more
