topic Re: How to connect to networking drives in SAS Programming

How to connect to networking drives

Gieorgie — Fri, 01 Oct 2021 10:40:53 GMT

proc import out=polis2
datafile="&glb_path.\01_projects\P010_date_MART\tests.xlsx"
sheet="RCDTCOD";
getnames=yes;
mixed=yes;
usedate=yes;
scantime=yes;
run;

The following code selects a file from my oracle disk, I would like to change to open from network drives.
at this location "\\CORP.AD.GS.COM\DFS"

I dont know how to do it

Re: How to connect to networking drives

Sajid01 — Fri, 01 Oct 2021 12:04:58 GMT

Hello

Modify this "&glb_path.\01_projects\P010_date_MART\tests.xlsx" to reflect the path of the new location.

Re: How to connect to networking drives

Gieorgie — Fri, 01 Oct 2021 12:14:56 GMT

I got error : ERROR: Physical file does not exist, /home/V1410190/corp.ad.gs.com and are you mean "datafile="&glb_path.\CORP.AD.GS.COM\DFS/folder/filex.xslx ?

Re: How to connect to networking drives

PaigeMiller — Fri, 01 Oct 2021 12:18:35 GMT

@Gieorgie wrote:
I got error : ERROR: Physical file does not exist, /home/V1410190/corp.ad.gs.com and are you mean "datafile="&glb_path.\CORP.AD.GS.COM\DFS/folder/filex.xslx ?

You have to use the EXACT path name and file name. If you mis-specify or mis-spell it in any way, it won't work. Your operating system can tell you the exact path name and file name to the Excel file.

Also, if SAS is running remotely, it can't access file in your local operating system. In that case, you will have to upload the file to the remote machine.

Re: How to connect to networking drives

andreas_lds — Fri, 01 Oct 2021 12:20:19 GMT

The error message looks as if your sas session runs on linux, so ask the admin to mount the drive and make it accessible to you.

Re: How to connect to networking drives

Gieorgie — Fri, 01 Oct 2021 12:20:38 GMT

proc import out=polisy2
datafile='\\CORP.AD.GS.COM\DFS\\_change\TEST__id.csv'
dbms=csv replace;

run; And i still getting error: ERROR: Physical file does not exist, /home/V1410190\corp.ad.gs.com

Re: How to connect to networking drives

PaigeMiller — Fri, 01 Oct 2021 12:24:42 GMT

@Gieorgie wrote:
proc import out=polisy2
datafile='\\CORP.AD.GS.COM\DFS\\_change\TEST__id.csv'
dbms=csv replace;

run; And i still getting error: ERROR: Physical file does not exist, /home/V1410190\corp.ad.gs.com

Look at the part I have turned into red text. /home/v1410190 is indicative that SAS is running on a server. It cannot access files on your local computer's operating system. You will have to upload the file to the server. (Or perhaps there is a way to map your local computer drive to a server drive, and your local IT staff or colleagues will have to tell you if this is possible or not.)

Re: How to connect to networking drives

Sajid01 — Fri, 01 Oct 2021 13:22:52 GMT

Hello @Gieorgie
The problem you are facing is of common occurrence particularly when some one is new to an organization or if there have been changes.
In addition to what all has been said in the posts above, there could be access restrictions.
Anybody who has been working for a while in the environment for example a senior colleague or the SAS Administrator would be the appropriate persons (local guides/champions )to help.
In the forum one can get directions and explanations but in a similar scenario I would seek assistance / guidance from my colleagues / SAS Admins first before going anywhere else.

Re: How to connect to networking drives

Gieorgie — Fri, 01 Oct 2021 13:42:32 GMT

Understood, really be honest im new on my corp. next time i will go to my colleague . I thougt it was much easier, and a problem is a small. Have a nice weekend

Re: How to connect to networking drives

PaigeMiller — Fri, 01 Oct 2021 13:48:16 GMT

@Gieorgie wrote:
Understood, really be honest im new on my corp. next time i will go to my colleague . I thougt it was much easier, and a problem is a small. Have a nice weekend

Some problems, like this one, are best answered locally, as most likely you have to upload the file of interest to your remote SAS installation, and the exact steps are probably different in each company.