I was given a program (written by someone else) to run.  My SAS/SQL skills are beginner-intermediate.  I have never worked with WITH and CAST functions before.  When I tried to run this program, it would take hours until it times out.  I put the option to bring back only 10 OBS - theoretically it shouldn't take long. Thoughts?  It seems like the program is running in loops OPTIONS OBS=10; OPTIONS COMPRESS=YES;   proc sql;   connect to teradata(database=xyz tdpid=edwprod user=xxxx password="xxxx");   create table agent as select *  from connection to teradata (   WITH ahist (contact_id, duration, account_id, per_num) as   (   SELECT distinct   ahist.contact_id,   ahist.duration,   ahist.account_id,   ahist.per_num   FROM acct_data ahist   where ahist.per_num = 6368   )   SELECT   ecm.cl_tid,   ahist.account_id,   ahist.duration,   agent.ecmcontact_id,   agent.per_num,   agent.user_role_dsc,   agent.start_ts,   artf.create_ts,   note.history_key_nm,   cast(agent.start_ts as date) as emp_date   FROM ecmcontact agent   join ahist   on ahist.contact_id=agent.ecmcontact_id   and ahist.per_num=agent.per_num   left outer join ecm_account ecm   on ecm.account_id=ahist.account_id   left outer join ecmartifact artf   on ahist.contact_id=artf.contact_id   and ahist.per_num=artf.per_num   left outer join citiecmnote note   on ahist.per_num=note.per_num   and note.ecm_artifact_id = artf.ecmartifact_id   ORDER BY ecm.cl_tid, artf.create_ts   );   quit; ... View more

I have two tables.  Table 1 is a list of IDs (eval_rl_id).   Table 2 is a list of queues and the rules that work in those queues. I want to combine tables 1 and 2 to get table 3.  I tried to join them in this order: eval_rl_id left join rule_id1 eval_rl_id left join rule_id2 eval_rl_id left join rule_id3 eval_rl_id left join rule_id4 eval_rl_id left join rule_id5 The results were many-many, which is incorrect. I tried merge : that too did not work for me. Proc Sort data=book2; by eval_rl_id; run; Proc Sort data=queue_rsn_rule_id_mapping; by rule_id1; run; data rule1; merge book2 (rename=(eval_rl_id=rule_id1)) queue_rsn_rule_id_mapping;   by rule_id1;   run; ************************************ table 3 EVAL_PRITY_CD EVAL_RL_ID eval_description Total Applications queue1 queue2 queue3 queue4 queue5 2100 4703 Description1 31 123 456 789 1152 4709 Description2 22 789 3600 5102 Description3 20 123 789 table1 EVAL_PRITY_CD EVAL_RL_ID eval_description Total Applications 2100 4703 Description1 31 1152 4709 Description2 22 3600 5102 Description3 20 table 2 queue dcsn_by priority_cd rule_id1 rule_id2 rule_id3 rule_id4 rule_id5 Total 123 emp1 2150 4703 15005 5102 (blank) (blank) 4 456 emp2 19000 2876 4703 (blank) (blank) (blank) 1 789 emp1 19000 4709 4703 5102 (blank) (blank) 3 etc... ... View more