So this is the query builder I would like to "automate" by it adding every month between the start and end date set by user to Left join certain columns to the beginning month and copying over certain columns from the various tables. PROC SQL; CREATE TABLE WORK.Joined_QUANTITY AS SELECT t1.company, t1.product, t1.Unit_201702, t1.Quantity_201702, t2.Quantity_201703, t3.Quantity_201704 FROM QUANTITY_201702 t1 LEFT JOIN TRADEED.QUANTITY_201703 t2 ON (t1.company= t2.company) AND (t1.product, = t2.product,) AND (t1.Unit_201702 = t2.Unit_201703) LEFT JOIN TRADEED.QUANTITY_201704 t3 ON (t1.company =t3.company) AND (t1.product = t3.product) AND (t1.Unit_201702 = t3.Unit_201704); QUIT; Basically I want to create a time series in which every months values are added, based on the join of company, then product then units (litres, kilograms, ounces etc). So the table will look something like this: Company, Product, Unit(of the beginning month), Value (beginning month), Unit (of 2nd month), value (of 2nd month), Unit (of 3rd month), value (of 3rd month). But all I want the user to do is select the start date and end date. Then want SAS to automatically add the value and units of each month to a table by company, product, unit. Doable? Sure. Can I code it? Absolutely not. lol!
... View more