Question
SAS programming . Can someone help me on report 2 it’s not working and I do not know if I’m doing it right.
12.14.4.4. 2.1.2. 3.4.2 3 2 5 2 5 1 5 1 3 5 5 2 5 4 1 1 5.5 3.5.5.3.5-53-3-1, 1,3-3.12 334 3423 53533.22125253142 1 545 322142433 13451551 54514 5.4.1 4.3.3.1 5.22 201 201 009 210 201 202 013 004 005 006 997 300 009 400 400 004 ons dos 100 102 103 104 105 006 100 os os 110 201 202 201 201 dos ▲[2 s 6 7 8 901 12 13 14 S 16 169 20 21 22 22 25 26 3 4
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 respondents 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.
Editor-Untitledl put in ehe Input sectson by puting their Tb azugula Pinenuta aquaah ahrinp egqplant E DATA Pizza: narit芷(labeluster.utm . edainottengiaeaarmnina i Gav. DLY-.., rtRSTOBge, INPUT Arungula s Pinuts s squash Shrimp Eogplant s run:quit:
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Sol:

variables are numeric You have taken character

use dsd in infile statement

give path in filename statement

Truncover option in infile statement to set missing value.

quit statement not needed

SAS PROGRAM IS:


filename mydata "/SASHome/home/s1493771/xmlfiles/pizza.csv";
data pizza;
infile mydata dsd truncover;
input id arugula pinenuts squash shrimp eggplant;
run;

proc print data=pizza;

run;

SAS Enterprise Guide File Edit View Tasks Favorites Program Tools Help ·습님闻昌を岶兔ㄨㄧ闫예!다 骂Process Flow Search Current Project Tree x Program put_xml_request xml atut Data ^ 因ProgramーLog SS Filter and ort Query Builder Where | Data - Describe Graph - Analyze Export Send To E eggplant 血Programs id (a) arugula pinenuts @) squash test_pc_sev_v01_macro combine4to1_v2 222 pc se_v01 pc sev_v01 macro al cc_cc shrimp 102 103 104 210 316 422 528 634 740 al ref co al ref hn gl cc cc gLcc_hn Program SAS Enterprise Guide File Edit View Tasks Favorites Program Tools Help g.G. 岶之ㄨ闪 Process Flow Search Cu t Tree program, input xml_requeetml pizza.c3V Programs ^ |闖Program. El Log Output Data Save, Run . Stop | Selected Server: SASApp (Connected)-戰! Analyze Program, l Export, Send To, Create, I changes 싶 Commit History [ combine4to1 v2 222_pc_sev v01 pc sev_v01 macro ilename mydata /SASHome/home/s1493771/xmlfiles/pizza.ca ㈠data pizza; al ccc infile mydata dsd trunc ver; input id arugula pinenuts squash shrimp eggplant; al ref_hn gl cc_cc gl ref_hn SASGRID 19

Add a comment
Know the answer?
Add Answer to:
SAS programming . Can someone help me on report 2 it’s not working and I do...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • SAS program. Need help with direction on how to do report 2 Report 2. A gournet...

    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...

  • I have the code buts its not working as this below instruction can anyone help Use...

    I have the code buts its not working as this below instruction can anyone help Use the requirements from the pizza part of Assignment 6 and do the following using CSS and an internal style sheet: 1.     Your Javascript function should be in an external file (don’t forget to move it up to studentweb too) 2.     Put a red border of 300px in width around the form 3.     There should be three Div sections: header, main_body, and footer. 4.     Center the name of your...

  • Java programming help My program wont run. could someone tell me why. everything seems correct to...

    Java programming help My program wont run. could someone tell me why. everything seems correct to me... giving me the error: Exception in thread "main" java.lang.NumberFormatException: For input string: "Stud" at java.base/java.lang.NumberFormatException.forInputString(Unknown Source) at java.base/java.lang.Integer.parseInt(Unknown Source) at java.base/java.lang.Integer.parseInt(Unknown Source) at Util.readFile(Util.java:35) at Driver.main(Driver.java:8) _________________________________________________________________________________________________________________________ Program Prompt: Write a program to perform statistical analysis of scores for a class of students.The class may have up to 40 students.There are five quizzes during the term. Each student is identified by a four-digit...

  • Hello I need help with questions 2 until question 9 if you can do that for me thanks. I need to s...

    Hello I need help with questions 2 until question 9 if you can do that for me thanks. I need to see all work and answers clearly. Thanks for the help I know it’s a lot but I really need help with this it’s a project that’s due tonight. Thanks ! 27 27889.0526471 10.12 1.09 28 SUMMARY OUTPUT 29 30 Regression Statistics 1 Multiple F 0.986442 32 R Square 0.973068 33 Adjusted 0.967681 34 Standard I 32.55341 35 Observati 36...

  • Hello, I'm having trouble with the trial balance. Can someone please help me with it. I...

    Hello, I'm having trouble with the trial balance. Can someone please help me with it. I think something is wrong with the adjusted trial balance. khampton ACCOUNTING SERVICE INC Dear Newbie, Welcome to Hampton! My name is Julio Antoni, your supervisor. We believe the best way for you to get familiar with what you are going to be doing here is to throw you right in, so we are asking you to start working on the books for us right...

  • Can someone help me solve 1 and 2? SE Homework 3 - Excel Sign in -...

    Can someone help me solve 1 and 2? SE Homework 3 - Excel Sign in - o X Share File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Calibri On General General B D - X AutoSum" A - 11 D- O AA === A ESS ab Wrap Text Merge & Center - Cut LE Copy Format Painter Clipboard Fill ZIU Paste B IU , $ - % , 809 Insert Delete...

  • can someone help me with this i am stuck with all these questions i dont get...

    can someone help me with this i am stuck with all these questions i dont get it Here are summary statistics for randomly selected weights of newborn girts: n = 155, X = 33.6 hg, 8 = 6.5 hg. Construct a confidence interval estimate of the mean. Use a 99% confidence level. Are these results very different from the confidence interval 31.3 hg <u <35.1 hg with only 13 sample values, x = 33.2 hg, and s = 2.3 hg?...

  • can someone pls help me with this probke? Problem 2: Worksheet 'customers' has the R (recency), F (frequency), and...

    can someone pls help me with this probke? Problem 2: Worksheet 'customers' has the R (recency), F (frequency), and M (Monetary value) related information for the representative 10 customers of a home store. Recency is the number of months since the last purchase made by the customer. Frequency is the average number of times the customer comes to the store for purchase. Monetary value is the average dollar value of the transactions that the customer makes with the store. The...

  • Can someone please check my work? If I made an error can you please correct me...

    Can someone please check my work? If I made an error can you please correct me and show me the steps of how to get there? Date 1. A national hal survey asked 207 U.s. 3rd graders what their favorite fruit is. ask a. Identify the variable, favorite pre b. Is the e. What is the implied population? aoz e variablequalitativor quantitative (circle one) 2. Categorize nominal, ordinal, interval, or ratio. these measurements associated with smartphones according to level: a....

  • I have a hard time doing budgets using excel. can someone help me out with questions...

    I have a hard time doing budgets using excel. can someone help me out with questions on this? I did not do well when I submitted it so I am not sure what I did wrong. We were unable to transcribe this image2019SummerFinal Project due 310 - Excel katie, [email protected] - AutoSave a File Home A1 0 X Comments Insert Page Layout Formulas Data Review View Help Search Share x 4 Part 1 M N O 45 Advertising $900 per...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT