f



Re: SAS V9.1 SQL table name re-use issue - Thanks!

Thanks to Peter and Bas and I will start using undopolicy=none should I
like to replace a table.

Regards,

T J


On Wed, 7 Sep 2005 12:08:10 -0400, Peter Crawford
<peter1.crawford@CITIGROUP.COM> wrote:

>On Wed, 7 Sep 2005 11:42:25 -0400, T J <tjpush@YAHOO.COM> wrote:
>
>>Hi everyone,
>>
>>Before SAS 9 I have lots of SQL codes that re-uses an existing table name
>>and there was no warning msg.
>>--------------------------------------------------------
>>data A; do i = 1 to 5 ; x= ranuni(0); output ; end; run;
>>
>>data b; do i = 1 to 5; y=ranuni(0); output; end; run;
>>
>>proc sql;
>>  create table a as
>>  select a.*, b.y
>>   from a, b
>>  where a.i = b.i;
>>quit;
>>----------------------------------------------------------
>>
>>Now in SAS 9, I will get this warning every time:
>>
>>14
>>15   proc sql;
>>16     create table a as
>>17     select a.*, b.y
>>18      from a, b
>>19     where a.i = b.i;
>>WARNING: This CREATE TABLE statement recursively references the target
>>table. A consequence of this is a possible data integrity problem.
>>NOTE: Table WORK.A created, with 5 rows and 3 columns.
>>
>>----------------------------------------------------------------------
>>
>>I wonder how everyone is dealing with this situation.  Is there an option
>>that we can use to turn off this particular warning?
>>
>>Thanks,
>>
>>T J
>
>
>before a create statement that replaces any of its inputs, use
> reset undopolicy = none;
>
>When you want to reinstate normal support/control, use
> reset undopolicy = optional;  *or required;
>
>see undoPolicy among the options on the proc sql statement, at
>http://support.sas.com/onlinedoc/913/getDoc/en/proc.hlp/a002473669.htm
>
>
>Peter Crawford
>
>surprisingly proc sql ; accepts both
>   reset undo_policy =
>and
>   reset undopolicy  =
0
tjpush (19)
9/7/2005 6:46:01 PM
comp.soft-sys.sas 142828 articles. 3 followers. Post Follow

0 Replies
798 Views

Similar Articles

[PageSpeed] 47

Reply:

Similar Artilces:

SAS V9.1 SQL table name re-use issue
Hi everyone, Before SAS 9 I have lots of SQL codes that re-uses an existing table name and there was no warning msg. -------------------------------------------------------- data A; do i = 1 to 5 ; x= ranuni(0); output ; end; run; data b; do i = 1 to 5; y=ranuni(0); output; end; run; proc sql; create table a as select a.*, b.y from a, b where a.i = b.i; quit; ---------------------------------------------------------- Now in SAS 9, I will get this warning every time: 14 15 proc sql; 16 create table a as 17 select a.*, b.y 18 from a, b 19 where a.i = b.i; WARNING...

RE : Re: RE : Re: copulas and SAS
Thanks, I appreciate your comments,I understand that copula is not the appropriate tool to use, what will be the alternative ? Adel David L Cassell <davidlcassell@MSN.COM> a �crit : joewhitehurst@GMAIL.COM replied: > >Adel, > >You may find the following artilce interesting. [article by Thomas Mikosch not copied] This is a really good article, and a really useful point to make. But 55K is a lot of article to copy. Would it have been easier to point to a URL? The people who read SAS-L as a digest and the people who have slow connections are probably not overly thrilled...

Re: Names of things (was Re: [SAS-L] external security managers a nd SAS)
Jack: I have used the term 'cell' to refer to the row/column intersection instance of a 'relvar' (relational variable). I would define a cell value as a relation of degree 1 and arity 1. An empty relation would have degree 1 and arity 0 (a column variable heading but no rows). In comparisons of different relvars in SQL, say, WHERE x=(select x from y where z), we have to name the type of yield of the subquery. I see no reason to avoid the name 'cell'. Sig -----Original Message----- From: Jack Hamilton [mailto:JackHamilton@FIRSTHEALTH.COM] Sent: Wednesday, January 14, 2...

