I have two data sets.
In data set 1 name vertical, I have the number of firms connected to each specific firm thus named connected.
In data set 2 name mee, I have the number of firms for my entire sample.
My problem: I was to obtain from the main data set named me, the firms that are not connected to firms in data set named vertical. Thus I was to skim through the mee data set using the column connected in data set vertical so that if for company id 3, any firms not on the connected column will be tagged as unconnected in another column.