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
- 7885 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 |
What is the purpose of trailing @ and @@? How do you use them?
what is the difference between %put and symbolgen?
Mention what is the difference between nodupkey and nodup options?
AE datasets names? how many types?
Name types of category in which SAS Informats are placed?
If i doest required Cumilative frequency in my table, generated by using PROC FREQ what i had to do?
what is conditional processing?
How is character variable converted into numeric variable and vice versa?
Why double trailing @@ is used in input statement?
In the flow of DATA step processing, what is the first action in a typical DATA Step?
what techniques and/or procs do you use for tables? : Sas programming
what is enterprise guide? What is the use of it? : Sas programming
Teradata 
