Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Base Table not found?

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • #8010
      bungalowbill
      Member

      For some reason I am getting “base table not found” errors when I try to import SAS data via ODBC. The table is created, but no data is imported. It just errors out and says “base table not found.” I'm sure I am doing something stupid that is causing this. Any ideas? Could it be a SAS ODBC issue?

      -bungalowbill

    • #14464
      bungalowbill
      Member

      I think I have actually found the answer to my problem. SAS is trying to open the dataset in Work.tablename and SQLyog is only sending it the tablename. I need to send it libname.tablename, for example if I am trying to import a table called Facts, SAS tries to open Work.Facts and obviously can't find it since it is part of the library factdata and thus must be referred to as factdata.Facts for SAS to know where to find it. Looks like I am going to have to write a SQL query for this.

Viewing 1 reply thread
  • You must be logged in to reply to this topic.