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
According to the documentation,
The NO$STSUFFIX system option formats the log to be more easily read.
Funny, I've been using that today to try to diagnose some Oracle query nightmares.
Looks like it's documented with sastrace:
Quentin,
It could also be the source of your nightmares. Take a look at: http://support.sas.com/kb/44/257.html
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.