f



Re: RE : SAS Programming With Dates -Problem

Thank you very much for your feedback. I would appreciate for your help for a simple code addressing this issue in proc expand.

Thanks,

Doyle

-------------- Original message --------------

> Have you seen the proc expand ?
>
> Otherwise, you could create a table with all dates and merge it with the
> original table.
>
> St�phane.
>
> -----Message d'origine-----
> De : SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] De la part de Doyle
> Kalumbi
> Envoy� : lundi 9 mai 2005 22:31
> � : SAS-L@LISTSERV.UGA.EDU
> Objet : SAS Programming With Dates -Problem
>
>
> Hi Users:
>
> I have a data set with date fields that are not evenly spaces by month. I
> would like to create a field with evenly spaced months from the first date
> value up to �30Apr2005�. For example the first observation with
> Accountid=31806 and a Trans_TransactionDateMoa value of 2002Jul: I would
> like to create the following date values inserted in between: 2002Jul
> 2002Aug 2002Sep 2002Oct " " 2005Apr
>
> For Accountid 31992, I would like to even dates starting from 2001Nov to
> 2005Apr including the 2002Feb. Below is a sample of my data structure:
>
> Thanks,
>
> Doyle,
>
>
> 31806 15538 2002JUL 1339 303 0
> 31822 15348 2002JAN 4048 50 50
> 31992 15295 2001NOV 1202 275 275
> 31992 15381 2002FEB 1202 -275 -275
> 32294 15382 2002FEB 2377 951 951
> 32318 15237 2001SEP 3034 62 247
> 32360 16022 2003NOV 7071 38 38
> 32559 16187 2004APR 4773 319 319
> 32559 16280 2004JUL 4773 210 420
> 32559 16303 2004AUG 4773 210 210
> 32559 16331 2004SEP 4773 210 210
> 32559 16369 2004OCT 4773 211 211
> 32559 16397 2004NOV 4773 210 210
> 32559 16427 2004DEC 4773 211 211
> 32559 16464 2005JAN 4773 421 421
> 32559 16516 2005MAR 4773 210 210
> 32559 16553 2005APR 4773 210 210
> 33269 15260 2001OCT 5869 2867 2867
> 33615 15144 2001JUN 3427 839 839
> 33615 15265 2001OCT 3427 91 167
> 33615 15305 2001NOV 3427 90 90
> 33615 15326 2001DEC 3427 91 91
> 33615 15363 2002JAN 3427 34 119
> 33615 15390 2002FEB 3427 148 148
> 33615 15455 2002APR 3427 79 170
> 33615 15490 2002MAY 3427 85 85
> 33615 15544 2002JUL 3427 98 189
> 33615 15600 2002SEP 3427 91 91
> 33615 15635 2002OCT 3427 98 98
> 33748 15180 2001JUL 2675 56 56
> 33810 15533 2002JUL 1911 22 22
> 33810 15564 2002AUG 1911 51 51
> 33810 15594 2002SEP 1911 144 144
> 33810 15628 2002OCT 1911 51 51
> 33810 15656 2002NOV 1911 51 51
> 33810 15719 2003JAN 1911 148 148
> 33810 15746 2003FEB 1911 51 51
> 33810 15774 2003MAR 1911 51 51
> 33810 15809 2003APR 1911 51 51
> 33810 15837 2003MAY 1911 51 51
> 33810 15902 2003JUL 1911 57 57
> 33810 15929 2003AUG 1911 146 146
> 33810 15960 2003SEP 1911 52 52
> 33810 15992 2003OCT 1911 51 51
> 33810 16051 2003DEC 1911 55 55
> 33810 16082 2004JAN 1911 144 144
> 33810 16113 2004FEB 1911 54 54
> 33810 16145 2004MAR 1911 93 93
> 33810 16173 2004APR 1911 14 14
> 33870 15166 2001JUL 1254 20 20
0
djrk0003 (51)
5/9/2005 8:51:17 PM
comp.soft-sys.sas 142828 articles. 3 followers. Post Follow

0 Replies
514 Views

Similar Articles

[PageSpeed] 49

Reply:

Similar Artilces:

