Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8015 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 do the put and input function do?
What are the five ways to do a table lookup in sas? : sas-grid-administration
how do you want missing values handled? : Sas programming
What do you code to create a macro? : sas-macro
What’s the difference between var b1 – b3 and var b1 — b3?
how to read the variables in sas? : Sas-administrator
Explain the special input delimiters used in sas programming.
what is enterprise guide? What is the use of it? : Sas programming
What is the difference between proportion and average?
How does the internal authentication work in sas? : sas-grid-administration
Give e an example of..
Difference between nodup and nodupkey options?
what do you mean by data staging area? : Sas-di
What are the new features included in the new version of SAS Programming Language?
how will you locate the sas platform applications? : Sas-bi
