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.