Hi,
We have resorted to FCMP+Format approach on several occasions with some of our customers, I know for certain that it works in SAS MA.
I'm somewhat surprised that for a very simple use case like yours (lead zero padding), isn't there a proper built-in format in SAS, did you look well? Like Zx. (Z10.)?
But since as you say the this code-driven format already works for you in SAS EG but doesn't work through an Information Map, I would first check if "option cmplib" (and option fmtsearch) is being executed within SAS Workspace Server and SAS Pooled Workspace Server context by default.
The proper way to make it happen would be in WorkspaceServer/autoexec_usermods.sas, PooledWorkspaceServer/autoexec_usermods.sas and StoredProcessServer/autoexec_usermods.sas.
Then restart an Object Spawner after the change.
WorkspaceServer is what is being used when you test the infomap from SAS Information Studio, and I think it is also occasionally used by SAS MA (may depend on a version). PooledWorkspaceServer is normally used by SAS MA for most sql queries. Depending on your use case, you may also need it in the Stored Process Server context for SAS MA. So I suggest to put it into all 3 autoexecs.
If not for that, then maybe try to rename both a format and a function to shorter names, not to exceed 7-8 characters...
Hope it helps!
-------
Dmitriy Alergant, Tier One Analytics