Hello I have one table (Table A) which has info about our clients. Their names, ID's, products owned, address etc etc. Most clients will have multiple entries since they own multiple products. I need to extract information for 50 or so clients from that list, these required clients name are present in a different table (Table B). If I try using an if statement that would take forever to write down all 50 clients name plus leaves room for a lot of error. I was wondering if there is a faster way to do this. I considered doing a left join but not sure if this would work since Table A would have multiple entries under the clients name and the name repeated many times while Table B would not have any repeats.    Thanks in advance! ... View more

I have two sales data one from April the other one from May. The data sets are on transaction level.   The April sales data looks like following Transaction_Date Location_Number Client_Name March 01              001                         aaa March 05              087                         aaa March 02              055                         bbb March 09              001                         bbb March 05              002                         ccc March 06              002                         ccc march 07              055                         ccc   The May data set looks like the following Transaction_Date Location_Number Client_Name May 01              001                         aaa May 05              087                         aaa May 02              055                         bbb May 09              001                         bbb May 05              002                         ccc May 06              002                         ccc May 07              055                         ccc May 06              002                         ddd May 07              055                         ddd May 01              001                         eee May 05              087                         eee   Client_Name now has ddd and eee as new clients which weren't there before. So I want to create a table which will have information for these new clients which I have added, so that the table looks like following   May 06              002                         ddd May 07              055                         ddd May 01              001                         eee May 05              087                         eee   Any advice on how I would go about this? Thanks in advance! ... View more

Hello I have a data set which has a variable ID with the client ID. I want to identify the fifth occurrence of that ID. For example if my data set looks like this I want to populate a variable called "INDICATOR" which will populate a value of 1 on the fifth occurrence. I know of the function first where I could use first.ID to do this for the first time the ID shows up, but is there a fifth function as well? Thanks in advance!   ID      NAME INDICATOR 001    apple 001    apple 001    apple 001    apple 001    apple    1 023    bb 023    bb 023    bb 023    bb 023    bb        1   ... View more