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
What Proc glm does?
explain the use of % includes a statement in sas? : Sas-administrator
What is the function of output statement in a SAS Program?
Can you explain the process of calendar?
Did you used proc test? when?
what do you mean by data staging area? : Sas-di
Mention what is the difference between nodupkey and nodup options?
What is the maximum and minimum length of macro variable
what is operational data and operational system? : Sas-di
Explain the special input delimiters used in sas programming.
How to create a permanent sas data set?
Enlist the syntax rules followed in sas statements.
Difference between nodup and nodupkey options?
what are the types of interactive display types? : Sas-bi
For clinical entire study how many tables will create approx?