Hi All, My requirement here is to merge 'n' number of datasets in a library using a sas macro as that seems to be the feasible solution.The sas datasets' names in the library are all different i.e.,does not start with the same prefix. all the datasets have a common variable which is date and the datasets have to be merged based on date. The data in the datasets are already sorted. I tried using proc sql to first gather all the variables in a macro variable. From there on how should the merge be accomplished?
... View more