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
- 7236 Views
- HSBC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / satheesh
%macro sam (&mon);
data &mon1.;
set &mon.;
run;
proc append base = sav.appendData data = &mon.;
run;
%mend;
%sam(Jan);
%sam(Feb);
%sam(Mar);
| Is This Answer Correct ? | 1 Yes | 1 No |
how to delete the duplicates by using proc sql?
What is the difference between nodupkey and nodup options?
How to get top scorer student from a class-table having different sections A,B, C & D? Each section having same number of students.
Which is the Best SAS training Institute in Delhi NCR for SAS certification preparation
Describe the function and untility of the most difficult SAS macro that you have written.
what is syntax of proc merge ?
what are different type of sas servers ? On which server does the sas code execute ?
what is sas application server? : Sas-di
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
explain the main difference between the nodup and nodupkey options? : Sas-administrator
is QUALCOMM using SAS ?
What is the basic syntax style in SAS?
Teradata 
