I need SAS code to count missing values in a dataset and display the results in the output.
Requirements:
Programming language: SAS and SQL
/*SAS CODING*/
data class;
set sashelp.class;
if Name = “Alfres” then Age = . ;
if Name = “Alice” then Sex = ” “;
if Name = “John” then Weight = . ;
run;
/*SQl CODE*/
proc sql;
select sum(missing(Age)) as Age_missing,
sum(missing(Sex)) as Sex_missing,
sum(missing(Weight)) as Weight_missing from class;
quit;
I have provided the assignment instructions. Please review and answer all requirements. My professors name is Grimes, if my name is needed for the assignment please let me know.
the sql query
select Email , count (Email)
from user
group by Email
having count(Email) >1 ;
Calculate the cancellation rate of requests with unbanned users (both client and driver) each day.
Why its tricky: It requires multiple joins, specific filtering on status, and a GROUP BY on a date rangeall in one query.
Assignment Instructions
You must have SQL Server Express and SQL Server Management Studio (SSMS) installed to complete this assignment. You must also install the Microsoft Report Builder application. The following document provides instructions on how to install Microsoft Report Builder:
You will need to fully understand the COVID-19 database design for this assignment. The COVID-19 database design diagram and data dictionary can be accessed via the following links:
Provide your assignment task responses in a Microsoft Word report document. Incorporate a screenshot of each completed Microsoft Report Builder report into the assignment document as proof of completed work.
Task 1 – Generate a Column Chart Report
You are tasked with generating a column chart report showing the five states/jurisdictions with the highest cumulative number of reported COVID-19 cases. Use the following guidance document to generate the column chart report:
Examine the generated column chart report. What information can be drawn from this report? What assertions can be made from this report?
Task 2 – Generate a Pie Chart Report
You are tasked with generating a pie chart report showing the administration percentage of each COVID-19 vaccine. Use the following guidance document to generate the pie chart report:
Examine the generated pie chart report. What information can be drawn from this report? What assertions can be made from this report?
Task 3 – Generate a Bar Chart Report
You are tasked with generating a bar chart report showing the monthly COVID-19 vaccine distribution for the first six months of 2021 in the United States. Use the following guidance document to generate the bar chart report:
Examine the generated bar chart report. What information can be drawn from this report? What assertions can be made from this report?
Task 4 – Generate a Line Chart Report
You are tasked with generating a line chart report showing the monthly reported COVID-19 cases in the 2021 calendar year. Use the following guidance document to generate the line chart report:
Examine the generated line chart report. What information can be drawn from this report? What assertions can be made from this report?
Task 5 – Generate a Tabular Report
You are tasked with generating a tabular chart report showing the monthly reported COVID-19 cases in the 2021 calendar year. Use the following guidance document to generate the tabular report:
Examine the generated tabular report. What information can be drawn from this report? What assertions can be made from this report?
Task 6 – Interpret Data Dashboards
Interpret the data dashboards by writing a 50-100 word description for each graph detailing the data.
Requirements: 8 PAGES
Please follow the steps and use the correct information
Requirements: However long the assignment says
Executive Report on Non-Relational Database Alternatives
Please note the GenAI results may be incomplete and/or incorrect. You may need to revise the questions posed to the GenAI applications to get an acceptable outcome. Also, the use of multiple GenAI applications for this assignment is recommended since they offer different levels of result fidelity.
Question one or more GenAI applications to gain the following:
Copy the GenAI-extracted content and paste it into the report document. Organize the GenAI-produced content in the report document to enhance readability, flow, and structure. Revise the content as required to maintain proper grammar and spelling. Provide a citation for each batch of content with the GenAI source denoted in the reports reference section.
Take screenshots of the question-answer sessions with the GenAI applications. The screenshots need to be included in an appendix of the executive-level report. Each screenshot needs to show the full question(s) given to the GenAI application and a partial set of results (i.e., you do not need to show the entire GenAI output for proof of performed work).
Report Parameters/Expectations
Compile the obtained information into an executive-level report written in Microsoft Word (or equivalent). Your paper must contain the following:
The report must adhere to the most current APA guidelines and contain proper grammar and spelling since it is being presented to Northwind Trader executives. The report does not need to have an abstract section or table of contents. Also, review the university policy on plagiarism. If you have any questions, please contact your professor. For assistance with APA requirements, please go to Academic Writer. You will find the link in the Academic Tools section of the course.
Requirements: long answer