Date:         Mon, 6 Dec 2004 12:00:17 -0600
Reply-To:     "Dunn, Toby" <Toby.Dunn@TEA.STATE.TX.US>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Dunn, Toby" <Toby.Dunn@TEA.STATE.TX.US>
Subject:      Re: view in sas
Comments: To: Ben <benpub7@YAHOO.COM>
Content-Type: text/plain; charset="us-ascii"

Ben,

A SAS view is a set of instructions to tell SAS how to generate a
dataset.  Where as a SAS dataset regardless of where there data
originally came from is actual data.  Now that said it can be the case
where you pull data from a database that is being updated (daily,
weekly, monthly, etc...) and the data you extracted from the data base
into a SAS data set represents the data table you pulled it from for
that moment.


/*SAS view */

Data one / view = one;
 Set two;
 Do something;
Run;


/*At this point there is no dataset ONE yet created.  Just a set of
instructions to tell SAS */*when data set one is called to be used
generate the data this way.                          */


Data three ;
 set one;
Do something;
Run;

/*Here we use view one and the data that is feed into data step three is
the data that is generated by running the instructions given in the view
called ONE.

HTH
Toby


HTH
Toby



-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Ben
Sent: Monday, December 06, 2004 11:48 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: view in sas


for data oriented SAS, I don't know what is the role that SAS view
takes. it seems to me the SAS datasets pulled out from database are
views of the database tables. is that right?

Thanks