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
- 12595 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 |
describe about physical data integration? : Sas-di
what are the categories that sas informats are used to the place the data? : Sas-administrator
What are the implications?
What are the parameters of scan function?
what is the difference between SET and MERGE?
what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?
What is the difference between using drop = data set option in data statement and set statement?
What is proc sql pass through facility?
What are the default statistics for means procedure?
what is program data vector? : Sas-administrator
data voter; input Age Party : $1. (Ques1-Ques4)($1. + 1); datalines; 23 D 1 1 2 2 45 R 5 5 4 1 67 D 2 4 3 3 39 R 4 4 4 4 19 D 2 1 2 1 75 D 3 3 2 3 57 R 4 3 4 4 ; Idont understand what the (Ques1-Ques4)($1. + 1) means. I have seen (Ques1-Ques4)(4*$1.), but what is (Ques1-Ques4)($1. + 1)? Appreciate all help Thanks
What is the difference between Regression and Logistic Regression? Can u explain the Assumptions/Conditions?
Teradata 
