Write a sas program that first creates variables

Assignment Help Finance Basics
Reference no: EM13278999

1. Go to YouTube and view the first 3 SAS sessions of Mike's SAS Tutorials. After viewing the videos, read the first chapter of My Little SAS Book. The first chapter is free at the link posted in the course syllabus. The rest of this book is available from Amazon for about $50 (paperback edition) and $25 (KINDLE edition).

2. Using his variable-assignment method, write a SAS program that first creates three variables: RF, RM, and R. Assign R the value 0.04, RM the value 0.12 and R the value 0.14. Before proceeding, use the video's PROC PRINT procedure to make sure you have done the DATA step correctly.

According to the Capital Asset Pricing Model (CAPM), the beta of a stock can be determined as follows:

Given this formula, add a line to your SAS code to calculate the beta of the stock. Your code should be the first line after the three assignment statements and will look like the following:

beta = (R - RF) / (RM - RF);

Add a PROC PRINT and run the DATA STEP and the PROC step.

Print the output to a PDF named: yourname_A1_2.pdf. You will be turning this in.

3. Now use the CARDS method to compute beta for three stocks. This time you will leave out the assignment statements because you will be reading in the observations listed below but you will need the assignment statement to compute the variable beta.

Copy and paste the following observations into your SAS program after the CARDS; statement (don't forget to add one line after the last observation containing a semicolon):

0.04 0.12 0.10
0.04 0.12 0.14
0.04 0.12 0.18

Add a PROC PRINT and print the results from your program as before naming the output yourname_A1_3.pdf. You will be turning this in.

The next two problems use data imported from an external source. Since you will be using different computers I can't give precise directions for this. You should download the data sets from BlackBoard to a data stick. When you import into SAS, you will need to specify the address of the data residing on your data stick.

4. From BlackBoard download the data set: data_A1.txt. It contains 26 observations of RF, RM and R. Each observation is preceded by a firm name. So there are 4 variables for each observation. You will need to modify your input statement in two ways. First, add a variable named firm_name. Second, you will need to define this variable as character.

You do this in the input statement. Your input statement will read:

input firm_name $ RF RM R;

As before compute beta and print your results in a file named yourname_A1_4.pdf.

5. From BlackBoard download the data set: data_A1.xls. This contains the same type of data as problem 4 above. Repeat problem 4 using the EXCEL data. Print those results in a file named yourname_A1_5.pdf.

Attachment:- Assignment 1.pdf

Reference no: EM13278999

Questions Cloud

What are the portfolio weights of each stock : An investor owns $10,000 of Adobe Systems stock, $15,000 of Dow Chemical, and $25,000 of Office Depot. What are the portfolio weights of each stock?
Human resource professionals must be proactive : Human Resource professionals must be proactive in order to be able to meet all of the challenges of the 21st Century. What are some of the changes to the work force environment that you see looming on the horizon?
What is the present value of these cash flows : Assume that you will receive $2,000.00 a year in year 1 through 5; $3,000.00 a year in years 6 through 8; and $4,000.00 in year 9. All of the cash flows will be received at the end of the year. If you require a 14% rate of return, what is the pres..
Find parameters of steam and pipe : Steam enters a circular pipe at 1600 kPa, 400 oC and 10 m/sec and exits at 1000 kPa and 32 m/sec. find parameters of steam and pipe
Write a sas program that first creates variables : Write a SAS program that first creates three variables: RF, RM, and R. Assign R the value 0.04, RM the value 0.12 and R the value 0.14. Before proceeding, use the video's PROC PRINT procedure to make sure you have done the DATA step correctly.
Derive the ber-bit error rate of a 8-pam system : derive the BER (Bit Error Rate) of a 8-PAM (Pulse Amplitude Modulation) system in an AWGN (Additive White Gaussian Noise) channel.
What will the price be in 6 years : The Jackson-Timberlake Wardrobe Co. just paid a dividend of $1.40 per share on its stock. The dividends are expected to grow at a constant rate of 8 percent per year indefinitely.
Questions needs facts-issue-holding-law-argument-conslusion : This questions needs Facts, Issue, Holding, Law, Argument and Conslusion - Power of the ILO Administrative Tribunal: Armstrong worked for a United Nations specialized agency in Geneva for seven years. As Part of his job, he tracked the civil rights a..
What is the value of the option to delay the project : The project's cost and expected annual cash flows would be the same whether the project is delayed or not. The project's WACC is 8.5%. What is the value (in thousands) of the option to delay the project?

Reviews

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd