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
- 8001 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
explain the function of substr in sas? : Sas-administrator
Differentiate input and infile.
How to create a permanent sas data set?
what is the use of proc sql? : Sas programming
What is the basic structure of the SAS base program?
Explain data_null_?
Explain substr function?
What does the trace option do?
what is sas metadata repository? : Sas-bi
name some data transformation used in sas di? : Sas-di
what is the use of proc contents and proc print in sas? : Sas-administrator
What is the function of output statement in a SAS Program?
Explain the difference between using drop = data set option in set and data statement?
I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com
how do you want missing values handled? : Sas programming
