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;

Answers were Sorted based on User's Feedback



create macros---you have 365 number of data and you need to merge it throw the macros,,,,,, data..

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

create macros---you have 365 number of data and you need to merge it throw the macros,,,,,, data..

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

create macros---you have 365 number of data and you need to merge it throw the macros,,,,,, data..

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

create macros---you have 365 number of data and you need to merge it throw the macros,,,,,, data..

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

create macros---you have 365 number of data and you need to merge it throw the macros,,,,,, data..

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

create macros---you have 365 number of data and you need to merge it throw the macros,,,,,, data..

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

Post New Answer

More SAS Interview Questions

how to add distinctly var variable values ex.. Data a; input var; datalines; 0 1 2 3 -1 -2 -3 ; run; adding all +ve value in one varibale n do the same for -ve too

5 Answers   CTS,


Describe a time when you were really stuck on a problem and how you solved it?

0 Answers   DELL,


which stats created by proc means that are not created by proc summary or vice versa?

2 Answers   GSK,


How does the internal authentication work in sas? : sas-grid-administration

0 Answers  


how to display duplicated observations in a data using base sas.

13 Answers   HCL, TCS,






What are the data types in sas?

0 Answers  


What are the special input delimiters used in SAS?

0 Answers  


Name and describe three SAS functions that you have used, if any?

4 Answers   Accenture,


How would you invoke a macro? : sas-macro

0 Answers  


How do you use the do loop if you don’t know how many times you should execute the do loop?

0 Answers  


How do you debug macros?

3 Answers   Accenture,


I Here clinical SAS training by Ramesh Azmeera is good. Is it confirm ?

2 Answers  


Categories