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
- 7859 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 can you create a macro variable with in data step? : sas-macro
what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming
Enlist the functions performed by sas.
what do the sas log messages "numeric values have been converted to character" mean? : Sas programming
What is the use of divide function?
what is sas metadata repository? : Sas-bi
Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma
For what purpose would you use the RETAIN statement?
how will you locate the sas platform applications? : Sas-bi
What do the mod and int function do? : Sas programming
How would you define the end of a macro? : sas-macro
If a variable contains letters or special characters, can it be numeric data type?
If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?
What can you learn from the SAS log when debugging?
What are the 3 components in sas programming?
