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: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year.I took the advanced exam this April because I wanted a relatively
systematic way of assessing my knowledge of SAS in a short time span.
For that purpose, it was worth it.
Since I learn SAS by doing new tasks, or re-doing old tasks in a new
way, I assume my knowledge of SAS is uneven, even though I am regarded
as productive, and frequently creative in using SAS to solve our group's
problems.
I passed the test, with lower subscores on the components that I
expected to be weakest on. I thought many of the questions made me
think about some fundamental, sometimes subtle, features of the
lan...
how to add fonts to the sas registry (was RE: Re: sas/graph:Success! A google search led me to:
http://support.sas.com/documentation/onlinedoc/base/91/freetype-hub.pdf
Which includes the magic option on FONTREG to use the "all" mode. (And
now that I look back on the FONTREG docs, I see it there was well :-P).
So here's code that works:
* =================================== ;
proc fontreg mode = all msglevel = verbose ;
truetype 'c:\windows\fonts' ;
run ;
data phoney ;
do n = 1 to 2000 ;
x = ranuni(-1) ;
if n le 1000 then grp = "one" ;
else grp = "two" ;
output ;
end ;
run ;
gopti...
Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #7Well Toby, let me ask something then. Since I am not an ODS fan and haven't
used proc report/tabulate for some time, would that be an automatic
disqualifier since you don't allow reference books or materials? SAS does
not provide tools that help me code ODS (except for EG) and therefore a
reference material is all I would need. Now, it's not like I haven't used
proc report (used it extensively at one time), it's just that I prefer other
means to produce the final output.
It seems that a test like this would toss me out of the pool from the
get-go. Heck, maybe that's wh...
Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #8On Tue, 4 Sep 2007, Alan Churchill wrote:
> It seems that a test like this would toss me out of the pool from the
> get-go. Heck, maybe that's what the goal would be ;-]
Well then, maybe the rest of us might have a chance then :)
Given that I have not used SAS regularly in months, I would be hurting.
Hopefully, I would not be tossed immediately either.
Isn't one point of the test to allow a organization to call itself a
partner or some other distinction? Maybe to be listed among companies on
SI's websites?
Kevin
Kevin Viel, PhD
Post-doctoral fellow
Department of Geneti...
Re: R vs. SAS (was Replacement for SAS (SPSS vs. SAS, redux)) #5I think that SAS and R are very similar, even though their
designs are very different. What matters is that both can be
used to accomplish the same things - just as English and
Swahilli serve the same purpose (communication) equally well.
As for the copyleft "mess", do you really believe the propaganda
and outright lies perpetrated by some companies? Remember, they
want you to pay $$$ for your software, and copyleft poses a huge
threat to that goal.
-----Original Message-----
From: Peter Flom [mailto:flom@NDRI.ORG]
Sent: Thursday, February 05, 2004 12:57 PM
To: SAS-L@LISTSERV.UGA....
Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #10I actually think you are straight-jacketing the interview for a senior
person. I would definitely look for someone who thought outside of the box.
That may be ways of doing things other than macros or ODS or else putting a
new spin on them. I ditched most of the macro language a decade ago, for
example.
As a hiring manager, I always went for creativity and not specific skills on
hand and was very pleased with my hires. But hey, I don't hire anymore so it
isn't something I have to face.
BTW, no client has ever asked me for certification nor have I been quizzed
on specific SAS knowledg...
Re: R vs. SAS (was Replacement for SAS (SPSS vs. SAS, redux)) #4No, sorry if I made it sound that way.....
SAS and R are totally different in the way they work, how they are
structured, what the statements look like, and so on. Not like French
and Spanish, not even like English and Spanish. More like English and
Swahilli.
R has a lot in common with S Plus, both are based on the S language.
But there is no hostility that I know of between S Plus and R (unlike
the situation with Linux)
Peter
>>> <ben.powell@CLA.CO.UK> 2/5/2004 10:36:32 AM >>> wrote
Sounds like R is the SAS equivalent of Linux .. who are incidentally in
all
sort...
Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #4Ed ,
I still contend and stick with they should both be able to program and know
how SAS works. I prefer the intervewing company give a test, were the
person being interviewed is sat in front a laptop or desktop and told to
write code to solve some problems. No online help no books just the persona
nd the computer. This weeds out those who can code and those who cant, from
those who can you then talk to them about the code they wrote and you can
deduce those who understand how SAS works and thos who dont. The pool you
are left with are the qualified candidates atleast from a SAS perspecti...
Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #11Kevin,
Thank you for the nice words...I am sure I wouldn't have a chance on any
stat exam, BTW.
What I am good at is being in an absolute crisis and trying to get it solved
with no time on the clock. That is why I think in a quirky manner. When the
obvious isn't working, take a different path because there is simply no time
left. It's what I did at MCI, SAS, and now as an independent.
....and that skill will not be measured on a certification exam or plopping
me in front of a PC to hammer out an example SAS program.
For any candidate, I can pick up their technical level with a few questions
and watching their reactions.
Alan
Alan Churchill
Savian
www.savian.net
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Kevin
Roland Viel
Sent: Tuesday, September 04, 2007 4:02 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year.
On Tue, 4 Sep 2007, Alan Churchill wrote:
> It seems that a test like this would toss me out of the pool from the
> get-go. Heck, maybe that's what the goal would be ;-]
Well then, maybe the rest of us might have a chance then :)
Given that I have not used SAS regularly in months, I would be hurting.
Hopefully, I would not be tossed immediately either.
Isn't one point of the test to allow a organization to call itself a
partner or some other distinction? Maybe to be listed among companies on
SI's websites?
Kevin
Kevin ...
Re: R vs. SAS (was Replacement for SAS (SPSS vs. SAS, redux)) #2Sounds like R is the SAS equivalent of Linux .. who are incidentally in all
sorts of a copy left/right mess at the moment.
On Thu, 5 Feb 2004 09:39:37 -0500, Peter Flom <flom@NDRI.ORG> wrote:
>I use both SAS and R; I"ve used SAS for 10 or 15 years, R for about 6
>months - 1 year.
>
>Each has strengths and weaknesses; I'd not like to give up either.
>
>Strengths of SAS (esp. compared to R)
>
>Tech support - I have SAS tech support's phone number and our license
>number memorized. They're great.
>
>SAS-L - There's also an R-help list...
Re: R vs. SAS (was Replacement for SAS (SPSS vs. SAS, redux)) #3Wow, that was a leap. Better not use Apache or PHP then.
Andy
>-----Original Message-----
>From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On
>Behalf Of ben.powell@CLA.CO.UK
>Sent: Thursday, February 05, 2004 10:37 AM
>To: SAS-L@LISTSERV.UGA.EDU
>Subject: Re: R vs. SAS (was Replacement for SAS (SPSS vs. SAS, redux))
>
>Sounds like R is the SAS equivalent of Linux .. who are
>incidentally in all
>sorts of a copy left/right mess at the moment.
>
>On Thu, 5 Feb 2004 09:39:37 -0500, Peter Flom <flom@NDRI.ORG> wrote:
>
>>I use both SAS a...
Re: SAS Job websites WAS(Re: SAS jobs for freshers in USOn Fri, 24 Mar 2006 11:27:44 -0500, Steven Raimi <steven.raimi@ONSTAR.COM>
wrote:
>Another very helpful (and focused) web site for SAS jobs is
>icrunchdata.com. I'll try to
....post from home later, where I have a set of links (I don't have them at
my new job here, which, FYI, I found via Monster).
I'll also try to avoid fumble-fingering that accidently posts my messages
before I'm done writing them!
Steve
...
Re: SAS Sample 1728 Was ---> Re: SAS Sample 1727Nice thread guys .... I guess this is what open source development is all
about ....
Got me thinking about suggesting a code/macro library on sascommunity.org?
Any thoughts?
...
Re: SAS Sample 1728 Was ---> Re: SAS Sample 1727 #3First, let me admit/acknowledge that I have no knowledge of the history of
this thread. Been tied up catching up post SAS Global Forum and post the
announcement of sasCommunity.org.
But I would like to offer some thoughts regarding Toby's comment:
> No as for the sascommunity.org, do we really want a macro library. Well I
> would say yes and no. I would like to have one and there are those who
> have
> paced some Macros on there already. I believe Don and Ron both have,
> actually they were on there before the Wiki went public. However, since
> people tend to get Ma...
Re: SAS and SAS/IML TO Cricardosilva@SERASA.COM.BR wrote:
>
>Dear Users,
>
>There's some way to convert SAS and/or SAS/IML codes to C code?
>
>Thanks,
>
>Ricardo=20
Sure there is.
Umm, unless you didn't want to spend a bunch of person-months
writing the code by hand, and then a bunch of person-years
validating and debugging all that code.
If all you want is something simple, like a sort, or a sum of constants
times your varables, then you can do that in any decent language.
If you want any kind of generality, you are stuck. Let's say you
want some subset of PROC MIXED in C. W...
Re: SAS programming and SAS/BI<div>Auto..,</div>
<div> </div>
<div> </div>
<div>>From what I've read, it hasn't been to clear what all<BR>>is involved with SAS/BI in terms SAS programming. So I take it<BR>>there's really isn't much programming involved.</div>
<div> </div>
<div>IMO and IME:</div>
<div>Yes and No; but really somewhere in between. One reason for the confusion is that SAS BI is a number of produ...
Re: SAS Sample 1728 Was ---> Re: SAS Sample 1727 #2Graham ,
I am not sure that the SI Tech Support examples should have all the error
checking that Chang wanted to throw in the macro. The examples should be
clear concise and easy to read and get going, as well as be illistrative.
Too much error checking in an example well is just over kill and even
detrimental to an example. However, any code solution on the SI Tech
Support web sit should follow basic rules of good practices and sound
advice. Such as with thier macros having atleast a somewhat good Macro
design.
Look at Example SAS Sample 1728:
The first method well lets say is soooo bad...
Re: SAS consulting and SAS license Paula,
I'm not a consultant but, I have had a little experience with SAS
licensing.
If I understand you questions correctly:
1) If I recall correctly, as a consultant, she can use the
contracting company's license only on company premises (may be wrong
about that detail) and she can only perform work for that specific
company using that copy of PC-SAS. If the company's license is
workstation-based then each PC SAS is installed on will count as a
license-copy. If the license is user-based then each workstation will
count for at least one license-copy (each pers...
Re: To SAS or not To SAS (or whatever else)!!,OK, I'll be the first to bite here.
First, check out our most excellent archives. There have been many, many
discussions on the merits of sas versus anything from spss to sql server
analytics to oracle to you name it. You might need to get creative in your
search, like sas AND advantage or sas AND oracle and (obviously) sas AND
spss.
I've used a good many of the analytical tools out there, including many
years with both sas and spss, and I can tell you from first hand knowledge,
nothing even comes close to sas with regard to flexibility of the tool.
You can do pretty much anything ...
Re: SAS 9 and SAS 8I suggest that you look at the SAS web site
http://support.sas.com/documentation/whatsnew/index.html
Nat Wooding
Environmental Specialist III
Dominion, Environmental Biology
4111 Castlewood Rd
Richmond, VA 23234
Phone:804-271-5313, Fax: 804-271-2977
pausha
<pausha1@GMAIL.CO
M> To
Sent by: "SAS(r) SAS-L@LISTSERV.UGA.EDU
Discussion" cc
<SAS-L@LISTSERV.U
GA.EDU> Subject
SAS 9 and SAS 8
11/20/2008 03:28
PM
Please respond to
pausha
<pausha1@GMAIL.CO
M>
Could someone send me the papers or articles that gives the
differences between sas 8 and sas 9 and new function and changes in
sas 9.
Thanks
CONFIDENTIALITY NOTICE: This electronic message contains
information which may be legally confidential and/or privileged and
does not in any case represent a firm ENERGY COMMODITY bid or offer
relating thereto which binds the sender without an additional
express written confirmation to that effect. The information is
intended solely for the individual or entity named above and access
by anyone else is unauthorized. If you are not the intended
recipient, any disclosure, copyi...
Re: load SAS table into DB2 temporary tablePascal:
Enclose SQL create and delete queries in a SQL EXECUTE() function and pass
them through to DB2. Once you have the table created, you can insert rows of
data (using BULKLOAD to speed up inserting large numbers of rows). Ask your
DB2 DBA about the correct syntax for DB2 temporary table name.
Sig
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of tonts
Sent: Wednesday, June 30, 2004 2:31 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: load SAS table into DB2 temporary table
Lois,
Thanks for your answer.
But the problem is a little bit different ...
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 75980 Paris Cedex 20
m�l : wielki@ined.fr t�l : 33 (0) 1 56 06 21 54
...
Re: RE : Re: copulas and SASAdel,
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...