Date:         Tue, 25 Jan 2005 10:35:03 -0500
Reply-To:     harry.droogendyk@RBC.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Harry Droogendyk <harry.droogendyk@RBC.COM>
Subject:      Re: Accessing an Oracle table (or view) with a $-sign in its name
Content-Type: text/plain; charset=iso-8859-15

As the SAS-L post ( http://tinyurl.com/4bdjm ) appears to indicate, you must use the validvarname=any and the "blah$blah"n syntax together.

Please post your code.

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of Erik
M Rasmussen
Sent: Tuesday, January 25, 2005 10:26 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Accessing an Oracle table (or view) with a $-sign in its
name


Hi Harry Droogendyk

unfortunately that option does NOT work
with the $-sign :-(

Any other ideas ?

Kind Regards, Erik


In article <0E5377DC9E9CE34C98D7CDA4EE29154A01659E94
@SEW01070.maple.fg.rbc.com>, harry.droogendyk@RBC.COM says...
> There's also the "$trange name"n syntax.  See previous SAS-L post at http://tinyurl.com/4bdjm
>
>
> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of Erik
> M Rasmussen
> Sent: Monday, January 24, 2005 6:15 AM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: Accessing an Oracle table (or view) with a $-sign in its name
>
>
> Dear All
>
> normally I extract a table/view like below:
>
> libname Argus oracle SCHEMA=G001SCHEMA ORACLE_73_OR_ABOVE=YES
> READ_LOCK_TYPE=NOLOCK user=YYYYYY password=XXXXXX path='ZZZZZZ';
>
> libname her8 v8 '.' shortfileext;
>
> data her8.Data_From_Oracle;
> set argus.U$CASE_ACTIONS;
> run;
>
> And - it works beautifully ;-)
>
> But not with the view "U$CASE_ACTIONS" (shown above) as it seems
> that SAS do not like the $-sign in the view name.
>
> Changing the name of the Oracle view is NOT an option.
>
> Any good ideas ??
>
> Kind Regards, Erik M R
>
>
> ------------------------------------------------------------
>
> This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately.
>
> Ce courrier électronique est confidentiel et protégé. L'expéditeur ne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) désigné(s) est interdite. Si vous recevez ce courrier électronique par erreur, veuillez m'en aviser immédiatement, par retour de courrier électronique ou par un autre moyen.
>
> ============================================================
>


------------------------------------------------------------

This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately.

Ce courrier électronique est confidentiel et protégé. L'expéditeur ne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) désigné(s) est interdite. Si vous recevez ce courrier électronique par erreur, veuillez m'en aviser immédiatement, par retour de courrier électronique ou par un autre moyen.

============================================================