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!
did you use
schema=dbo; ?
Just right click my mouse on the dataset,I just add a picture,you can see it.
Thanks
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.
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
How Do I Look it Up If I Cannot Spell It: An Introduction to SAS® Dictionary Tables?
Thanks
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
Chris,
I don't think it can check the size or create-time of the table.
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?
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.