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?
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.