topic Re: proc sql connect to aster on 9.4 M6 in SAS Programming

proc sql connect to aster on 9.4 M6

avinashginjupal — Thu, 02 Apr 2020 10:23:49 GMT

we are trying to run below code on our 9.4 M6 environment

proc sql;
Connect to aster (server="xxxxx.xxxxxx.xxx" database="XXXXXXX" user="&Aster_id" password="&Aster_pwd");
Create table Aster1 as select * from connection to aster
(
select *
from
lim_koy_cmf.stoplist
limit 10
);

disconnect from aster;
quit;

and facing below error

ERROR: PROC SQL requires any created table to have at least 1 column.

Where same code is working fine in our other 9.4 M3 environment. Can I get some assistance in getting this fixed?

Re: proc sql connect to aster on 9.4 M6

AhmedAl_Attar — Thu, 02 Apr 2020 11:28:48 GMT

You will be better off calling SAS Tech Support for such request

Re: proc sql connect to aster on 9.4 M6

AnandVyas — Thu, 02 Apr 2020 12:25:45 GMT

I just checked the configuration for SAS/Access to Aster and it uses ODBC driver to make a connection. By any chance is there any difference in the ODBC configuration?