|Date: ||Fri, 20 May 2011 12:40:50 +0000|
|Reply-To: ||"Fehd, Ronald J. (CDC/OCOO/ITSO)" <rjf2@CDC.GOV>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||"Fehd, Ronald J. (CDC/OCOO/ITSO)" <rjf2@CDC.GOV>|
|Subject: ||Re: Presentation question for RUGs and SGF - SAS datasets or
|Content-Type: ||text/plain; charset="us-ascii"|
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
report (summary) == periodic or accumulating snapshot
Here is sql to begin your search:
PROC SQL; describe table dictionary.tables;
select LibName, MemName, MemType,
MemLabel, Nobs, Nvar
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: firstname.lastname@example.org [mailto:owner-sas-
> email@example.com] 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
> > sets?
> > Depends on what you need to demo. I have used sashelp.shoes for my
> > on speaking Klingon. I used the Northwind database that comes with
> > Microsoft access for papers on SQL and Access. I would think you can
> > a SAS dataset in sashelp or the samples library that would be
> > Dianne @ census