topic Re: Help me with an assignment in SAS Programming

Help me with an assignment

kcmitche — Thu, 16 Mar 2017 02:50:32 GMT

Hello Community. I have a quick question to ask the community. I have a data set (attached below) I'm trying to answer a few questions. i need to write code to help answer a few questions. I need to identify the top 5 player_name and team_name that had offensive rebounds ('O' in the event_desc_id) that led to a 3FGA, 3FGM, 2FGA, directly after (row below) Thank you for any help. Let me know if you don't understand I'll try and make it easier . So far the only coding i have is proc import datafile="/home/kcmitche/DataChallengeEuroGamePBP-2.csv" out=EuroBB dbms=csv replace; run;

Help me with an assignment

kcmitche — Thu, 16 Mar 2017 02:33:49 GMT

Re: Help me with an assignment

LinusH — Thu, 16 Mar 2017 08:20:14 GMT

So do I understand correctly that you are taking SAS training, and now you want someone else to write your code? Then you'll learn nothing more than if you just read documentation without context.

Your training facility is the ones that should guide you in your assignments.

Re: Help me with an assignment

RW9 — Thu, 16 Mar 2017 09:32:53 GMT

I agree with @LinusH, writing it yourself is the way to learn. Just to add to this, learning how to post a good question will also help you get good answers. Attaching files for your data is one bad way to start. Files from the internet are security risks and wouldn't be downloaded. Post test data in the form of a datastep in the post itself:

https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712

Also, just looking at the small bit of code you have there I see a lack of understanding with your data. You have a proc import filetype=csv, CSV stands for Comma Separated Variable file - nothing to do with Excel even though Excel does include a parser which can open that filetype. So the file you attach does not match your import step. Secondly proc import is a guessing procedure, i.e. it tried to examine the file and guess the best import structure, i.e. should this variable be character/numeric etc. Not a good idea in any situation

Re: Help me with an assignment

kcmitche — Thu, 16 Mar 2017 16:45:12 GMT

It's an online teach you SAS g. Not a facility.

I'm not looking for someone to write out my specific code.

but show me where i should even be looking

I know i need to start by making a table

and then identify how many times each variable is in a row and then who's row it is in.

I' having trouble figuring out the more complex part where i need to use the rows after what I am checking based on criteria.

I've never worked with criteria based analytics.

Re: Help me with an assignment

Reeza — Thu, 16 Mar 2017 18:17:50 GMT

@kcmitche wrote:

It's an online teach you SAS g. Not a facility.

I'm not looking for someone to write out my specific code.

but show me where i should even be looking

I know i need to start by making a table

and then identify how many times each variable is in a row and then who's row it is in.

I' having trouble figuring out the more complex part where i need to use the rows after what I am checking based on criteria.

I've never worked with criteria based analytics.

You haven't posted enough for us to even point in a direction right now. You're using terms that I'm sure make perfect sense to you but don't to us.

So far the responses have more details that your question. The import step that you've shown only brings in your data but doesn't provide any useful information.

https://communities.sas.com/t5/SAS-Communities-Library/How-to-ask-a-question-in-SAS-Analytics-U-Communities/ta-p/221163