Homework answers / question archive / I am having an assignment that I MUST get 100% to pass this class

I am having an assignment that I MUST get 100% to pass this class

Computer Science

Share With

I am having an assignment that I MUST get 100% to pass this class. Please follow the instruction on Homework 8 pdf file. Please take a look at my STATA grade file as it is similar to this assignment. The file includes my professor's comments. Also, Please consider this comment from my professor: ": Look for sample codes+ STATA's EGEN handout. I'm using almost identical list of tasks from that handout and coded up with SAS. So, please take a look at the handout and see how many you can manage on your own, THEN go through my SuggestedAK codes. You should change the library path at the top of the SAS program to your file folder path and run the lines and see what happens. This will help you with the last part of Homework 8". Again, please check with the expert and make sure he can get all the tasks correctly. I need to get all the answers correct to pass. 
ECON 62052/72052 Data Preparation for Academic Research Jooyoun Park Homework 8. SAS Data Prep #3 Deadline: December 11th (Sun) < Total points: 70 pts > Assignment instruction: 3. Submit your SAS program file, output file as a PDF, and the log file as log. 4. Name your files: SAS program [your_last_name]_hw8.sas Output: [your_last_name]_hw8_output.pdf Log: [your_last_name]_hw8.log Summary stat file: [your_last_name]_hw8_summarystats.xlsx 9. Write all codes in one do file but separate each task by using comments to improve visibility. 10. Log file and output file should be from one run of a completed SAS program. Finish your codes. Close the log and result window. Then run your SAS program in its entirety to create the log and output. Or you can close SAS and open it again and just run the completed SAS program. (If not, I will subtract 10 points from your grade.) 11. Comment what you are doing generously so I can understand what you are doing. That is, comment for me, not just for your own reference. 12. If a question requires you to write answers that are not codes, write them as comments on the SAS program. 13. AVOID PLAGIARISM AT ALL COST! Put away my in-class program files while you are coding, then you can’t possibly plagiarize. 14. ADD TITLE TO ALL TABULATIONS, SUMMARY STATS, AND ETC.. TASK 8 (rate 4): Constructing some categorical variables for summary stats: a. Age Groups i. Construct a numeric variable, agegroup, to take the following value based on the variable age. 1 if age 15-21 2 if age 22-45 3 if age 46-65 4 if age 66-85 ii. Create a format (value label) named agegroup_lbl and assign it to agegroup. iii. Display the values of format agegroup_lbl. (This is not proc freq.) iv. Tabulate agegroup with the value labels displayed. b. Employment status i. empstat_cps8 shows the various employment status. Using empstat_cps8, make a new variable named empstatus and assign the following values: 1 Employed 2 Unemployed 3 Not in the labor force ii. Create a format (value label) named empstatus_lbl and assign it to empstatus. iii. Display the values of format empstatus_lbl. (This is not proc freq.) ECON 62052/72052 Data Preparation for Academic Research Jooyoun Park iv. Tabulate empstatus with the value labels displayed. v. Save the formats you currently have as a SAS data file named hw8_formats.sas7bdat. - This should include all formats that are brought in from hw8_ipumstimeuse_formats.sas7bdat and agegroup_lbl and empstatus_lbl. (Do not submit this file.) vi. Open that format file you just saved and tabulate FMTNAME variable (just do proc freq). This should TASK 9 (rate 3): Inflation adjustment for monetary variables. There are two earnings variables that are written in monetary units, earnweek and hourwage. Adjust the values for inflation and convert them to 2017 USD using CPI. Code in a way that there is no hand-entering of any CPI information into the code. a. Find the necessary CPI data and make a SAS dataset named cpidata.sas7bdat b. Summarize earnweek and hourwage before making any changes. (Notice the upper bound values, $99.99 for hourwage and $2,884.61 for earnweek). c. Carry out the inflation adjustment by merging cpidata file. Convert the values to 2017 USD. d. Impose the upper bound on both variables, $99.99 for hourwage and $2,884.61 for earnweek. e. Change the variable labels to reflect the change. f. Summarize earnweek and hourwage after making the changes. Compare it to the summary table you made before the inflation adjustment. Does everything look right? TASK 10 (rate 7): BASIC summary statistics: Here we’ll create a lot of summary statistics for the time-use file as we did in Stata file. If you have not checked my comments on your STATA assignment (HW4), you should do so before working on this. For this assignment, you need to produce statistics to fill out the table provided below. General Instructions: • Gender variable is named sex. Race group variable is named race. Refer to their value labels (formats). • Code in the way that you can easily copy-and-paste the outputs into the table with minor edits. • Not all stats are complicated to code. The easier, the better. Use whatever method you want. • Format all stats to have only two decimal points. • Comment a lot, explain what you are doing. • Make this table in an excel file or document file and submit it separately. Specific Instructions: a. Age: mean and standard deviation of ages for each subgroup. b. Educational Attainment: Share of observations with each degree category WITHIN each subgroup. c. Earnings distribution: mean, standard deviation, 10th percentile, 90th percentile ECON 62052/72052 Data Preparation for Academic Research Jooyoun Park d. Labor market statistics: Unemployment rate and labor force participation rate You guys didn’t do this very well in STATA homework. Look at my suggested answer key for HW4 and understand what I did and then make the SAS codes. Again the definition for the unemployment rate and labor force participation rate are as follows: • Unemployment Rate (%) = #Unemployed #Employed + #Unemployed × 100(%) • Labor Force Participation Rate = Labor Force Adult Population × 100(%) - Labor force = #Employed + #Unemployed - Adult population = #Labor force + #Not in the labor force = entire sample - You can find these using empstatus. TABLE. Basic Summary Statistics ALL Gender Race Male Female White Black Asian/ Pacific Islander Mixed Race Native American No. of obs. a. Age: Mean (s.d.) b. Degree attainment (% sample) ---- ---- ---- ---- ---- ---- ---- ---- Less than high school High school diploma or eqv. Some college Bachelor’s degree Post-graduate degree c. Earnings distribution ---- ---- ---- ---- ---- ---- ---- ---- Mean hourly wage (s.d.) Median hourly wage 10th percentile 90th percentile d. Labor Market Statistics ---- ---- ---- ---- ---- ---- ---- ---- Unemployment Rate (%) Labor Force Participation Rate (%)