158
edits
Changes
Jump to navigation
Jump to search
→Instructions on Matching PortCos to Issuers and M&As From Ed
\COPY makeysstd TO 'MAMatchInput.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV
--119374
Use this text file to match against the PortCoMatchInput. Your job will be to determine whether the matches between the MAs and PortCos are true matches. The techniques that I used are described in the section below.
===IPO Cleaning and Matching===
\COPY ipostd TO 'IPOMatchInput.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV
--11149
As with MA, match this file against the PortCoMatchInput file without mode 2. Then manually check the matches using the techniques described below.
I generally use MAX for amounts and MIN for dates. I also chose to use MIN on text strings.
