create macros---you have 365 number of data and you need to
merge it throw the macros,,,,,,
data file1;
input a @@;
cards;
1 2 3 4
;
run;
data file2;
input a @@;
cards;
5 6 7 8
;
run;
data file3;
input a @@;
cards;
9 10 11 12
;
run;data file4;
input a @@;
cards;
13 14 15 16
;
run;
- 6 Answers
- 10650 Views
- WNS, I also Faced
- E-Mail Answers
Answer Posted / venkat
%macro merging(f,x);
%do i=1 %to %eval(&x-1);
data &f&n;
merge &f&n &f%eval(&i+1);
by a;
run;
%end;
%mend merging;
%merging(file,4);
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?
why is sas data integration studio important? : Sas-di
How does the internal authentication work in sas? : sas-grid-administration
what other sas products have you used and consider yourself proficient in using? : Sas programming
Give e an example of..
What do you know about symput and symget?
Did you used proc test? when?
How do dates work in sas?
describe how to adjust the performance of data integrator? : Sas-di
Explain the purpose of retain statement.
how can you create zero observation dataset? : Sas programming
How would you identify a macro variable?
what are the categories that sas informats are used to the place the data? : Sas-administrator
How we can call macros with in data step? : sas-macro
What is the difference between %put and symbolgen? : sas-macro
