| 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/
| 
