topic Re: Proc Import issues in SAS Programming

Proc Import issues

David_Billa — Fri, 05 Aug 2022 06:47:24 GMT

What would be the likely cause for this issues? File is available in respective location.

proc import 
datafile="/share/sasdata/analytics/INPUT/2019_SUBMISSION_07_31_2019.xlsx" 
dbms=xlsx 
out=work.FSU
replace;
RANGE="Sheet1$C7:AG50000";
run;

Error:

Why extra slash '/' is being shown before the filename in log?

ERROR: Physical file does not exist, /share/sasdata/analytics/INPUT//2019_SUBMISSION_07_31_2019.
NOTE: The SAS System stopped processing this step because of errors.

Re: Proc Import issues

Kurt_Bremser — Fri, 05 Aug 2022 07:13:19 GMT

The extra slash is an issue of the ERROR display (UNIX would collapse two successive slashes to one on its own, anyway).

Check your spelling (upper/lowercase), and retype the whole filename from scratch. You may have an un-displayable character in there which confuses the file interface (because the .xlsx extension is missing).

In particular, be careful when using macro variables. They may contain an invisible macro token.

Re: Proc Import issues

David_Billa — Fri, 05 Aug 2022 10:13:41 GMT

@Kurt_Bremser Still the same error even after manually typed the file name. I'm not certain how to resolve this issue now.

Re: Proc Import issues

andreas_lds — Fri, 05 Aug 2022 10:36:16 GMT

You have checked the spelling? The directory is really named INPUT, not "input"? The filename has only uppercase letters?

Re: Proc Import issues

David_Billa — Fri, 05 Aug 2022 12:30:14 GMT

Folder which I posted is right. I could import the file if I use Import Wizard after placing the file in desktop.

Re: Proc Import issues

Kurt_Bremser — Fri, 05 Aug 2022 13:09:37 GMT

The path on your desktop is not guaranteed to be available on the SAS server. Talk with your SAS admins if and how the share is mounted on the SAS server.

Re: Proc Import issues

Sajid01 — Fri, 05 Aug 2022 13:10:52 GMT

The error is clear. SAS is not able to locate the file.
A gentle reminder Unix is case sensitive.
Another thought is the /share folder on the root of filesystem?

Re: Proc Import issues

David_Billa — Fri, 05 Aug 2022 13:38:54 GMT

Another thought is the /share folder on the root of filesystem? Yes

Re: Proc Import issues

Kurt_Bremser — Fri, 05 Aug 2022 14:59:18 GMT

Run this:

data files;
length dref $8 name $200;
rc = filename(dref,"/share");
did = dopen(dref);
if did
then do;
  do i = 1 to dnum(did);
    name = dread(did,i);
    output;
  end;
  rc = dclose(did);
end;
else putlog "Directory is inaccessible";
rc = filename(dref);
keep name;
run;

and look if your next subdirectory is found; if yes, repeat for it, until you arrive at your file.