Your written Portfolio Project should meet the following requirements provide at least two paragraphs of detailed information about the project,

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Portfolio project requirements

Your written Portfolio Project should meet the following requirements:

 

• Provide at least two paragraphs of detailed information about the project, the site, and the dataset used.

• Provide the code with your modification comments.

• Include screenshots from the execution.

• Add code to generate SAS summary statistics

• Add code to generate Hypotheses for a two-sample t test

• Include screenshots from the output result.

• Provide SAS code

• You will produce a seven- to ten-page report documenting your actions on data, findings, and what you did to get this project completed.

 

You will get the SAS code examples at: https://github.com/HHS-AHRQ/MEPS/tree/master/SAS#sas-examples and the data files from the U.S. Department of Health & Human Services at: https://meps.ahrq.gov/mepsweb/data_stats/download_data_files.jsp

 

The SAS data file is h192.SSP

The Code file that needs to be modified to meet the above requirements is pasted below.

 

/*****************************************************************************/

/* Accessibility and quality of care, 2016

/*

/* Children with dental care

/*

/* Example SAS code to replicate number and percentage of children with dental

/*  care, by poverty status

/*

/* Input file: C:\MEPS\h192.ssp (2016 full-year consolidated)

/*****************************************************************************/

 

ods graphics off;

 

/* Load FYC file *************************************************************/

 

FILENAME h192 "C:\MEPS\h192.ssp";

proc xcopy in = h192 out = WORK IMPORT;

run;

 

/* Define variables **********************************************************/

/*  - For 1996-2007, AGELAST must be created from AGEyyX, AGE42X, AGE31X     */

/*  - For 1996, use 'POVCAT' instead of 'POVCAT96'                           */

 

data MEPS;

                SET h192;

 

 /* Children receiving dental care */

                child_2to17 = (1 < AGELAST & AGELAST < 18)*1;

                child_dental = ((DVTOT16 > 0) & (child_2to17 = 1))*1;

run;

 

proc format;

  value child_dental

                  1 = "One or more dental visits"

                  0 = "No dental visits in past year";

 

  value POVCAT

                  1 = "Negative or poor"

                  2 = "Near-poor"

                  3 = "Low income"

                  4 = "Middle income"

                  5 = "High income";

run;

 

/* Calculate estimates using survey procedures *******************************/

 

ods output CrossTabs = out;

proc surveyfreq data = MEPS missing;

                FORMAT child_dental child_dental. POVCAT16 POVCAT.;

                STRATA VARSTR;

                CLUSTER VARPSU;

                WEIGHT PERWT16F;

                TABLES child_2to17*POVCAT16*child_dental / row;

run;

 

proc print data = out noobs label;

                where child_2to17 = 1 and child_dental ne . and POVCAT16 ne .;

                var child_dental POVCAT16 WgtFreq StdDev RowPercent RowStdErr;

run;

Attachments:

Related Questions

. Introgramming & Unix Fall 2018, CRN 44882, Oakland University Homework Assignment 6 - Using Arrays and Functions in C

DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma

. The standard path finding involves finding the (shortest) path from an origin to a destination, typically on a map. This is an

Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t

. Develop a program to emulate a purchase transaction at a retail store. This program will have two classes, a LineItem class and a Transaction class. The LineItem class will represent an individual

Develop a program to emulate a purchase transaction at a retail store. Thisprogram will have two classes, a LineItem class and a Transaction class. Th

. SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of

. Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of