could someone please guid me.I have three datasets called - ' period1 data ' ,
'period 2A data ' and ' period2B Data ' I want to produce a comprehensive breakdown of revenues generated over the four week period , where period 1 data is for 2 weeks and period 2 data is divided into one week each.
The sample data is :
Period 1 Period 2A Period 2B
Transaction ID Transaction number 1 – 8 1 – 8 1 – 8
Date of Sale Date of the transaction 9 – 18 9 – 18
Time of Sale Time of the transaction 19 – 26 9 – 16
Laptop Model AP3965 or AT3600 27 – 32 19 – 24
Units Sold Number of laptops sold 33 – 35 25 – 27
Warranty 0 = NO, 1 = YES. 36 28
Its given that during both periods the sale price of the AT3600 laptop was
$ 1,199.99 and during Period 1 the sale price of the AP3965 laptop was $ 699.99. During Period 2 this laptop was available on special offer at $ 499.99.
I need to produce a breakdown of revenues generated over the four week period.
Could you please suggest me a code for the same .
The data analysis code you are looking to compose in your SAS program is based on what you term "comprehensive breakdown of revenues", also depending on the data you have available.
There are SAS PROCs, such as PROCs TABULATE, MEANS, SUMMARY, UNIVARIATE, each having particular data-analysis and/or built-in reporting capabilities. These functions can make use of "formattted" variable values, giving you the opportunity to use a SAS FORMAT to take a SAS DATE (numeric) variable and use the month/year formatted portion for analysis and output display.
Also, suggest you look at your available SAS "date" related variables and consider using a DATA step with SAS functions to derive a "month-start-date" or by week, as suits your analysis requirements.
Consider the wealth of SAS-hosted documentation and supplemental technical / conference reference materials and papers you have at your "free use" disposal on the SAS support http://support.sas.com/ website, either using Google search or the website's SEARCH facility.
Google advanced search argument, this topic/post:
data analysis revenue breakdown by month site:sas.com