Re: SAS System Viewer 9.1 unable to open SAS datasets ( SAS 9.1.3)
A question in return: is your table from windows? compressed from another system? and specially with personnel formats hard coded inside? Andre msiddu2000 a �crit : > SAS System Viewer 9.1 was able to open datasets that were created by > V8 engine (SAS 8.2), but is unable to open datasets that are created > with V9 engine (SAS 9.1.3). > > Does this need SAS System Viewer to be upgraded ? > or > Something else needs to be done ? > > -- Andr� WIELKI INED (Institut National d'Etudes D�mographiques) Service Informatique 133 Boulevard Davout 7598...

Re: SAS 9.1.1 Vs SAS EG 4.1
Kumar If you are using SAS EG connected to a unix server, and you are submitting the code on the unix server - then yes, I would expect you to get missing value as the unix server in all liklehood cannot see "c:\......" Perhaps you could check the LOG generated by SAS EG and forward that to the list. Cheers Robin ---- SAS-L Nirmal <lazybone2k@GMAIL.COM> wrote: > Dear SAS-L listers, > > I have tried the following sas code in both SAS 9.1(PC sas) and SAS EG 4.1 > connected to a SAS 9.1.3 server on a unix machine. I am getting totally > different results. Can an...

Re: RE : Re: copulas and SAS
Adel, Think Joke! But, more seriously, it did prompt me to look up the origins of the copula as a functional. Joe On 9/27/06, adel F. <adel_tangi@yahoo.fr> wrote: > > Hi, > I do not know how this is related to my orginal question. > > My understanding of copula is, it is a joint distribution with uniform > margins, the problem how to obtain a copula which fits better a data? > > If there is any suggestion from members of SAS list, about examples for > copulae with SAS, I will appreciate that > > Thanks a lot > > Adel > Joe Whitehurst <joew...

Re: RE : Re: SAS on a Mac
Not sure why this has spawned 3 threads: http://listserv.uga.edu/cgi-bin/wa?A1=ind0704e&L=sas-l#21 ...

Re: RE : SAS/ACCESS: How do you determine existence of a table using DB2 pass-through?
Hi, Datametric. Thank you so much for responding to all my new year's questions. I had kind of been hoping that it would be as easy to determine table existence as executing a %sysfunc(exist(db2libref.mytable)), and in fact it is, but there's a trick to it. When I first tried it, it didn't seem to work for me. Here's how I did that: libname dbln db2 database=xdb user="id" using="password"; %let tex1 = %sysfunc(exist(dbln.tbl1)); %* this table exists; %let tex2 = %sysfunc(exist(dbln.tbl2)); %* this table does not exist; %put tex1 = &tex1.; %put tex...

Re: Emailing SAS Graphs using the pull down option -- SAS 9.1
David Johnson <d@DKVJ.BIZ> writes: [...] > The point of my sad tale is that anther prediction I made in the same venue > looks more likely now. I said that there would be an increase in unanswered > and unread messages because of the inability of the reader to identify > genuine material from the rubbish. Emails with attachments are treated by > me with grave suspicion, and it is very likely it will be deleted if the > message subject is not immediately relevant to me. Since a number of > packages that support emailing files will generate an email with a subjec...

Re: What r the data types in SAS? in Base SAS , and SAS SQL
> From: Amar Mundankar > Sent: Tuesday, July 21, 2009 8:10 AM > To: sas-l@uga.edu > Subject: What r the data types in SAS? in Base SAS , and SAS SQL > > Hi all, > What are the different data types in Base SAS and SAS SQL?? character, lengths from 1 to 32,000+ numeric: lengths from 2 to 8 dates are a subtype of numeric and are identified by their date, datetime, or time formats the new proc TSPL (Table Server Processing Language) supports ANSI data types: bigint, tinyint, etc. http://support.sas.com/documentation/cdl/en/tsag/30878/HTML/default/a003 065339.htm http://s...

Re: How to Update table in SAS using Proc SQL with Where
On Fri, 13 Apr 2007 15:35:13 -0400, SUBSCRIBE SAS-Nim Pat <npp1129@GMAIL.COM> wrote: >Hi All, >I have table without any Key Identifier, Welcome to real world. Now I need >to compare records with each other in same table like: >Condition Like: >If Var1(in record# 1)= Var1(Record other than #1) and >Var2 <> Var2 and >Date1 (in record# 1) - Date1 (Record other than #1) > 5 >And then Update Field flag = 1 >Else flag = 0; > >Please if anyone has any idea?? >Thanks, >Nim Isn't it just a straightforward update you want then, using "exis...

Re: Emailing SAS Graphs using the pull down option -- SAS 9.1 #5
David Many thanks for the reply. I, too, have no love for BMPs and when offered the opportunity, save graphics files in more compact formats. While our internal email will allow me to send such porcine files, our limits on stored email will often cause problems. I have had a couple replies from tech support and they, of course, said that I have two alternatives: 1) use the feature as it now stands: select email from the drop down and send it as a bmp with a default name 2) use the export feature where I have complete control and then create the message on my own and attach the...

