topic Re: why odbc dataset can't show detail in SAS Procedures

why odbc dataset can't show detail

Mike_Davis — Fri, 18 May 2012 14:03:37 GMT

Hello everyone,

If a dataset was signed from an odbc,when I right click the dataset in explore of SAS, it can't show how many rows and waht is the create date. why?

Thanks!

Re: why odbc dataset can't show detail

Linlin — Fri, 18 May 2012 15:15:27 GMT

did you use

schema=dbo; ?

Re: why odbc dataset can't show detail

Mike_Davis — Fri, 18 May 2012 15:44:21 GMT

Just right click my mouse on the dataset,I just add a picture,you can see it.

Thanks

Re: why odbc dataset can't show detail

Linlin — Fri, 18 May 2012 17:11:00 GMT

below is my libname statment:

libname x odbc dsn=**** uid=**** password=**** schema=dbo;

can you see a screen like the attached screen shot? if so you can click the columns tab.

Re: why odbc dataset can't show detail

Mike_Davis — Fri, 18 May 2012 17:20:27 GMT

Hi Linlin,

The column tab only show informaton of column,I want to check how many rows in the dataset and the create date.

these informations locate at general tab.

Thanks

Re: why odbc dataset can't show detail

sassharp — Fri, 18 May 2012 18:35:45 GMT

http://www2.sas.com/proceedings/sugi31/259-31.pdf

Re: why odbc dataset can't show detail

Mike_Davis — Fri, 18 May 2012 20:42:28 GMT

How Do I Look it Up If I Cannot Spell It: An Introduction to SAS® Dictionary Tables?

Thanks

Re: why odbc dataset can't show detail

Ksharp — Mon, 21 May 2012 02:18:26 GMT

The best way is entering the DataBase(DB2 Sybase ...) your ODBC connected and use their SQL to query these information. Can you connect with the Administrator of these database ?

Ksharp

Re: why odbc dataset can't show detail

ChrisNZ — Mon, 21 May 2012 03:13:40 GMT

run

option details;

Re: why odbc dataset can't show detail

Ksharp — Mon, 21 May 2012 04:35:10 GMT

Chris,

I don't think it can check the size or create-time of the table.

Re: why odbc dataset can't show detail

ChrisNZ — Mon, 21 May 2012 06:00:46 GMT

You might be right.

It works with oracle so I assumed it worked for most common sas/access engines.

Mike can you confirm when you have tried?

Re: why odbc dataset can't show detail

shivas — Mon, 21 May 2012 07:13:45 GMT

Hi Mike,

I Guess you cannot get created date information using base SAS for odbc library,but you can get this information for sas datasets.

If you want to know create date information you can login to sqlserver and properties you will get that.

Hope this helps...

Thanks,

Shiva