Adding format catalogs without losing others


As I mentioned when creating a user-defined format for Information Maps in a prior post custom or user-defined formats can be created and stored quickly in the default format catalog for all Business Intelligence products within "Lev1\SASApp\SASEnvironment\SASFormats".

This is useful for custom sorting, reclassifying or grouping data as well as a bunch of other tricks.
Define a custom sort order for Web Reports or OLAP Data
Filter on Missing Values in Web Reports

Well the thing is if you decide to create another location for your format catalogs and use the example I provided in that prior post, then you lose the ability to use the default format catalog in "Lev1\SASApp\SASEnvironment\SASFormats".

If you would like to use both locations included is the code for Lev1\SASApp\sasv9_usermods.cfg.

-set fmtlib1 "E:\sharedformats"
-set fmtlib2 "C:\SAS\EBIserver\Lev1\SASApp\SASEnvironment\SASFormats"
-fmtsearch (fmtlib1 fmtlib2)

More information on the fmtsearch system option is available in the SAS Documentation.


About Author

Angela Hall

Senior Technical Architect

Angela offers tips on using the SAS Business Intelligence solutions. She manages a team of SAS Fraud Framework implementers within the SAS Solutions On-Demand organization. Angela also has co-written two books, 'Building BI using SAS, Content Development Examples' & 'The 50 Keys to Learning SAS Stored Processes'.

Related Posts

1 Comment

  1. OLAP is a high-end business intelligence software that is now finding a great use in business industries to produce accurate results and future reports.

Leave A Reply

Back to Top