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
- 6190 Views
- I also Faced
- E-Mail Answers
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 are the different servers in sas? : sas-grid-administration
what is the difference between floor and ceil functions in sas? : Sas-administrator
how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5
What is factor analysis?
What do the mod and int function do? : Sas programming
How to create an external dataset with sas code?
What are the statements in proc sql?
hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?
What are the automatic variables for macro? : sas-macro
Name any two sas spawners? : sas-grid-administration
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
what are informats in sas? : Sas-administrator
How to create a permanent sas data set?
explain the difference between proc means and proc summary?
What is program data vector (pdv) and what are its functions?
