Hi, I have a dataset which contains unique records based on a client id. For example: Client ID Location Employment Status Year 1 Metro Unemployed 2001 1 Remote Employed 2002 1 Metro Employed 2003 2 Metro Employed 2003 2 Metro Employed 2003 3 Remote Employed 2003 3 Remote Employed 2003 3 Remote Employed 2003 Now,using client id = 1 as the example, it shows a discrepancy in the outputs for Location and Employment Status. What I am trying to achieve is a consistent output for these variables based on some conditions. The first condition would be that the client id has to be consistent (i.e. so that it is only looking at records that contain that particular client id. The second condition would be simply be "if any of the outcomes for Location = Remote, then all outcomes for this particular client id would = remote (i.e. the 2 outcomes that = "metro" would be overwritten with "remote". The second condition is not the problem I am having, it is the first condition whereby the "if else statement" that I will use for the second condition needs to be based on the the client id being the same in all records that are to be used to execute this calculation. I have searched the forums but am unable to find what I am looking for. I am a new user so hopefully I have explained myself well enough? Many thanks Cam
... View more