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 the functions used for character handling?
what is intially documentation in sas?
what is business intelligence? : Sas-bi
how do you debug and test your sas programs? : Sas programming
what can you learn from the sas log when debugging? : Sas programming
Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com
For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration
describe about physical data integration? : Sas-di
How are numeric and character missing values represented internally?
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
what is enterprise guide? What is the use of it? : Sas programming
What is the basic syntax style in SAS?
Mention the difference between ceil and floor functions in sas?
how can you put a "trace" in your program? : Sas programming
why is sas data integration studio important? : Sas-di