This is something I am working on: 1. I have a main dataset (A) on which I am applying filters to see the data that I have to edit manually. 2. Once the filtered datasets are created and I have edited the data manually in SAS EG, I want to update the main dataset (A) with the values from the filtered datasets. For this I am sorting the filtered datasets and then using data step and update t1 t2. 3. I have written a macro with proc sort in it and I can call it 10 times for 10 datasets and run the data step and update ten times to update the values. I believe we can call a macro on an array. These are the steps I tried 1. I created a dataset tbl_names containing the table names, tried to create an array tbl_list and then call the macro in a do loop but it did not work. %macro st(ds); proc sort data = &ds; by address_line_1; run; %mend; data tbl_names; input tbl_names1- tbl_names10 (: $35); datalines; t1 t2 t3; run; I used an example to define the above dataset tbl_names but this statement (input tbl_names1- tbl_names10 (: $35);) is currently not working. data _null_; set tbl_names; array tbl_list[*] tbl_names1- tbl_names10; do i=1 to dim(tbl_list); %st(tbl_list(i)); end; run; Parts of this code may not be working, I tried to re write but I was not able to. The code is just to give a picture of what I am trying to achieve. Please let me know.
... View more
