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
how do you pull data from equifax?tell me the process?
What do you know about symput and symget?
What is the command used to find missing values?
Intern stastical programmer written test
WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
Tell me about % include and % eval? : sas-macro
What is the difference between using drop = data set option in data statement and set statement?
Explain what Proc glm does?
What is the use of function Proc summary?
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
what type of graphs we will create(for 2+years candidates)?
What is PDV?
What are the best sas programming practices for handling very large datasets? : sas-grid-administration
What are the differences between sum function and using “+” operator?