I actually think you are straight-jacketing the interview for a seniorperson. 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 anew spin on them. I ditched most of the macro language a decade ago, forexample.As a hiring manager, I always went for creativity and not specific skills onhand and was very pleased with my hires. But hey, I don't hire anymore so itisn't something I have to face.BTW, no client has ever asked me for certification nor have I been quizzedon specific SAS knowledg...
Re: Deleting SAS Data from a SAS DATASET #10
On Fri, 15 Aug 2008 17:20:13 -0500, Mary <mlhoward@AVALON.NET> wrote:>And what about the time of the database administrator who now needs to keeptrack of 24 indexes to each index in the previous table? I just can't seeour DB2 administrators would have ever thought to organize the data thisway, though we had many very large tables, like the user had, that werepurged by month; it does seem like it would be a lot of 'people work' tomanage 24 tables plus one index instead of just one table, even if queryingdidn't suffer(and I do think that it could).....hi,There are only 24, not like thousands or millions! :-) and with any DBsystem, if you have a huge table, then it is more likely that it will map tomultiple physical files behind the scene anyway.In terms of querying speed, i rather think it can be faster. One way is tospawn many sas sessions to do multiple separate queries at the same time,then put together... sort of like do-it-yourself parallel processing.implementation is left as homework. happy friday!cheers,chang...
Re: PC SAS vs. Mainframe SAS #10
I started off on mainframes with ISPF and JCL 24 years ago. Didn't make thecomplete move to Windows until around 1998 or 1999. Been doing Windowsexclusively since then. Just letting you that I've spent years in bothworlds.First, perhaps this is just a matter of taste, but I find the Windowsdevelopment environment far superior to the mainframe. I do admit that I'venot heard of syntax highlighting or other enhancements you mention. Nor doI know of anyone else who has. I guess this is not more widely knownbecause the mainframe types that I've run into aren't rea...
Re: Converting from SAS 5 to SAS 9 #10
http://www.sas.com/presscenter/bgndr_history.html1985 ... Technology milestones...First SAS System release for PC DOS (Base SAS and SAS/RTERM software) isimmediate success.Micro-to-mainframe link (SAS/C Compiler) is introduced for PCs linking tomainframes.Paul ChoateDDS Data Extraction(916) 654-2160-----Original Message-----From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of NatWoodingSent: Friday, December 17, 2004 7:01 AMTo: SAS-L@LISTSERV.UGA.EDUSubject: Re: Converting from SAS 5 to SAS 9RobinI must beg to differ- A pc DOS version of SAS was announced...
Re: SAS Text Editor #6
Try Crimson Editor. It's free.Wensui Liu <liuwensui@GMAIL.COM> escribi�: emacsOn Tue, Apr 29, 2008 at 6:02 AM, cherish k wrote:> I got the add ons from the text pad website. Thanks anyway. If there is any other better free editor, please let me know.>> Cherish>> cherish k wrote: Hi Dan,>>>> Thanks for the reply. I too use Textpad but I don't know how to how to set it up so that it can highlight for the SAS syntax. How to configure it for the SAS extension syntax.>> Thanks> Cherish>> 'Nordlund, Dan (DSHS/RDA)'...
Re: AW: SAS Text Editor
you mean the old DEC EDT editor, or an emulator?I've used Anker-Berg Sonne's SEDT on pc's, and it does a pretty good job..j.Stefan Pohl wrote:> Uses someone SAS in WinEdt?>> Stefan.>>> -----Urspr�ngliche Nachricht----->> Von: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] Im>> Auftrag von Fehd, Ronald J. (CDC/CCHIS/NCPHI)>> Gesendet: Dienstag, 29. April 2008 22:01>> An: SAS-L@LISTSERV.UGA.EDU>> Betreff: Re: SAS Text Editor>>>>> From: cherish k>>> Can somebody direct me to a good SAS text editor for Windows.>>> Basically I need for just syntax highlighting (I don't need>>> an editor with prompts etc).>> http://www.sascommunity.org/wiki/Text_Editors>>>> http://en.wikipedia.org/wiki/Comparison_of_text_editors>--'Games? Solitaire? I have a 2-node VAXcluster, 3 Windows 2000 servers, 2Windows 2003 servers, 1 MySQL Database Server, 1 Postgres DatabaseServer, 1 Linux server, several Ubuntus and a direct satellite feed tomy windows desktop background, who needs toys???' - Jim...
Re: SAS Text Editor #3
I got the add ons from the text pad website. Thanks anyway. If there is any other better free editor, please let me know.Cherishcherish k <hawks_cherish@yahoo.co.in> wrote: Hi Dan,Thanks for the reply. I too use Textpad but I don't know how to how to set it up so that it can highlight for the SAS syntax. How to configure it for the SAS extension syntax.ThanksCherish'Nordlund, Dan (DSHS/RDA)' <NordlDJ@dshs.wa.gov> wrote: > -----Original Message-----> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On> Behalf Of cherish k> Sent: Monday,...
Re: SAS Text Editor #11
Cherish,You can request for a free copy of my Notebook Light. Its built-in CodeEditor is ready to use -- no complex configuration required just for syntaxhighlighting. You can easily submit your code/program for processing by thelocal SAS server. Batch processing? -- no problem!It opens SAS log files in color, too, plus you get IntelliSense and a nicecode indenter, which you can't find anywhere.If you want to boost your productivity, this is the right tool to own. Idon't believe anyone is too old to be learning new tricks!And in case you didn't know, this tool has the 'thumbs up' from Paul Kent,Vice President, Platform Research and Development (based from an e-mail Ireceived from him last year).Regards, Audihttp://sas2themax.com----- Original Message -----From: 'cherish k' <hawks_cherish@YAHOO.CO.IN>To: <SAS-L@LISTSERV.UGA.EDU>Sent: Thursday, May 01, 2008 11:44 PMSubject: Re: SAS Text Editor> Hi Dan,>> Thanks a lot for the help. I was able to configure it.>> Regards,> Cherish>> 'Nordlund, Dan (DSHS/RDA)' <NordlDJ@dshs.wa.gov> wrote: > -----Original> Message----->> From: cherish k [mailto:hawks_cherish@yahoo.co.in]>> Sent: Tuesday, April 29, 2008 1:03 AM>> To: Nordlund, Dan (DSHS/RDA); cherish k; SAS-L@LISTSERV.UGA.EDU>> Subject: RE: SAS Text Editor>>>> Hi Dan,>>>> Thanks for the reply. I too use...
Re: SAS Text Editor #7
Excellent Question!!!!! I can think of several..I used to use DIGITAL's EDT and then TPU/EDT for aLooooooooooooonnnnnnnnggggggggggg time... ;-) Until all the keypadactivity on one hand started giving me trouble...I then switched to Gvim, (Vi iMproved). It's a superset of the vieditor, and it has SAS syntax builtin, plus syntaxes (sp?) for almostevery known language..Knowing and using ONE editor makes for very fast and efficent editing..Plus, for me, using batch mode makes sure my SAS code encapsulates allmy logic, so it 'remembers' what I did. We had one user ...
Re: SAS Text Editor #9
I don't suppose anybody out there is using the 'e' editor for sas are they? I'm really liking it for ruby/rails work, but haven't tried to set it up for sas. And since it's a clone of a mac program (textmate) there doesn't seem to be much in the way of sas support...I never thought I'd consider ditching ultraedit, but those snippets... So convenient.-----Original Message-----From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of webonomicSent: Wednesday, April 30, 2008 4:04 PMTo: SAS-L@LISTSERV.UGA.EDUSubject: Re: SAS Text EditorSimilar to Crimson Editor is Context Editor:http://www.contexteditor.org/SAS highlighter: http://www.contexteditor.org/highlighters.php?filter=Q-TAlternatively, give sas2themax a try. I use it fairly often and it works great. http://sas2themax.comJaredOn Apr 30, 8:06 am, liuwen...@GMAIL.COM (Wensui Liu) wrote:> i am wondering here if there is anyone who has experience using emacs> + ess on unix and run the sas within emacs? If yes, how is the> configuration of emacs?> I really appreciate any insight.>>>> On Wed, Apr 30, 2008 at 9:42 AM, Jim Agnew <ag...@vcu.edu> wrote:> > you mean the old DEC EDT editor, or an emulator?>> > I've used Anker-Berg Sonne's SEDT on pc's, and it does a pretty good job..>> > j.>> > Stefan Pohl wrote:>> > > Uses someone SAS in WinEdt?>> >...
Re: SAS Text Editor #5
emacsOn Tue, Apr 29, 2008 at 6:02 AM, cherish k <hawks_cherish@yahoo.co.in> wrote:> I got the add ons from the text pad website. Thanks anyway. If there is any other better free editor, please let me know.>> Cherish>> cherish k <hawks_cherish@yahoo.co.in> wrote: Hi Dan,>>>> Thanks for the reply. I too use Textpad but I don't know how to how to set it up so that it can highlight for the SAS syntax. How to configure it for the SAS extension syntax.>> Thanks> Cherish>> 'Nordlund, Dan (DSHS/RDA)' <NordlDJ@...
Re: SAS-L BOF at SAS Global Forum 2009 #10
Thanks Joe and congratulations to you too. And thank you all for thekind words.I enjoy my time spent here on SAS-L, I learn something most every daynot always just about SAS. In 30 years learning SAS I've learned moresince I began participating actively in SAS-L than in all the timebefore that. I hope to learn a lot more in future.Maybe I will get to SGF next year.On 3/26/09, Joe Matise <snoopy369@gmail.com> wrote:> Also, congrats to _null_, very well deserved indeed - i've learned a ton> from many of you, and _null_ is high on that list :)>> -Joe>> On Thu, Mar 26, 2009 at 8:09 AM, Joe Matise <snoopy369@gmail.com> wrote:>> > Thanks all, very honored! It's a pleasure to learn from everyone and> > occasionally return some of that learning to others. I regularly amaze my> > (much more experienced) colleagues with tips from the list :)> >> > Hopefully I'll be able to attend one of the SGFs someday soon and meet you> > all!> >> > -Joe> >> >> > On Wed, Mar 25, 2009 at 7:49 PM, Arthur Tabachneck <art297@netscape.net>wrote:> >> >> My congratulations to DataNull and Joe, as well, both extremely well> >> deserved.> >>> >> And, if you had as much trouble as I did in trying to click on Mike's link> >> to the analyses, hopefully the following will work better:> >>>...
Re: SAS pays expenses for 10 students to present at SAS Global
datastepper@YAHOO.COM wrote:>>SAS-Lers,>>Please excuse me if this post is not appropriate for this forum. I am a>long time reader, first time poster to the list.>>I got an email from SAS about an opportunity for students- and thought>folks out there might be interested.>>SAS is paying for up to 10 students to present a paper at SAS Global Forum.>This is part of the 'SAS Student Ambassador Program'.>>Apparently, airfare and hotel are included as well as registration fees.>You can find out more at>http://www.sas.com/govedu/edu...
Re: Indenting text in SAS editor? #3
Mark the text,press the tab indent puttonorMark the textPress the Shift TAb to decrease teh indent levelWorks for me---- David Wright <David_wright@SPRA.COM> wrote:> rolandberry@hotmail.com (RolandRB) wrote in> <1162331780.609358.291340@b28g2000cwb.googlegroups.com>:>> >> >David Wright wrote:> >> Is there a quick way to indent a range of text in the (enhanced) SAS> >> editor?> >>> >> How about submitting text?> >>> >> -Using SAS 9.1 for windows xp2> >> >Isn't it done by...
Re: Suggested enhancements to the SAS text editor
I would be interested in text excluding and string manipulation.Wendi-----Original Message-----From: Nat Wooding [mailto:Nathaniel_Wooding@DOM.COM]Sent: Monday, October 06, 2003 2:43 PMTo: SAS-L@LISTSERV.UGA.EDUSubject: Suggested enhancements to the SAS text editorThe recent thread on text editors (which I have not had time to readcompletely) and especially ISPF reminded me that at NESUG, I asked aboutsome possible enhancements and was asked to poll the list to see if howmuch interest there is.In particular, I would like to see the exclude and find all functions. Forthose who ...
Re: Include SAS code w/o including SAS code #10
Summary: Macro generation of correct SAS code requires SAS execution.#iw-value=1Alan,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, thattitle statement depends on the execution of the previous steps.Hence it cannot be generated by the macro facility without actuallyexecuting the previously generated code.The problem is similar to that of using CALL EXECUTE to generateSAS code via a macro call. In the case of CALL EXECUTE one can workaround the problem by using %NRSTR to hide the call during the DATAstep execution, but you have explicitly required the macro to generatecorrect code without executing. Now there is no work around.In essence you are asking, 'Is the macro facility so weak that thereis a program that can predict the output of every macro withoutexecuting it?' Since that output can depend on the execution of SAScode, one must first be able to predict the result of executing everySAS program without actually doing the executing. It seems highlyunlikely that the SAS Institute is up to the jo...
Re: Exporting a SAS data set to Text file on SAS unix #3
hi ... actually, what I posted earlier was too much code (sorry)this is enough (a bit more succinct)* variable names into a macro variable (tab separated);proc sql noprint;select name into :vars separated by '09'xfrom dictionary.columnswhere libname eq 'SASHELP' and memname eq 'CLASS'order varnum;quit;data _null_;file 'z:class.txt' dsd dlm='09'x ;if _n_ eq 1 then put '&vars';set sashelp.class;put (_all_) (:);run;--Mike ZdebU@Albany School of Public HealthOne University PlaceRensselaer, New York 12144-3456P/518-402...
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 8dates are a subtype of numericand are identified by their date, datetime, or time formatsthe 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/a003065339.htmhttp://s...
Re: Indenting text in SAS editor? #4 1557896
Thank you Choate, Paul@DDS <pchoate@DDS.CA.GOV> for such generous praise:>A great paper on this is>http://www2.sas.com/proceedings/sugi31/237-31.pdf - The Personal Touch:>Control Your Environment as a SAS(r) User by Peter Crawford - if you>ever get a chance, go see one of Peter's presentations at SGF, he's a>master.Those of you in reach of London (UK, not ontario.....) might beinterested in the technical event http://www.technical-event.co.ukreferred earlier on SAS-L, athttp://listserv.uga.edu/cgi-bin/wa?A2=ind0610D&L=sas-l&P=61556>The Tech...
Re: Indenting text in SAS editor? #4 677058
This '))' syntax is used in the old SAS Program Editor, not the EnhancedEditor. The editor syntax resembles SPF on MVS.hthPaul ChoateDDS Data Extraction(916) 654-2160-----Original Message-----From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf OfDavid WrightSent: Monday, November 06, 2006 3:30 PMTo: SAS-L@LISTSERV.UGA.EDUSubject: Re: Indenting text in SAS editor?rolandberry@hotmail.com (RolandRB) wrote in<1162331780.609358.291340@b28g2000cwb.googlegroups.com>:>>David Wright wrote:>> Is there a quick way to indent a range of text ...
Re: Running SAS jobs sequentially in batch mode
harry.droogendyk@RBC.COM replied:>Create a new 'master' program, and %include all the production jobs in>sequence.>>Note that unless you clean up work datasets and any macro variables>created by each production job, subsequent jobs will not be starting in>a pristine environment. It may be a good idea to include a new program>between each production job to kill all work datasets and query>sashelp.vmacro to create %symdel statements to delete macro variables.Since I haven't said the 'P' word in a few days, let me suggest:PerlA Perl &...
Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year.
I took the advanced exam this April because I wanted a relativelysystematic 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 newway, I assume my knowledge of SAS is uneven, even though I am regardedas productive, and frequently creative in using SAS to solve our group'sproblems.I passed the test, with lower subscores on the components that Iexpected to be weakest on. I thought many of the questions made methink about some fundamental, sometimes subtle, features of thelan...
how to add fonts to the sas registry (was RE: Re: sas/graph:
Success! A google search led me to:http://support.sas.com/documentation/onlinedoc/base/91/freetype-hub.pdfWhich includes the magic option on FONTREG to use the 'all' mode. (Andnow that I look back on the FONTREG docs, I see it there was well :-P).So here's code that works:* ;proc fontreg mode = all msglevel = verbose ; truetype 'c:windowsfonts' ;run ;data phoney ; do n = 1 to 2000 ; x = ranuni(-1) ; if n le 1000 then grp = 'one' ; else grp = 'two' ; output ; end ;run ; gopti...
Re: R vs. SAS (was Replacement for SAS (SPSS vs. SAS, redux)) #3
Wow, that was a leap. Better not use Apache or PHP then.Andy>-----Original Message----->From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On>Behalf Of ben.powell@CLA.CO.UK>Sent: Thursday, February 05, 2004 10:37 AM>To: SAS-L@LISTSERV.UGA.EDU>Subject: Re: R vs. SAS (was Replacement for SAS (SPSS vs. SAS, redux))>>Sounds like R is the SAS equivalent of Linux .. who are>incidentally in all>sorts of a copy left/right mess at the moment.>>On Thu, 5 Feb 2004 09:39:37 -0500, Peter Flom <flom@NDRI.ORG> wrote:>>>I use both SAS a...
There is no shortage of options for text editors geared towards developers on the Mac, but TextMate is our top pick. It wins out thanks to its massive programming language syntax support, helpful code snippets, expandability, and integration with the OS X terminal.
Every SAS analyst must know every SAS keyboard shortcuts that are used in Mac OS X and Windows operating systems. Check SAS Keyboard shortcuts for SAS Studio Workspace and code editor. Select text from the cursor to the same location on the previous line. UltraEdit is an award-winning text editor. CNET/Download.com says about UltraEdit: 'With its clear layout and powerful project and work-space features, it can handle complex and sophisticated software-development projects.
TextMate
Platform: Mac OS X
Price: Free!
Download Page
Features
- Column Selections and Column Typing
- Expand Trigger Words to Code Blocks With Tab-able Placeholders
- Support for Darcs, Perforce, SVK, and Subversion
- Works As External Editor for (s)ftp Programs
Note: This feature list is borrowed from the TextMate site and the links will take you directly to TextMate's pages containing more info on each feature.
Advertisement
Where It Excels
TextMate is excellent. It's as simple as you need it to be, providing only a single window for editing a single document, or it can expand to handling a large file structure. It supports syntax highlighting for practically any programming language you can think of, plus it contains code snippets. These things can be expanded by downloading third-party add-ons. TextMate has great code organization features. It updates frequently enough that you feel taken care of but not so frequently you want to smack it in the face (like with Evernote). You can even use TextMate as your text editor in the terminal with the command mate
. If you're looking for a WYSISYG editor, TextMate—and this entire category—is not for you. If you just want to write code in a great editor, you've come to the right app.
Notepad For Mac
Advertisement
Where It Falls Short
Organizing the files you're currently working on could be a little more user-friendly, as it can be a little bit tedious if you don't open your entire work folder immediately at launch. The undo history is so detailed that you can find yourself pressing Command+Z a lot just to get back to the place you wanted. Generally it's just faster to retype it. Overall, though, there's very little to complain about. At one point we complained about its $58 price tag, but now that TextMate is open-source and free it's got almost everything going for it.
Advertisement
The Competition
Sas Text Editor For Macro Convert
It's impossible to avoid mentioning SublimeText because it's so similar. It has almost the same support for language syntax as TextMate, and even has a Windows version as well (which is where the app originated, but that Mac version is still very Mac-like). Honestly, whether you use Sublime Text or TextMate is really going to come down to preference. They're both excellent and both, perhaps, a bit too expensive. They also both come with trials, so you can check them both out and decide for yourself.
Advertisement
But maybe you're someone who doesn't want to pay for their programming-friendly text editor. If that's you, there are a couple of other alternatives that don't cost a thing. First, TextWrangler is a capable option with a loyal user base (if they haven't already upgraded to its big brother BBEdit), but it's a little low on capabilities and has an interface that feels pretty dated. Alternatively, there's Fraise (the successor to Smultron), which is another free, capable, but not-as-amazing-as-TextMate (and Sublime Text) text editor.
The other free option that's probably most like TextMate (and Sublime Text, for that matter) is Kod. It supports over 65 languages, is remarkably fast and lightweight, and only comes with one real disadvantage: it's in its early stages of development. When I checked it out earlier this year, however, it was pretty solid. Kod is very much worth a look, even if it hasn't been around for quite as long as the others.
Advertisement
Simple Text Editor For Mac
Lifehacker's App Directory is a new and growing directory of recommendations for the best applications and tools in a number of given categories.
Advertisement