SAS Enterprise Guide 7 | Import DBF

[MariaD]

Hi Folks,

Recently we move to SAS 9.4 and  SAS EG 7 on Unix. Now, the users has problem to import .DBF files using point-and-click. We tried to use the following code:

proc import datafile='\\folder_on_network\file.DBF'
      dbms=dbf
      out=work.table replace;
      server='IP';
      port=9621;
      serveruser='domain\user';
      serverpass='senha';
run;

But the procedure not recognise the PCFF server options and our files are on windows network folder:

30               server='IP';
                 ______
                 180
31               port=9621;  

Any idea to resolve it?

Regards,

[SASKiwi]

This link should help: https://documentation.sas.com/?docsetId=acpcref&docsetTarget=p04mnmm6ms0y8yn1ass9qgxa932c.htm&docset...

It lists the statements that are valid for PROC IMPORT and DBMS = DBF. You can't use server, port, serveruser, serverpass with DBMS = DBF. I suspect you need to have the DBF folder directly accessible by your SAS server, not on another one.