You could use PROC PWENCODE to encode the passwords. While that stops casual users from deciphering the original password, it doesn't stop users from copying the password to use in their own processes. ... View more

Hi,   I am trying to do something similar. It works fine with a local path on the PC where PC files serer is Installed. We have Base SAS on a UNIX server and I am trying to run the code below fro SAS EG. The below will run fine if I also specify username and password, but I dont want to hard code my credentials in the code. Wanted to ask if there are any workarounds . I need to export to both excel and access.   PROC EXPORT data=sashelp.cars dbms=excelcs outfile="\sharepoint Location\test_cars.xls" replace; sheet = Data; server="10.47.87.96" ; port=9621; run;   PROC EXPORT DATA=sashelp.cars OUTTABLE="cars1" DBMS=ACCESSCS REPLACE ; DATABASE="\SharePoint location\test_cars.MDB"; SERVER="10.47.87.96"; PORT=9621; RUN;   Thanks, Praveena ... View more