Help using Base SAS procedures

sastrace option

Reply
Regular Contributor
Posts: 169

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,363

sastrace option

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: 169

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,363

sastrace option

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

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,363

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: 169

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

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
  • 851 views
  • 0 likes
  • 3 in conversation