Hello everyone,
i am working on Mergers and Acquisition. I have a variable named "Acquirer Name" which are the names of the acquirer companies. Some acquirers names appears more than one time in the list. I need to create two dummy variables named "First Time Acquirers" and "Serial Acquirers". The acquirers will be code 1 under serial acquirers which have more than one acquisitions and 0 for other wise. Same for the First time acquires the dummy will be coded 1 for first time acquirers and 0 for otherwise. Thanks