Altair SLC doesn't support the _ALL_ syntax for proc contents for ODBC-connected databases.

Question

Unlike SAS, Altair SLC doesn't support the ALL syntax for proc contents for ODBC-connected databases.

Note 'proc contents' works with [libname].table but fails with [libname].all, see below

1         libname sqlite odbc noprompt=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX;

NOTE: Library sqlite assigned as follows:

Engine:        ODBC

Physical Name:  (SQLite version 3.43.2)

2

3         * this works;

4         proc contents data=sqlite.avgs nods;

5         run;quit;

WARNING: truncating character column sex to 1024 characters long, based on dbmax_text setting.

NOTE: Procedure contents step took :

real time : 0.031

cpu time  : 0.031

6

7         * but this does not;

8         proc contents data=sqlite.all nods;

9         run;quit;

NOTE: No matching members in directory

NOTE: Procedure contents step took :

real time : 0.030

cpu time  : 0.000

NOTE: Libref SQLITE has been deassigned.

ltair SLC

The CONTENTS Procedure

Data Set Name           AVGS

Member Type             VIEW

Engine

Observations                .

Variables               4

Indexes                 0

Observation Length      1789

Deleted Observations             0

Data Set Type

Label

Compressed              NO

Sorted                  NO

Data Representation

Encoding                wlatin1 Windows-1252 Western

Alphabetic List of Variables and Attributes

Number    Variable      Type             Len             Pos    Format          Informat

3    AVG_AGE       Char             255            1279    $255.           $255.

       4    AVG_HEIGHT    Char             255            1534    $255.           $255.

       1    NAMES         Char             255               0    $255.           $255.

       2    SEX           Char            1024             255    $1024.          $1024.

Altair SLC

The CONTENTS Procedure

Directory

Libref         SQLITE

Engine         ODBC

Data Source

Roger DeAngelis_21630 · Answer

I could not get proc datasets, proc sql or proc contents  to diplay the tables in a sqlite database, howerver 'proc sql passthu' di work.

proc sql;

connect to odbc

(noprompt="DRIVER=SQLite3 ODBC Driver;

Database=d:\sqlite\mysqlite.db;

LoadExt=d:\dll\sqlean.dll;");

select * from connection to odbc

(select name as sqlite_objects  from sqlite_master);

quit;

sqlite_objects

sqlean_define

sqlite_autoindex_sqlean_define_1

have

avgs