Re: Emailing SAS Graphs using the pull down option -- SAS 9.1 #4
I think this is what I would expect. There is no love lost between the space on my hard drive and BMP files. I find them to be extremely inefficient and prefer one of the compressed formats, selecting the level of compression the task will bear. This also means I specify an output file name and use an appropriate SAS/Graph driver for the output. The default behaviour is useful only to demonstrate that the graph generation works and that the email engine is correctly configured. Depending on an approach that delivers bloat mails puts my work at risk of not being read due to file sizes and e...

Re: Emailing SAS Graphs using the pull down option -- SAS 9.1 #6
I don't see it as derailing the conversation, when the original poster wanted to be able to change file names to meaningful values. Rather than viewing this goals as a whimsical desire, it is appropriate to testify as to the necessity of providing this feature so that those involved in deciding whether the change will be made can be persuaded to view it with appropriate seriousness. The decision to list the change lies with SAS, the decision to vote for it as a change rests in the SAS user community. So I think it is eminently relevant. The increase in the range of candidate files type...

Re: Emailing SAS Graphs using the pull down option -- SAS 9.1 #2
David Alas, but your knowledge of vulgar American idioms does seem to be sufficient to handle normal locker room conversation. You did, indeed, recognize my reference. If they shoot the messengers, do they also shoot those who accurately predict unfortunate future events? If so, I suggest that you start digging a foxhole. I, too, view any attachment from an unknown source as suspicious and I have noted a sudden spate of these in the past month or two. It seems like two or three are now coming in daily. Nat Nat Wooding Environmental Specialist III Dominion, Environmental Biology 4111 Castl...

Web resources about - Re: SAS V9.1 SQL table name re-use issue - Thanks! - comp.soft-sys.sas

Donald Trump’s Iowa Post Mortem: Skipping Fox Debate May Have Benefited Opponents
Donald Trump told Fox News Channel’s “Hannity” that his decision to skip the Republican debate in Iowa last week and instead hold a benefit for ...

iPhone 7 reportedly gets rid of one of Apple's biggest design flaws
There's little doubt that the iPhone 7 release date will be in September and include a new design, but now hearing we're what that may in fact ...

Yahoo to cut 1,700 workers as CEO tries to save her own job
SAN FRANCISCO (AP) — Yahoo is laying off about 1,700 employees and shedding some of its excess baggage in a shake-up likely to determine whether ...

First U.S. Zika virus transmission reported, attributed to sex
By Jon Herskovitz AUSTIN, Texas (Reuters) - The first known case of Zika virus transmission in the United States was reported in Texas on Tuesday ...

Europe and the U.S. Have Reached a New Agreement on Data-Sharing
More Yahoo Will Lay Off 15% of Workforce IKEA Really Wants You to Put Your Phone Away and Enjoy Your Life Here’s Why Twitter’s Stock Is Surging ...

‘Star Wars,’ ‘Revenant’ Rain on ‘Mad Max’ Parade at Visual Effects Society Awards
Is it a telling sign for George Miller's opus in the Oscar derby?

Android Marshmallow: The smart person's guide
This comprehensive guide covers the must-know details about Android Marshmallow.

North Korea plans long-range rocket launch in defiance of warnings
SEOUL, South Korea — North Korea plans to launch a long-range rocket it claims is for an Earth observation satellite, but critics think it's ...

Judge could rule on Cosby bid to toss sex-assault charges
NORRISTOWN, Pa. (AP) — A suburban Philadelphia judge hopes to decide whether to dismiss a sexual assault case against actor Bill Cosby over an ...

'American Crime Story' cast: Where they were during O.J. Bronco chase
The low-speed police pursuit of NFL great O.J. Simpson through the streets and freeways of Southern California on Sept. 17, 1994, might not be ...

Resources last updated: 2/3/2016 8:34:20 AM