topic Re: SASHELP Data sets in SAS Programming

SASHELP Data sets

michaelm90 — Fri, 10 May 2019 16:42:28 GMT

Hello, I am having trouble with this problem using the sas supplied dataset sashelp.baseball.

(dataset: SASHELP.BASEBALL) Report the expected value in American league (LEAGUE=AMERICAN) whose 1987 Salary in $ Thousands (SALARY) is 600 or higher under the independence of salary and league. (Up to three decimal places, please)

The correct answer is 52.717. Here is my code:

proc means data=sashelp.baseball;
where league='American';
where salary>=600;
run;

Re: SASHELP Data sets

Reeza — Fri, 10 May 2019 16:47:23 GMT

That's not how you have two conditions in a WHERE statement - check your log and see what it says. You can have multiple conditions by separating them with an AND.

where league = 'American' and salary>=600

Re: SASHELP Data sets

michaelm90 — Fri, 10 May 2019 16:56:27 GMT

Even after fixing that it still yielded the wrong answer, am I using the right statement?

Re: SASHELP Data sets

Reeza — Fri, 10 May 2019 16:57:58 GMT

Actually I don't think you are. I think the expectation here may have been to fit a GLM model and then to report the predicted value overall. Expected Value is throwing me off a bit - but given your previous question I think that's right.