LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (July 2005, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Fri, 8 Jul 2005 13:51:40 -0700
Reply-To:   DC <chendlcan@YAHOO.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   DC <chendlcan@YAHOO.COM>
Subject:   SAS 8.2 to SAS 9.1 libname convertion
Content-Type:   text/plain; charset=iso-8859-1

Hi All,

my codes created on SAS 8.2 does not work on SAS 9.1? Anyone knows how to convert the below code to SAS 9.1? Thanks a lot!

SAS 8.2: libname bb dbaccess 'x:\a\b\c\d.mdb' bbb='asdfgh zxcvbn'; libname cc dbaccess 'x:\a\b\c\d.mdb' ccc='asd zxc';

proc sql; create table eee as select b.* from cc.ccc A, bb.bbb B where a.id=b.id; quit;

SAS 9.1: libname bb 'x:\a\b\c\d.mdb' ; libname cc 'x:\a\b\c\d.mdb' ;

proc sql; create table eee as select b.* from cc.asd_zxc A, bb.asdfgh_zxcvbn B where a.id=b.id; quit;

problem: seems sth wrong with "asdfgh_zxcvbn" log shows "File bb.asdfgh_zxcvbn.DATA does not exist."

____________________________________________________ Sell on Yahoo! Auctions no fees. Bid on great items. http://auctions.yahoo.com/


Back to: Top of message | Previous page | Main SAS-L page