Re: Diffrence between SAS coding and SAS implementation #3
saikumarkorrapati@GMAIL.COM wrote: > >Hi Group, > >i just wanted to clarify my doubt > >I am working with SAS in financial domain from past 2 years. > >Usually i do codoing for conversion of all input files ( whatever the >type like excel ,. flat files etc) and generate the reports and >maintaing data bases and performence tuning etc ... > > >But recently i come across the words from some of the business managers >- SAS implementation. > >What is mean by SAS implementation ? > > implematation is like automation of all the tasks? > >or still it mean SAS in all phases of the project ? > > > >Thanks in advance. > >Sai kumar First, you have to bear in mind that much of this is buzzword bingo. So what I have used may not be what your managers mean. But I would guess that they mean 'SAS implementation' to mean the process of installing all the SAS components they want, and getting those pieces tuned properly to meet their needs. It may also include the programming portions needed to get their business processes up and running. HTH, David -- David L. Cassell mathematical statistician Design Pathways 3115 NW Norwood Pl. Corvallis OR 97330 _________________________________________________________________ From photos to predictions, The MSN Entertainment Guide to Golden Globes has it all. http://tv.msn.com/tv/globes2007/?icid=nctagline1 ...

Re: Diffrence between SAS coding and SAS implementation #2
I think SAS Institute is in the process of transforming itself from being primarily a Tools vendor to a Tools plus Solutions vendor. Right now, I think SI is spending more on Solutions development and marketing than they are Tools development. I would guess that Implementation refers to the solutions, e.g. Retail Revenue Optimization. In many ways, these are more challenging assignments than merely writing SAS code to solve more narrowly defined problems. Joe On 1/10/07, SAS_learner <proccontents@gmail.com> wrote: > Sai, > > It might be fancy term that HR guys coined or It might be installing SAS on > cross platform operating systems. It may be of great important with BI > installation is pretty complicated managers in this list might know what it > is ??????? Sorry could not help you much > > thanks > > On 1/10/07, saikumarkorrapati@gmail.com <saikumarkorrapati@gmail.com> wrote: > > > > Hi Group, > > > > i just wanted to clarify my doubt > > > > I am working with SAS in financial domain from past 2 years. > > > > Usually i do codoing for conversion of all input files ( whatever the > > type like excel ,. flat files etc) and generate the reports and > > maintaing data bases and performence tuning etc ... > > > > > > But recently i come across the words from some of the business managers > > - SAS implementation. > > > > What is mean b...

Re: Include SAS code w/o including SAS code
I want the statements only, not the processing. Alan Alan Churchill Savian www.savian.net -----Original Message----- From: ./ ADD NAME=Data _null_, [mailto:iebupdte@gmail.com] Sent: Tuesday, August 12, 2008 6:20 AM To: Alan Churchill Cc: SAS-L@listserv.uga.edu Subject: Re: Include SAS code w/o including SAS code You need to provide more details. It is unclear to me if you want the statements generated by the macro MPRINT/MFILE written to the file or the MACRO definition FILE/PUT. Syntax MFILE | NOMFILE MFILE routes output produced by the MPRINT option to an external file. This is useful for debugging. On 8/12/08, Alan Churchill <savian001@gmail.com> wrote: > All, > > > > Ok, I think this might be doable but I am drawing a blank. > > > > Suppose I have this code: > > > > %macro xyz; > > data temp.temp4; > > .do some sas stuff. > > run; > > %mend; > > > > Is there a way to write the macro statements out to a file? I can run them > but I would also like to save them outside of SAS. > > > > Thanks, > > Alan > > > > Alan Churchill > Savian > <http://www.savian.net/> www.savian.net > ...

