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 derfloh 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
Joined
Mar 22, 2005
Messages
4
Location
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 **
 
Please don't post the same question in multiple places.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top