I'm having issues with proc sql returning results from a view. When I execute the proc sql statement in teradata SQL assistant, rows are returned but inside of SAS it returns 0 rows. My SAS proc sql statement is basic : LIBNAME TD TERADATA tdpid = "xx.x" SCHEMA=myschema USER=USER1 PASSWORD="xxxxx" SQLGENERATION=DBMS ; Proc Sql; Select * from TD.mytable; Quit; Any thoughts on what is going on here. I've used this similar command successfully many times before on other views in the environment. Thanks!
... View more