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.
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.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.