what is the meaning of this SAS option?

[Mike_Davis]

Hello all,

Could anyone explain the meaning of the following SAS option part for me? special for "no$stsuffix"

Thanks!

Mike

options sastrace = ',,,sd' sastraceloc = saslog no$stsuffix

[art297]

According to the documentation,

The NO$STSUFFIX system option formats the log to be more easily read.

[Quentin]

Funny, I've been using that today to try to diagnose some Oracle query nightmares.

Looks like it's documented with sastrace:

http://support.sas.com/documentation/cdl/en/acpcref/63181/HTML/default/viewer.htm#n0yx5o6hz6nts6n0zi...

[art297]

Quentin,

It could also be the source of your nightmares.  Take a look at: http://support.sas.com/kb/44/257.html

[Quentin]

Thanks Art,

In this case the nightmares started before I added STRACE.  I have a simple join that is running in a stored process.  Reading data from an oracle database, using a libref defined in the metadata that uses SAS/ACCESS to Oracle.

The stored process ran fine a week ago.  Now the join is crashing a "call tech support" segmentation error.

It's very much like http://support.sas.com/kb/20/460.html but I'm not using views (and I'm on 9.3).

What's driving me crazy is that it worked last week.  And now the join works if I run it from EG, works if I batch submit it , and works if I run the stored process on the workspace server.  So I think I'm going to have to ask the admin to just restart the stored process server, and see if that helps...

--Q.