topic Re: import /export error in SAS Enterprise Guide

import /export error

sas_9 — Thu, 02 Jan 2014 20:31:12 GMT

Hi Friends - I am using sas 9.1 and have mdb 97-2003.

I am importing mdb files into sas dataset in work library and then exporting that sas dataset into mdb file into another folder using below code. But i am getting an error saying that

"ERROR: FILE= or TABLE= is required and must be specified"

but same code working for .xls file

Can someone help me to figure what's wring with my code please!!!

Thanks!

libname a 'f:\sam\a'; /*test.mdb file is here*/

libname b 'f:\sam\b'; /*getting same mdb file here*/

proc import datafile='f:\sam\a\test.mdb'

out=abc

dbms=access replace;

run;

proc export data=abc

outfile='f:\sam\b\tets.mdb'

dbms=access replace;

run;

Re: import /export error

jakarman — Thu, 02 Jan 2014 21:02:38 GMT

SAS/ACCESS(R) 9.3 Interface to PC Files: Reference See datatable as being different between Excel/Access

Re: import /export error

ballardw — Thu, 02 Jan 2014 21:15:58 GMT

Or http://support.sas.com/techsup/technote/ts793.pdf for 9.1.3 and higher examples.

Basically you are missing the datatable="access table name" parameter.

Re: import /export error

sas_9 — Thu, 02 Jan 2014 23:02:01 GMT

I am using below code but still not working,

proc import out=abc

datatable='xyz'

dbms=access replace;

database='f:\sam\a\xyz.mdb';

run;

getting error like,

ERROR: file= or table= is required and must be specified.

Don't know what is missing...

Re: import /export error

sas_9 — Fri, 03 Jan 2014 00:14:51 GMT

more surprisingly - if i use IMPORT wizard - it's working fine...:-)

Re: import /export error

jakarman — Fri, 03 Jan 2014 06:25:37 GMT

Than you can save the source the wizard generates and compare that whith what you have tried.

Re: import /export error

Vish33 — Fri, 03 Jan 2014 12:25:43 GMT

try this,

proc import datafile='f:\sam\a\test.mdb'

datatable="&table_name"

out=abc

dbms=access replace;

run;

proc export data=abc

outfile='f:\sam\b\tets.mdb'

outtable="&table_name"

dbms=access replace;

run;

Re: import /export error

Doc_Duke — Fri, 03 Jan 2014 15:10:09 GMT

you have an extra semicolon after 'replace'.

Re: import /export error

sas_9 — Fri, 03 Jan 2014 17:18:55 GMT

Hi Vish -

i think we cannot mention file= and table= options at same time - you will get an error...

%let table_name=test.mdb;

proc import datafile='f:\sam\a\test.mdb'

datatable="&table_name"

out=abc

dbms=access replace;

run

Re: import /export error

sas_9 — Fri, 03 Jan 2014 18:48:28 GMT

Thanks all for posting your comments on my issue...I am good for now...

I run same piece of code on different server and it absolutely fine - nothing wrong at all but i am still getting an error where i was running previously.

%let table_a=f:\sandip\a\xyz.mdb;

%let table_b=f:\sandip\b\xyz.mdb;

options symbolgen;

proc import

out=def

datatable="xyz"

dbms=access replace;

database="&table_a";

run;

proc export data=def

outtable="xyz"

dbms=access replace;

database="&table_b";

run;

/*-----------this code ran fine with different server------------Thanks a lot---------------*/

Re: import /export error

jakarman — Sat, 04 Jan 2014 08:11:52 GMT

Sounds like a wrong error message as you are pointing now to an inconsistent machine installation.

That is an other issue type. Good that you are able to continue the work.

Re: import /export error

sasprofile — Thu, 19 May 2016 18:12:12 GMT

Hello Friends, I have same kind of issue when am trying to import and export excel files from Grid node to PC file server. below are the codes am using,but not sure where its going wrong. proc export data= sashelp.prdsale; dbms=xls; outfile="D:\pcfile\prdsale.xls"; port=xxxx; server="xxxxxxxxx"; sheet=sheet1; run; proc import dbms=excelcs datafile='D:\pcfile\Demo.xls' out=\tmp REPLACE; port=xxxx; server="xxxxxx"; sheet=sheet1; run; These are the error am getting,any suggestions or advice would be really appreciated. Proc import dbms=excelcs data='D:\pcfile\Demo.xls' ---- 22 76 Error 22-322 Syntax error,expecting onc eof the following: ;,DATAFILE,DATATABLE,DBMS,DEBUG,FILE Error 76-322 Syntax error,statement will be ignored outfile=\tmp REPLACE; port=xxxx; server="xxxxxxx"; run; server proc export data=sashelp.prdsale; Error:FILE or TABLE is required and must be specified. dbms=xls; file="D:\pcfile\prdsale.xls"; port=xxxx; server="xxxxxx"; sheet=sheet1; run; Thank you

Re: import /export error

LinusH — Fri, 20 May 2016 06:04:53 GMT

This thread is more than two years old.
Check your syntax.