SAS# homework 2You can work on this assignment by connecting to the wrds cloud from Windows or by working directly in UNIX (see the Windows and the UNIX versions of my programs in Topic 2). In both cases, you will need to solve this assignment using both the standard PROCs in SAS and the PROC SQL (see the standard and the SQL versions of my programs in Lecture 2). You need to attach 2 programs at the end of your solution: the standard SAS program and the program that uses PROC SQL. However, you only need to provide one output with your answers. You do not need to multiply returns by 100 for this exercise.sas代写 assignment2(Download daily return and volume information for the following stocks:American Express Co. (ticker AXP), Chevron Corp (ticker CHV),  United  Technologies  Corp.  (ticker UTX), Caterpillar Inc. (ticker  CAT),  and  McDonalds  Corp.  (ticker  MCD).  Extract the data for the time period July 1, 1986 to December 30, 2000. The dataset that you need is called dsf and it is located in the wrds library: /wrds/crsp/sasdata/a_stock. Report the average trading volume for each of theseYou need to first identify the firm permno by accessing wrds via your browser. Then, you need to write your program in SAS.Download index data for the same period. The dataset that you need is called dsix and is located in the wrds library: /wrds/crsp/sasdata/a_indexes. For each stock, compute the return in excess of the equally-weighted market return. The equally-weighted market return is stored in the variable ‘ewretd’. If we define Ritas the return on a stock i and Rmt the equally-weighted return on the market porfolio, then this excess return is:Tit =Rit – RmtCompute the univariate statistics for the excess returns for each stock and include the printout with your answer. Which 2 stocks have heavier tails?Remember to attach your 2 programs (the standard SAS program and the SQL version) at the end of your solutions.最先出自315代写  sas代写 更多请查看 统计代写合作：315代写

所有的编程代写范围：essayghost为美国、加拿大、英国、澳洲的留学生提供C语言代写、代写C语言、C语言代做、代做C语言、数据库代写、代写数据库、数据库代做、代做数据库、Web作业代写、代写Web作业、Web作业代做、代做Web作业、Java代写、代写Java、Java代做、代做Java、Python代写、代写Python、Python代做、代做Python、C/C++代写、代写C/C++、C/C++代做、代做C/C++、数据结构代写、代写数据结构、数据结构代做、代做数据结构等留学生编程作业代写服务。