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. ... View more

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; ... View more

I'd like to make a table showing me how many times this happened to each player. 'O' stands for offensive rebounds.   Basically i would like to find a way to find the top 5 players whose offensive rebounds resulted in an attempted shot on the basket ... View more

So I'm trying to count the number of times that a selected variables happen directly after an 'O'.     For example in the sample data. row 25 has 'O' and directly below that row 26 has a '2FGA'   I want to find a way to show how many times that the player_name associated with an 'O' resulted in a 2FGA or 3FGA directly after the 'O'.  I don't care about the player_name in the following row or in the row with 'O'     try and explain differently in row 25.  Honeycutt, Tyler = 1 'O' (because directly after there was a 2FGA   next would be  Rice, Tyrese (row 29) he would = 1 because there was a 3FGM after.   does that make more sense.   ... View more

so far this is all i have.      proc import datafile="/home/kcmitche/DataChallengeEuroGamePBP-2.csv" out=EuroBB dbms=csv replace; run; data want (drop=last); set have; last=lag(event); if event in ('2FGA','3FGA') and last eq 'O' then output; run;     again rookie here ... View more

When I run the results nothing pops up it does straight to the output tab ... View more

i couldn't figure it out with the code you suggested.  Sorry i'm still new to sas. All i did was import the data and then followed with what you wrote but clearly that wasn't correct. ... View more

I'll give it a try but to try and make myself more clear i'm attaching an example of the data.   So you'll see 5 columns   1st (no title) / 2nd (team_name) / 3rd (player_name) / 4th (event_desc_id) / 5th (event_desc)   so basically there will be values in the 'event_desc_id' column such as 2FGAB, AG, FV, D, O, 3FGA, 2FGA I would like to count the number of times that the row directly after an 'O' has a '3FGA' or a 2FGA'   hopefully that will make a bit more sense    ... View more