Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #9
Lets keep this to straight SAS, I dont tell people what they should use in
SAS to produce the report, but rather I say here is what the report should
look like, here i sthe data set, here ar the specs, now go make it happen.
If your hirng a junior level programmer they should know the data step and
say proc sort, proc print, proc format. If your going after a Senior level
programmer the test should be harder and reflect more things like ODs,
In your case you dont promote straight SAS solutions and that is great, but
a whole other market than a straight SAS programmer.
...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
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. #6
I interviewed at a company that gave a test where I had a half hour to
produce a very simple report using PROC REPORT. I was provided all the
manuals I wanted, but because I had used PROC REPORT before, I wanted none
of them. I finished in five minutes, and most people on SAS-L would be
able to beat that time.
240 314 4400 x1374
"toby dunn" <tobydunn@HOTMAIL.COM>
Sent by: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
09/04/2007 05:15 PM
Please respond to
"toby dunn" <tobydunn@HOTMAIL.COM>
SAS-L@LISTSE...Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #4
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. #2
Test preparation is akin to following a simple algorithm:
1. Evaluate the test and discover if it is worth taking.
2. If #1 evaluates false then go to exit.
3. Determine if your *test* knowledge of SAS is insufficient.
4. If #3 evaluates true, do the test preparation.
5. Pay the money.
6. Take the test.
From your standpoint, the step of paramount importance is step #1. That is
where you mainly failed. From SAS' standpoint, only one step matters: #5.
This is the only reason the test was created in the first place.
The world would be a better place if all employers un...Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #7
Well 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. #3
Okay, I think I need to weigh-in on this.
First, the exam is designed to test what you know about how SAS works.
I think it does a fair job at that. (I say so partly because I only
scored 89 on the exam. Now, I didn't prepare for the exam; I was really
testing the exam when I took it as opposed to using the exam to test my
The exam doesn't know how well you can program. There is a big
difference between having a large vocabulary and knowing the rules of
grammar and knowing how to write. Similarly, there's a big difference
between knowing how SAS works and knowing how...Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #5
Good deal Bob, atleast that company was headed in the right direction IMO...
I have given such tests and taken them. I ussually give them a data set,
the specs I want them to follow, and a example of what I want the output to
look like. Then I tend to give them like 4 or 5 hours if they need it to
complete the project. In reallity they should be done in an hour or so.
The test should be challenging but not too challenging, and the solution
should involve a few data steps, procedures, and some type of reporting.....
Comprimise is like telling a lie, it gets easier and easier....Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #8
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
Kevin Viel, PhD
Department of Geneti...Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #10
I 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
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...SAS Advanced Programming Exam for SAS 9: SAS Joke of the year.
Sick joke, not funny.
You would have thought that adding the 9 tag to the exam would have
meant testing the ability of using version 9. Not so. The exam doesn't
test the ability of version 9. It doesn't even test the ability of
using SAS. It tests one's ability of guessing the right answer,
because on a lot of the questions that's all you can do.
We cannot take material out of the test centre, so I am relating these
issues from memory, but 42 is the answer to the Universe, and this one
did stick in my memory.
Question 42: Correct answer: None of the above. They have swapped ...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: Converting from SAS 5 to SAS 9 #11
It's a platform issue much more than a version issue. Quoting from the V. 9
"SAS System 9 can read, but not update, libraries that were created in the
V5 and V5TAPE formats. Note that the V5 and V5TAPE engines cannot be
specified on the LIBNAME statement. However, SAS will identify the correct
engine to use with these libraries if no engine is specified."
I suspect that the V5 libraries created on OS and DOS mainframe systems had
the same internal structure.
Al never actually ...Re: SAS programming and SAS/BI
<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>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 9 and SAS 8
I suggest that you look at the SAS web site
Environmental Specialist III
Dominion, Environmental Biology
4111 Castlewood Rd
Richmond, VA 23234
Phone:804-271-5313, Fax: 804-271-2977
Sent by: "SAS(r) SAS-L@LISTSERV.UGA.EDU
GA.EDU> ...Re: Running SAS programs from within a SAS program
You can use a series of %include statements naming the programs in the order
you want to call them in.
%include "drive:\your_folder\program name.txt" ;
M. Soobader, PhD
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of
Keith W. Larson
Sent: Friday, November 18, 2005 10:32 PM
Subject: Running SAS programs from within a SAS program
I have several small(ish) SAS programs that convert
and format DBF files. Thanks to all who helped solve...Re: Running a SAS program within a SAS program
On Mon, Apr 21, 2008 at 12:55 PM, Kathleen Santos
> I would like to combine multi years of data into one. Each year has a
> particular data set and a particular program to create a SAS dataset.
> However, not all programs are the same (e.g. variable names may change
> throughout the years).
> What I would like to do is to create one program that would call on the
> other programs to create SAS datasets. Then I'll integrate them together and
> do whatever I it is I need to do.
> I ...Re: SAS CONNECT/SAS Display Manager or BASE SAS
Abc Unha posted the following:
> We have SAS EBI Server license. Many or our SAS Programmer wants to
> use BASE
> SAS (or SAS Display Manager) instead of SAS Enterprise Guide.
> But As you know Windows Server comes with only two terminal licenses.
> I see that we have SAS/CONNECT license (which came with BI suite). Can
> install BASE SAS on PC and use SAS/CONNECT to run code on the server?
> Or Do we have to buy PC license for BASE SAS?
> What's options we have. Please help.
Abc, I can't claim to know the ABC'...Simulator for SAS Base Programming for SAS(r) 9 Certification Exam
Here's a sneak-peek at the upcoming SAS Certification exam simulator and
Requirements for Beta testers:
o must be at least SAS Base Programming certified
o must have a license to the SAS Online Tutor (that came with SAS 8.2 or
o preferably a SAS book or SUGI author/presentor (optional)
Happy New Year to all!
...Re: Converting from SAS 5 to SAS 9 #9 1545842
I believe DOS is not the MS-DOS you're thinking of; it was
one of IBMs mainframe operating systems (the other system at
the time would have been OS --> MVS --> z/OS). Unless
written in transport, you'll need a mainframe to read them.
---- Original message ----
>Date: Fri, 17 Dec 2004 19:52:28 +1300
>From: Robin Templer <robin.templer@XTRA.CO.NZ>
>Subject: Re: Converting from SAS 5 to SAS 9
>AH ... - then you do have an issue and I suspect a mission.
>1. SAS V5 never ran in the DOS or Windows environment - so
I sus...Re: Can a SAS program call another SAS program
> From: David Fickbohm
> I am writing a report that counts the number of widgets produced by
> partners. I have a small routine that finds the partners id
> number and
> name. Obviously I could copy this code into my program and
> execute it. I was wondering if there was a more elegant way
> of "Calling" a SAS program
> from within a SAS program.
> I am running SAS 8.1 in windows.
surely that is a typo: 9.1? i.e.: -The- 9.1==9.1.3
- - - subRoutineX.sas - - -
- - - subRoutineX.sas end - - -
- - - autoexec.sas - - -
filen...Re: Reusing code from SAS Program in another SAS Program
Store your code snippets in a PDS and then %include into your programs.
For example this program includes a format called "$REGCRT" that I've stored
in the PDS DSCHEER.PROD.RUN.FORMATS($REGCRT):
//LOOKUP JOB (DSDBX0000T,DS80,20,5,0),'CHOATE 654-2160',TIME=1,
//GOSAS EXEC HWSAS
//SYSIN DD *
OPTIONS PS=2000 LS=80;
LIBNAME VENDOR 'DS.SYS.WORK.VENDOR.PANEL' DISP=SHR;
FILENAME FMT 'DSCHEER.PROD.RUN.FORMATS' DISP=SHR;
RETAIN SENDDATE VENDRC RCNA...Re: Running a SAS program within a SAS program #3
You can use %INCLUDE in a SAS program to call other SAS programs.
Center for Health Program Development and Management
University of Maryland, Baltimore County
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Sent: Monday, April 21, 2008 12:55 PM
Subject: Running a SAS program within a SAS program
I would like to combine multi years of data into one. Each year has a
particular data set and a particular program to create a SAS dataset.
However, not all p...Re: Running a SAS program within a SAS program #2
Based on your subject, my immediate impulse was %inlude() where you put a
fileref in the quotes. However, I think you want to do something else. You
say that you have individual programs that produce a set for each year. Do
you store these sets somewhere or do you run the programs when you want
data for a given year. I would suggest that you first get a collection of
these yearly sets and run a contents on each one. Then, write a program
mylib.year1(rename = (Dates = Date ....))
The idea would b...