I am having a library, in that there are five datasets with five variables each and having only one observation.Out of five variables one variable is numeric.
I want the data from all five datasets with a numeric variable.
How can I do this using datastep or a macro without knowing whether a variable is numeric?
Thanks in advance.
This is an example of how I would do it, but it takes a couple steps. In this example, I create three datasets with different variable formats. After merging these sets, I determine the numeric variables using PROC CONTENTS and PROC SQL and then limit my final dataset to just those variables.