I'm very new to SAS and so I am not as familiar with the right phrasing for things. The issue that I am having is when I share code between a co-worker and myself.  He uses a different libname for the same database source than I use.  Instead of bringing the same database source in twice (using libname for my naming convention and another libname for his) I thought there must be an easier way to just take the libname, call it into my procedure at the beginning, and only need to rename it in one spot.  I hate doing a search and replace for the library within the code.  Seems inefficient.  I don't like the libnames that he uses because they don't mean as much to me when I'm coding because the two libraries are very different with what I pull from them. Is that a better clarification? ========= I found the answer.  I used a macro: %Let NewDB = OldDB; ---------------- Then in my proc sql procedure under From I did From      &NewDB..First_Name  (the ampersand and the two periods were essential to get it to read the macro) This pulled in the data from the OldDB library and it let me name it as NewDB when I was programming. ... View more