SAS ACCESS to ODBC/Proc SQL

Reply
Super Contributor
Posts: 336

SAS ACCESS to ODBC/Proc SQL

Hello,

I am trying to access data through SAS Access to ODBC using the little test program below:


Libname sqlserv ODBC Schema=DBO DSN=sassql;
Libname Daten "C:\Users\MyName\Desktop\xxx\Daten";

Proc SQL NoPrint;
  Create Table Daten.Query_1_Test As
  Select Sum(Quantity_OpenOrder_t_IsBillingNo) As Qty_OpenOrder_t Format=Commax15.3,
         KeyDate_Month_Key  
  From sqlserv.vFact_SalesOrder_DP 
  Where KeyDate_Month_Key in (201401)
  Group By KeyDate_Month_Key
  Order By KeyDate_Month_Key   
  ;
Quit;

The problem is that it yields different results when I run it at different times. The code runs without errors. The data is historical data. Is there a way to check if the SQL-procedure timed out or caused a different error that does not show in the log during execution?

Trusted Advisor
Posts: 1,203

Re: SAS ACCESS to ODBC/Proc SQL

Hi,

Not sure, seems like KeyDate_Month_Key picking something else in addition to 201401. Modify where clause and try this to see how it works.

Where KeyDate_Month_Key in (201401) and KeyDate_Month_Key is not null

Ask a Question
Discussion stats
  • 1 reply
  • 118 views
  • 3 likes
  • 2 in conversation