It looks like your problem is that you've got a quote in a table name:
If it is possible to rename that table, that might work. =20
Also, if you use the import feature in SAS, it will write code for you =
that you can save and put in a program- you might try that to see if it =
can handle this kind of file name. I'd rename the table in Access, =
though- a quote in a table name is likely to contiously cause you =
----- Original Message -----=20
Sent: Wednesday, January 16, 2008 11:31 AM
Subject: How to access automatically in SAS a MS Access table name =
which has more than 32 characters?
Happy New Year ,
Please, I need your help in figuring out how to access in SAS a MS
table name which has more than 32 characters. As this program merges 5
databases, I need to have almost everything automated. That's why I
don't want to rename manually the table names.
Please find the program below.
Thanks in advance for your kind assistance,
- - -
options VALIDVARNAME=3DANY ;
libname DBsource access 'S:\Data
Management\External\Projects\MTCT-Plus\MTCT-Plus November 2007
/* Creating the Pediatric HIV result information additional */
data* pedResultadd ;
set dbsource.'tblInfantHIVTestResultsAdditional'n (keep =3D
testid studyid labid i2 i2_da i2_mo i2_yr i2a i2b i2text
- - - The log - -
1637 /* Creating the Pediatric HIV result information additional */
1639 data pedResultadd ;
1640 set dbsource.'tblInfantHIVTestResultsAdditional'n (keep =3D
ERROR 211-185: Invalid data set name.
1642 testid studyid labid i2 i2_da i2_mo i2_yr i2a i2b i2text
Jean Baptiste KAMGANG,
Lead Data Manager - CDC Cameroon
US Centers for Disease Control and Prevention
Mutengene, SouthWest Province Cameroon, Africa
E mail: JBKamgang@cm.cdc.gov.
Tel: + 237 3 335 1690
Fax: + 237 3 335 1692
Cell: + 237 9 984 79 14