Date:         Mon, 3 Apr 2000 15:02:49 -0700
Reply-To:     Ya Huang <ya.huang@AGOURON.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ya Huang <ya.huang@AGOURON.COM>
Subject:      getoption function can not be used in proc sql?
Content-Type: text/plain; charset=us-ascii

Hi there,

According to online hlep:

PROC SQL supports all the functions available to the SAS DATA step,
except for
LAG, DIF, and SOUND.  Other SQL databases support their own set of
functions.

It does'nt seem to be true for getoption function, I tried the following
code and got
the error message:

proc sql;
select distinct libname, getoption('fmtsearch') as fmtpath
from dictionary.catalogs
;

ERROR 65-58: Name 'GETOPTION' is too long for a SAS variable name.

Other functions seems to be OK, for example substr()

Any thoughts?

Ya Huang