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
- 6759 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 SAS/Graph?
How do i read multiple spaces in datasets?
how can u join the two tables without using proc sql Joins and nested queries ?
what are the best practices to process the large data sets in sas programming? : Sas-administrator
What is highest missing value for numeric?
how does sas handle missing values in procs? : Sas programming
what is the difference between informat$8. $char8.
How can you put a "trace" in your program?
Differentiate between ceil and floor functions.
what are methods to identify duplicate observations?
Name validation tools used in SAS
What are the scrubbing procedures in sas?
Teradata 
