I have a sas data set (see excel sheet attached) where I need to answer the following 3 questions below.... since there is no month variable in the data I am not able to do a proc means to get highest profit .... any pointers would be appreciated.... thanks.... see attached data set... Q1) Of the 48 months in the data, which month has the highest total profit? Which month has the highest profit rate? Show your results in a table, and allow two decimals for numbers and percentages. ; Q2): Of the 12 months of a year, which month has the highest profit and which month has the highest profit rate? Are these two months the same? If not, try to use data to explain why. Similarly, clearly document your tables and format properly. ; Q3): which product has the highest profit rate in each year? You may need to use the variable sub_category. Create a table that shows the product and its profit rate and the year. Format profit rate to as a percentage with 2 decimal places, e.g., 12.34%;
... View more