Glad to be of service. I hate to say this but in the Windows world things are quite a bit easier as you can define all of your ODBC settings in SAS. Best practice is to define all this stuff for all SAS users in SAS metadata via SAS Management Console. It works a treat at our site anyway .  ... View more

John, I'm glad this worked for you.  Your success story will help future users who are looking for similar guidance. Chris ... View more

Good morning TimArm, That was one of the things Quentin suggested as well, I already have an e-mail out to see if they have it installed and I have been reading documentation last night about how to utilize it to get what I want. Thank you for the suggestion, you guys have all been very helpful in giving me ideas that I did not have before. John ... View more

Apparently it was my SAS job that got hung up, probably on one of my previously failed attempts.  My guess is that it was waiting for a password, not being able to accept my key location and when I stopped the "Running..." job, it never did the signoff or endrsubmit, causing my whole job to become corrupted with my lack of knowledge. So!  I rebuilt my SAS EG file, re-ran the code and it worked perfectly. My apologies and Patrick, thank you for your help, this one is chalked up to my being too bullheaded about it. Thanks again! John ... View more

To arrive at an understanding of the syntax of what data _null_; originally supplied, I utilized the following two documents: SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition http://www2.sas.com/proceedings/sugi26/p073-26.pdf I was looking in the wrong place for what I was trying to do, trying to manipulate the file instead of what was actually being put into the file - that was my mistake. Now I am much more enlightened to the extent and power of the PUT statement thanks to DN and this wonderful documentation. Thanks again! John ... View more