if you have 365 no of data set and each one having different
variable from each other. how will you read by creating
macros and create a single data set.
- 2 Answers
- 6173 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / manoj mishra
Make a library where all data set resides. Use proc contect
and out option to create a data of proc contect from where
we get all data set name. Create Macro using Call Symput for
each dataset name into separate macro variable. We can not
merge them as they dont have common variable. We need set or
Append or SQL to merge them together.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / singh.naveen409
%macro naveen(xx,n);
data www;
merge
%do i=1 %to &n;
&xx&i
%end;
;
run;
%mend naveen;
%naveen (qq,2);
| Is This Answer Correct ? | 1 Yes | 10 No |
What is program data vector (pdv) and what are its functions?
is data integration and etl programming is same? : Sas-di
How are the analysis data sets structured?
How would you determine the number of missing or nonmissing values in computations?
Mention sas system options to debug sas macros.
Can you execute a macro within a macro? Describe. : sas-macro
CHOOSE ANY ONE OF THE PROCEDURE FOLLOWING TO GENERATE THE REPORTS? HOW CAN YOU SAY IT IS BETTER THAN THE OTHER? AND DEFERENCIATE THESE TWO ? 1). REPORT PROCEDURE 2). TABULATE PROCEDURE
What are the efficacy variables in your study?
2 Answers Accenture, Quintiles,
Describe a time when you were really stuck on a problem and how you solved it?
If you could design your ideal job, what would it look like?
Explain the message ‘MERGE HAS ONE OR MORE DATASETS WITH REPEATS OF BY VARIABLE’.
how do u validate the program which u have written.
Teradata 
