Hi,
Has anyone used this option in 9.1.3? I'm trying to gain insight into a pass-through statement going to Oracle. I put the following in front of the Proc sql statement:
options sastrace=’,,d,’ sastraceloc=saslog nostsuffix;
and got back the following error:
ERROR: Invalid option value ’ for SAS option TOKEN_INVALID,YYRTOK.
61 ,,d,’ sastraceloc=saslog nostsuffix;
The SAS System
_
180
ERROR 14-12: Invalid option value ’ for SAS option TOKEN_INVALID,YYRTOK.
ERROR 180-322: Statement is not valid or it is used out of proper order.
Thanks!
--Ben
I've never used the option, but your statement appears to have one less comma than the statement shown in at least the 9.2 documentation. i.e.,
options sastrace=',,,d' sastraceloc=saslog nostsuffix;
This is actually running under 9.1.3, so it may have changed going to 9.2. The different values (according to page 273 of the SAS/Access for Relational Databases (9.1.3) are:
’,,,d’
’,,d,’
’,,,sa’
’,,t,’
off
I picked the first one.
--Ben
I don't know if it makes a difference but, if you look closely at the documentation, there is a space right after the initial quotation mark. i.e., ' ,,d,'
options sastrace=’,,d,’
I think you are copying the code and pasting in the code window. I dont mean its wrong. I mean just hard code quotation marks like ' '
Make sure once you pasted the code remove your single quotes and type again.
I agree with sassharp! I don't know if the leading space makes a difference, or not, but both of the following executed for me without error:
options sastrace=',,d,' sastraceloc=saslog nostsuffix;
options sastrace=' ,,d,' sastraceloc=saslog nostsuffix;
But it sure would be nicer if code shown in the documentation could ALWAYS simply copied and pasted. Unfortuanately, it isn't, especially with respect to quotation marks.
Hi,
Found the issue: the SAS docs use single quotes in their examples; using double quotes resolved the syntax problem.
I'm not sure if this is an issue with the install locally or something else. Very strange.
Thanks very much for your help!
--Ben
I think even single quotes also works. But you need to type single quotes from your key board instead of copying the code from some where else.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.