Date:         Mon, 12 Apr 2010 06:27:16 -0400
Reply-To:     Dimitri Shvorob <dimitri.shvorob@VANDERBILT.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Dimitri Shvorob <dimitri.shvorob@VANDERBILT.EDU>
Subject:      Checking if LIBNAME assignment failed

Can anyone suggest a test for a successful LIBNAME assignment that would
handle the case of a read-only (hence a test by attempting a write is
insufficient) ODBC source?

Thank you.

%let valid = 0;
libname mylib odbc dsn = "myodbc";
%LibnameStatus(mylib, valid);
%put &valid.;