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
- 10602 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
how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming
What are the limitations for memory allocation for SAS variables
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?
how many types prompting framework can be broken down to? : Sas-bi
Of all your work, where have you been the most successful?
What are the different servers in sas? : sas-grid-administration
What are the prime responsibilities of data integration administrator? : Sas-di
Explain bmdp procedure?
what is SAS OPTIMIZATION?
How you can read the variables that you need?
What are the differences between sum function and using “+” operator?
what is treatment emergent events and treatment emregent adverse event
what are several options for creating reports in web report studio? : Sas-bi
What do the put and input function do?
What is proc sort?
