%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
12801 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

what are some differences between proc summary and proc means? : Sas programming

1190

what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi

1135

What is the sas data set? : sas-grid-administration

1027

what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming

1180

What is the SAS data set?

1175

how could you generate test data with no input data? : Sas programming

1235

Difference between nodup and nodupkey options?

1268

I have a dataset concat having a variable a b & c. How to rename a b to e & f?

1331

Explain how you can debug and test your SAS program?

1051

how does sas handle missing values in formats? : Sas programming

1187

How to convert a numeric variable to a character variable?

1255

name some data transformation used in sas di? : Sas-di

1031

What are the applications primarily used by business analyst? : Sas-bi

1049

please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??

2135

Describe what are the different levels of administrative users in sas? : sas-grid-administration

1081