How could i automate the code in the scenario:Every month
one new data set will be created for that perticular month
transaction list.Now i would like to update the data in the
source table by appending every month data automatically.
jan---set jan;
feb---set jan feb;
mar---set jan mar;
- 2 Answers
- 7086 Views
- HSBC, I also Faced
- E-Mail Answers
Answer Posted / naresh
%macro update_table(demo1)
%let X = "JAN,FEB,MAR,APR";
%do i = 1 %to 4
%let y = scan(&x,i,',');
data &Master_table;
update &Master_table &y;
by acc_id;
run
%let i = %eval(&i+1);
%end;
%mend update_table;
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the role of unrestrictive users? : sas-grid-administration
what is factor analysis? : Sas-administrator
what is information maps?
What are the advantages of using sas?
Describe what are the different levels of administrative users in sas? : sas-grid-administration
What do the PUT and INPUT functions do?
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??
What areas of SAS are you most interested in?
how will you location sas platform applications available from web browser? : Sas-bi
how do you test for missing values? : Sas programming
What are the functions used for character handling?
What does proc print, and proc contents are used for?
how will you locate the sas platform applications? : Sas-bi
What are the statements in proc sql?
