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
- 10604 Views
- WNS, I also Faced
- E-Mail Answers
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
What is PROC in SAS?
What is proc sort?
Explain how merging helps to combine data sets.
What is the different between functions and PROCs that calculate the same simple descriptive statistics?
What are the new features included in the new version of SAS Programming Language?
how do you debug and test your sas programs? : Sas programming
what is the primary data source for the wrs? : Sas-bi
What are the different versions of sas that you have used until now? : sas-grid-administration
What are the table names in oracle database...?
Name few SAS functions?
why a stop statement is needed for the point= option on a set statement?
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 ways in which macro variables can be created in sas programming?
How do you delete duplicate observations in sas?
how does sas handle missing values in sort order? : Sas programming
