topic Re: what is the meaning of this SAS option? in SAS Procedures

what is the meaning of this SAS option?

Mike_Davis — Fri, 26 Oct 2012 16:54:26 GMT

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

Re: what is the meaning of this SAS option?

art297 — Fri, 26 Oct 2012 17:16:28 GMT

According to the documentation,

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

Re: what is the meaning of this SAS option?

Quentin — Fri, 26 Oct 2012 17:43:59 GMT

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#n0yx5o6hz6nts6n0zi844i9fsc2l.htm

Re: what is the meaning of this SAS option?

art297 — Fri, 26 Oct 2012 18:27:52 GMT

Quentin,

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

Re: what is the meaning of this SAS option?

Quentin — Fri, 26 Oct 2012 18:45:56 GMT

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.