Answered step by step
Verified Expert Solution
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):
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started