Date: Wed, 17 Dec 2003 10:50:16 -0500
Reply-To: "Fehd, Ronald J. (PHPPO)" <rjf2@CDC.GOV>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Fehd, Ronald J. (PHPPO)" <rjf2@CDC.GOV>
Subject: Re: Question about Permanent Datasets
Content-Type: text/plain; charset="us-ascii"
as a data manager
I would recommend that you
1. Read your data from the DAT directory
and create a permanent SAS data set;
formats go in this library as well.
2. Review Data
my own SOP has seven steps here
3. Data Structure Reorganization:
rotation, transpose, subset, etc
anything needed to be done for the next step:
4. Number Crunching, Summarization, and Reporting
Divide and Conquer
in programming means
Divide Tasks into Meaningful Groups
the smaller the better
Ron Fehd the macro maven CDC Atlanta GA USA RJF2@cdc.gov
If you always try to be logical,
you probably won't ever have much sorrow,
or much fun.
-- Ashleigh Brilliant pot-shot #4438
I don't necessarily agree
with everything I say.
-Marshall McLuhan, cultural historian
and communications theorist (1911-1980)
> From: Sober Hi [mailto:soberhi@YAHOO.COM]
> Any DIRECT references to
> relevant articles would be appreciated.
> Let's say I have a folder called: DAT which contains various
> datasets (ds1, ds2, etc.....); So the data is stored on the
> SAS server in a "flat file".
> Let's also say that I need my SAS program to do various
> calculations on ds1.
> QUESTION: Is it better to:
> (1) Create a dataset in the SAS temporary WORK folder,
> process all calculations in the WORK-based dataset andthen
> copy it out to the flat file dat.ds1?
> Example of (1):
> Data ds;
> set dat.ds1;
> process multitudes of calculations on ds
> Data dat.ds1;
> set ds; /* where this is from WORK */
> (2) Do the actual calculations on the dat.ds1 itself
> (including a couple of sorts)..... and not create the
> temporary dataset?
> What considerations do I need to think about (ie: size of
> dataset, number of calculations, etc....)?
> Thank you so much to all the responders......
> Great forum.