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...
SAS 9 and SAS 8Could 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
http://support.sas.com/documentation/whatsnew/index.html
and many proceedings at http://www.lexjansen.com
On Nov 20, 3:28=A0pm, pausha <paus...@gmail.com> wrote:
> Could =A0someone 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
...
Re: PHREG SAS 8 vs SAS 9Sorry I changed the number of loops to 10 instead of 1000 to reduce the
running time. But still, it takes much longer in SAS 9 compared to SAS
8...
----- Original Message -----
From: "Francois Torche" <torche@i-minds.be>
Sent: Fri, December 19, 2008 13:58
Subject:PHREG SAS 8 vs SAS 9
Hi All,
The following code runs in less than a minute on SAS 8.2 and more than 11
on SAS 9. I know it's something related to PHREG but I don't know why?
Any help would be appreciated ;-)
Thanks,
François
<CODE>
PROC FORMAT;
VALUE dis_fmt 1='Case' 0='Control';
VALUE exp_fmt 1='Vaccntd' 0='Unvaccntd';
RUN;
DATA test (label = Output Case-Control Macro 19DEC08:13:18:12 Search B);
Ncases = 200;
C_C_Rat = 2;
Vac_Cov = 0.8;
Market_sh = 1;
OR = 0.5;
Alpha = 0.05;
_theta = 2.5;
Limit = 1;
Uplow = "U";
OUTPUT;
RUN;
DATA test;
SET test nobs=last;
IF _N_ = last THEN CALL SYMPUT("NofTest",put(_N_,best.));
if (Vac_cov * OR)/(1-Vac_cov+Vac_cov * OR) > 1 then delete;
RD = (OR-1) * Vac_cov * (1-Vac_cov) / (1-Vac_cov + OR * Vac_cov);
Zalpha = PROBIT(1-Alpha/2);
LABEL Ncases = "Number of cases" C_C_rat = "Case-control ratio" VAC_COV =
"Vaccination coverage - baseline - P(vaccinated|not ill)" OR = "Odds
Ratio" Alpha = "Alpha
Error - Type I" Limit = "Upper or Lower limit for the confidence interval
of OR or VE" Uplow =
"Say if Limit is an upper or lower lim...
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: 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...
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: 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: 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. #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 8.2 = SAS 8.02 ?On Mon, 6 Dec 2004 10:29:57 -0500, Igor Kurbeko
<ikurbeko@ATHEROGENICS.COM> wrote:
>Hi, guys.
>
>
>
>Are SAS releases 8.2 and 8.02 one and the same?
>
>
>
>I wanted to apply hot fix for SAS Release 8.2 (TS2M0) B2BB97.
>
>But we use SAS 8.02
Hi, Igor,
SAS releases 8.2, 8.02, and 8e refer to the same thing Release 8.2
(TS2M0), at least on Windows platform and likely so in other platforms.
It seems an outcome of the development and marketing not in sync -- which
is much frequent happening in the industry. Like Java 2 is in fact Java
1.2 and above, ms off...
SAS 8 and SAS 9 on the same serverI'm installing SAS 9.1.2 on a Windows 2000 server where the SAS 8 is
already installed and functional. For a test period, both version
should work on the same server.
What's the best way to configure the Object Spawner (Integration
Technologies)?? I think on these two options below:
Option 1: Create one Spawner service for each SAS version. I'd have two
services running on Windows, each one executing one specific version of
SAS.
Option 2: One only Spawner service. The Spawner file would have one
entry for each SAS version. Each SAS version would be alocated on a
diferent IOM por...
Re: Converting from SAS 5 to SAS 9 #9 641267I did a little googling tonight and came across some SAS faqs about
converting V5 files to V6. It seems that Proc V5toV6 was available on most
platforms but not on the pc. However, there is supposed to be a V5 engine
available that will allow SAS V6 to read a V5 file.
Nat
...
Re: SAS 9.2 backward compatible with SAS 9.13 ?--- On Thu, 1/8/09, freshforlife <ravi.taneja@GMAIL.COM> wrote:
> From: freshforlife <ravi.taneja@GMAIL.COM>
> Subject: SAS 9.2 backward compatible with SAS 9.13 ?
> To: SAS-L@LISTSERV.UGA.EDU
> Date: Thursday, January 8, 2009, 12:39 PM
> Hi Guys,
>
> Just heard from one of our data vendors that SAS 9.2
> isn't going to be
> backward compatible with SAS 9.13. This seemed bizarre to
> me -- they
> essentially meant that a dataset processed in 9.2 cannot be
> opened in
> SAS 9.13.
>
> Just wanted to run it through you guys and know what your
> views are.
>
> Thanks,
> Ravi
Ravi,
This sounds like your data vendor is trying to sell you something
you may not need. I ran code in 9.2 that created a permanent
SAS dataset. I then started SAS 9.1.3 and read the dataset.
Here is the code that I submitted in SAS 9.2:
libname temp "c:\temp";
data temp.test92to913;
do i=1 to 20;
y = rannor(1234579);
output;
end;
run;
proc means data=temp.test92to913;
run;
This generated the results:
Variable N Mean Std Dev Minimum Maximum
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
i 20 10.5000000 5.9160798 1.0000000 20.0000000
y 20 -0.2290414 0.8500575 -1.7714081 1.3953167
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
And in SAS 9.1.3, I submitte...
PHREG SAS 8 vs SAS 9Hi All,
The following code runs in less than a minute on SAS 8.2 and more than 11
on SAS 9. I know it's something related to PHREG but I don't know why?
Any help would be appreciated ;-)
Thanks,
François
<CODE>
PROC FORMAT;
VALUE dis_fmt 1='Case' 0='Control';
VALUE exp_fmt 1='Vaccntd' 0='Unvaccntd';
RUN;
DATA test (label = Output Case-Control Macro 19DEC08:13:18:12 Search B);
Ncases = 200;
C_C_Rat = 2;
Vac_Cov = 0.8;
Market_sh = 1;
OR = 0.5;
Alpha = 0.05;
_theta = 2.5;
Limit = 1;
Uplow = "U";
OUTPUT;
RUN;
DATA test;
SET test nobs=last;
IF _N_ = last THEN CALL SYMPUT("NofTest",put(_N_,best.));
if (Vac_cov * OR)/(1-Vac_cov+Vac_cov * OR) > 1 then delete;
RD = (OR-1) * Vac_cov * (1-Vac_cov) / (1-Vac_cov + OR * Vac_cov);
Zalpha = PROBIT(1-Alpha/2);
LABEL Ncases = "Number of cases" C_C_rat = "Case-control ratio" VAC_COV =
"Vaccination coverage - baseline - P(vaccinated|not ill)" OR = "Odds
Ratio" Alpha = "Alpha
Error - Type I" Limit = "Upper or Lower limit for the confidence interval
of OR or VE" Uplow =
"Say if Limit is an upper or lower limit" ;
RUN;
ODS noresults;
ODS LISTING CLOSE;
DATA sample (KEEP = simulat disease exposure match vaccinated);
seed = 0;
ncaseold=0;
nctrlold=0;
pcases = (0.8*0.5) / (1 - (0.8*(1-0.5)));
pvacc = 1;
DO i=1 TO 10/*1000*/;
**run this loop from the 1st to the ith simulation;
simulat = i;
**set the vari...
Re: SASChandu,
You should be able to find some info in the SPD Engine section of the
on-line documentation.
HTH,
Ken
-----Original Message-----
From: chandu.isi@GMAIL.COM
To: SAS-L@LISTSERV.UGA.EDU
Sent: Mon, 3 Jul 2006 09:03:00 -0700
Subject: SAS - 9; Partition of SAS Datasets.
Hi All,
Recently I heared from some of my friends...that SAS - 9
supports PARTITION of SAS datasets. I tried for getting syntax and some
details, but couldn't able to get. Is anyone has any idea about the
partitions of SAS datasets, if so can any one help me out on this?
Thanks in advance.
Chandu.
_____...
SAS System Viewer 9.1 unable to open SAS datasets ( SAS 9.1.3)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 ?
In message
<0ae08496-acd1-4c40-8828-b88d059c0d0e@f40g2000pri.googlegroups.com>,
msiddu2000 <msiddu2000@gmail.com> writes
>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 ?
SAS System Viewer 9.1 can:
(1) Read SAS v8 data sets created by SAS v8 on Windows or UNIX
(2) Read SAS v8 data sets created by SAS v9 on Windows
(3) Read SAS v9 data sets created by SAS v9 on Windows
SAS System Viewer 9.1 can not:
(1) Read SAS v8 data sets created by SAS v9 on UNIX
(2) Read SAS v9 data sets created by SAS v9 on UNIX
Alternatives:
(1) There is a beta version of the CDISC Viewer that can be downloaded
from the SAS web site, but it is fragile.
(2) There is also a SAS Universal Viewer bundled with SAS v9.2 for
Windows.
.....Phil Holland
--
--------------------------------------------------------
Holland Numerics Ltd
94 Green Drift, Royston, Herts SG8 5BT, UK
mobile : +44-(0)7714-279085
email : <NEWS@hollandnumerics.com>
URL : http://www.hollandnumerics.com/
...
Re: Summary of the differences of Base SAS 9.1.3 and SAS 9.2You heard wrong... check out sascommunity.org, there's a page there
somewhere that describes the differences.
The major things that make a difference to me are XLSX support and improved
hash support, but FCMP and ODS/Proc Template improvements undoubtedly make a
huge difference to many folks.
-Joe
On Mon, Oct 19, 2009 at 5:17 PM, Jerry <jerryang@cisco.com> wrote:
> Anyone have the release notes (or a summary of it?) On what the major
> differences to expect from Base SAS 9.1.3 and 9.2?
>
> From what I heard, there aren't that many differences besides a new
> in...
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: Converting from SAS 5 to SAS 9 #10http://www.sas.com/presscenter/bgndr_history.html
1985 ... Technology milestones...
First SAS System release for PC DOS (Base SAS and SAS/RTERM software) is
immediate success.
Micro-to-mainframe link (SAS/C Compiler) is introduced for PCs linking to
mainframes.
Paul Choate
DDS Data Extraction
(916) 654-2160
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Nat
Wooding
Sent: Friday, December 17, 2004 7:01 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Converting from SAS 5 to SAS 9
Robin
I must beg to differ- A pc DOS version of SAS was announced...
Re: Deleting SAS Data from a SAS DATASET #8On 8/15/08, Mary <mlhoward@avalon.net> wrote:
> A view helps on deletes, but I wonder how it affects performance of querying the data- wouldn't storing the data in 24 different locations cause a significant slowdown in perfomance upon querying the data versus having it all in one table that is indexed? If this data is queryied a lot but only deleted once a month, the time in querying (which probably is in peak time) could be much more important than the time in deleting (which could be run when the computer is not busy, such as nights or weekends).
It is not the VIEW that has an influence on deleting the old data.
I would think that having the 24 indexed data sets might be about as
good as having the giant data set. I would think the indexes could be
used while accessing the data through views. Where's that guy that
says he knows everything about using indexed data sets?
I would agree that much depends on how the data is used. And I don't
know the answers to those questions.
>
> -Mary
> ----- Original Message -----
> From: ./ ADD NAME=Data _null_,
> To: SAS-L@LISTSERV.UGA.EDU
> Sent: Friday, August 15, 2008 3:51 PM
> Subject: Re: Deleting SAS Data from a SAS DATASET
>
>
> Summary: PROC DATASETS; AGE statement. + VIEWs
>
> This won't help you delete data from your very big data set, but you
> may find this example interesting.
>
> You say you append data monthly to a big data set then when b...
Re: SAS 9.1 and SAS-callable SUDAANLouise Hadden <louise_hadden@ABTASSOC.COM> wrote:
> My company will be rolling out SAS version 9.1 soon. I have been
doing a
> lot of work at my internal clients' request using SAS-callable SUDAAN
in
> version 8.2, and wondered if anyone had experience doing the same with
> version 9.1. Not using SUDAAN is not an option for me (it's not my
> choice), so I am hoping for a seamless transition to 9.1! Thanks in
> advance for any advice.
Okay, here's two bits of advice:
[1] Your copy of SUDAAN ought to run just fine with SAS 9.1 . Install
9.1,
then do the ...
Re: Deleting SAS Data from a SAS DATASET #9On Fri, 15 Aug 2008 16:09:46 -0500, Mary <mlhoward@AVALON.NET> wrote:
>A view helps on deletes, but I wonder how it affects performance of
querying the data- wouldn't storing the data in 24 different locations
cause a significant slowdown in perfomance upon querying the data versus
having it all in one table that is indexed? If this data is queryied a
lot but only deleted once a month, the time in querying (which probably is
in peak time) could be much more important than the time in deleting
(which could be run when the computer is not busy, such as nights or
weekends).
hi,
good point! but as shown below, you can make a view of multiple datasets
having the separate indexes, and where seems to be fine with this.
interesting. ran on sas 9.1.3 sp4 on windows.
cheers,
chang
/* test datasets */
data one two;
set sashelp.class;
ds = "one";
output one;
ds = "two";
output two;
run;
/* separately index on age */
proc datasets lib=work;
modify one;
index delete age;
index create age;
modify two;
index delete age;
index create age;
quit;
/* make a view of two datasets appended */
proc sql feedback;
drop view work.oneTwo;
create view oneTwo as
select * from one union select * from two
order by age;
quit;
/* where is utilizing the indexes */
options msglevel=i;
data sixteenAndOlder;
set oneTwo; /* we are using the view */
where age >= 16;
run;
/* on log
INFO: Index Age selected for WHERE clause optimiz...
Re: Converting from SAS 5 to SAS 9 #5Mikeey
I did try V8 before I sent the posting just to be sure that V5toV6 was not
available and I too, found it not there. I see that Dale did not find it in
a V6.12 installation. I just ran a mainframe 6.09E job and the proc is
there. I find it odd that it would not be available in 6.12 since this is a
V6 proc. The spelling is
V5TOV6
Nat
Michael Raithel
<michaelraithel@W To: SAS-L@LISTSERV.UGA.EDU
ESTAT.COM> cc:
Sent by: "SAS(r) Subject: Re: Converting...
Re: Converting from SAS 5 to SAS 9 #12 1545866Hello Friends,
I remember using PC SAS 6.04. I missed using the first version for PCs,
6.03. To make it useful (SAS/CONNECT to the mainframe), we had to be able
to load PC-DOS (MS-DOS), SAS, and your mainframe terminal emulator with
conventional memory (640 KB). We had to swap out our existing emulator for
another one with a smaller footprint to make it work. I over-clocked that
IBM AT with a new crystal but that is another, OT story ;-)
Just to confirm and clarify, Version 5 was never released for use on
personal computers. So if the data set was created on a personal computer,
it had ...