Re: How to get the location of SAS code in the same SAS code thru #4
I use a macro from Frank DiIorio, CodeCrafters, Inc. that rely on SAS Dictionary Tables: %macro source_code/store; %global source_code; proc sql noprint; select XPath into :Source_Code separated by ' ' from dictionary.extfiles where fileref like "#LN00006" ; quit; %mend; The store is optional since I like to store compiled macros in a single location and call in with a mstored and sasmstore= options. I just add the following to my code to get a footnote indicating the full path and name of code submitted: %source_code; footnote1 "SOURCE CODE: &source_code"; >On Wed, 11 Apr 2007 07:43:50 -0700, Alok <alok.rustagi@GMAIL.COM> wrote: > >>Hi all, >> >>I am facing a problem in which I need to get the location/path of a >>SAS code in a macro variable. I need to use the macro variable in the >>same SAS code. Is there any SAS option available which can do this for >>me? Or is there a code snippet which can achieve the same purpose? >> >>Can you please help me out as soon as possible since I need to deliver >>this tomorrow. Any help will be greatly appreciated. >> >> >>Thanks, >>Alok ...

Re: Include SAS code w/o including SAS code #6
Good Don. I should have remembered that trick from SGF. One minor issue, it doesn't preserve formatting. Other than doing the string split myself, any suggestions? Alan Alan Churchill Savian www.savian.net -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Don Henderson Sent: Tuesday, August 12, 2008 7:37 AM To: SAS-L@LISTSERV.UGA.EDU Subject: FW: Include SAS code w/o including SAS code resending as I did not mean to send to just Andre ---------------------------------------- > From: donaldjhenderson@hotmail.com > To: wielki@ined.fr > Subject: RE: Include SAS code w/o including SAS code > Date: Tue, 12 Aug 2008 13:34:41 +0000 > > > Alan, > > If you want the generated SAS code try (untested): > > data _null_; > file "code.sas"; > length code $32000; > code = resolve('%xyz'); > put code; > run; > > You may want to format it (e.g., new line whenever you start a new statement). > > HTH, > donh > > ---------------------------------------- >> Date: Tue, 12 Aug 2008 14:52:02 +0200 >> From: wielki@INED.FR >> Subject: Re: Include SAS code w/o including SAS code >> To: SAS-L@LISTSERV.UGA.EDU >> >> Alan, >> not precisely clear what you are searching >> think thus also about this kind of program >> in addition to the mprint mfile answer of ~data _null_ >> HTH >> Andre >> &...

Re: Include SAS code w/o including SAS code #5
you want to save the macro code in its own file access then depends on modifying one of the three uses of the word: SASautos Tutorials A SASautos Companion: Reusing Macros http://tinyurl.com/45nzzk for: http://www2.sas.com/proceedings/sugi30/267-30.pdf Ron Fehd the macro maven CDC Atlanta GA USA RJF2 at cdc dot gov > -----Original Message----- > From: Alan Churchill > Ok, I think this might be doable but I am drawing a blank. > Suppose I have this code: > %macro xyz; > data temp.temp4; > .do some sas stuff. > run; > %mend; > > Is there a way to write the macro statements out to a file? I > can run them > but I would also like to save them outside of SAS. ...

Re: Include SAS code w/o including SAS code #8
You are not consistent. One time you say you don't want to execute the macro then you say you do. Question: Where is the "macro" when YOU begin to want it? Please describe your processing in complete detail. On 8/12/08, Alan Churchill <savian001@gmail.com> wrote: > I actually never want to store the macro code. I only want it available in a > temp file which I then consume. For example: > > %macro xyz; > data temp.temp4; > ...do some sas stuff... > run; > %mend; > > > I want to save the contents, formatted, into a text file (i.e. > c:\temp\program.sas) which I can then consume in another application. I also > want to execute the code. Hence: > > %xyz; > > Save the contents of the macro file to a text file with CRLF included. I > don't want the run, merely the statements. > > Thoughts? > > Alan > > Alan Churchill > Savian > www.savian.net > > > -----Original Message----- > From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Fehd, > Ronald J. (CDC/CCHIS/NCPHI) > Sent: Tuesday, August 12, 2008 8:15 AM > To: SAS-L@LISTSERV.UGA.EDU > Subject: Re: Include SAS code w/o including SAS code > > you want to save the macro code in its own file > > access then depends on modifying one of the three uses of the word: > SASautos > > Tutorials > A SASautos Companion: Reusing Macros > > http://tinyurl.com/45nzzk fo...

