SAS Support Communities

@rick_b wrote: Thank you for your suggestions. It is difficult to find a subsample that better illustrates the nuances than the one I provided. I included bet and event days in an attempt to make the visual logic more understandable. The last issue you ask me to clarify is the one that I really need help solving - identifying the last completed 'block' of bets. Games last three hours and begin only on certain days/times, but betting is continuous, so I need to identify a way to efficiently establish the last completed round of bet-on games prior to each bet. I've tried establishing bet and event blocks but keep encountering problems when trying to properly sum just the most recent set of bet outcomes. Here is my current approach (which is incomplete but may help stimulate new ideas). I will amend with another gamblers' bets in a moment...   if event_dayofweek='Monday' and event_hour=13 then event_block=1; if event_dayofweek='Monday' and event_hour=16 then event_block=2; if event_dayofweek='Monday' and event_hour=20 then event_block=3; if event_dayofweek='Tuesday' then event_block=4;*week 15 2021; if event_dayofweek='Thursday' and event_hour=12 then event_block=5; if event_dayofweek='Thursday' and event_hour=16 then event_block=6; if event_dayofweek='Thursday' and event_hour=20 then event_block=7; if event_dayofweek='Friday' then event_block=8; if event_dayofweek='Saturday' and event_hour=13 then event_block=9; if event_dayofweek='Saturday' and event_hour=16 then event_block=10; if event_dayofweek='Saturday' and event_hour=20 then event_block=11; if event_dayofweek='Sunday' and event_hour=9 then event_block=12; if event_dayofweek='Sunday' and event_hour=13 then event_block=13; if event_dayofweek='Sunday' and event_hour=16 then event_block=14; if event_dayofweek='Sunday' and event_hour=19 then event_block=15; if event_dayofweek='Sunday' and event_hour=20 then event_block=15; *; if bet_dayofweek='Monday' and bet_hour<16 then last_event_block_completed=15; I think we need to use a sliding window calculation method, where each new result is added to the total of the previous ones until the event is completed. It's funny, I couldn't even imagine that behind the beautiful picture in games there could be such complex databases and calculations. When I started working with this, I hadproblems with banuses. I mean, those that can be obtained, for example, in gamblizard and elsewhere. For us, this is routine work. For ordinary people who play, this is just entertainment. I often think about this. if bet_dayofweek='Monday' and bet_hour ge 16 and bet_hour<20 then last_event_block_completed=1; if bet_dayofweek='Monday' and bet_hour ge 20 and bet_hour<23 then last_event_block_completed=2; if bet_dayofweek='Monday' and bet_hour ge 23 then last_event_block_completed=3; if bet_dayofweek='Tuesday' then last_event_block_completed=3; if bet_dayofweek='Wednesday' then last_event_block_completed=3; if bet_dayofweek='Thursday' and bet_hour<16 then last_event_block_completed=4; if bet_dayofweek='Thursday' and bet_hour ge 16 and bet_hour<20 then last_event_block_completed=5; if bet_dayofweek='Thursday' and bet_hour ge 20 and bet_hour le 23 then last_event_block_completed=6; if bet_dayofweek='Thursday' and bet_hour ge 23 then last_event_block_completed=7; if bet_dayofweek='Friday' then last_event_block_completed=7; if bet_dayofweek='Saturday' and bet_hour<16 then last_event_block_completed=8; if bet_dayofweek='Saturday' and bet_hour ge 16 and bet_hour<20 then last_event_block_completed=9; if bet_dayofweek='Saturday' and bet_hour ge 20 and bet_hour<23 then last_event_block_completed=10; if bet_dayofweek='Saturday' and bet_hour ge 23 then last_event_block_completed=11; if bet_dayofweek='Sunday' and bet_hour<13 then last_event_block_completed=11; if bet_dayofweek='Sunday' and bet_hour ge 13 and bet_hour<16 then last_event_block_completed=12; if bet_dayofweek='Sunday' and bet_hour ge 16 and bet_hour<20 then last_event_block_completed=13; if bet_dayofweek='Sunday' and bet_hour ge 20 and bet_hour<23 then last_event_block_completed=14; if bet_dayofweek='Sunday' and bet_hour ge 23 then last_event_block_completed=15;   You need to calculate the running profit/loss for each player, starting from the last completed event. ... View more

I'm happy every time there are discounts. This is a unique opportunity to expand your knowledge in the field of analytics and data by obtaining sought-after certifications. I just found dissertation research topics, I use great list for this. I will choose a suitable topic and take courses. This is the best investment in yourself. ... View more

The answers to these questions are standard everywhere. You can even find them on google. But it was hard for me in college when they asked air pollution essay, I used https://studydriver.com/air-pollution-essay/ for this. So all the difficulties are still to be faced. Students don't know where they are! If something is a joke. ... View more

Agnieszka, I have researched these days more your article. It's always interesting to learn how people started using new tools and software. I can imagine that attending the summer school for academic teachers was a valuable experience. It's also impressive that you have been teaching reporting and data analysis using SAS for so long. Also, while I'm interested in learning more about SAS, I think I would buy college essays online. Since academic integrity is important, and I believe in doing my own work, but also some help from professionals from https://papersowl.com/buy-college-papers is always welcome and useful for gaining knowledge. But, thanks for sharing your thoughts on SAS Viya for Learners with me. I'm curious, what specific benefits have you noticed from using SAS Viya for Learners compared to SAS9? Has it improved your students' learning experience or made it easier for you to teach? ... View more

As a newbie aboard, I'm so glad to find this, thanks! ... View more

Hey there, a newbie aboard! Great question! Model retraining can mean different things depending on the context, but in general, it refers to updating an existing model using new data. So, your understanding is partially correct! When you retrain a model, you typically use the same model architecture and parameters as before, but update the model's weights (or coefficients) based on new data. In this way, the model can improve its accuracy and generalizability as it learns from more examples. As for SAS Model Studio specifically, I'm not 100% sure, but based on my experience with other machine learning tools, I would expect that it updates the existing model's weights rather than generating a completely new model. However, if there are new variables or features in the data that were not included in the original model, you may need to modify the model architecture to account for these changes. Hope that helps! Let me know if you have any more questions. ... View more