SAS V9.1 SQL table name re-use issue
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;
create table a as
select a.*, b.y
from a, b
where a.i = b.i;
Now in SAS 9, I will get this warning every time:
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
I appreciate your comments,I understand that copula is not the appropriate tool to use, what will be the alternative ?
David L Cassell <davidlcassell@MSN.COM> a �crit :
>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)
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'.
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?
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 ?
> Something else needs to be done ?
INED (Institut National d'Etudes D�mographiques)
133 Boulevard Davout 7598...Re: SAS 9.1.1 Vs SAS EG 4.1
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.
---- 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
Think Joke! But, more seriously, it did prompt me to look up the
origins of the copula as a functional.
On 9/27/06, adel F. <firstname.lastname@example.org> wrote:
> 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
> Joe Whitehurst <joew...Re: RE : Re: SAS on a Mac
Not sure why this has spawned 3 threads:
...Re: RE : SAS/ACCESS: How do you determine existence of a table using DB2 pass-through?
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: email@example.com
> 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://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
>I have table without any Key Identifier, Welcome to real world. Now I need
>to compare records with each other in same table 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??
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
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
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
The increase in the range of candidate files type...Re: Emailing SAS Graphs using the pull down option -- SAS 9.1 #2
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
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.
Environmental Specialist III
Dominion, Environmental Biology