Hi Dears, I am trying to run the below codes and they do not show any result. Could you try it and let me know if it works for you? Load the Data: proc import datafile='/path/to/customers.csv' out=customers dbms=csv replace; getnames=yes; run: Summary Statistics: proc means data=customers n means std min max; var Total Revenue Unit Cost Discount; run; Frequency Distribution: proc freq data=customers; tables Customer_Group OrderTypeLabel CustomerCountryLabel; run; Visualizations: proc sgplot data=customers; histogram Total_Revenue; run; proc sgplot data=customers; vbar Customer_Group / response=Total_Revenue stat=mean; run; Step 4: Predictive Statistics Correlation Analysis: proc corr data=customers; var Total_Revenue Customer_BirthDate Unit_Cost Discount; run; Regression Analysis: proc reg data=customers; model Total_Revenue = Customer_BirthDate Unit_Cost Discount; run; ANOVA for Sales Channels: proc anova data=customers; class OrderTypeLabel; model Total_Revenue = OrderTypeLabel; run; Thanks and regards, ... View more

I don't think this is the only way to predict and analyze your future sales. There are so many details in our dais regarding each company that even a tiny point and change could tour the situation upside down. Sometimes in a reasonable and sometimes in a wrong way. I like to work with https://belkins.io/. They provide me with all the information I need to know and apply a different strategy each time. I also tried other platforms, but they haven't been as accurate as this one. You can have months when your sales might go down, but after every 3 months, you should see improvements each time if you do a month. ... View more

In my use of the word "predictive", no time variable is needed (although certainly you can do predictive modeling if you do have a time variable). If you are baking chocolate chip cookies, you have temperature, you have amount of shortening, and the response is some measure of taste, you can statistically determine a relationship using temperature and amount of shortening to predict the taste.   Your sales example seems to be weak for the reasons I mentioned. It's not a statistical relationship been sales and price per unit and quantity, it's a deterministic relationship.     ... View more

Hi Dears, I am trying to run the below codes and they do not show any result. Could you try it and let me know if it works for you? Load the Data: proc import datafile='/path/to/customers.csv' out=customers dbms=csv replace; getnames=yes; run: Summary Statistics: proc means data=customers n means std min max; var Total Revenue Unit Cost Discount; run; Frequency Distribution: proc freq data=customers; tables Customer_Group OrderTypeLabel CustomerCountryLabel; run; Visualizations: proc sgplot data=customers; histogram Total_Revenue; run; proc sgplot data=customers; vbar Customer_Group / response=Total_Revenue stat=mean; run; Step 4: Predictive Statistics Correlation Analysis: proc corr data=customers; var Total_Revenue Customer_BirthDate Unit_Cost Discount; run; Regression Analysis: proc reg data=customers; model Total_Revenue = Customer_BirthDate Unit_Cost Discount; run; ANOVA for Sales Channels: proc anova data=customers; class OrderTypeLabel; model Total_Revenue = OrderTypeLabel; run; Thanks and regards, ... View more