Hi, so I have two SAS datasets, one of which is approximately 780GB and the other with approximately 5700 observations. In the smaller dataset, the 5700 observations have a unique identifier also present in the 780GB dataset. I was wondering if there was a way to extract all the observations in the large dataset that match the identifiers from the smaller dataset (there are multiple observations for each identifier in this dataset). I have tried merging the two using an inner join; however, it took SAS over 72 hours to complete this. Is there a way to reference the variable in the smaller dataset in a where statement or any other way to trim down the length of time it takes to perform this function? Thank you in advance.
... View more