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
How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?
What is the difference between one to one merge and match merge? Give an example.
If a variable contains letters or special characters, can it be numeric data type?
Hi, If anyone has base SAS certification dumps, please share.
What do the SAS log messages "numeric values have been converted to character" mean?
how the sas basic syntax style described? : Sas-administrator
what is the use of proc contents and proc print in sas? : Sas-administrator
What is a macro routine?
How you can read the variables that you need?
Explain data step in SAS
What is the differnce between SDTM 3.1.2 to 3.1.1 version
Describe the function and untility of the most difficult SAS macro that you have written.
What is the basic structure of a sas program?
Tell e how how dealt with..
what is PhaseIII, ODS, TLG, Macro and Proc in SAS