05-18-2012 10:03 AM
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?
05-18-2012 01:11 PM
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.
05-18-2012 01:20 PM
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.
05-20-2012 10:18 PM
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 ?
05-21-2012 02:00 AM
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?
05-21-2012 03:13 AM
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...