As an analytics developer, you need to calculate weekly sales using SAS PROCEDURES. You are generating...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
As an analytics developer, you need to calculate weekly sales using SAS PROCEDURES. You are generating descriptive statistics for the store sales. It will help store manager to display popular items in the store entrance. Using the Train.csv file or any other file, complete the following: Step 1: Include PROC MEANS in your SAS script and calculate descriptive statistics that represents weekly sales for a certain department in a given store in a given week. Step 2: Use title and footnotes to output. Step 3: Use the label for each output column. Zip and submit your SAS scripts as well as output screenshots. OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 68 69 DATA Train; 70 71 INFILE '/home/u63041500/CSV Files/train.csv DSD DELIMITER="!: 72 73 LABEL storeID="Store ID" deptID="Department ID" date="Date" weekly_sales="Weekly Sales" isHoliday="Is Holiday"; 74 75 FORMAT date yymmdd10.; 76 77 INFORMAT date yymmdd10.; 78 1 79 80 DATE=date; As an analytics developer, you need to calculate weekly sales using SAS PROCEDURES. You are generating descriptive statistics for the store sales. It will help store manager to display popular items in the store entrance. Using the Train.csv file or any other file, complete the following: Step 1: Include PROC MEANS in your SAS script and calculate descriptive statistics that represents weekly sales for a certain department in a given store in a given week. Step 2: Use title and footnotes to output. Step 3: Use the label for each output column. Zip and submit your SAS scripts as well as output screenshots. OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 68 69 DATA Train; 70 71 INFILE '/home/u63041500/CSV Files/train.csv DSD DELIMITER="!: 72 73 LABEL storeID="Store ID" deptID="Department ID" date="Date" weekly_sales="Weekly Sales" isHoliday="Is Holiday"; 74 75 FORMAT date yymmdd10.; 76 77 INFORMAT date yymmdd10.; 78 1 79 80 DATE=date;
Expert Answer:
Answer rating: 100% (QA)
Code DATA Train INFILE Traincsv DSD DELIMITER LABEL storeIDStore ID de... View the full answer
Related Book For
Intermediate Accounting
ISBN: 978-1260481952
10th edition
Authors: J. David Spiceland, James Sepe, Mark Nelson, Wayne Thomas
Posted Date:
Students also viewed these programming questions
-
Vehicles arrive at a single toll booth beginning at 8:00 A.M. They arrive and depart according to a uniform deterministic distribution. However, the toll booth does not open until 8:10 A.M. The...
-
In Florida, real estate agents refer to homes having a swimming pool as pool homes. In this case, Sunshine Pools Inc. markets and installs pools throughout the state of Florida. The company wishes to...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
What are the two(2) products dimensions that could be used if a position Map/Perception Map were to be created for VIA instant coffee?
-
An incident x-ray photon is scattered from a free electron that is initially at rest. The photon is scattered straight back at an angle of 1800 from its initial direction. The wavelength of the...
-
Michael wants a program that calculates and displays the percentage of the total points he contributed to his basketball teams final score. Michael will provide the number of twopoint baskets, the...
-
Randomly permute each row of the matrix below using R. \[\left[\begin{array}{llll}1 & 1 & 1 & 1 \\2 & 2 & 2 & 2 \\3 & 3 & 3 & 3 \\4 & 4 & 4 & 4\end{array} ight]\] You can construct the matrix below...
-
Bonds A and B are two straight yen-denominated international bonds, with the same maturity of four years and the same YTM of 9 percent. Bond A has an annual coupon of 11 percent and is accordingly...
-
The Alberta Plumbing Company (APC) operates a plumbing repair business, with branches located throughout the province of Alberta. They saw improved performance in the volume of repairs in the month...
-
Ye Olde Creamery, a popular ice cream store on campus, has one line for its tasty treats. Students arrive at the Creamery about one every minute. Because of the new automated Wave N Pay payment...
-
Yoshi Company completed the following transactions and events involving its delivery trucks. Year 1 1 Paid $23,515 cash plus $1,785 in sales tax for a new delivery truck estimated to have a five-year...
-
Write a program called 'palindromeprime.java' that finding all palindromic primes between two integers supplied as input (start and end points are excluded). A palindrome number is a number that...
-
What does each of these three groups (elected and appointed officials, managers and supervisors, and HR directors and specialists) contribute to public personnel management?
-
Today is April 22, 2021. The bond prices for "bond #4" and "bond #5" are given in the table below. Both bonds have a face value of $100 #4 Coupon: 2% Maturity: Oct 22, 2021 Price: 100 #5 Coupon: 3%...
-
5. Convert 111012 to decimal. Assume it is unsigned. 6. Solve for x in 2x 001000002 7. Convert 010110012 to decimal. Assume unsigned again.
-
What strategy can be used to help students in Science or Social Studies? List two strategies and provide examples.
-
An investor has initial wealth wo that she must divide between two risky assets. Denote the total investment into asset i by w; for i E {1, 2}. There are two possible states H and L for the economy....
-
A woman at a point A on the shore of a circular lake with radius 2 mi wants to arrive at the point C diametrically opposite on the other side of the lake in the shortest possible A time. She can walk...
-
El Gato Painting Company maintains a checking account at American Bank. Bank statements are prepared at the end of each month. The November 30, 2021, reconciliation of the bank balance is as follows:...
-
Suppose the Environmental Protection Agency is in the process of investigating Ozone Ruination Limited for possible environmental damage but has not proposed a penalty as of December 31, 2020, the...
-
Arlington Steel Company is a producer of raw steel and steel-related products. On January 3, 2022, Arlington enters into a firm commitment to purchase 10,000 tons of iron ore pellets from a supplier...
-
The result from problem 5.21 shows that the reservoir temperature for a Mach 20 helium tunnel can be very reasonable. This is why several very high Mach number helium hypersonic wind tunnels exist....
-
Write the \(z\) component of Eq. (6.7), and use it to derive Eq. (6.13). Equation 6.13: \(\frac{\partial(ho w)}{\partial t}+abla \cdot(ho w \mathbf{V})=-\frac{\partial p}{\partial z}+ho f_z\) pf d V...
-
Prepare a balanced scorecard for HSBC Bank (http://www.hsbc.com).
Study smarter with the SolutionInn App