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
- 7985 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 portability of sas programmes?
What is the difference between SAS functions and procedures?
What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?
What is data _null_?
We have a string like this "kannafromsalembut" ,from this i want to get only "fromsal" (but one condition with out using substring function)here we can not use scan because in the given string there is no delimeter? so give ans without out using substring ?
Explain the difference between using drop = data set option in set and data statement?
In the flow of DATA step processing, what is the first action in a typical DATA Step?
how to generate means for every subject;
What are the difference between the sas data step and sas procs?
Does anybody have SAS Training manual or documentation or can you refer me any book to have better understanding on SAS. I am fresher to SAS tool. (Ready to pay)
which date functions advances a date time or date/time value by a given interval? : Sas programming
Name some categories in sas 9? : sas-grid-administration
Teradata 
