Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SAS to Access

Status
Not open for further replies.

YJHappy

Programmer
Mar 22, 2005
4
US
I use the code below to export data to Access:

proc export data=proto.final
outtable="final"
dbms=access replace;
database="G:\CD Data\ccdbase8.mdb";
run;

Then have error:
ERROR: Libname PROTO is not assigned.
ERROR: Export unsuccessful. See SAS Log for details.

What should I do now?

Thanks!
 
the libname error you have is not a problem with the export function. it means that you have defined to SAS where it can find the file final. presumably this is in a directory somewhere on your hard disk (if you're using PC SAS). you need a statement like this...

libname proto "directory path";

note that the quotes are necessary and that the full directory path goes between them.

good luck!

** mp **
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top