My personal preference is to use SAShelp data sets.

YMMV, especially as I think there are not fact tables in SAShelp.

That said, there is no documentation that I am aware of that describes whether the table is.a: dimension (lookup) table fact table, report (summary) == periodic or accumulating snapshot

see also: http://www.sascommunity.org/wiki/Database_Vocabulary

Here is sql to begin your search:

PROC SQL; describe table dictionary.tables; select LibName, MemName, MemType, MemLabel, Nobs, Nvar from Dictionary.Tables; quit;

note2self: run SmryEachVar on libref=SAShelp and provide pseudo==best.guess documentation

note: much to my surprise I found that SAShelp.Shoes, which seemed obvious that it was a summary report had two observations for one item. ;-(

"Things are not always as they seam!"

Ron Fehd the sql dictionaries maven

> -----Original Message----- > From: owner-sas-l@listserv.uga.edu [mailto:owner-sas- > l@listserv.uga.edu] On Behalf Of Jack Hamilton > Sent: Thursday, May 19, 2011 9:09 PM > To: Dianne Rhodes > Cc: SAS-L@LISTSERV.UGA.EDU > Subject: Re: [SAS-L] Presentation question for RUGs and SGF - SAS > datasets or other data? > > I agree, I'd rather see a standard data set supplied, or have one > generated de novo at random. I don't want to type in or download data. > > Is there a list somewhere of all the data sets that come with base SAS? > I know that there are differences across versions, and additional > sample data sets may appear if you have more products installed. > > > > On May 19, 2011, at 12:11 PM, Dianne Rhodes wrote: > > >> Do you prefer to see presentations that use SAS data sets or other > data > > sets? > >> > >> > > > > Depends on what you need to demo. I have used sashelp.shoes for my > paper > > on speaking Klingon. I used the Northwind database that comes with > > Microsoft access for papers on SQL and Access. I would think you can > find > > a SAS dataset in sashelp or the samples library that would be > appropriate. > > > > Dianne @ census