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
- 8010 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 does sas handle missing values in functions? : Sas programming
In SAS explain which statement does not perform automatic conversions in comparisons?
i want to upload titles and footnotes to excel file?how it is possible?
what is transformation in sas data integration? : Sas-di
What is the difference between %local and %global? : sas-macro
WHAT IS DEBUGGING? HOW TO TEST THE DEBUGGING IN SAS?
What is the work of tranwrd function?
In PROC PRINT, can you print only variables that begin with the letter “A”?
What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?
what is enterprise guide? What is the use of it? : Sas programming
what is treatment emergent events and treatment emregent adverse event
Have you been involved in editing the data or writing data queries?
1 Answers BioServe, Oracle, Sasken,
Teradata 
