There seems to be much more to this question...
In order to be able to export fields from multiple tables in the same export, one needs to control and fine-tune Information Map folder visibility level by subject levels (SUBJECT_ID_1=...). All data items required for the export (or the folders where they are located) need to be "visible" to the subject level of this export.
At the same time, having 9(!) subject levels in SAS MA seems like an unnecessary overcomplication. Out of several dozen SAS MA implementations that my team has seen, including some very complex ones, only one required this many subject levels (and that implementation was really unique in many ways).
Having 9 tables or star schemas the information map each representing a separate business entity is not unusual. But every table containing an entity (like a Sales Order) does not necessarily require a separate subject level to be defined. Quite a lot of things can be achieved just with infomapping the data and without introducing new subject levels, especially when Communications don't need to happen on that level;
Based on a few recent questions, it appears that the topic starter has embarked on a complex SAS MA implementation (with CDM, third-party integrations, complex data mart) and tries to self-navigate the entire process... That's great on one hand, but unfortunately it's too easy to screw up a SAS MA implementation on many levels (and only realize what was done wrong after a significant time comes by and end-users encounter issues, challenges, and limitations). Perhaps, the Topic Starter's company should consider engaging SAS services, or an experienced 3rd party partner organization to consult or assist in such an implementation...
-------
Dmitriy Alergant, Tier One Analytics