Create a new dataset from the separate ones you just created consisting only of those employees who paid by “cash or check” or “payroll deduction

Create a new dataset from the separate ones you just created consisting only of those employees who paid by “cash or check” or “payroll deduction

Read in employee_donations.txt, employee_addresses.txt, and empolyee_payroll.csv and create separate permanent SAS datasets. Usedatalines for theemployee_donations data ·Merge the three datasets together and only keep employees who are in all of the 3 datasets · Drop any variable where the variable name begins with ‘Street’ · Create a total donation variable (May need to use ‘sum’ function or conditional logic)· Print only Salary and Birth Date. Format both variables. · Produce Frequencies on total donations · Produce Cross Frequencies of gender by marital status. What does it tell you?·What Person(s)contributed themost money? ·What Person(s)contributed the highest percent of their salary? ·What Person(s) is the oldest person in the data? ·Produce separate datasets for each method ofpayment ·Create a new dataset from the separate ones you just created consisting only of those employees who paid by “cash or check” or “payroll deduction”. Put a comment in ·Print all variables but only for the employees who have 3 or more dependents. Use at least one title, one footnote, and one label ·Email me the .sas, .log, and .html files

Leave a Comment

Scroll to Top