topic Re: SAS 9.4 scenario case 10 in SAS Programming

SAS 9.4 scenario case 10

Teeleaf — Sat, 10 Aug 2019 05:43:14 GMT

For the 1st "Test your code" question in scenario case 10:

1. What is the number of observations where the variable Type is Sedan?

The answer is showing obs:262.

However, I have obs:405.

Is it because the source data updated or I missed any step?

Thanks in advanced.

Re: SAS 9.4 scenario case 10

Cynthia_sas — Sat, 10 Aug 2019 14:09:01 GMT

Hi: Can you provide some context for the question. Where did the question come from? Are you working in Programming 1? If so, what Lesson is the question in? Are you working on something else? Homework? Practice exam? If the Practice Exam, is it the Pearson VUE Practice Exam or the SAS Practice Exam. What is the WHOLE question? There must be code that you wrote to derive your answer? Was there starter code or suggested code? What was that code?

Without knowing the name of the data set you're using, it could be SASHELP.CARS, it could be some other file -- it's hard to provide any meaningful feedback.

Cynthia

Re: SAS 9.4 scenario case 10

andreas_lds — Mon, 12 Aug 2019 06:26:42 GMT

@Teeleaf wrote:

For the 1st "Test your code" question in scenario case 10:

1. What is the number of observations where the variable Type is Sedan?

The answer is showing obs:262.

However, I have obs:405.

Is it because the source data updated or I missed any step?

Thanks in advanced.

Then, most likely something is wrong with your code. In sashelp.cars are only 262 obs with type = "Sedan".

Re: SAS 9.4 scenario case 10

ballardw — Mon, 12 Aug 2019 15:01:18 GMT

And only 428 total observations in SASHELP.CARS.

At a minimum You need to show 1) any code used to create the data set you summarized and 2) the code used for the summary.

Re: SAS 9.4 scenario case 10

Teeleaf — Wed, 14 Aug 2019 05:28:51 GMT

Thanks so much all !!

I think I misunderstood the question.

I think the question is asking the total number of observations where the variable Type is Sedan.

Not the number of observations where the variable type is sedan that With Average MPG Over 40.

To be more detail, i will provide the question and the code from answer key below.

Here is the question:

Open the ehs02 program from the EHS folder and correct the errors in the program below.
Example Code 2 ehs02 Program: Fix the Errors

work.mycars;
set sashelp.cars;
AvgMPG=mean(mpg_city, mpg_highway);
run;
title 'Cars With Average MPG Over 40';
proc print data=work.mycars
var make model type avgmpg;
where AvgMPG>40;
run;
title 'Average MPG by Car Type';
proc means data=work.mycars avg min max maxdec=1;
var avgmpg;
class type;
run;
title;

Test Your Code:
1. What is the number of observations where the variable Type is Sedan?
2. How many observations are printed to the report titled, “Cars With Average MPG Over 40”?

Objectives Accomplished:
• Identify the characteristics of SAS statements.
• Define SAS syntax rules and identify common syntax errors such as misspelled keywords, unmatched quotation marks,
missing semicolons, and invalid options.
• Use the log to help diagnose syntax errors in a given program.

---------------------------------------------------------------------------------------------

below is the code from the answer keys:

data work.mycars;
set sashelp.cars;
AvgMPG=mean(mpg_city, mpg_highway);
run;
title "Cars with Average MPG Over 40";
proc print data=work.mycars;
var make model type avgmpg;
where AvgMPG>40;
run;
title "Average MPG by Car Type";
proc means data=work.mycars mean min max maxdec=1;
var avgmpg;
class type;
run;

title;

Re: SAS 9.4 scenario case 10

Teeleaf — Wed, 14 Aug 2019 05:30:05 GMT

Thanks so much all !!

I think I misunderstood the question.

I think the question is asking the total number of observations where the variable Type is Sedan.

Not the number of observations where the variable type is sedan that With Average MPG Over 40.

To be more detail, i will provide the question and the code from answer key below.

Here is the question:

Test Your Code:
1. What is the number of observations where the variable Type is Sedan?
2. How many observations are printed to the report titled, “Cars With Average MPG Over 40”?

---------------------------------------------------------------------------------------------

below is the code from the answer keys:

title;