Date:         Mon, 3 Mar 2003 09:25:57 -0500
Reply-To:     Ed Heaton <EdHeaton@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ed Heaton <EdHeaton@WESTAT.COM>
Subject:      Re: "Rules" for naming etc datasets and views in same library
Comments: To: "peetie_wheatstraw@lycos.com" <peetie_wheatstraw@lycos.com>
Content-Type: text/plain

Peetie,

Your answer is no.  A view and a data set in the same library cannot have
the same name.  Imagine the problems if they could.

Suppose you could and did have a data set myLib.myDat and a view
myLib.myDat.  Then, if you coded...

Proc freq data=myLib.myDat ;
Run ;

would the FREQ procedure process the data set or the view?

Ed

Edward Heaton, Senior Systems Analyst,
Westat (An Employee-Owned Research Corporation),
1600 Research Boulevard, Room RW-3541, Rockville, MD 20850-3195
Voice:  (301) 610-4818                    Fax:  (301) 610-5128
mailto:EdHeaton@westat.com                http://www.westat.com



-----Original Message-----
From: Peetie Wheatstraw [mailto:peetie_wheatstraw@LYCOS.COM]
Sent: Sunday, March 02, 2003 7:33 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: "Rules" for naming etc datasets and views in same library


Hi,

SAS datasets (memtype=DATA) and SAS views (memtype=VIEW)
often reside in the same library. What are the rules
for naming etc such entities? I searched the onlinedoc
and didn't find anything.

Replacing datasets with same-named datasets has long
been common practice and may save disk space. Is there
any way to allow replacement of a dataset with a
same-named view (and vice-versa) avoiding the following
problem?

786  data one / view=one; x=4; run;

ERROR: Unable to create WORK.ONE.VIEW because WORK.ONE.DATA already exists.
ERROR: Unable to save DATA STEP view WORK.ONE.
NOTE: The SAS System stopped processing this step because of errors.

Are there different rules for sql-created views and
data-step views?

Etc etc.

  Thanx,
  Peetie

------------------------------------------------------------
| Peetie Wheatstraw            peetie_wheatstraw@lycos.com |
------------------------------------------------------------


_____________________________________________________________
Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year.
http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus