%MACRO mer; DATA file_all_365; MERGE %DO i=1 %TO 365;

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 / vijay

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

Answer Posted / vijay

%MACRO mer;
DATA file_all_365;
MERGE
%DO i=1 %TO 365;
file&i
%END;;
RUN;
%MEND;

%MER;

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What does proc print, and proc contents are used for?

1074

What is maximum number of rows and cols can be handled in SAS?

1513

What would be the value of month at the end of data step execution and how many observations would be there?

1088

what is the difference between nodup and nodupkey options? : Sas programming

1136

I need level 2 to 5 sas using companies in india

2342

Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?

2199

what is business intelligence? : Sas-bi

1022

What is a method to debug and test your SAS program?

1298

For clinical entire study how many tables will create approx?

1924

How to specify variables to be processed by the freq procedure?

1044

Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?

1868

What is by-group processing?

962

is data integration and etl programming is same? : Sas-di

1027

explain what is factor analysis? : Sas-administrator

1065

Explain the difference between informat and format with an example.

1135