Sign Up Login


  1. Categories >> Software >> Data Warehouse >> SAS
  2. Suggest New Category

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;

Question Posted / singh.naveen409

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

in data set200 observation how to take 110,150,170 using sql procedure?

7 Answers   Accenture,

Baseline definition in your study

3 Answers   Accenture, Quintiles,

Name statements that are execution only.

14 Answers   Accenture,

What does P-value signify about the statistical data?

0 Answers  

If reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record?

4 Answers  

what are all the default values getting in PROC MEANS...???

2 Answers  

The below code we are using for creating more than one macro variables in proc sql using into clause. How we can use same code to create macro variables vara, varb, varc instead of var1, var2, var3.? proc sql noprint; select count(distinct(patient)) into :var1 - :var3 from dataset1 group by trtreg1c ; quit;

1 Answers   Accenture,

Write a SAS macro to calculate number of numbers in an email address

2 Answers  

Give e an example of..

0 Answers  

At compile time when a SAS data set is read, what items are created?

14 Answers   Accenture,

What is your favorite all time computer book? Why?

0 Answers   Oracle,

what is the difference between unique key and primary key? : Sas-di

0 Answers  

For more SAS Interview Questions Click Here
Categories