Date:         Wed, 22 Jul 2009 15:20:36 -0400
Reply-To:     Tom <tomquin99@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Tom <tomquin99@GMAIL.COM>
Subject:      table or view? -- import from MS Access

I will import data from MS Access to SAS.
I use the code below to get the content of the database.
libname mylib Access  "\\path\mydata.mdb";
proc contents data=mylib._all_ noprint out=contents;run;

I know there are at least two types of components in the mdb file. One is
regular table, anoher is view or query.

My question is how I can distinguish them in SAS ?

In the output above,
MEMNAME gives all the names of the components;
TYPEMEM are all empty;
MEMTYPE has a single value 'DATA'


Thanks a lot for reply.