BookmarkSubscribeRSS Feed
michaelm90
Fluorite | Level 6

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;
3 REPLIES 3
Reeza
Super User
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
michaelm90
Fluorite | Level 6

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

Reeza
Super User
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.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1068 views
  • 0 likes
  • 2 in conversation