DATA Step, Macro, Functions and more

sas option fmtsearch

Reply
Super Contributor
Posts: 371

sas option fmtsearch

[ Edited ]

 

Hello,

Please, When I use the instructions :  put(v2, $frt2.) et

option fmtsearch = (lib1  lib2) ; It do not get any error message, but sas 9.4 does apply the instruction put(v2, $frt2.)

I still usually with the value v2. why ?

 

 

libname  lib1  "\rep1\format1";

libname  lib2  "\rep2\format2";

 

option fmtsearch = (lib1  lib2) ;

 

Proc sql;

 create table  test as

select v1,

         put(v2, $frt2.)

from toto;

quit;

 

 

 

 

 

 

Respected Advisor
Posts: 3,799

Re: sas option fmtsearch

Look at the documentation but I think you need to specify the catalog name if it is not formats.

 

options fmtsearch=(lib1.myfmts lib2.morefmts);

 

 

Super User
Posts: 5,497

Re: sas option fmtsearch

[ Edited ]

Can't test it right now, but might you need to specify where to put the result such as:

 

put(v2, $frt2.) as v2

 

Also worth checking:  are you expecting the FRT format to exist in LIB2 but it actually also exists (with a different definition) in LIB1?

Ask a Question
Discussion stats
  • 2 replies
  • 171 views
  • 2 likes
  • 3 in conversation