%macro mydata(my,n); data XXX; merge %do i=1 %to &n; &my&i

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;

Question Posted / ashutosh

6 Answers
12359 Views
WNS, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

Give some examples where proc report’s defaults are different than proc print’s defaults?

1011

Explain what is SAS informats?

1039

How to create an external dataset with sas code?

1068

How does the internal authentication work in sas? : sas-grid-administration

1066

How would you define the end of a macro? : sas-macro

1034

How does proc sql work?

1026

What is the basic structure of a sas program?

1057

I need level 2 to 5 sas using companies in india

2327

what is sas metadata repository? : Sas-bi

1052

What are the uses of sas?

1166

What is the basic structure of the SAS base program?

1230

Can you execute macro within another macro? : sas-macro

936

what is the use of sas management console? : Sas-di

1033

what is business intelligence? : Sas-bi

1014

Mention how to limit decimal places for the variable using proc means?

1057