03-05-2012 09:56 AM
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
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.
03-05-2012 11:14 AM
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;
03-05-2012 03:59 PM
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:
I picked the first one.
03-05-2012 05:32 PM
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.
03-05-2012 05:42 PM
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.
03-06-2012 09:58 AM
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!