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
- 7909 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 does sas handle missing values in assignment statements? : Sas programming
Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?
How will you generate test data with no input data?
hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?
What is Linear Regression?
What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?
What system options would you use to help debug a macro? : sas-macro
what is sas olap server? : Sas-di
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
Intern stastical programmer written test
how does sas handle missing values in functions? : Sas programming
Explain by-group processing?
What is a macro routine?
what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming
what do the pad and dim functions do? : Sas programming
