About ToddS

ToddS · ‎04-19-2017

For those of us who could not make it to SGF, can we see what you presented?

ToddS · ‎09-21-2016

It turns out that my problem did not require the hotfix referenced. All I had to do was change the following option: Data > Performance > Maximum number of rows to display in the data grid with SAS/ACCESS data: > no limit I originally had it limited to 100,000 rows so the SQL generated added a limit of 100,000 but the Netezza Access code also added a limit 100,000 so the code would bomb. Now it works and the dataset opens.

ToddS · ‎09-14-2016

I am able to connect to a Netezza database using a libname statement. In the servers window I can see the tables in that library. I used to be able to double click on a table and it opened up in SAS. I am using EG 7.12. Now when ever I double click on a table I get the following error: SAS Enterprise Guide cannot open the data file: "NETSND.ADULT". [Error] CLI open cursor error: ERROR: 'SELECT * FROM AA_INZA_SND..ADULT LIMIT 10000 limit 10000' error found "LIMIT" (at char 46) expecting a keyword. So it sounds like the underlying code in repeating the limit statement twice. How do we fix that? The work around is to use Query Builder directly to create SQL code to view the data. But I rather go back to just double clicking! Any help you give me would be great.

ToddS · ‎04-06-2015

Thanks Chris! That worked like a charm. I never thought of looking there. I looked under project maintenance in tools but couldn't find anything.

ToddS · ‎04-03-2015

I am using SAS EG 7.1 and my project file has gottent too big. Now it will only open up in a notepad file. As a result I can't access the usual project log window in order to clear the project log. How do I clear a project log manually so I can go back to normal?