Re: How to get the location of SAS code in the same SAS code thru #3 1561853
For Jobs run in BATCH you can use &SYSPROCESSNAME or something like %let pgmname=%sysfunc(getoption(sysin)); or for FILES submitted from Enhanced Editor in WINDOWS SAS/V9 you can use the following to access these two environment variables. %let FNAME = %sysget(SAS_EXECFILENAME); %let FPATH = %sysget(SAS_EXECFILEPATH); On 4/11/07, Alok <alok.rustagi@gmail.com> wrote: > Hi all, > > I am facing a problem in which I need to get the location/path of a > SAS code in a macro variable. I need to use the macro variable in the > same SAS code. Is there any SAS option available which can do this for > me? Or is there a code snippet which can achieve the same purpose? > > Can you please help me out as soon as possible since I need to deliver > this tomorrow. Any help will be greatly appreciated. > > > Thanks, > Alok > ...

Re: Include SAS code w/o including SAS code #14
Charles, I did very similar things across multiple datacenters with NDM and the JCL Reader awhile back. And yes, explaining a SyncSort, EasyTrieve, SAS milkshake to a newbie was an exercise in frustration. Hell, I told them early on that SyncSort had limited commands (7 at the time?) but would take them years to master threw them for a loop. Welcome to binary ;-] That said, I think the details of what I am doing need something else. The problem with tossing out a problem on SAS-L (and elsewhere) is that the particular need is generalized to the point of losing what the original constraints are bound by. After looking at the proposals and the ideas, I am still faced with what I need to accomplish. Hence, while the %include was not what I wanted, it worked out the best. Melding 2 systems together, SAS and .NET, makes me choose alternatives that aren't as pretty as I would like. Nonetheless, I have something that works now. ....and I forge ahead. BTW, this isn't client work but SAS community work for my spare time. I appreciate everything everyone has contributed and it will be returned. Alan Alan Churchill Savian www.savian.net -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of charles.harbour@ACT.ORG Sent: Wednesday, August 13, 2008 5:23 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: Include SAS code w/o including SAS code What you ask can be done (just about <anything> can be done in sas), but at what price? T...

Re: Include SAS code w/o including SAS code #4
I actually never want to store the macro code. I only want it available in a temp file which I then consume. For example: %macro xyz; data temp.temp4; ...do some sas stuff... run; %mend; I want to save the contents, formatted, into a text file (i.e. c:\temp\program.sas) which I can then consume in another application. I also want to execute the code. Hence: %xyz; Save the contents of the macro file to a text file with CRLF included. I don't want the run, merely the statements. Thoughts? Alan Alan Churchill Savian www.savian.net -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Fehd, Ronald J. (CDC/CCHIS/NCPHI) Sent: Tuesday, August 12, 2008 8:15 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: Include SAS code w/o including SAS code you want to save the macro code in its own file access then depends on modifying one of the three uses of the word: SASautos Tutorials A SASautos Companion: Reusing Macros http://tinyurl.com/45nzzk for: http://www2.sas.com/proceedings/sugi30/267-30.pdf Ron Fehd the macro maven CDC Atlanta GA USA RJF2 at cdc dot gov > -----Original Message----- > From: Alan Churchill > Ok, I think this might be doable but I am drawing a blank. > Suppose I have this code: > %macro xyz; > data temp.temp4; > .do some sas stuff. > run; > %mend; > > Is there a way to write the macro statements out to a file? I > can run them > but I would also like to ...

