I sort of tried before and couldn't.
I'm going to try again.
But, while I'm working on it, maybe someone else has already done this and can help.
I want to access a file within a macro, without use of a data step.
The file has a single line/record/observation in it.
I want to read that single record and assign the value to a macro variable.
Again, without use of a datastep, just essentially pure macro.
The desire is to maintain maximum security and portability of the code and minimize the maintenance of users and their passwords.
We have AD, and the SAS MetaData Server, whose user's are refreshed every night from AD. But, AD does not, and will not for some time to come, yet, contain application user ID's -- like, for instance, "Oracle". So, if I create the library in the MetaData Server, I have to hard code in the user and password into the libary definition, which defeats the security and maintainability issues.
So, for unattended batch processing, I have created the macros and language structures. Of course, now there is the chore of having to set/change users and passwords manually in two places: 1) AD, 2) for my group's SAS stuff. But since a user has to update their password at least every 30 days, doing this twice isn't so bad, and application level passwords can likewise be easily maintained.
Message was edited by: Chuck