Thank you! This worked wonderfully! ... View more

Thank you Ksharp! This worked beautifully! I guess the key point here is the use of the %bquote and %str function within the macro. Thanks again!   ... View more

Thank you for your reply. I used the formula below for the referenced cell:   =IF(ISBLANK(Overlay!E4), "", Overlay!E4)   This will properly populate blanks into the cells, and SAS will now import these as nulls. Thank you for your help!   ... View more

Interesting.. Thank you for your reply CaseySmith.   If I explicitly connect to the workplace server (by expanding my server view), then the project will run in parallel the first time.   I am currently on 7.11 HF2 (7.100.1.2785), so it seems like I am impacted by this bug. For now, I will be aware to explicitly connect to the server if I am running for the first time (or just never close my EG session )   The decision to upgrade to HF5 will have to be determined by our environment administrators unfortunately. Hopefully sometime soon! ... View more

Hi Reeza, Please see attached JOINED_ATTR table, MEF_GROUP_INDEX table, and an example output table which will be called ATTR_EURO_UK_VAR according to my code.   Let me know if you have any tips   Thanks   ... View more

Thanks all for the replies! I don't do too much in the final data step, so this will fit my needs for now!   ... View more

Thanks for your help! Yes, I am using the "quoted" list for an in () statement for a "where" condition.   I thought the double quotes would be an issue, but it seems to be working. I am using your datastep alternative, as this seems a bit more simple and straightforward for my purposes. Thank you both for the help! ... View more