Hello We are having SAS Viya 4 (Release 2023.10) running on AWS. I have executed the following code in SAS Studio. I see that a table is created but no data is pulled.
79
80 proc sql;
81 connect to ODBC as AWS(dsn='smDSN' user='username' password=xxx );
82 create table test as
83 select *
84 from connection to AWS(
85 select *
86 from dbTest.TableA
87 where myVar = '1-Jan-24')
88 ;
NOTE: Table WORK.TEST created, with 0 rows and 254 columns.
89 disconnect from AWS;
90 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 2.50 seconds
cpu time 0.07 seconds
Running the same code on SAS 9.4 pulls more than a million rows.
NOTE: Table WORK.TEST created, with 1731330 rows and 254 columns.
Wondering if there is a different way of doing this in Viya 4 ? Requesting guidance from the community.
... View more
