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;
Answer Posted / ashutosh
%macro mydata(my,n);
data XXX;
merge
%do i=1 %to &n;
&my&i
%end;
;
by a;
run;
%mend;
%mydata(file,4);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are all the reports you generated in your recent project?
What is a put statement?
Mention sas system options to debug sas macros.
Describe what are the different levels of administrative users in sas? : sas-grid-administration
What is the role of sas grid administrator? : sas-grid-administration
Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.
AE datasets names? how many types?
what is transformation in sas data integration? : Sas-di
Which function is used to count the number of intervals between two sas dates?
what is the use of sas management console? : Sas-di
what do you mean by data staging area? : Sas-di
what are the categories that sas informats are used to the place the data? : Sas-administrator
what is broad cast agent? : Sas-bi
what are validation tools that are used in sas? : Sas-administrator
What is the difference between using drop = data set option in data statement and set statement?