How to change the reference to the Oracle to SAS folder

[Gieorgie]

I have a reference to a folder that is on Oracle, but the libraries have already been transferred to the SAS server. I do not know how to add / change to open the file outside Oracle

datafile="&glb_path.\01_projects\credit\_test\RCDT2021.xlsx"
            dbms=excel replace;
     sheet="RCDTCOD"; 
     getnames=yes;
     mixed=yes;
     usedate=yes;
     scantime=yes;```


This folder is 1: 1 already on shared disc. ```\01_projects\credit\_test\RCDT2021.xlsx"```

[andreas_lds]

The titles says something about oracle, but in the code you have posted i see an excel-file. So, please be specific and explain what you have and what you want.

[Gieorgie]

This is the code that opens an excel file for me on the Oracle server. I would like to change the code to open the same file for me from shared servers (disks) : corp.ad.gs.com\dfs\01_projects\credit\_test\RCDT2021.xlsx

[Gieorgie]

and i gor erro ERROR: Physical file does not exist

[Sajid01]

This error means that file does not exists. If the file exists, then check your full path and filename. Thier could be mistakes in that.

[Sajid01]

Hello @Gieorgie 
This question and your question https://communities.sas.com/t5/SAS-Programming/How-to-connect-to-networking-drives/m-p/771559#M24487...  are essentially identical.
What has been said applies here too.