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
- 7988 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
How we can create SAS USER DEFINED CODE?
What is the maximum and minimum length of macro variable
describe about physical data integration? : Sas-di
If a variable contains letters or special characters, can it be numeric data type?
what is operational data and operational system? : Sas-di
What is your favorite all time computer book? Why?
What are the new features included in the new version of SAS Programming Language?
How to create a permanent sas data set?
What are all the problems you faced while validating tables and reports?
What is substr function?
what do the pad and dim functions do? : Sas programming
How does proc sql work?
how does sas handle missing values in assignment statements? : Sas programming
What are types of transport files?
Can you execute macro within another macro? : sas-macro
