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
- 7858 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 the need of INDEX in datasets?
Why and when do you use proc sql?
Describe 5 ways to do a “table lookup” in SAS?
In sas admin differentiate between roles and capabilities? : sas-grid-administration
Compare sas with other data analytics tools.
What are the criticality that you have faced during your project in SAS?
We want to merge file A and B. File A has variable age, file B provide birthdate. How to merge the data according to age in file B
Please write codes to merge two datasets and keep every record in the first dataset.
What is a put statement?
name some data transformation used in sas di? : Sas-di
One way of creating a new variable in Macros is by % Let....What is the other way..?
I have 2 data sets A & B. Both have a variable called Age in them, each of them specifying a different functionality. In my program I use bot these data sets. How do I specify which Age variable I want to use?
Teradata 
