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.
Answer Posted / 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 |
Post New Answer View All Answers
name the scheduler for scheduling job and explain the scheduler? : Sas-di
What are the scrubbing procedures in sas?
For what purposes have you used sas macros? : sas-macro
What are the statements in proc sql?
what is sas enterprise intelligence architecture? : Sas-bi
I have a dataset concat having variable a b & c. How to rename a b to e & f?
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
what are validation tools that are used in sas? : Sas-administrator
What is SAS informats?
name some data transformation used in sas di? : Sas-di
Explain data step in SAS
Explain input and put function?
what is information maps?
Given an unsorted data set, how to read the last observation to a new data set?
What’s the difference between var b1 – b3 and var b1 — b3?