Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12815 Views
- WNS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jugaadu
Sorry missed the data step here is the corrected Version;
%MACRO Data_Create;
%Do i = 1 %to 365;
DATA file&i;
INPUT a @@;
CARDS;
4*&i-3 4*&i-2 4*&i-1 4*&i
;
RUN;
%MEND;
%Data_Create;
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / venkat
%macro merging(f,x);
%do i=1 %to %eval(&x-1);
data &f&n;
merge &f&n &f%eval(&i+1);
by a;
run;
%end;
%mend merging;
%merging(file,4);
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / 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 |
Answer / 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 |
Answer / 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 |
Answer / jugaadu
%MACRO Data_Create;
%Do i = 1 %to 365;
INPUT a @@;
CARDS;
4*&i-3 4*&i-2 4*&i-1 4*&i
;
RUN;
%MEND;
%Data_Create;
| Is This Answer Correct ? | 0 Yes | 4 No |
I have a dataset concat having variable a b & c. How to rename a b to e & f?
what are several options for creating reports in web report studio? : Sas-bi
Explain the use of proc print and proc contents?
What is the purpose of _error_?
What is data _null_?
how to rearrange the data as our wish by using dataset block?
What is instream data in SAS?
What are the joins,types of joins and thier functions?
Differences between where and if statement?
what is PhaseIII, ODS, TLG, Macro and Proc in SAS
What do the put and input function do?
What do you feel about hardcoding?
Teradata 
