Date: Mon, 2 Apr 2007 22:22:35 -0700
Reply-To: David L Cassell <davidlcassell@MSN.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: David L Cassell <davidlcassell@MSN.COM>
Subject: Re: Organising data sets
In-Reply-To: <1175530783.837324.315120@q75g2000hsh.googlegroups.com>
Content-Type: text/plain; format=flowed
ramsathish@GMAIL.COM wrote:
>
>Dear all,
>
> In Microsoft Excel (Spread Sheet), we can create / save many
>sheets under one file. Similarly is there anyway to organise two or
>more dataset in a library to a single dataset with multiple sheets in
>the library.
>
>Any one please help me.
>
>Thanks in advance.
First, you need to understand the difference between a real database
and a bunch of stuff in a spreadsheet.
Second, you need to think about the value of a couple data sets
'connected' together in some well-defined way. In database
management, we take tables and link them together via keys.
This (eventually) yields a whole slew of data tables, all linked together
through a database schema. A full-scale RDBMS will do this, providing
a view into the entire warehouse of tables.
SAS can do some of this. You can certainly define views and/or
new data sets which are the resultants of linking a collection of
data sets together.
But SAS does more in some situations. If some of your sheets
are just look-up tables, then SAS would use formats to provide
this sort of data translation. It's just a different paradigm.
So what exactly are you looking for? If you explain it in more detail,
someone can undoubtedly tell you how to get there. Unless you're
looking for a way to take a wad of crud that violates all database
standards, and magically cram it into a functional database schema.
HTH,
David
--
David L. Cassell
mathematical statistician
Design Pathways
3115 NW Norwood Pl.
Corvallis OR 97330
_________________________________________________________________
Need a break? Find your escape route with Live Search Maps.
http://maps.live.com/?icid=hmtag3
