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;
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);
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?
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.