I feel like this should be easy but I'm really struggling.    I have two tables, each has two columns: Table 1: Start date, Stop date Table 2: Count of surgeries, Day   I want to create a third (final) table that has Three columns; start date, stop date, sum of surgeries between those dates.   (Below tables have small date ranges for the sack of example but these would be much larger in practice) Table 1 (I have): Start Stop 7/3/2018 7/5/2018 7/5/2018 7/10/2018   Table 2 (I have): Day Count_of_Surgeries 7/3/2018 21 7/4/2018 3 7/5/2018 12 7/6/2018 25 7/7/2018 31 7/8/2018 5 7/9/2018 1 7/10/2018 10   Table 3 (I want): Start Stop Sum_surgeries 7/3/2018 7/5/2018 36 7/5/2018 7/10/2018 72   Dates setup to include mid-night to mid-night so in actuality the "stop" date count is not actually included in the sum. ... View more

I have a set of data that I transposed so that now all instances of results are in columns result_1, result_2, etc.  Now I need to do additional steps which include PROC SQL and I'm looking for a way to say *add all columns that start with result_*  The goal is to automate this program but I won't know how many instances of "result_" their will be for any given time period, as far as I'm aware their is no maximum. PROC SQL; CREATE TABLE test AS SELECT      T1.NAME,      T1.DATE,      T2.(ALL COLUMNS THAT START WITH RESULT) FROM      LIST1 AS T1      INNER JOIN LIST2 AS T2           ON T1.UID = T2.UID; QUIT; ... View more