Folks,
I'm just now beginning to use Access. To date, I've managed hundreds
of thousands of records in SAS, but would like to expand my software
horizon. I've read some and sat throught some classes, but one of
things that I can't seem to get my head wrapped around is this: if
you're given a large table that has missing and incomplete records and
you want to clean that data up, (replace missing dates using the
previous record and randomly assign records a value based on a number
of criteria for example), do you actually modify the original table or
simpy create queries that create "temporary" tables that contain the
new and improved records?
I know that in SAS, you may have several data steps and several
temporary data sets, but when you get the data like you want it, you
create a permanent SAS data set that is stored on your computer or a
server. In the end, your raw data remains in tact and you also have a
cleaned copy of that data for subsequent analyses. All of the
intermediate data sets are gone when you exit SAS. Perhaps queries in
Access can be viewed as intermediate data steps. And I suppose that if
you wanted, you could create a permanent copy of the cleaned table once
you got the data just the way you wanted it. Does this make any sense
at all?
Mike
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
