topic Re: fmtsearch in EG in SAS Enterprise Guide

fmtsearch in EG

andreas_zaras — Tue, 10 Mar 2015 10:11:40 GMT

Hello,

I have created a user defined format in Enterprise Guide and I saved it in a permanent library. I know from Base SAS that in order to tell SAS to search in a particular library so as to find a format we use the fmtsearch option. How can we apply the fmtsearch option using thew GUI?

Thank you very much in advance,

Andreas

Re: fmtsearch in EG

Kurt_Bremser — Tue, 10 Mar 2015 11:18:08 GMT

You can include the ftmsearch option in the custom code to be sent before the execution of a task, or in the custom code to be sent when a connection to a workspace server is established. Or you could include it in the autoexec_usermods.sas file in the configuration directory of the respective workspace server.

Re: fmtsearch in EG

andreas_zaras — Tue, 10 Mar 2015 11:24:31 GMT

Hello Kurt,

Thanks for your answer. I was wondering if we could tell SAS EG to search in a particular library for formats through the GUI without using any code. Any ideas?

Thanks again,

Andreas

Re: fmtsearch in EG

Kurt_Bremser — Tue, 10 Mar 2015 11:39:22 GMT

SAS IS code. EVERYTHING is done with code. Every task in EG is nothing but a code generator, and the code generated should be used as the starting pount for serious work.

Startup code is THE one means to automate SAS behaviour, and it is the place where you have to put your ftmsearch option. You just need to determine if you need it everytime for everyone using the workspace server (autoexec_usermods.sas, serverside) or just personally (then use custom code sent from EG).

Re: fmtsearch in EG

ChrisHemedinger — Tue, 10 Mar 2015 11:49:09 GMT

These blog posts might help as well:

http://blogs.sas.com/content/sgf/2014/05/01/autoexecs-the-sas-enterprise-guide-advantage/

And this one, for some context:

http://blogs.sas.com/content/sasdummy/2009/10/20/do-me-a-favor-stop-doing-me-favors/

Chris

Re: fmtsearch in EG

SASKiwi — Tue, 10 Mar 2015 18:38:21 GMT

If you store your permanent format in a catalog called LIBRARY.FORMATS (LIBRARY is usually one of the SAS automatically setup libraries) by using: proc format library = library, then you wont need FMTSEARCH as SAS looks in LIBRARY.FORMATS automatically.

Re: fmtsearch in EG

andreas_zaras — Wed, 11 Mar 2015 08:56:06 GMT

Thanks for your answer! It works! SA EG searches for formats in the library work and i the permanent library with the name library.

Thanks again,

Andreas