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 / singh.naveen409
%macros mydata(my,n);
data www;
set
%do i=1 %to &n;
&my&i
end;
;
run;
%mend;
%mydata(file,4);
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
how do the in= variables improve the capability of a merge? : Sas programming
what are 5 ways to perform a table lookup in sas? : Sas-administrator
How many ways to overcome a missing values???
What is the maximum length of the macro variable?
for whom is sas data integration studio designed? : Sas-di
What is your favorite all time computer book? Why?
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
What are the data types in sas?
Differentiate between proc means and proc summary.
what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming
Explain the difference between using drop = data set option in set and data statement?
what is transformation in sas data integration? : Sas-di
In SAS explain which statement does not perform automatic conversions in comparisons?
Explain by-group processing?
how do you debug and test your sas programs? : Sas programming