08-08-2014 06:10 AM
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,
Where KeyDate_Month_Key in (201401)
Group By KeyDate_Month_Key
Order By KeyDate_Month_Key
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?
08-08-2014 06:46 AM
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