Date:         Wed, 5 Apr 2000 20:42:01 PDT
Reply-To:     wei cheng <cheng_wei@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         wei cheng <cheng_wei@HOTMAIL.COM>
Subject:      Re: getoption function can not be used in proc sql?
Comments: To: ya.huang@AGOURON.COM
Content-Type: text/plain; format=flowed

Did you try getoption(fmtsearch)?

>From: Ya Huang <ya.huang@AGOURON.COM>
>Reply-To: Ya Huang <ya.huang@AGOURON.COM>
>To: SAS-L@LISTSERV.UGA.EDU
>Subject: getoption function can not be used in proc sql?
>Date: Mon, 3 Apr 2000 15:02:49 -0700
>
>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

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com