SAS Enterprise Guide 7 | Import DBF

MariaD — Mon, 19 Nov 2018 18:09:18 GMT

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,

Re: SAS Enterprise Guide 7 | Import DBF

SASKiwi — Mon, 19 Nov 2018 20:15:27 GMT

This link should help: https://documentation.sas.com/?docsetId=acpcref&docsetTarget=p04mnmm6ms0y8yn1ass9qgxa932c.htm&docsetVersion=9.4&locale=en

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.

topic Re: SAS Enterprise Guide 7 | Import DBF in SAS Enterprise Guide

SAS Enterprise Guide 7 | Import DBF

Re: SAS Enterprise Guide 7 | Import DBF