BookmarkSubscribeRSS Feed
Mike_Davis
Fluorite | Level 6

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

4 REPLIES 4
art297
Opal | Level 21

According to the documentation,

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

Quentin
Super User

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

BASUG is hosting free webinars Next up: Jane Eslinger presenting PROC REPORT and the ODS EXCEL destination on Mar 27 at noon ET. Register now at the Boston Area SAS Users Group event page: https://www.basug.org/events.
art297
Opal | Level 21

Quentin,

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

Quentin
Super User

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.

BASUG is hosting free webinars Next up: Jane Eslinger presenting PROC REPORT and the ODS EXCEL destination on Mar 27 at noon ET. Register now at the Boston Area SAS Users Group event page: https://www.basug.org/events.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 1431 views
  • 0 likes
  • 3 in conversation