topic Re: proc import in SAS Programming

proc import

sfffdg — Tue, 05 Jul 2022 04:42:35 GMT

Hi,

Why the below import does not work.

PROC IMPORT DATAFILE = 'N:\Comp1\SubComp1\ISS5315\ISS-5315 dds impacted with info from Product catalogue GG Update.xlsx'
OUT = list1
DBMS = XLSX
REPLACE;
SHEET = "Sheet1";
GETNAMES = YES;
RUN;

I get the below error:

ERROR: Physical file does not exist, N:\Comp1\SubComp1\ISS5315\ISS-5315 dds impacted with info from Product catalogue GG Update.

Thanks.

Re: proc import

Kurt_Bremser — Tue, 05 Jul 2022 05:03:33 GMT

Most probable cause: the N drive is not available on the server where SAS runs. Try to use a UNC path instead, or have your SAS server admins mount the network share.

Re: proc import

sfffdg — Tue, 05 Jul 2022 07:06:19 GMT

No , it works for other files..so it might not be the problem

Re: proc import

Kurt_Bremser — Tue, 05 Jul 2022 07:21:32 GMT

Then first verify that the path to the directory is correct, and create a directory listing:

data files;
length dref $8 name $200;
rc = filename(dref,"N:\Comp1\SubComp1\ISS5315");
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 not found!";
drop rc did dref;
run;

If this does not work as expected, post the complete log.

Re: proc import

sfffdg — Tue, 05 Jul 2022 08:15:25 GMT

It worked and the file name is in the dataset.

Re: proc import

Kurt_Bremser — Tue, 05 Jul 2022 09:48:38 GMT

Then make sure that you use the same name in the PROC IMPORT as returned by the directory listing; if in doubt, look at a hex-formatted display of the filename to find any "funny" characters (like a leading blank).