Hi Learner_sas, When I had a similar issue, support gave me the following tip and it worked for me The problem you mention could occur due to incorrect setting of default metadata server, to configure the same, you can start Integration Technologies configuration wizard from Start menu > Programs > SAS > Utilities > SAS Integeration Technologies Configuration (on the client machine where you use EG from) Click on "Configure Default SAS Metadata Server > Clear Settings  > Finish. Regards Jeroen. ... View more

Hi DevNand, I did not really try to understand your code, But this is an (untested) way to loop over some procs. HTH Jeroen. BTW I have some troubles formatting these messages . So sorry for that. proc sql; create table driver as select Query_ID , DB2_Query , TD_QUery from test123 ; quit; %macro do_it(Query_ID, DB2_Query, TD_QUery); proc sql NOERRORSTOP EXEC; connect to db2 as db2 (connection parameter) create table work.db2_&Query_ID as select * from connection to db2 (&DB2_Query ) ; connect to teradata as td (connection parameter); execute(<There seems to be missing a teradata query id here>) by td; create table work.td_&Query_ID as select * from connection to td (&TD_QUery) ; quit; PROC SORT DATA=chase.db2_&Query_ID OUT=chase.db2_sort_&Query_ID; BY _all_; RUN; PROC SORT DATA=work.td_&Query_ID OUT=work.td_sort_&Query_ID; BY _all_; RUN; ods listing; proc compare base=work.db2_sort_&Query_ID compare=work.chase.td_sort_&Query_ID; run; /* Delete your files here */ ods tagsets.excelxp close; ods listing close; %mend; data _null_; set driver; call execute ('%do_it (' !! Query_ID !! ',' !! DB2_Query !! ',' TD_QUery !! ');'); run; ... View more

Hi Ghastly_Kitten, I did try it out. I updated the dynamic table with only the value that I wanted. Enterprise Guide will show a dropdown box with nothing selected initially; if you open the list you will only see that value that exists in the table. So that means you still have to click 30 times, but you don't have to think . Another problem is that several users could potentially run the same stored process with different values. So a real solution should be on the client side and not on the server side. Thanks again for your answers ... View more

Hi ghastly_kitten, Thanks for your answer, I could see it working by making sure that the data source would have only one value (The one with my initial value). But would this also work for numeric prompts? And if I would like to give the user the option of changing the value for a list prompt, how would that work. Is it possible to dynaically define the default value for a dynamic list? Thanks Jeroen ... View more