Date:         Wed, 15 Aug 2007 15:53:32 GMT
Reply-To:     "Kenneth M. Lin" <kenneth_m_lin@SBCGLOBAL.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Kenneth M. Lin" <kenneth_m_lin@SBCGLOBAL.NET>
Organization: SBC http://yahoo.sbc.com
Subject:      Re: SAS functions not available in Proc SQL
Comments: To: sas-l@uga.edu

That's what makes SAS so magical.  The documentation is so long tand
unsearchable hat often you have to find things out by trials and errors.

<jontugman@yahoo.co.uk> wrote in message
news:1187190507.523821.311970@50g2000hsm.googlegroups.com...
> In the Standard SAS Help:
> SAS DATA Step Functions
> PROC SQL supports all the functions available to the SAS DATA step,
> except for LAG, DIF, and SOUND.
>
> And yet when I tried the new SAS v9 function VValue in SQL I got:
> ERROR: The VVALUE function is not supported in PROC SQL, it is only
> valid within the DATA step.
>
> But Where can I find a list of what functions are supported? Not from
> SAS help. There is no reference in the help for VValue, or Proc SQL to
> this error.
>
> I have searched this group - not found in current history - so if
> posted before please refer me to the link.
>
> Not in SAS Support or SAS Notes
>