To practice your skills as a newly hired data analytics developer, you have pulled information from Wikipedia to use as sample data to show president and number of days in office from each state.

Assignment Instructions

In SAS Studio, create a new folder named PresidentData.

Upload the USPresident.csv data file into the PresidentData folder.

Read external data from the USPresident.csv file use INFILE, create a SAS data set named USPresident and save it in the WEBWORK library.

Include a conditional statement in your code that selects only presidents from Ohio. Calculate the total number of days each president was in office. Days in office are calculated using the Took office and left office columns.

Take the following screenshots for submission:

A screenshot of the USPRESIDENTS dataset in the WEBWORK library showing metadata of $44$ total rows and $6$ total columns.

A copy of your code $($text copy$).$

A screenshot of the RESULTS tab showing Table of Contents.

Include these screenshots in one Word document and be sure to annotate each screenshot.

OPTIONS ERRORS$=200$; $/*$ Set the limit to $200$ or a higher number.

This allows SAS to display up to $200$ error messages in the log $*/$

$/*$ Create a SAS data set named USPresident and

save it in the WEBWORK library $*/$

LIBNAME WEBWORK $\text{'}/$home$/$u$63728168/.$sasstudio$/$webwork$/$RS$17574\text{'}$;

DATA WEBWORK.USPresident;

$/*$ Read external data from the USPresident.csv file using INFILE $*/$

INFILE $\text{'}/$home$/$u$63728168/$PresidentData$/$USPresidents$.$csv$\text{'}$ DELIMITER$=\text{'},\text{'}$ FIRSTOBS$=2$ DSD MISSOVER;

INPUT Presidency $ President $ Took$\_$office :MMDDYY$10.$ Left$\_$office :MMDDYY$10.$ Party $ HomeState $ In$\_$office$\_$days;

LABEL Presidency $=$ 'Presidency' President $=$ 'President' Took$\_$office $=$ 'Took Office' Left$\_$office $=$ 'Left Office' Party $=$ 'Party Affiliation' HomeState $=$ 'Home State' In$\_$office$\_$days $=$ 'Days in Office';

$/*$ Calculate the total number of days in office $*/$

In$\_$office$\_$days $=$ INTCK$(\text{'}$days$\text{'},$ Took$\_$office, Left$\_$office$)+1$;

$/*$ Include a conditional statement in your code that selects only presidents from Ohio $*/$

IF HomeState $=$ 'Ohio' THEN OUTPUT;

FORMAT Took$\_$office Left$\_$office MMDDYY$10.$;

RUN;

PROC DATASETS LIB$=$WEBWORK;

CONTENTS DATA$=$USPresident;

RUN;

$/*$ Display the first five observations of the dataset for verification $*/$

PROC PRINT DATA$=$WEBWORK.USPresident$($OBS$=5)$;

RUN;