Hello, I have a set of tables in two libraries. I need to create these tables in a work library. So basically let's assume I have the following: lib1.table_a lib1.table_b and so on lib2.table_a lib2.table_b ... Desired Output: Work.Lib1_table_a Work.Lib1_table_b Work.Lib2_table_a Work.Lib2_table_b what have i done so far is: %let Lib = Lib1.; %let table = table_a; data &table; set &Lib&table; run; What I need to do is: Macro should simply read the data from ANY DATASET in source library and then output the TARGET table which is an exact copy of the SOURCE table, but its name was passed using %let statement (which I think I've done) Macro that includes “do while” statement application. The program should produce output when %let statement is set to YES, otherwise it should output error message in the log. I am not fluent in the loop subject so plain language would be highly appreciated. Thank you Regards
... View more