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 makes sas stand out to be the best over other data analytics tools?
Explain how you can debug and test your SAS program?
How can you create a macro variable with in data step? : sas-macro
Explain bmdp procedure?
what are the categories that sas informats are used to the place the data? : Sas-administrator
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
This entry was posted in General. Bookmark the permalink. Post a comment or leave
Explain what is data step?
if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation
Describe the function and untility of the most difficult SAS macro that you have written.
please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??
what is null hypothesis? why do you consider that?
Mention some common errors that are usually committed in sas programming.
explain what is data set in sas? : Sas-administrator
What is the difference between INPUT and INFILE ?