To mount an MPXV7002 pressure sensor (SMT) on a PCB, it has to be raised above the board by about 3 mm to allow the plastic tubing to be attached to the pressure ports. This is an 8-pin device that normally surface mounts with the ports off the end of the board, however, restrictions dictate the ports (that are at the level of the bottom of the device case) have to be within the board. Thus the need for a way to elevate the sensor with something conductive that will surface mount to the board (or through hole) and allow the sensor to surface mount to it. Is there such an item available, other than standard straight male pin headers?
Mount at Edge - probably the most sensible option is to simply mount the part at the edge of the board. This way the ports overhang the edge of the board and you don't need to worry about height. You could also mount at the edge of a slot in the board for the same effect.
SOIC to DIP Adapter - You can get SOIC to DIP adapters (or make one) which basically are a small PCB with pin headers for plugging in to a DIP IC socket. You would solder your sensor to the adapter so that the ports overhang the edge of the adapter PCB. Then you can position a DIP socket anywhere on your board and plug in the adapter. This will give the required height clearance. You don't necessarily have to use a DIP socket, if you design your own adapter you can use any board to board connector you want.
You could design something like this:
Cable Mount - Pretty similar to option (2). You have an adapter board with the sensor mounted on it. You then attach a cable to the adapter so that you can position your sensor at a useful place in whatever enclosure your design is put in.