SAS Procedures

Help using Base SAS procedures
BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hello ,

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 .

Kind Regards ,

mark
1 REPLY 1
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
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.

Scott Barry
SBBWorks, Inc.

Google advanced search argument, this topic/post:
data analysis revenue breakdown by month site:sas.com

sas-innovate-white.png

Join us for our biggest event of the year!

Four days of inspiring keynotes, product reveals, hands-on learning opportunities, deep-dive demos, and peer-led breakouts. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 713 views
  • 0 likes
  • 2 in conversation