BookmarkSubscribeRSS Feed
doudouh
Fluorite | Level 6

Hi,

 

I created an odbc intersystems cache library but I can't see any table.

 

could you help me

Thx

 

6 REPLIES 6
LinusH
Tourmaline | Level 20

Step one, test from a non-SAS client on the same machine. Like Excel.

Then there can be tons of reasons: authorization, source table names not comply with SAS naming conventions (table names longer than 32 char as an example).

Also, check with the DBA if they can spot any messages during your access.

Can you perform an explicit SQL pass through?

Data never sleeps
doudouh
Fluorite | Level 6

Thx for your replay.

I don't have the name of the tables in order to do this test. 

SASKiwi
PROC Star

So how did you create this? In code, in SAS Management Console, or some other means? Without details of how you set this up we can only guess what might be wrong.

doudouh
Fluorite | Level 6

Hi,

 

I created the librairy in Management console, everything is correct.

 

Thx

LinusH
Tourmaline | Level 20
Say what now? So how do you even know that there are any tables? In order to trouble shoot this you need help from people on the DB side.
Data never sleeps
doudouh
Fluorite | Level 6

Ok Thx,

I will see with DBA team

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 6 replies
  • 1014 views
  • 0 likes
  • 3 in conversation