So, I contacted SAS Support and they provided a solution... I looked through our database and found some old tracks where sites had to query Table Value Functions passed to the database and it looks like the only way this can work is to use PROC SQL explicit pass-through syntax. I've included a link below to the section of documentation that discusses this method of connecting to databases via the SAS/ACCESS Interface to ODBC engine. I also attempted to modify the basic syntax in this documentation with your specifics. I think the query below should work with one modification. You'll have to find the schema associated with the table in the database and replace schema with the actual schema name. Explicit pass-through passes native database syntax over to the database for processing. Since you have to reference tables with schema.tablename syntax in the database, this also needs to be used in when passing the query over from SAS: SAS/ACCESS to ODBC explicit pass-through documentation: https://go.documentation.sas.com/?docsetId=acreldb&docsetTarget=p1f29m86u65hken1deqcybowtgma.htm&docsetVersion=9.4&locale=en proc sql;
connect to odbc (NOPROMPT=&DB READBUFF=100);
create table TableAsOf_Jan162020 as
select * from connection to odbc
( select * from Schema/Libname.TableNameAsOf('2020-01-16 08:00:00') );
quit; Hope that helps anyone else in the same problem.
... View more
