Dear SAS Users,   The version of SAS Studio that I use was recently upgraded to 3.6 (full details below) and it includes a very annoying 'feature' that automatically generates a close parenthesis every time I type an open parenthesis.  I cannot figure out how to turn it off.  I have already turned off 'hint' and 'autocomplete' (which are also very annoying) but cannot figure out how to remove this feature.  Please advise.   Thanks, Eric     Release: 3.6 (Basic Edition) Supported browsers: Microsoft Internet Explorer 11 Mozilla Firefox 21+ Google Chrome 27+ Apple Safari 6.0+ (on Apple OS X) Build date: Apr 20, 2017 3:45:50 PM SAS Mid-tier release: Apr 18, 2017 2:38:00 PM Java Version: 1.7.0_111 SAS release: 9.04.01M4P11092016 SAS platform: Linux LIN X64 2.6.32-696.3.2.el6.x86_64 Site name: ######## Site number: ####### Copyright © 2012-2017, SAS Institute Inc., Cary, NC, USA. ... View more

Dear SAS Community,   I am trying to get my output to print to the listing window instead of HTML.  I am using SAS 9.4 and I have set my preferences to revert back to the SAS 9.2 way of display (under Tools/Preferences uncheck "Create HTML", uncheck "Use ODS Graphics" and check "Create Listing".  Whenever I run a proc I get the "WARNING: No output destinations active." and no output anywhere. When I run   ODS LISTING; ODS LISTING SHOW; Proc Means data=sashelp.class;run;   I get this output: 1587  ODS LISTING; 1588  ODS LISTING SHOW; Current LISTING select list is set to default value (ALL). Current OVERALL select list is: ALL 1589  Proc Means data=sashelp.class;run; WARNING: No output destinations active.   How can I open output destinations?  I thought "PROC LISTING;" was supposed to do that.   Thanks, Eric ... View more

Hi SAS Community,   I am using SAS 9.4 and I (accidentially) closed ODS LISTING by doing "ODS _ALL_ CLOSE;" and now I can't get my output back.  I have done "ODS LISTING;" and it doesn't fix it; all proc statements run but nothing shows up in the results pane and nothing appears in the output window.  When I do "ods listing show;" I get this output:   2307  ods listing show; Current LISTING select list is set to default value (ALL). Current OVERALL select list is: NONE   Can anyone else help me?   Thanks, Eric ... View more

Hi SAS, I am trying to execute a PROC SQL query to a teradata database where I only pull data (I perform no computations) but I get this error: ERROR: Teradata row not delivered (trget): Numeric overflow occurred during computation. I am aware of this tip: http://support.sas.com/kb/31/658.html But as you can see from my code snippet below, I am using teradata mode.  The query works in Teradata SQL assistant.  How can I get it to work in SAS? Thanks, Eric proc sql;     connect to teradata (user=USERNAME password=PASSWORD             database=DATABASE server=SERVER mode=teradata connection=global);     create table alldata as select * from connection to teradata       (SELECT  distinct var1, var2...     ); disconnect from teradata; quit; ... View more