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
Explain how merging helps to combine data sets.
How do you specify the number of iterations and specific condition within a single do loop?
What is connection profile? : sas-grid-administration
What is PROC in SAS?
What are SAS/ACCESS and SAS/CONNECT?
What is the basic structure of a sas program?
what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
what is information maps?
Tell me more about the parameters in macro? : sas-macro
What is PDV?
Describe a time when you were really stuck on a problem and how you solved it?
What is a method to debug and test your SAS program?
where are dashboard components are created and maintained? : Sas-bi
Describe the ways in which you can create macro variables?