Hi Tom, I ran the query you sent me and I got results but with an error (proc sql; 25 connect to ODBC as teste 26 (noprompt = XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 27 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 28 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 29 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX); 30 31 create table work.mydata as 32 select * from connection to teste 33 ( select * from dbo.CutOffLegalPhases ('2017-01-01') ); NOTE: Compressing data set WORK.MYDATA decreased size by 84.70 percent. Compressed is 1432 pages; un-compressed would require 9362 pages. NOTE: Table WORK.MYDATA created, with 383834 rows and 32 columns. 34 execute ( dbo.CutOffLegalPhases('2017-01-01') ) by teste; ERROR: CLI execute error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '2017-01-01'. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 35 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 36.92 seconds cpu time 4.44 seconds
... View more