Re: Running SAS programs from within a SAS program
Keith, 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" ; Mah-J M. Soobader, PhD Principal consultant STATWORKS www.statworks.com -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of Keith W. Larson Sent: Friday, November 18, 2005 10:32 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Running SAS programs from within a SAS program Dear All, I have several small(ish) SAS programs that convert and format DBF files. Thanks to all who helped solve formatting problems. I would like to create a master SAS program that calls each one in sequence. Any ideas? Cheers, Keith __________________________________ Yahoo! FareChase: Search multiple travel sites in one click. http://farechase.yahoo.com ...

Re: Running a SAS program within a SAS program
%include() On Mon, Apr 21, 2008 at 12:55 PM, Kathleen Santos <flowerpotcat@gmail.com> wrote: > Hello, > > 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 hope someone can help me. > > Thanks. > > Kathleen > -- =============================== WenSui Liu ChoicePoint Precision Marketing Phone: 678-893-9457 Email : wensui.liu@choicepoint.com Blog : statcompute.spaces.live.com =============================== ...

Re: RE : Re: copulas and SAS
Adel, 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 <joewhitehurst@GMAIL.COM> a �crit : > David, > > "The complete attempt to deal with the term is would go to the form > and matter of every thing in existence, at least, if not to the > possible form and matter of all that does not exist, but might. As > far as it could be done, it would give the grand Cyclopaedia, and its > yearly supplement would be the history of the human race for the > time." > > On 9/26/06, David L Cassell proclaimed: > > "... A copula is nothing more than a functional allowing you to link > the multivariate distribution to marginal distributions in an > invariate manner...". > > This caused Augustus De Morgan to leap from his grave and refute David > thusly: > > "The complete attempt to deal with the term "is" would go to the form > and matter of every thing in existence, a...

Re: Running a SAS program within a SAS program #3
Kathleen, You can use %INCLUDE in a SAS program to call other SAS programs. Jack Clark Research Analyst Center for Health Program Development and Management University of Maryland, Baltimore County -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Kathleen Santos Sent: Monday, April 21, 2008 12:55 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Running a SAS program within a SAS program Hello, 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 hope someone can help me. Thanks. Kathleen ...

Re: Running SAS programs from within a SAS program #2
Or better when programs are in one directory file code "drive:\your_folder\" ; %inc code ( prog1 prog2 prog3 ... ) ; Then the next step is parameter driven macros in an autocall library. %prog1(parm1=...) %prog2(alpha=...) ..... Ian Whitlock ================= Date: Fri, 18 Nov 2005 22:54:54 -0500 Reply-To: mah-j@statworks.com Sender: "SAS(r) Discussion" From: "mah-j@statworks.com" <msoobader@VERIZON.NET> Subject: Re: Running SAS programs from within a SAS program Comments: To: "Keith W. Larson" <keith_w_larson@YAHOO.COM> In-Reply-To: <20051119033140.88868.qmail@web51405.mail.yahoo.com> Content-type: text/plain; charset=iso-8859-1 Keith, 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" ; Mah-J M. Soobader, PhD Principal consultant STATWORKS www.statworks.com -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L]On Behalf Of Keith W. Larson Sent: Friday, November 18, 2005 10:32 PM To: SAS-L Subject: Running SAS programs from within a SAS program Dear All, I have several small(ish) SAS programs that convert and format DBF files. Thanks to all who helped solve formatting problems. I would like to create a master SAS program that calls each one in sequence. Any ideas? Cheers, Keith ______________________...

Re: Running a SAS program within a SAS program #2
Kathleen 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 similar to Data mylib.combined; set mylib.year1(rename = (Dates = Date ....)) mylib.year2(rename= (Sdates=Date....)) ..... ; The idea would be to get rid of the variations in the variable names. You could simply copy in the individual programs into one honking big program and keep running this until you get a uniform combined set but you will use a lot of machine cycles doing this. Assuming that you have to make several passes at the data in order to get things right, I would work from stored data sets where all you are doing is changing the rename statements. Good luck Nat Wooding Environmental Specialist III Dominion, Environmental Biology 4111 Castlewood Rd Richmond, VA 23234 Phone:804-271-5313, Fax: 804-271-2977 Kathleen Santos <flowerpotcat@GMA IL.COM> To Sent by: "SAS(r) SAS-L@LISTSERV.UGA.EDU Discussion" cc <SAS-...

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. still!?!? surely that is a typo: 9.1? i.e.: -The- 9.1==9.1.3 include it: - - - subRoutineX.sas - - - *...; - - - subRoutineX.sas end - - - - - - autoexec.sas - - - filen...

