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;
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 PROC gplot?
What is the difference between %local and %global? : sas-macro
Are you involved in writing the inferential analysis plan? Tables specfications?
Mention how to limit decimal places for the variable using proc means?
Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??
What are the applications primarily used by business analyst? : Sas-bi
what are sas/access and sas/connect? : Sas programming
What are the advantages of using sas?
What is PDV?
What do the PUT and INPUT functions do?
sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately
how to read the variables in sas? : Sas-administrator
Explain proc univariate?
How to read an input file in sas?
in the flow of data step processing, what is the first action in a typical data step? : Sas programming