Question

SAS program. Need help with direction on how to do report 2

Report 2. A gournet pizza restaurant is considering adding new toppings to its menu. Each month they survey ten customers about their preferences for three different toppings. They want data on several different toppings, so they do not always ask about the same three toppings. Customers rate each topping on a scale of 1 (would never order) to 5 (would order often). The raw data file Pizza.csv has variables for the respondent's ID, and the ratings for five different toppings: arugula, pine nuts, squash, shrimp, and eggplant. The first one or two digits in the ID correspond to the month of the survey (that is, 1--Jan., 2- Feb. 12 Dec.). (a) Open the data set using Excel notice the presence and location of missing data. In a comment section at the beginning of your code, discuss how you might address the missing data in the file with options in the INFILE statement. Remember to close this Excel file before working with it in SAS. (b) Read the observations from the Pizza.csv file omitting the results from January (you believe they were compromised results). Name the data set pizza. (e) Use d PROCEDURE sLep w priľal Lhe dala sel. Cuuipare your uulpul Lu Llae Excel ile.

Answer 1

Solutiona:

with file name statement give the location of file and

with infile statement to specify the source of data that is read by the input statement in a SAS data step.

with data step in sas create sas dataset

with proc step in sas create report.

truncover option in infile to read missing values

SAS Code:

filename mydata "C:\pizza.csv";

data pizza;

infile mydata truncover;

input ID arugula pinenuts squash shrimp eggplant;

run;

SolutionB:

SAS code:

data pizza;

set pizza;

where id ne 1;

run;

Solutionc:

SAS code:

Proc print data=pizza;

id ID

var arugula pinenuts squash shrimp eggplant;

by ID;

run;