Re: Reusing code from SAS Program in another SAS Program
Keith - 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, // USER=DSPAULC,MSGCLASS=X,NOTIFY=DSPAULC //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; %INC FMT($REGCRT); DATA LOOKUP; RETAIN SENDDATE VENDRC RCNAME VENDOR NAME ADDR1 ADDR2 ADDR3 ZIP PHONENUM INVADDR1 INVADDR2 INVZIP; SET VENDOR.PANEL; WHERE VENDOR IN ('HV0010' 'HV0011'); RCNAME=PUT(VENDRC,$REGCRT.); KEEP SENDDATE VENDRC RCNAME VENDOR NAME ADDR1 ADDR2 ADDR3 ZIP PHONENUM INVADDR1 INVADDR2 INVZIP; PROC PRINT; RUN; ENDSAS; Since %INC is a macro you can put it anywhere in open code and it will read the code snippet during compilation. hth Paul Choate DDS Data Extraction (916) 654-2160 -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Keith Sent: Friday, May 20, 2005 3:23 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Reusing code from SAS Program in another SAS Program I write SAS programs on the Mainframe. I have several programming steps in multiple programs that use the same IF statements, for example. Maintenance is getting to b...

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...

Re: SAS programming and SAS/BI
<div>Auto..,</div> <div>&nbsp;</div> <div>&nbsp;</div> <div>&gt;From what I've read, it hasn't been to clear what all<BR>&gt;is involved with SAS/BI in terms SAS programming. &nbsp;So I take it<BR>&gt;there's really isn't much programming involved.</div> <div>&nbsp;</div> <div>IMO and IME:</div> <div>Yes and&nbsp;No; but really&nbsp;somewhere in&nbsp;between.&nbsp; One reason for&nbsp;the confusion is that SAS BI is a&nbsp;number of products/tools/apps.&nbsp;&nbsp;Another&nbsp;is that&nbsp;companies may use all or only a portion of the BI apps,&nbsp; may&nbsp;still utilize&nbsp;non SAS BI&nbsp;products (Base) and may incorporate non SAS products.&nbsp; So "BI" can&nbsp;mean almost anything you want it to.&nbsp;&nbsp;</div> <div>&nbsp;</div> <div>Yes: There is just as much SAS programming with SAS BI.&nbsp; Just expect to use EG instead of Base.&nbsp; You may&nbsp;or may not&nbsp;use ETL&nbsp;Studio/DI studio.&nbsp;&nbsp;</div> <div>No:&nbsp; There is virtually no SAS programming if you&nbsp;only use the point and click apps (web report studio,&nbsp;etc.) or EG in that manner.&nbsp; </div> <div>No:&nbsp; There is virtually no SAS programming if you are the Admin (set...

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 skills.) 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 to program. The exam does not test how well you can program. That said, when I look for someone to hire that I don't know, I need everything I can get to evaluate the candidate. Sure, it would be nice if they brought a portfolio of their code so I could see what they can write. That seldom happens, and when it does the code is often not really written by the applicant. So, I look for other things. An applicant often tells what they worked on, but that too can be exaggerated. What am I left with? Well, someone can program who doesn't know SAS, but probably they won't be a very good SAS programmer. I'd rather have the exam to judge than to not have the exam. If I were to apply for a job where the employer didn't know me, I would also want the certification to help them make the decision. Oh, as for the version 9 questions, I remember finding several. Just d...

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 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 knowledge. YMMV. Alan Alan Churchill Savian www.savian.net -----Original Message----- From: toby dunn [mailto:tobydunn@hotmail.com] Sent: Tuesday, September 04, 2007 7:04 PM To: savian001@GMAIL.COM; SAS-L@LISTSERV.UGA.EDU Subject: Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. ALan , 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, macro, etc... In your case you dont promote straight SAS solutions and that is great, but a whole other market than a straight SAS programmer. To...

Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #2
jontugman, 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. 7 Exit. 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 understood that as well. However, some recruiters/HRers require the certificate as a CYA backup should they accidentally hire a pure test-passer. Fortunately, I have not seen many occurrences of this nature since the inception of the boondoggle, perhaps because most candidates are almost inevitably interviewed by people qualified in SAS better than HR. And most qualified people saw the program for what it is even before its advent. SAS-L is replete with numerous posts to prove it. Needless to say, it does not imply in any way that any certificate-holder has no more SAS behind the belt than the certificate can cover. Far from that! Many fantastic real-world people have been forced into the thing by their SAS partnership business needs, many have taken it just for the heck of it because their employer would pay for it, etc. My opposition to the thing as a matter of principle is based on t...

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..... Toby Dunn Comprimise is like telling a lie, it gets easier and easier. Each comprimise you make, that becomes your standard. Perfection doesnt exist, once you reach it, its not perfect anymore. It means something else. From: Bob_Abelson@HGSI.COM Reply-To: Bob_Abelson@HGSI.COM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. Date: Tue, 4 Sep 2007 17:22:59 -0400 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. Bob Abelson HGSI 240 314 4400 x1374 bob_abelson@hgsi.com "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 d...

Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #4
Ed , 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 perspective and you can make your choice from there. Toby Dunn Comprimise is like telling a lie, it gets easier and easier. Each comprimise you make, that becomes your standard. Perfection doesnt exist, once you reach it, its not perfect anymore. It means something else. From: Ed Heaton <EdHeaton@WESTAT.COM> Reply-To: Ed Heaton <EdHeaton@WESTAT.COM> To: SAS-L@LISTSERV.UGA.EDU Subject: Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. Date: Tue, 4 Sep 2007 16:52:16 -0400 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 skills.) The exam doesn't know how well you can program...

Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #11
Kevin, 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. #9
ALan , 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, macro, etc... In your case you dont promote straight SAS solutions and that is great, but a whole other market than a straight SAS programmer. Toby Dunn Comprimise is like telling a lie, it gets easier and easier. Each comprimise you make, that becomes your standard. Perfection doesnt exist, once you reach it, its not perfect anymore. It means something else. From: Alan Churchill <savian001@GMAIL.COM> Reply-To: Alan Churchill <savian001@GMAIL.COM> To: SAS-L@LISTSERV.UGA.EDU Subject: Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. Date: Tue, 4 Sep 2007 15:54:31 -0600 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), ...

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 what the goal would be ;-] Alan Alan Churchill Savian www.savian.net -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of toby dunn Sent: Tuesday, September 04, 2007 3:34 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. 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..... Toby Dunn Comprimise is like telling a lie, it...

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 SI's websites? Kevin Kevin Viel, PhD Post-doctoral fellow Department of Genetics Southwest Foundation for Biomedical Research San Antonio, TX 78227 ...

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. Bob Abelson HGSI 240 314 4400 x1374 bob_abelson@hgsi.com "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> To SAS-L@LISTSERV.UGA.EDU cc Subject Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. Ed , 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 perspective and you can make your choice from there. Toby Dunn Comprimise is like telling a lie, it gets easier and easier. Each comprimise you make, that becomes your standard. Perfection doesnt exist, once...

