topic Re: Data Analysis Questions in SAS Programming

Data Analysis Questions

collegestudent2 — Mon, 29 Nov 2021 16:29:15 GMT

I have data recorded from football games over the years that has game date, winning team, winning score, losing team, and losing score.

1. How do I create a variable that will calculate the difference in points between the two teams?

2. How do I present the game date using a format that includes the day of the week?

3. How do I create a cumulative counter variable that tracks the total number of bowl games?

4. How do I create a cumulative counter variable that tracks the number of wins for each team?

Re: Data Analysis Questions

PaigeMiller — Mon, 29 Nov 2021 15:37:29 GMT

@collegestudent2 wrote:

I have data recorded from football games over the years that has game date, winning team, winning score, losing team, and losing score. The data is from a bowl game, so only two teams.

1. How do I create a variable that will calculate the difference in points between the two teams?

It sure would help if you showed us a portion of your data.

Re: Data Analysis Questions

collegestudent2 — Mon, 29 Nov 2021 16:30:07 GMT

The Data:

Re: Data Analysis Questions

PaigeMiller — Mon, 29 Nov 2021 16:32:00 GMT

It looks like a homework problem ... is it? Show us what you have tried so far.

Re: Data Analysis Questions

Reeza — Mon, 29 Nov 2021 16:58:08 GMT

@collegestudent2 wrote:

1. How do I create a variable that will calculate the difference in points between the two teams?

https://video.sas.com/detail/videos/sas-analytics-u/video/4573023399001/creating-a-new-column-in-sas?autoStart=true&page=1

2. How do I present the game date using a format that includes the day of the week?

https://video.sas.com/detail/video/4572997796001/formatting-values-in-sas?autoStart=true&q=format

3. How do I create a cumulative counter variable that tracks the total number of bowl games?

4. How do I create a cumulative counter variable that tracks the number of wins for each team?

https://stats.idre.ucla.edu/sas/faq/how-can-i-create-an-enumeration-variable-by-groups/

Links above contain tutorials under 5 minutes each to answer your questions. If you still need help, please post your code and explain what issues you're having please.