Hi all, I'm trying to merge multiple sas file with a SAS file containing unique ID libname have "C:\Users\fkvn\Desktop\SAS files" libname want "C:\Users\fkvn\Desktop\overview" In my have library I have these files: id, SMS, u10_clucose, u28_tgly, y7_toothdata, u28_toothdata, u28_chol - this folder expands over time so more tables will be added to the folder. So the code has to be automatic and generic? Probably some macro variables containing all datasets name my folder "Have". I want an output table showing me which tables each id exists in? The new column name should be the name of the dataset with 0/1 values - where 1 indicates that the ID exist in the table and 0 if not. Output table should look like this: ID u10_clucose u28_tgly y7_toothdata u28_toothdata y7_toothdata u28_chol 1 1 1 0 0 1 2 1 1 1 1 0 3 1 1 1 0 0 Kind regards Frank
... View more