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


Please Help Members By Posting Answers For Below Questions

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

603


What are the functions which are used for character handling functions?

620


explain the proc in sas? : Sas-administrator

629


what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?

1689


How many data types are there in SAS?

638






what are validation tools that are used in sas? : Sas-administrator

595


what are sas bi dashboard components? : Sas-bi

667


Can you suggest us materials for sdtm mapping?

4041


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

576


What are the different versions of sas that you have used until now? : sas-grid-administration

738


Name validation tools used in SAS

698


What are the difference between sas functions and procedures?

644


what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming

572


Mention what is PROC in SAS?

605


what do the sas log messages "numeric values have been converted to character" mean? : Sas programming

547