SAS ACCESS to ODBC/Proc SQL

user24feb — Fri, 08 Aug 2014 10:10:48 GMT

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?

Re: SAS ACCESS to ODBC/Proc SQL

stat_sas — Fri, 08 Aug 2014 10:46:36 GMT

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

topic Re: SAS ACCESS to ODBC/Proc SQL in SAS Programming

SAS ACCESS to ODBC/Proc SQL

Re: SAS ACCESS to ODBC/Proc SQL