Re: Include SAS code w/o including SAS code #2
Alan, not precisely clear what you are searching think thus also about this kind of program in addition to the mprint mfile answer of ~data _null_ HTH Andre libname malibmac "d:\temp"; options mstores sasmstore=malibmac; %macro foobar(aarg)/store source des='nothing or interresting'; %put arg=&arg; %mend; %copy foobar/source; Alan Churchill a �crit : > All, > > > > Ok, I think this might be doable but I am drawing a blank. > > > > Suppose I have this code: > > > > %macro xyz; > > data temp.temp4; > > .do some sas stuff. > > run; > > %mend; > > > > Is there a way to write the macro statements out to a file? I can run them > but I would also like to save them outside of SAS. > > bname malibmac "d:\f\"; > > Thanks, > > Alan > > > > Alan Churchill > Savian > <http://www.savian.net/> www.savian.net > > -- 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: Include SAS code w/o including SAS code #9
Remember the formatting/indentation is lost in macro anyway as white space = is not relevant. The best you can do is what mprint does for you - a new st= atement on column 1 on on new line. =20 -don> Date: Tue=2C 12 Aug 2008 08:38:31 -0600> From: savian001@GMAIL.COM> S= ubject: Re: Include SAS code w/o including SAS code> To: SAS-L@LISTSERV.UGA= ..EDU> > Good Don. I should have remembered that trick from SGF. One minor i= ssue=2C it> doesn't preserve formatting. Other than doing the string split = myself=2C any> suggestions?> > Alan> > Alan Churchill> Savian> www.savian.n= et> > > -----Original Message-----> From: SAS(r) Discussion [mailto:SAS-L@L= ISTSERV.UGA.EDU] On Behalf Of Don> Henderson> Sent: Tuesday=2C August 12=2C= 2008 7:37 AM> To: SAS-L@LISTSERV.UGA.EDU> Subject: FW: Include SAS code w/= o including SAS code> > resending as I did not mean to send to just Andre> = > ----------------------------------------> > From: donaldjhenderson@hotmai= l.com> > To: wielki@ined.fr> > Subject: RE: Include SAS code w/o including = SAS code> > Date: Tue=2C 12 Aug 2008 13:34:41 +0000> >> >> > Alan=2C> >> > = If you want the generated SAS code try (untested):> >> > data _null_=3B> > = file "code.sas"=3B> > length code $32000=3B> > code =3D resolve('%xyz')=3B>= > put code=3B> > run=3B> &g...

Re: Include SAS code w/o including SAS code #11
Thanks Ian. I actually switched it over to a %include since readability is critical here. The only other method I can think of is to use datalines but that is not as convenient either. The underlying problem behind this exercise was: How can I have a set of valid SAS statements be filed into a text file and also be available for execution? Immediately, I said %include since that is obvious. However, I was hoping to also be able to see the lines and make quick modifications in the editor. Since I have had time to think about it some more, I decided to go ahead and split it out into 2 programs and simply %include them. That way I retain formatting. The only negative is that they are now in 2 tabs but I can live with that. All of the exploration done by people and pointing out various options has been helpful. The formatting though is critical and I don't want to run my cleaner on it. Sometimes it is best to just KISS. Alan Alan Churchill Savian www.savian.net -----Original Message----- From: iw1junk@comcast.net [mailto:iw1junk@comcast.net] Sent: Tuesday, August 12, 2008 10:29 AM To: SAS(r) Discussion Cc: Alan Churchill Subject: Re: Include SAS code w/o including SAS code Summary: Macro generation of correct SAS code requires SAS execution. #iw-value=1 Alan, I do not see how this is possible. Consider: %macro q ( seed=0 ) ; %local cum ; data w ( keep = r ) ; do i = 1 to 20 ; r = ranuni ( &seed ) ; output ; ...

Re: Include SAS code w/o including SAS code #13
What you ask can be done (just about <anything> can be done in sas), but at what price? The put statement is your friend--think if you were to generate a whole job, not just a macro. The problem comes if you have any macro variables that would need to be resolved when the second job runs-- now you have to play with quoting, so that sas doesn't try to interpret them at compile time. And that can cause horrible headaches, esp if there are some macro vars that you do want evaluated at compile time. I have some code that was used on the mainframe to generate dynamically created jobs that were then submitted either right into the reader or across the wire to another machine--jcl, including macro resolutions for pds, member name and ds name, as well as the job logic. It was a real hassle to maintain, and difficult for a new person to pick up without doing a lot of hand holding (or try and be patient, and after the 5th mistake, they figure it out). Trying to coordinate batch processing across multiple machines, when you have an established production window, where you can't be waiting indefinitely for a dataset that may never come-- presents its own set of challenges. If you're still curious, let me know and I'll pass it along. CH On Tue, 12 Aug 2008 10:38:11 -0600, Alan Churchill <savian001@GMAIL.COM> wrote: >Thanks Ian. > >I actually switched it over to a %include since readability is critical >here. The only other method I can th...

