Determine the average value of research payments

Assignment Help Applied Statistics

Reference no: EM132547212 , Length: word count:1500

Task 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:

Question 1. Read the data into SAS using a data step or using a libref where appropriate. Ensure variables are formatted accordingly where required.

Question 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.

Question 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.

Question 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.

Question 5. Use at 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.

Question 6. Include any other relevant analysis of this data (only) to assist you to understand the payments being made to US physicians.

Attachment:- Assignment - report format.rar

Reference no: EM132547212

Questions Cloud

How many units did the company sell during January : Tiger Enterprise uses a periodic inventory system. Details for the inventory account for month of January, How many units did the company sell during January

Describe the plain view doctrine : Describe the plain view doctrine, and why it has such a significant impact on digital forensics?

An individual whose cells have 36 chromosomes : An individual whose cells have 36 chromosomes; how many chromosomes are present in the daughter cells after meiosis?

What is a segmented income statement and how is used : The units can be reworked for $1 per unit and sold for full price of $6 each. If Henny-Penny rework the defective units, how much net return will result?

Determine the average value of research payments : Determine the average value of research payments given by each Manufacturer. Include in your report the details

What is the ending inventory under the average-cost method : Assuming that a perpetual inventory system is used, what is the ending inventory (rounded) under the average-cost method

Trace the path of the production of a protein : Trace the path of the production of a protein through the cell from the start to the plasma membrane

Describe the methods used in collecting the outcome data : Describe the rationale for the methods used in collecting the outcome data. Describe the ways in which the outcome measures evaluate the extent to which.

Plasma membrane of animals : 1. What molecule is found in the plasma membrane of animals but not other organisms (like plants)?

User Account

All Pages