Help using Base SAS procedures

Reg:Appending

Reply
N/A
Posts: 0

Reg:Appending

Hi

i am having a dataset named Final. i am having a library named Reports,after the scheduling is completed there will be 5 datasets in that libarary(Reports).And i dont know the names of that datasets and they should be appended to final dataset .and it should be scheduled daily.
Super Contributor
Posts: 318

Re: Reg:Appending

Hi,

This might help you out. Probably this is not the best solution but this might give you some idea on how to do it. Regarding scheduling, in what OS are you?

/* data set that contains the name of the datasets*/
proc sql;
create table temp as
select memname from dictionary.tables
where libname='Reports';
quit;

/* append to final table */
%macro append2final(dsn=);
proc append base=final data=&dsn force;run;
%mend append2final;

/* loop through the table containing table names of the library Reports */
data _null_;
set temp;
call execute('%append2final(dsn='|| memname ||')';
run;

Best Regards,
Milton
Ask a Question
Discussion stats
  • 1 reply
  • 104 views
  • 0 likes
  • 2 in conversation