Re: Include SAS code w/o including SAS code #7
I don't believe there is inconsistency in my statement. I don't want the log (run), just the statements. A macro is a macro so I can always run it if need be but the main gist is that I need the statements. I will just break the statements myself and do the formatting using Don's technique. Thanks for the help, Alan Alan Churchill Savian www.savian.net -----Original Message----- From: ./ ADD NAME=Data _null_, [mailto:iebupdte@gmail.com] Sent: Tuesday, August 12, 2008 9:05 AM To: Alan Churchill Cc: SAS-L@listserv.uga.edu Subject: Re: Include SAS code w/o including SAS code You are not consistent. One time you say you don't want to execute the macro then you say you do. Question: Where is the "macro" when YOU begin to want it? Please describe your processing in complete detail. On 8/12/08, Alan Churchill <savian001@gmail.com> wrote: > I actually never want to store the macro code. I only want it available in a > temp file which I then consume. For example: > > %macro xyz; > data temp.temp4; > ...do some sas stuff... > run; > %mend; > > > I want to save the contents, formatted, into a text file (i.e. > c:\temp\program.sas) which I can then consume in another application. I also > want to execute the code. Hence: > > %xyz; > > Save the contents of the macro file to a text file with CRLF included. I > don't want the run, merely the statements. > > Thoughts? > > Alan...

Re: FW: Include SAS code w/o including SAS code
On Tue, 12 Aug 2008 13:36:52 +0000, Don Henderson <donaldjhenderson@HOTMAIL.COM> wrote: >resending as I did not mean to send to just Andre > >---------------------------------------- >> From: donaldjhenderson@hotmail.com >> To: wielki@ined.fr >> Subject: RE: Include SAS code w/o including SAS code >> Date: Tue, 12 Aug 2008 13:34:41 +0000 >> >> >> Alan, >> >> If you want the generated SAS code try (untested): >> >> data _null_; >> file "code.sas"; >> length code $32000; >> code = resolve('%xyz'); >> put code; >> run; >> >> You may want to format it (e.g., new line whenever you start a new statement). >> >> HTH, >> donh >> >> ---------------------------------------- >>> Date: Tue, 12 Aug 2008 14:52:02 +0200 >>> From: wielki@INED.FR >>> Subject: Re: Include SAS code w/o including SAS code >>> To: SAS-L@LISTSERV.UGA.EDU >>> >>> Alan, >>> not precisely clear what you are searching >>> think thus also about this kind of program >>> in addition to the mprint mfile answer of ~data _null_ >>> HTH >>> Andre >>> >>> libname malibmac "d:\temp"; >>> options mstores sasmstore=malibmac; >>> %macro foobar(aarg)/store source des='nothing or interresting'; >>> ...

Re: Include SAS code w/o including SAS code #12
OK, now I get it. You don't know that you already have what you need. In your example you say... Suppose I have this code: %macro xyz; data temp.temp4; .do some sas stuff. run; %mend; So you have it you don't need to get it you've already got it. The formatting that you desire is right there, no problem. If the macro is in aggregate storage location then you also "have it". It is waiting be auto called, read with infile, or opened with an editor. If it is stored compiled and the source was saved you can look at the source just as Andre suggested using %copy. If calling the macro with RESOLVE returns gt 32767 characters what do you do then? You could read the compiled macro from the work.sasmacr. Limited testing suggests that the formatting you desire is preserved in the catalog entry. filename ft56f001 catalog 'work.sasmacr.<NAME>.macro'; data _null_; infile ft56f001; input; list; run; On 8/12/08, Alan Churchill <savian001@gmail.com> wrote: > I don't believe there is inconsistency in my statement. I don't want the log > (run), just the statements. A macro is a macro so I can always run it if > need be but the main gist is that I need the statements. > > I will just break the statements myself and do the formatting using Don's > technique. > > Thanks for the help, > Alan > > Alan Churchill > Savian > www.savian.net > > > -----Original Message---...

