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

Explain how merging helps to combine data sets.

605


How do you specify the number of iterations and specific condition within a single do loop?

613


What is connection profile? : sas-grid-administration

642


What is PROC in SAS?

597


What are SAS/ACCESS and SAS/CONNECT?

620






What is the basic structure of a sas program?

588


what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming

713


If you were told to create many records from one record, show how you would do this using array and with proc transpose?

792


what is information maps?

1603


Tell me more about the parameters in macro? : sas-macro

582


What is PDV?

715


Describe a time when you were really stuck on a problem and how you solved it?

2079


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

706


where are dashboard components are created and maintained? : Sas-bi

552


Describe the ways in which you can create macro variables?

622