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;
- 6 Answers
- 10605 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
Why and when do you use proc sql?
What do the SAS log messages "numeric values have been converted to character" mean?
What is the good sas programming practices for processing large data sets?
How do you delete duplicate observations in sas?
what is sas data set?
what are validation tools that are used in sas? : Sas-administrator
What is the difference between proportion and average?
why is sas data integration studio important? : Sas-di
Mention how to limit decimal places for the variable using proc means?
What is the difference between nodupkey and nodup options?
Compare sas with other data analytics tools.
what is sas database server? : Sas-di
how do you want missing values handled? : Sas programming
What are the data types that sas contain?
do you prefer proc report or proc tabulate? Why? : Sas programming
