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
- 10664 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 are the statements in proc sql?
if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...
what is data governance? : Sas-di
What is the difference between where and if statement?
What do the mod and int function do? : Sas programming
sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately
how does sas handle missing values in formats? : Sas programming
What do you code to create a macro? : sas-macro
What is the difference between reading data from an external file and reading data from an existing data set?
what is data integration? : Sas-di
what are some differences between proc summary and proc means? : Sas programming
how does sas handle missing values in sort order? : Sas programming
how does sas handle missing values in functions? : Sas programming
What is the function of Stop statement in a SAS Program?
How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?
