Prev: aggregate remaining obs /records SQL
Next: SAS optmization
From: allen scully on 19 Mar 2010 16:21
I'm trying to get some PL/SQL code to run in PROC DBLOAD - however the
code has the syntax 'exit when tr_pk%NOTFOUND'.
The presence of the % sign seems to cause some issues, as SAS is
reading it as some kind of Macro language. Wondering if there is
anything that can be invoked to have SAS ignore the % sign as any kind
of macro?
From: Tom Abernathy on 19 Mar 2010 19:21
On Mar 19, 4:21 pm, allen scully <allen.scull...(a)gmail.com> wrote:
> I'm trying to get some PL/SQL code to run in PROC DBLOAD - however the
> code has the syntax 'exit when tr_pk%NOTFOUND'.
> The presence of the % sign seems to cause some issues, as SAS is
> reading it as some kind of Macro language.  Wondering if there is
> anything that can be invoked to have SAS ignore the % sign as any kind
> of macro?

Depends on how you are passing the code.
If it is as a quoted string then use single quote characters instead
of double quote characters.
If not then macro quoting such as %str(%%) to protect the percent
characters.
 | 
Pages: 1
Prev: aggregate remaining obs /records SQL
Next: SAS optmization