Re: Include SAS code w/o including SAS code #3
You need to provide more details. It is unclear to me if you want the statements generated by the macro MPRINT/MFILE written to the file or the MACRO definition FILE/PUT. Syntax MFILE | NOMFILE MFILE routes output produced by the MPRINT option to an external file. This is useful for debugging. On 8/12/08, Alan Churchill <savian001@gmail.com> wrote: > All, > > > > Ok, I think this might be doable but I am drawing a blank. > > > > Suppose I have this code: > > > > %macro xyz; > > data temp.temp4; > > .do some sas stuff. > > run; > > %mend; > > > > Is there a way to write the macro statements out to a file? I can run them > but I would also like to save them outside of SAS. > > > > Thanks, > > Alan > > > > Alan Churchill > Savian > <http://www.savian.net/> www.savian.net > ...

Re: Include SAS code w/o including SAS code #10
Summary: Macro generation of correct SAS code requires SAS execution. #iw-value=1 Alan, I do not see how this is possible. Consider: %macro q ( seed=0 ) ; %local cum ; data w ( keep = r ) ; do i = 1 to 20 ; r = ranuni ( &seed ) ; output ; end ; run ; data _null_ ; set w end = eof ; cum + r ; if eof then call symputx ( "cum" , cum ) ; run ; title1 "Cum = &cum" ; %mend q ; This macro ends up generating a TITLE statement. However, that title statement depends on the execution of the previous steps. Hence it cannot be generated by the macro facility without actually executing the previously generated code. The problem is similar to that of using CALL EXECUTE to generate SAS code via a macro call. In the case of CALL EXECUTE one can work around the problem by using %NRSTR to hide the call during the DATA step execution, but you have explicitly required the macro to generate correct code without executing. Now there is no work around. In essence you are asking, "Is the macro facility so weak that there is a program that can predict the output of every macro without executing it?" Since that output can depend on the execution of SAS code, one must first be able to predict the result of executing every SAS program without actually doing the executing. It seems highly unlikely that the SAS Institute is up to the jo...

Re: How to get the location of SAS code in the same SAS code thru #3 685847
> From: Alok > I am facing a problem in which I need to get the > location/path of a SAS code in a macro variable. I need to > use the macro variable in the same SAS code. Is there any SAS > option available which can do this for me? Or is there a code > snippet which can achieve the same purpose? - - - MyMacro.sas - - - %macro MyMacro(path=); %*...; %Mend; - - - MyProgram.sas - - - %Let Path2MyMacro = c:\temp\MyMacro.sas; %Include "&Path2MyMacro."; %MyMacro(path = &Path2MyMacro.); Ron Fehd the macro maven CDC Atlanta GA USA RJF2 at cdc dot gov ...

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: search SAS data set from SAS code
> From: Rose > Hi All, > Suppose I have a sas permanent data set which was created > early, I know > the library path but I couldn't remember in which sas program code I > created it. how can I search from so many sas program files in > different folders and find it. a problem familiar to all of us delayed-housekeeping folks. Libname Libref '<directory-specification>'; DATA LibRef.DataSetName; use your system utilities to search for the dir-spec of your libref. search: *.sas containing text: <dir-spec> once you have found the libname...

Re: SAS code beautifier or SAS Tidy #3
Yes indeed. I gave Alan the worst code (authors shall remain anonymous to protect the guilty, but the project involved Mortgage Banking services...) I have seen in over two decade of looking at SAS code, and his utility cleaned it right up. On Wed, Jun 10, 2009 at 4:30 PM, Richard Read Allen <peakstat@wispertel.net>wrote: > Try www.savian.net. I think Alan Churchill may have developed some > utilities > that may be able to help you. > > -Richard > > -----Original Message----- > From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Mary > Sent: ...

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 language. I did some guessing, but that was on my weaker topics. So the exam results, in my view, reflected something real. I agree, a prospective employer should not put much stock in SAS certification exams. Many highly effective people are not good test takers. Besides, this exam is a crude instrument. My score was identical to a colleague who still regularly asks me for guidance in finding solutions in SAS to specific problems. I probably know more SAS than he does (and he is a good SAS programmer), but you wouldn't know from the exam results. As to version 9-specific questions, I don't recall whether there was much material that was version 9 only. But I expected the test to be more oriented to "advanced" concepts than to new features of version 9. By the way, even though I passed, I can't get a SAS advanced certificate -- because I haven't taken the...