I had a question relating to the request. Is'nt such a macro very inefficient. let us say you want to extract the past 6 months of data. In such a case you loop 6 times. Then you would be reading the original dataset 6 times for each create of a new datset / table will go against the original table. Or Am i missing something? it is much easier to code it using base sas instead of trying to use SQL.
... View more