Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This question requires you to use STOCKS Dataset under SASHELP library. You are required to paste the SAS code in the textbox below along with

This question requires you to use STOCKS Dataset under SASHELP library. You are required to paste the SAS code in the textbox below along with answering any questions asked. Make a SAS program to do the following:

  • Generate a temporary dataset named "Stocks" that uses SASHELP.STOCKS to get the data
  • Bring only the following variables from the SASHELP.STOCKS dataset
    • Stock
    • Date
    • High
    • Low
    • Volume
  • Filter the data to include only the observations for the month of March, June, September and December.
  • The data should also be filtered for the observations that are less than 25 years old from today.
  • Generate a new column, "Day" that contains the specific weekday extracted from the Date. This column should contain the character equivalent weekday of the date, e.g., Monday, Tuesday etc. (Hint: Use proc format for creating weekday format)
  • Format Date column as Thu, Dec 1, 2005.
  • Write Proc Tabulate to generate the output shown below (make sure to keep in to account the labels):
image text in transcribed
Volume High Low Sum Mean Mean Stock Day IBM Monday $137,318,360.00 $113.54 $100.37 Tuesday $83,717,372.00 $115.25 $99.53 Wednesday $39,726,862.00 $108.68 $95.42 Thursday $30,335,217.00 $100.69 $87.91 Friday $29,683, 160.00 $116.89 $99.98 Weekly Total / Avg. $320,780,971.00 $112.25 $98.08 Intel Day Monday $1084740300.00 $72.72 $62.15 Tuesday $607,085,708.00 $60.28 $50.60 Wednesday $345, 127,852.00 $65.73 $53.83 Thursday $214,960,353.00 $56.89 $49.34 Friday $234,001,284.00 $45.09 $31.58 Weekly Total / Avg. $2485915497.00 $64.00 $53.46 Microsoft Day Monday $1016092706.00 $89.38 $68.44 Tuesday $690,939,414.00 $82.25 $70.88 Wednesday $402,829,704.00 $69.01 $57.81 Thursday $289,230,586.00 $49.70 $41.20 Friday $312, 167, 100.00 $68.46 $55.82 Weekly Total / Avg. $2711259510.00 $78.20 $63.34

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Bond S Franchise Guide

Authors: Robert E. Bond ,Robert Bond

14th Edition

1887137300, 978-1887137300

More Books

Students also viewed these General Management questions