topic Re: How to change the reference to the Oracle to SAS folder in SAS Programming

How to change the reference to the Oracle to SAS folder

Gieorgie — Fri, 01 Oct 2021 07:58:52 GMT

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"```

Re: How to change the reference to the Oracle to SAS folder

andreas_lds — Fri, 01 Oct 2021 09:21:27 GMT

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.

Re: How to change the reference to the Oracle to SAS folder

Gieorgie — Fri, 01 Oct 2021 09:29:50 GMT

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

Re: How to change the reference to the Oracle to SAS folder

Gieorgie — Fri, 01 Oct 2021 09:31:54 GMT

and i gor erro ERROR: Physical file does not exist

Re: How to change the reference to the Oracle to SAS folder

Sajid01 — Fri, 01 Oct 2021 12:10:30 GMT

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.

Re: How to change the reference to the Oracle to SAS folder

Sajid01 — Fri, 01 Oct 2021 14:37:45 GMT

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