When using the "metaout" option in SAS on a SQL database views, behavior varies based on the option: With "metaout=ALL," use "exist(view)" to get true. Example: data _null_;
rc = libname("jb_dw", "", "META", "liburi=""SASLibrary?@libref='jb_dw'"" metaout=ALL");
if rc ne 0 then do;
put rc=;
put ms=;
end;
run;
%put exist=%sysfunc(exist(jb_dw.BANKDAGE_STAMOPL)); *false;
%put exist_view=%sysfunc(exist(jb_dw.BANKDAGE_STAMOPL,view)); *true; With "metaout=data," use "exist" (without "view") to get true. Example: data _null_;
rc = libname("jb_dw", "", "META", "liburi=""SASLibrary?@libref='jb_dw'"" metaout=data");
if rc ne 0 then do;
put rc=;
put ms=;
end;
run;
%put exist=%sysfunc(exist(jb_dw.BANKDAGE_STAMOPL)); *true;
%put exist_view=%sysfunc(exist(jb_dw.BANKDAGE_STAMOPL,view)); *false; Can anybody explain this behavior?
... View more
