Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6645 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 |
How do you write a test plan?
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro
what is change analysis in sas di ? : Sas-di
what is the basic structure sas administrator? : Sas-administrator
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
For what purpose(s) would use the RETURN statement?
How to include or exclude specific variables in a data set?
What report output formats can you generate using SAS?
What is run-group processing?
Did you used proc lifetest? when?
2 Answers Accenture, Parexel, Quintiles,
What are the scrubbing procedures in sas?
What is the command used to find missing values?
Teradata 
