Read excel file into a sas data set using proc import


Problem

The Microsoft Excel file named CarTalk.xlsx contains information regarding episodes of the automotive repair radio talk show Car Talk. Variables in this file include episode number, air date, title, and a description of the show.

i. Examine the Microsoft Excel file Cartalk.xlsx by printing the Excel spreadsheet using the XLSX LIBNAME engine.
ii. Read the Microsoft Excel file Cartalk.xlsx into a SAS data set using the XLSX LIBNAME engine.
iii. Read the Microsoft Excel file into a SAS data set using PROC IMPORT.
iv. Print the two SAS data sets.
v. Read the rows of the Excel file that correspond to the month of May into SAS using the IMPORT procedure. Print the data set.

Request for Solution File

Ask an Expert for Answer!!
Computer Engineering: Read excel file into a sas data set using proc import
Reference No:- TGS03312684

Expected delivery within 24 Hours