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;

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Why and when do you use proc sql?

749


I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com

2257


Mention sas system options to debug sas macros.

655


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 ...

932


How is character variable converted into numeric variable and vice versa?

582






what is the Population you used in your project, is it ITT or PP?

2170


Explain the main difference between the sas procedures and functions? : Sas-administrator

529


What is the maximum length of the macro variable?

663


for report generation which one you used proc report or data_null_?

6565


What is the function of output statement in a SAS Program?

601


I have a dataset concat having a variable a b & c. How to rename a b to e & f?

750


Describe the function and untility of the most difficult SAS macro that you have written.

1717


What is run-group processing?

614


What is the work of tranwrd function?

657


is data integration and etl programming is same? : Sas-di

568