My Input data looks like below, I am unable to automate the code. Please help me: Customer ID Total_Sales YEAR Sales_Date 1 794.68 2017 13Oct2017 2 6201.00 2016 07Apr2016 3 2000.00 2016 14Sep2016 4 2000.00 2016 14Oct2016 5 2000.00 2016 15Sep2016 6 1000.00 2018 30Mar2018 7 500.00 2019 01Apr2019 8 1500.00 2016 03Apr2016 9 750.00 2016 23Mar2016 10 500.00 2016 13Sep2016 11 500.00 2016 11Sep2016 12 2000.00 2016 16Sep2016 13 2021.00 2016 09Aug2016 14 500.00 2016 15Apr2016 15 882.00 2018 15Oct2018 16 750.00 2019 19Jul2019 17 750.00 2019 03Mar2019 18 499288.00 2016 24Aug2016 19 500.00 2016 18Apr2016 20 500.00 2016 17Oct2016 I am unable to automate the code : PROC SQL; CREATE TABLE WORK.'QUERY_FOR_SAMPLE DATA_0000'n AS SELECT /* COUNT_of_Customer ID */ (COUNT(t1.'Customer ID'n)) AS 'COUNT_of_Customer ID'n, /* SUM_of_Total_Sales */ (SUM(t1.Total_Sales)) FORMAT=F12.2 AS SUM_of_Total_Sales, t1.YEAR FROM WORK.'QUERY_FOR_SAMPLE DATA'n t1 WHERE t1.Sales_Date <= '1Jan2017'd AND t1.YEAR = 2016 GROUP BY t1.YEAR; QUIT;
... View more