Endless running of code

anandmgjsa — Wed, 05 May 2021 17:51:14 GMT

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.

Re: Endless running of code

Kurt_Bremser — Wed, 05 May 2021 18:06:20 GMT

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.