Re: Can a SAS program call another SAS program #3
Dear SAS-L-ers, David Fickbohm posted the following: > 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. > David, there sure is a more elegant way; and a simple one at that! Simply use the %INCLUDE statement. The %INCLUDE statement allows you to in...

Re: Reusing code from SAS Program in another SAS Program #5
Ian, I agree with your statement: "Well maybe it is best postponed to the time Keith shows that parameterization would be helpful to him." If it does turn out that parameterization would be helpful to him, he is in luck. I will agree to offer him, and SAS-L, the best example that my understanding of the SAS Component Language and my meager skills will allow. And I hope you, and as many other mmmm's as possible, will do likewise with the SAS Macro Language. I hope it has become apparent to you and other mmmm's that the SAS Component Language can handle whole classes of pr...

Re: Can a SAS program call another SAS program #2
Dave, What you want to do can be done with %include. Bob Abelson HGSI 240 314 4400 x1374 bob_abelson@hgsi.com David Fickbohm <DavidF@HOMEGAIN.COM> Sent by: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> 10/15/2004 04:05 PM Please respond to David Fickbohm To: SAS-L@LISTSERV.UGA.EDU cc: Subject: Can a SAS program call another SAS program People, 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...

Re: Possible to run a SAS program within another SAS program?
Julie, Uhhh create a macro that simply %includes the programs you want and in what order. It would be very specific to you the creator and user, in other words right biw I can't think of a good way to pass al the info you need to the macro from the user. As you can tell the user interface would be the crucial part of this. I personally wouldnt want to have this in my production code but have written SAS programs that do nothing more than %include a list of programs. Toby Dunn From: oseithedude@GMAIL.COM Reply-To: oseithedude@GMAIL.COM To: SAS-L@LISTSERV.UGA.EDU Subject: Possible to run a SAS program within another SAS program? Date: Wed, 7 Dec 2005 11:28:43 -0800 Hello, I have 9 SAS programs, all within the same Windows folder that I usually run at the same time - one right after the other. For convenience, is it possible to write a simple SAS program that will let me run all the programs at once or to have a program that will allow me to pick and choose which SAS programs I want to run (e.g., in the case I only want to run the first 3 and last program out of the 9 SAS programs) and which order the programs are run in? I guess what I'm really looking for is if there is a way to call another SAS program using only a couple lines of code so that, if I choose not run that program, I can just comment that code out or something like that. Let me know if this is possible, thanks!!! Julie ...

