Hello, I am pulling data from SQL server.
it takes about 1 hour when I use sas and about 3 mints using SQL server Management Studio. data comes back but takes ages to pull it using SAS
here is a sample code that I used to query... please advise
Proc SQL;
create table temp_A
as
select distinct a.number, b.type, c.country, d.city from R1.dbo.Tbl_Numbers a left join R1.dbo.Tbl_Type b on (a.ID = b.AcID) left join R1.dbo.Tbl_Country c on (a.CID = c.CID) left join R1.dbo.Tbl_City d on (a.ID = d.AcID) where dateDTTM >= '01Jun2016' and dateDTTM < '01Jun2017' and ( upper(b.Comments) like '%HOURS%' or upper(b.History) like '%HOURS%' or upper(b.Group) like '%HOURS%' ) and c.TCode = 3 and d.ACode in ('F', 'C') ;
Thanks
... View more