Hi all,   I have a large amount of transaction data and I'm wanting to pull transactions where a count of previous transactions have taken place prior to a given transaction in a specified amount of time.  For example, I might want to see all transactions where there were two transactions that took place at the same merchant in the previous hour on the same card.     I have account numbers and the datetime of the authorizations to work with along with merchant name, merchant category, and a bunch of variables to specify the activity I'm looking for.  I have other systems I can use to pull such activity but it's slow and clunky.  I've been playing around with different code but can't seem to come up with something that works.     Any suggestions on how I can accomplish this?  No need to provide code examples if it's easier to just explain in words how I can do this.   If further explanation of what I'm trying to accomplish is needed just let me know and I'll be happy to provide.   Thanks! ... View more

Hi, I work in credit card fraud and recently got access to SAS Enterprise Miner and SAS Enterprise Guide.  I have a fairly good knowledge of SQL so I've been able to use SQL in Enterprise Guide to work with datasources I wasn't previously able to work with using SQL which has been great.  What I'd really like to do though is figure out how to use link analysis in Enterprise Miner to identify compromised merchants.  All of my transaction information is stored in one table.  This includes the account number, merchant name, date, time, whether or not a transaction is fraud etc.  I know I need to pull out the transaction data for just the cards that have fraud and then set that up as transaction data but I've read through tons of pages of tutorials and can't figure out how to do this.  It took me forever just to figure out how to put my LIBNAME statement in the project start code so that I could add my data source as input data.  None of the tutorial information I have found seems to explain how to do really basic things or if it does it's specific to a case study and doesn't give a general explanation.  Can anyone point me towards information that will help me accomplish what I'm wanting to accomplish?  I do have some programming experience so I feel like I can figure this stuff out if I can find the information I'm looking for.  I'd be extremely grateful for any help you can provide.  Thanks! ... View more