Re: Reusing code from SAS Program in another SAS Program #4
In response to a question by Keith, Paul Choate suggested using %INC. The suggestion is reasonable, but not his explanation. Since %INC is a macro you can put it anywhere in open code and it will read the code snippet during compilation. %INC is neither a macro nor a macro instruction. It is one of a few old SAS commands that begin with a %-sign and predate the current macro language. This can be shown by a batch job run with the option NOMACRO. Here is the log. NOTE: SAS (r) Proprietary Software Release 8.2 (TS2M0) Licensed to The SAS Learning Edition V2.0, Site ...

Web resources about - Re: RE : SAS Programming With Dates -Problem - comp.soft-sys.sas

Mercury (programming language) - Wikipedia, the free encyclopedia
11.07.2 (August 3, 2012 ; 2 months ago ( 2012-08-03 ) ) Mercury is a functional logic programming language geared towards real-world applications. ...

IBM brings Swift to the cloud, releases web framework Kitura written in Apple’s programming language
Only months after Apple officially open-sourced Swift , IBM today is announcing that they are bringing Apple’s Swift programming language to ...

Upfront Report: Scripps to Double Down on Holiday Programming, Halloween Through Christmas
Scripps Network is doubling down on its holiday programming. As part of its pitch to advertisers during the 2016 upfronts, the cable programmer ...

Stephanie Todd Upped to VP Programming at HLN
Stephanie Todd has been promoted to vp of programming at HLN. Todd, who has been with CNN Worldwide more than 20 years, will have oversight ...

JavaScript Dominates As The No. 1 Most Used Programming Language
Programming languages come and programming languages go. Unless you are JavaScript.

HBO to deliver 600 hours of original programming in 2016 as Netflix rivalry intensifies
As we've touched on previously, the sheer volume of original programming being churned out by Netflix is unprecedented. Illustrating the company's ...

Announcing #BlogHer16 Programming Track: Mind Your Business
... strategy says about your business Make your income source(s) work for you I’m looking forward to revealing the rest of our conference programming ...

Sylvia Anderson Dies: ‘Thunderbirds’ Co-Creator And Ex-HBO UK Programming Chief Was 88
... and website confirmed Wednesday. Anderson’s career took her from iconic status in the childens’-television industry to a spin as head of programming ...

Sunday Afternoon ESPN Programming Is Grim
There’s really something to be said for ESPN’s Sunday afternoon programming, when the Worldwide Leader cedes all sports coverage to the broadcast ...

Save hundreds on the Python Programming Bootcamp
Save hundreds on the Python Programming Bootcamp

Resources last updated: 3/18/2016 8:39:59 PM