topic sastrace option in SAS Procedures

sastrace option

BenConner — Mon, 05 Mar 2012 14:56:11 GMT

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

sastrace option

art297 — Mon, 05 Mar 2012 16:14:19 GMT

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;

sastrace option

BenConner — Mon, 05 Mar 2012 20:59:00 GMT

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

sastrace option

art297 — Mon, 05 Mar 2012 21:59:35 GMT

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

Re: sastrace option

sassharp — Mon, 05 Mar 2012 22:32:49 GMT

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.

Re: sastrace option

art297 — Mon, 05 Mar 2012 22:42:35 GMT

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.

Re: sastrace option

BenConner — Tue, 06 Mar 2012 14:58:56 GMT

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

Re: sastrace option

sassharp — Tue, 06 Mar 2012 15:13:39 GMT

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.