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
- 7906 Views
- HSBC, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the use of the %include statement?
Mention how to limit decimal places for the variable using proc means?
What is the maximum length of the macro variable?
Compare sas with other data analytics tools.
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
How to read an input file in sas?
Intern stastical programmer written test
what is data access? : Sas-di
what is PhaseIII, ODS, TLG, Macro and Proc in SAS
What are the parameters of scan function?
what is hierarchy flattening? : Sas-di
In ARRAY processing, what does the DIM function do?
Differentiate between ceil and floor functions.
What is the difference between SAS functions and procedures?
what is the difference between unique key and primary key? : Sas-di
