|
Kevin,
SASHELP.VMEMBER (from DICTIONARY.MEMBERS) contains a record for each "SAS
file". "SAS files" include not only SAS data sets, but also things like
catalogs and item stores, which don't have columns and therefore wouldn't
show up in VCOLUMN. So, my guess is that the "missing" LIBNAMES contain one
or more of these, but no data sets or views.
Hope that's it!
Mike Rhoads
Westat
RhoadsM1@Westat.com
-----Original Message-----
From: Kevin Roland Viel [mailto:kviel@EMORY.EDU]
Sent: Thursday, June 03, 2004 4:57 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: SASHELP.VCOLUMN is missing libraries
I have submitted the following code:
proc sql ;
title "SASHELP.vcolumn" ;
select distinct libname
from SASHELP.vcolumn
;
title "SASHELP.vmember" ;
select distinct libname
from SASHELP.vmember
;
quit ;
I have obtained:
SASHELP.vcolumn
Library
Name
FVIII
MAPS
SASHELP
SASUSER
SASHELP.vmember
Library
Name
AA
FILE_ID
FVIII
GAIT
MAPS
PCR
SASHELP
SASUSER
SNP23
WORK
All of these libraries are functional, i.e. I can access them through the
explorer window or in my code. Might anyone suggest a reason? If I
create a temporary dataset from a dataset in AA, for instance, then I can
use VCOLUMN to obtain its variables.
Thanks,
Kevin
Kevin Viel
Department of Epidemiology
Rollins School of Public Health
Emory University
Atlanta, GA 30322
| 
