Help using Base SAS procedures

sastrace option

Reply
Regular Contributor
Posts: 179

sastrace option

Hi,

Has anyone used this option in 9.1.3?  I'm trying to gain insight into a pass-through statement going to Oracle.  I put the following in front of the Proc sql statement:

options sastrace=’,,d,’ sastraceloc=saslog nostsuffix;

and got back the following error:

ERROR: Invalid option value ’ for SAS option TOKEN_INVALID,YYRTOK.
61                           ,,d,’ sastraceloc=saslog nostsuffix;
                                                The SAS System

                             _
                             180

ERROR 14-12: Invalid option value ’ for SAS option TOKEN_INVALID,YYRTOK.

ERROR 180-322: Statement is not valid or it is used out of proper order.

Thanks!

--Ben

PROC Star
Posts: 7,467

sastrace option

Posted in reply to BenConner

I've never used the option, but your statement appears to have one less comma than the statement shown in at least the 9.2 documentation.  i.e.,

options sastrace=',,,d' sastraceloc=saslog nostsuffix;
Regular Contributor
Posts: 179

sastrace option

This is actually running under 9.1.3, so it may have changed going to 9.2.  The different values (according to page 273 of the SAS/Access for Relational Databases (9.1.3) are:

’,,,d’

’,,d,’

’,,,s’

’,,,sa’

’,,t,’

off

I picked the first one.

--Ben

PROC Star
Posts: 7,467

sastrace option

Posted in reply to BenConner

I don't know if it makes a difference but, if you look closely at the documentation, there is a space right after the initial quotation mark.  i.e., ' ,,d,'


Frequent Contributor
Posts: 110

Re: sastrace option

Posted in reply to BenConner

options sastrace=’,,d,’

I think you are copying the code and pasting in the code window. I dont mean its wrong. I mean just hard code quotation marks like '  '

Make sure once you pasted the code remove your single quotes and type again.

PROC Star
Posts: 7,467

Re: sastrace option

I agree with sassharp!  I don't know if the leading space makes a difference, or not, but both of the following executed for me without error:

options sastrace=',,d,' sastraceloc=saslog nostsuffix;

options sastrace=' ,,d,' sastraceloc=saslog nostsuffix;

But it sure would be nicer if code shown in the documentation could ALWAYS simply copied and pasted.  Unfortuanately, it isn't, especially with respect to quotation marks.

Regular Contributor
Posts: 179

Re: sastrace option

Hi,

Found the issue: the SAS docs use single quotes in their examples; using double quotes resolved the syntax problem.

I'm not sure if this is an issue with the install locally or something else.  Very strange.

Thanks very much for your help!

--Ben

Frequent Contributor
Posts: 110

Re: sastrace option

Posted in reply to BenConner

I think even single quotes also works. But you need to type single quotes from your key board instead of copying the code from some where else.

Ask a Question
Discussion stats
  • 7 replies
  • 908 views
  • 0 likes
  • 3 in conversation