Hi,   One of my SAS-users receives following error when executing her sas-code via command line (batch mode): ./sas + sas-file ERROR: The informat Z was not found or could not be loaded   The format "Zw" is a standard format (no informat as error indicates).  When executing her sas-code via EGuide then no ERROR received while error when via batch-mode.   I've checked the OPTION FMTSEARCH for EGuide (working fine) and batch mode (not OK) : Via EGuide : FMTSEARCH=( APFMTLIB WORK LIBRARY ) with APFMTLIB = SASEnvironment/SASFormats -> no files in this folder Via batch mode :  FMTSEARCH=(WORK LIBRARY)   What can be cause of this issue? Thanks.   FYI. snippet producing error :  proc Sql;                 create table &lib_tmp..&dataset_vat._entr as                     select distinct t1.*,                         t2.C_CODEENTRPSTATU_CODE,                         t2.D_I_INSCR_KBO as BeginDatumONKBO,                         t2.D_I_KBO_CLOT as EindDatumONKBO,                         t2.D_I_DEBUT as OprichtingsDatum,                         t2.D_I_CESS as BeeindigingsDatum                     from &lib_output..&dataset_vat.(where=(substr(put(C_I_ENTRP_NUM,z10.),1,1)^="2")) as t1                         left join &SITRAN..ENTREPRISE_ETABLISSEMENT as t2 on (t1.C_PERS_IDF=t2.C_PERS_IDF);             quit; ... View more

Hi,   I'm truying to create a dataset on a UNIX-folder which is available through a symbolic link. SAS-code snippet : libname TEST "/sas/prd/data/DIR_III_4/SHARE_INVORDERING/OUTPUT"; /*generates error*/ *libname TEST "/sas/prd/data/DIR_III_4/DIR_III_4"; -> works fine data TEST.JLSSET3; input name $ sales; datalines; Steven 40 Jurgen 100 David 150 ; Error generated : 26 libname TEST "/sas/prd/data/DIR_III_4/SHARE_INVORDERING/OUTPUT"; NOTE: Libref TEST was successfully assigned as follows: Engine: V9 Physical Name: /sas/prd/data/DIR_III_4/SHARE_INVORDERING/OUTPUT 27 *libname TEST "/sas/prd/data/DIR_III_4/DIR_III_4"; 28 data TEST.JLSSET3; 29 input name $ sales; 30 datalines; ERROR: User does not have appropriate authorization level for library TEST.   The UNIX-user 'sasdir34' who actually writes to this UNIX-folder (linked to WorkSpaceServer) can create files via command line on the folder without any problem. See UNIX-commands : -bash-4.4$ pwd /sas/prd/data/DIR_III_4 -bash-4.4$ ls -l total 14 drwxr-xr-x 12 sasdir34 sastusers 15 Dec 5 10:07 DCU drwxr-xr-x 49 sasdir34 sastusers 82 Dec 13 11:58 DIR_III_4 lrwxrwxrwx 1 sasdir34 sastusers 25 Nov 26 2012 SHARE_INVORDERING -> /sas/prd/data/invordering lrwxrwxrwx 1 sasdir34 sastusers 27 Oct 28 2010 Shared_Data_Preparation -> ../Shared_Data_Preparation/ -bash-4.4$ touch SHARE_INVORDERING/OUTPUT/testfile.txt -> file "test_file.txt" is created in SHARE_INVORDERING/OUTPUT   Any idea why a dataset can't be directly written to UNIX-folder -> via symbol link available?   PS. creating the dataset in WORK and then export to this folder does work : data work.JLSSET3; input name $ sales; datalines; Steven 40 Jurgen 100 David 150 ; proc export data=JLSSET3 outfile="/sas/prd/data/DIR_III_4/SHARE_INVORDERING/OUTPUT/JLSSET3.xlsx" dbms=xlsx replace; run; ... View more