I have to perform my Assignment with help of SAS studio and submit it in a report in a pdf format. Attaching all the files needed for assignment
Assignment 2 Due Friday 19 June 11:59 pm Format Write a report on the topic introduced below. Use the “Example of report format.docx” template (as on Canvas) for guidance on the report structure and what is required in each section. Also refer to the rubric for an indication of the standards required to achieve full marks. This report must include an appendix where you will copy all SAS code as text (not an image). Word limit: 1,500 words in total (of the main body text only. All tables, appendices and main titles excluded). (Report = 14 marks) Submission Submit your report in a Microsoft Word Document or a PDF file, to Turnitin on Canvas. Work that is not your own will be penalised and may result in a zero mark and disciplinary action. Ensure you check the report file has uploaded correctly and is visible in Canvas. Incorrectly submitted assignments will not be marked. Late submissions will incur a 10% deduction of total available marks each day, up until 5 days late when the assignment will receive a score of zero. If you are having difficulty with completing on time, make contact with Alice early to get help and advice. Do not discuss any part of this assessment with anyone else. Tasks On Canvas you will find five files, a mix of csv, txt and dat files and SAS formatted files. This information has been modified from data sourced from www.cms.gov. The files contain payment information from medical suppliers to physicians. See the image on the last page for guidance on the relationship between the tables. A data dictionary has also been provided on Canvas. Use this information complete the following Tasks using SAS coding, with the goal of exploring the following questions. Question: What financial benefits are being provided to physicians? To assist you in answering this research question, you will need to complete at least the tasks listed on the following page using SAS code: 1. Read the data into SAS using a data step or using a libref where appropriate. Ensure variables are formatted accordingly where required. (3 marks) 2. Produce a graph that shows the distribution of the value of general payments made, for each of the different types of categories being drug, biological, device or other. Adjust your graph so this shows on a log scale. Ensure the graph is clearly labelled and has an informative title. (1 marks) 3. Using PROC SQL, determine the average value of research payments given by each Manufacturer. Include in your report the details (name etc) for the five Manufacturers with the highest average payment, in an output produced with SAS code. Ensure this is well presented. (1 marks) 4. Create a new variable “Funding” to represent the type, or combination of funding received by each physician. Produce a count of this new variable and show the percentage of the full cohort of physicians in this data set. (2.5 marks) 5. Use a t test to determine whether there is a difference in the average value of general payments for “Medical Doctor” compared to “Doctor of Dentistry” ie using their primary type. Use α=0.1. (1.5 marks) 6. Include any other relevant analysis of this data (only) to assist you to understand the payments being made to US physicians. (6 marks) Data sourced from: www.cms.gov Note some fields have been modified for the purpose of this assignment. http://www.cms.gov/ Physicians General payments Research Payments Companies Ownership Assignment 2 Due Friday 19 June 11:59 pm Format Submission Tasks Manufacturer_Name,Manufacturer_ID,Manufacturer_Name_Sub,Manufacturer_State,Manufacturer_Country 3M Company,100000000301,3M Company,MN,United States "410 MEDICAL, Inc",100000196851,"410 MEDICAL, Inc",NC,United States "4WEB, Inc",100000010575,"4WEB, Inc",TX,United States "A-dec, Inc",100000005393,"A-dec, Inc",OR,United States ABB Con-Cise Optical Group LLC,100000000190,ABB Con-Cise Optical Group LLC,FL,United States ABIOMED,100000010740,ABIOMED,MA,United States ACADIA Pharmaceuticals Inc,100000141529,ACADIA Pharmaceuticals Inc,CA,United States "ACE Surgical Supply Co., Inc",100000010411,"ACE Surgical Supply Co., Inc",MA,United States "ACELL, Inc",100000046254,"ACELL, Inc",MD,United States "ACIST MEDICAL SYSTEMS, Inc",100000196862,"ACIST MEDICAL SYSTEMS, Inc",MN,United States ACUMED LLC,100000000216,ACUMED LLC,OR,United States ADMA BioManufacturing LLC,100000231823,ADMA BioManufacturing LLC,FL,United States "ADVANCED RESPIRATORY, Inc",100000005391,"Advanced Respiratory, Inc",MN,United States "AKRIMAX PHARMACEUTICALS, LLC",100000005635,"AKRIMAX PHARMACEUTICALS, LLC",NJ,United States "ALCRESTA THERAPEUTICS, Inc",100000196817,"Alcresta Therapeutics, Inc",MA,United States "ALK-Abello, Inc",100000010705,"ALK-Abello, Inc",TX,United States ALLEN MEDICAL SYSTEMS,100000136442,Allen Medical Systems,IN,United States "AMAG Pharmaceuticals, Inc",100000010948,"AMAG Pharmaceuticals, Inc",MA,United States "AMDT Holdings, Inc",100000291828,"AMDT Holdings, Inc",TN,United States "APO-PHARMA USA, Inc",100000010867,"APO-PHARMA USA, Inc",FL,United States "ARBOR PHARMACEUTICALS, Inc",100000005507,"ARBOR PHARMACEUTICALS, Inc",GA,United States "ARGON MEDICAL DEVICES, Inc",100000010702,"ARGON MEDICAL DEVICES, Inc",TX,United States "ASAHI INTECC USA, Inc",100000000111,"ASAHI INTECC USA, Inc",CA,United States "ASCEND Therapeutics US, LLC",100000000129,"ASCEND Therapeutics US, LLC",VA,United States "ASSERTIO THERAPEUTICS, Inc",100000000324,"Assertio Therapeutics, Inc",IL,United States "AUGMENIX, Inc",100000136371,"AUGMENIX, Inc",MA,United States "AUGMENIX, Inc",100000136371,"Augmenix, Inc",MA,United States "AbbVie, Inc",100000000204,"AbbVie, Inc",IL,United States Abbott Laboratories,100000010680,Abbott Laboratories,IL,United States Accelerate Diagnostics inc,100000191769,Accelerate Diagnostics inc,AZ,United States "Acclarent, Inc",100000010475,"Acclarent, Inc",CA,United States Accuray Incorporated,100000010570,Accuray Incorporated,CA,United States "Acella Pharmaceuticals, LLC",100000196863,"Acella Pharmaceuticals, LLC",GA,United States "Acera Surgical, Inc",100000196855,"Acera Surgical, Inc",MO,United States Acessa Health inc,100000196775,Acessa Health inc,TX,United States "Aclaris Therapeutics, Inc",100000216808,"Aclaris Therapeutics, Inc",PA,United States "Acorda Therapeutics, Inc",100000010800,"Acorda Therapeutics, Inc",NY,United States "Actelion Pharmaceuticals US, Inc",100000000253,"Actelion Clinical Research, Inc",NJ,United States "Actelion Pharmaceuticals US, Inc",100000010476,"Actelion Pharmaceuticals, Ltd",CA,United States "Actelion Pharmaceuticals US, Inc",100000010813,"Actelion Pharmaceuticals US, Inc",CA,United States Acteon Inc,100000061309,Acteon Inc,NJ,United States "Active Medical, LLC",100000010499,"Active Medical, LLC",UT,United States "Acuity Surgical Devices, LLC",100000151734,"Acuity Surgical Devices, LLC",TX,United States Acumed LLC,100000000216,Acumed LLC,OR,United States "Adamas Pharmaceuticals, Inc",100000226811,"Adamas Pharmaceuticals, Inc",CA,United States Advanced Accelerator Applications,100000196773,Advanced Accelerator Applications,NJ,United States "Advanced Bionics, LLC",100000010424,"Advanced Bionics, LLC",CA,United States Advanced Circulatory Systems inc,100000010761,Advanced Circulatory Systems inc,MN,United States "Aegerion Pharmaceuticals, Inc",100000000128,"Aegerion Pharmaceuticals, Inc",MA,United States "Aerie Pharmaceuticals, Inc",100000216803,"Aerie Pharmaceuticals, Inc",NC,United States Aerin Medical inc,100000231819,Aerin Medical inc,CA,United States Aesculap Akademie GmbH,100000005608,Aesculap Akademie GmbH,,Germany "Aesculap Biologics, LLC",100000005660,"Aesculap Biologics, LLC",PA,United States "Aesculap Implant Systems, LLC",100000005658,"Aesculap Implant Systems, LLC",PA,United States "Aesculap, Inc",100000000268,"Aesculap, Inc",PA,United States Agfa HealthCare Corporation,100000005605,Agfa HealthCare Corporation,SC,United States "Agilent Technologies, Inc",100000151579,"Agilent Technologies, Inc",CA,United States "Agiliti Surgical, Inc",100000005394,"Agiliti Surgical, Inc",MN,United States "Agios Pharmaceuticals, Inc",100000181751,"Agios Pharmaceuticals, Inc",MA,United States "AirXpanders, Inc",100000176740,"AirXpanders, Inc",CA,United States "Akorn, Inc",100000010866,"Akorn, Inc",IL,United States "Alafair Biosciences,Inc",100000196813,"Alafair Biosciences,Inc",TX,United States Alcon Laboratories Inc,100000005405,Alcon Laboratories Inc,TX,United States Alcon Research Ltd,100000000218,Alcon Research Ltd,TX,United States "Alexion Pharmaceuticals, Inc",100000005462,"Alexion Pharmaceuticals, Inc",MA,United States "Align Technology, Inc",100000005613,"Align Technology, Inc",CA,United States "Alimera Sciences, Inc",100000056293,"Alimera Sciences, Inc",GA,United States "Alkermes, Inc",100000000255,"Alkermes, Inc",MA,United States Allergan inc,100000000278,Allergan inc,NJ,United States Almirall LLC,100000011034,Almirall LLC,PA,United States Alpha Orthopedic Systems,100000010710,Alpha Orthopedic Systems,KY,United States "Alphatec Spine, Inc",100000011129,"Alphatec Spine, Inc",CA,United States Amarin Pharma inc,100000010379,Amarin Pharma inc,NJ,United States Ambu inc,100000151688,Ambu inc,MD,United States "Amendia, Inc",100000011196,"Amendia, Inc",CA,United States "American Medical Hospital Supply Company, Inc",100000011043,"American Medical Hospital Supply Company, Inc",CA,United States American National Red Cross,100000071386,American National Red Cross,DC,United States American Orthodontics Corporation,100000010599,American Orthodontics Corporation,WI,United States American Regent,100000010540,American Regent,NY,United States Amgen inc,100000000203,Amgen inc,CA,United States Amneal Pharmaceuticals LLC,100000126368,Amneal Pharmaceuticals LLC,NJ,United States "Amniox Medical, Inc",100000010926,"Amniox Medical, Inc",FL,United States Analogic Corporation,100000011025,Analogic Corporation,MA,United States "Ancora Heart, Inc",100000151633,"Ancora Heart, Inc",CA,United States "AngioDynamics, Inc",100000005504,"AngioDynamics, Inc",NY,United States "Anika Therapeutics, Inc",100000010397,"Anika Therapeutics, Inc",MA,United States "Antares Pharma, Inc",100000076367,"Antares Pharma, Inc",NJ,United States Apollo Endosurgery US Inc,100000016245,Apollo Endosurgery US Inc,TX,United States Applied Medical Corporation,100000005642,Applied Medical Resources Corporation,CA,United States Applied Medical Technology Inc,100000005443,Applied Medical Technology Inc,OH,United States Apyx Medical Corporation,100000046274,Apyx Medical Corporation,FL,United States "Aries Pharmaceuticals, Inc",100000151650,"Aries Pharmaceuticals, Inc",CA,United States Aroa Biosurgery Incorporated,100000231824,Aroa Biosurgery Incorporated,CA,United States "Arrinex, Inc",100000196771,"Arrinex, Inc",CA,United States "Arrow International, Inc",100000011041,"Arrow International, Inc",PA,United States "Arrow Interventional, Inc",100000066369,"Arrow Interventional, Inc",MA,United States Artegraft inc,100000010834,Artegraft inc,NJ,United States "Arteriocyte Medical Systems, Inc",100000011211,"Arteriocyte Medical Systems, Inc",MA,United States "Arthrex, Inc",100000005371,"Arthrex, Inc",FL,United States Arthrosurface Incorporated,100000005469,Arthrosurface Incorporated,MA,United States Ascensia Diabetes Care US inc,100000151689,Ascensia Diabetes Care US inc,NJ,United States Astellas Pharma Global Development,100000005406,Astellas Pharma Global Development,IL,United States Astellas Pharma Inc,100000010648,Astellas Pharma Inc,,Japan Astellas Pharma US Inc,100000000137,Astellas Pharma US Inc,IL,United States AstraZeneca Pharmaceuticals LP,100000000146,AstraZeneca Pharmaceuticals LP,DE,United States AstraZeneca Pharmaceuticals LP,100000000160,AstraZeneca AB,,Sweden AstraZeneca Pharmaceuticals LP,100000010370,AstraZeneca UK Limited,,Great Britain (Uk) AstraZeneca Pharmaceuticals LP,100000196872,Acerta Pharma LLC,CA,United States "Astute Medical, Inc",100000136488,"Astute Medical, Inc",CA,United States "Athenex Pharmaceutical Division, LLC",100000211778,"Athenex Pharmaceutical Division, LLC",NY,United States Atos Medical Inc,100000010403,Atos Medical Inc,WI,United States "AtriCure, Inc",100000005372,"AtriCure, Inc",OH,United States "Auris Health, Inc",100000226828,"Auris Health, Inc",CA,United States "Avadel Specialty Pharmaceuticals, LLC",100000196805,"Avadel Specialty Pharmaceuticals, LLC",MO,United States "Avanir Pharmaceuticals, Inc",100000005729,"Avanir Pharmaceuticals, Inc",CA,United States Avanos Medical,100000076358,Avanos Medical,GA,United States Avedro inc,100000226827,Avedro inc,MA