Help using Base SAS procedures

what is the meaning of this SAS option?

Reply
Regular Contributor
Posts: 222

what is the meaning of this SAS option?

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

PROC Star
Posts: 7,472

Re: what is the meaning of this SAS option?

Posted in reply to Mike_Davis

According to the documentation,

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

PROC Star
Posts: 1,322

Re: what is the meaning of this SAS option?

Posted in reply to Mike_Davis

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...

PROC Star
Posts: 7,472

Re: what is the meaning of this SAS option?

Quentin,

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

PROC Star
Posts: 1,322

Re: what is the meaning of this SAS option?

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.

Ask a Question
Discussion stats
  • 4 replies
  • 455 views
  • 0 likes
  • 3 in conversation