cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Amicheals
‎12-31-2018
  • 5 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Sas drop teradata table issues

by Calcite | Level 5 in New SAS User
‎12-28-2018 09:34 AM
‎12-28-2018 09:34 AM
Jan,   Thank you. I am getting the following error when trying to run that code   Required operator not found in expression: sysfunc(exist(tdlib.DataLoad))   any ideas? ... View more

Re: Sas drop teradata table issues

by Calcite | Level 5 in New SAS User
‎12-27-2018 12:03 PM
‎12-27-2018 12:03 PM
Jan One last question. In that code you sent me above. What If I just wanted to drop the table regardless if there is data in it. So check for DataLoad, if exists drop otherwise move to next step. Sorry to throw a wrench into it ... View more

Re: Sas drop teradata table issues

by Calcite | Level 5 in New SAS User
‎12-27-2018 11:25 AM
‎12-27-2018 11:25 AM
Jan,   is there a way to add something into that proc sql so if the table does not exist it just moves on to the next step? ... View more

Re: Sas drop teradata table issues

by Calcite | Level 5 in New SAS User
‎12-27-2018 10:19 AM
‎12-27-2018 10:19 AM
-Jan I spoke to soon, I can use a proc sql statement. ... View more

Sas drop teradata table issues

by Calcite | Level 5 in New SAS User
‎12-27-2018 09:33 AM
‎12-27-2018 09:33 AM
Greetings,   I have a table in Teradata named DataLoad. It has two columns, LoadID and EmpAI   I am trying to create a simple script that will check the table DataLoad and see if it has any rows inside it, If it does it does nothing, if there is no data in the table it drops it. Any suggestions on how to achieve this? ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎12-31-2018 09:55 AM
Quick links