Date:         Tue, 4 Mar 2003 09:30:36 -0600
Reply-To:     peetie_wheatstraw@lycos.com
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Peetie Wheatstraw <peetie_wheatstraw@LYCOS.COM>
Organization: Lycos Mail  (http://www.mail.lycos.com:80)
Subject:      Re: "Rules" for naming etc datasets and views in same library
Comments: To: Ed Heaton <EdHeaton@westat.com>
Content-Type: text/plain; charset=us-ascii

On Mon, 3 Mar 2003 09:25:57
 Ed Heaton wrote:
>Peetie,
>
>Your answer is no.  A view and a data set in the same library cannot have
>the same name.

You answer a question invented by yourself, not I.

I asked about:

>Is there any way to allow replacement of a dataset with a
>same-named view (and vice-versa)  ...

Replacement. R-e-p-l-a-c-e-m-e-n-t. Not co-existence.

Evidently "Replacement" is not practical.

I also asked about "rules" ...

>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?

Would be a hulluva mess, wouldn't it?  :-)

  Cheers,
  Peetie

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

>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
>


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