Endless running of code

[anandmgjsa]

Hi

when I am running the below code, it's running endless.Please help.

%let date_start = '2021-02-01';

%let date_end = '2021-04-30';

%let country = sg

proc sql;

%conximp(p_&country._eap_v,implink,db,dbmax_test = 30)

create table login_newas select * from conection to implink

(

select * 

from p_&country._eap_v.eap_event

where mis_date between &date_start and &date_end

)a;

quit;

but, when I ru the below code, it runs fine:

%let date_start = '2021-02-01';

%let date_end = '2021-04-30';

%let country = sg

proc sql;

%conximp(p_&country._eap_v,implink,db,dbmax_test = 30)

create table login_newas select * from conection to implink

(

select ccsid,mis_date

from p_&country._eap_v.eap_event

where mis_date between &date_start and &date_end

)a;

quit;

Only if i add select * , it runs endless.

Please help.

[Kurt_Bremser · Accepted solution]

How many columns does the table p_sg_eap_v.eap_event in your DBMS have?

SELECT * might lead to a serious observation size, and all that data has to be moved across the network.