BookmarkSubscribeRSS Feed
avinashginjupal
Obsidian | Level 7

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?

2 REPLIES 2
AhmedAl_Attar
Ammonite | Level 13
You will be better off calling SAS Tech Support for such request
AnandVyas
Ammonite | Level 13
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?
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 929 views
  • 0 likes
  • 3 in conversation