Code Doctors

From sasCommunity
Jump to: navigation, search

Code Doctors

Annual SGF conferences have many good aspects. We can duplicate the best features in the virtual global SAS users group here. Put up your coding question and the doctor will be right with you. Doctors, watch Recent Changes on the left bar. Charlie Shipp 03:56, 18 April 2010 (UTC)


Click on the 'edit' tab to edit this page with your question; and click on 'save' under the edit-box, after 'preview' if you want. Be sure you don't leave with only previewing or your editing will be lost. You may want to create you text in a word doc or at least have your important writing on the clipboard. The right questions and answers could later appear as a sasCommunity.org TIP. Charlie Shipp 04:11, 18 April 2010 (UTC) Comments about "Code Doctors" can go into 'Discussion'.


QUESTION: How do I improve my 'search' in sasCommunity.org ?
PS: Lainie Hoverstad is programmer for this site and presented an SGF paper on this.
Charlie Shipp 13:46, 20 April 2010 (UTC)

Lainie will have time later to discuss the sasCommunity.org extended search capabilities. For now you can read her co-authored paper:
http://support.sas.com/resources/papers/proceedings10/299-2010.pdf
to learn about putting exact important wording in quotes, adding a required word with ‘+’ and excluding entries with ‘-’ when you see too many links going to Scandinavian Airlines or SAS Shoes, for example. Your search can be an iterative process. Plus Renee Harper and Lainie Hoverstad teach that Google search is popular. Be sure to look at the sasCommunity.org SASopedia:
http://www.sascommunity.org/wiki/Sasopedia

Charlie Shipp 21:01, 21 April 2010 (UTC)


QUESTION: What were the major announcements at SAS Global Forum 2010 Seattle; and which detail generated the most discussion on SAS-L?
ANSWER: http://www.SAS.com/news has the major announcements: Free hardware/software for schools; massive parallel processing w/SAS; SAS Social Media and SAS Social Media Analytics; SAS Mobile Dashboard (for business leaders); Interfaces to the R open-source statistical computing language for SAS and JMP.

But by far the most discussed item on SAS-L was the announced move from Display Manager (DM) to Enterprise Guide (EG). I’ll put Jack Hamilton’s more extended list of his favorite items learned in my SGF notes next week. Charlie Shipp 04:07, 23 April 2010 (UTC)

Check out "personal Highlights" of Susan Slaughter on her excellent business site.!.
http://susanslaughter.wordpress.com/2010/04/19/highlights-of-sas-global-forum/ .!.
Hope this helps. Charlie Shipp 02:55, 24 April 2010 (UTC)
Please also visit http://www.sascommunity.org/wiki/SAS Global Forum 2010 Town Hall
Here is the original Jack Hamilton note that generated so much interest and discussion:
"Not in any particular order:
- SAS is pushing Enterprise Guide over SAS for Windows Display Manager as the primary interface for users. In the EG 4.3 code editor, there will code completion and context sensitive help. This will be very helpful. The person I talked to said that this would not be put into the SAS for Windows Enhanced Editor.
- The next release, 9.22, is due this summer. [Later discussion revealed that this might not be a complete release, but only for some Stat products. SAS's use of version identifiers is confusing.]
- They are putting a lot of work into mobile interfaces to SAS data. The demo was of the iPhone, but there will also be versions for Blackberry and Windows mobile. It appears that they are going for proprietary solutions rather than standards-based one.
- JMP 9 will include the ability to call R, and there's an add-in for Excel.
- "Social Media analysis" and "sentiment analysis" were the buzzwords. Think of it as text mining Twitter - huge amounts of data to process.
- Under consideration for formats:
- Regular expression validation
- Regular expression transformation
- Ability to call user-created function as a format.
- PROC REPORT
- This trick was known to other people, but not to me: you can effectively make the LINE statement conditional by printing it with $VARYING with a length of 0. And it's likely to stick around.
- No plans to allow grouping or ordering by calculated variables.
- The ability to call stored procedures from batch SAS is under consideration. This would be very useful.
- The ZIP filename engine for input is present but not supported for 9.2. It's not likely to be supported in 9.3, maybe in 9.4. Writing ZIP files is already supported in SAS 9.2 as part of ODS. No password support.
- The next version of the SAS Add-In for Microsoft Office will support uploading data in a fairly clean way. That will come out this summer. Version 4.4, maybe next year, will support the ExcelXP tagset, so it will be possible to download multi-page workbooks with formulas.
- Linguistic sorting and non-native sorting are much better supported. We can sort a and A together, or use the ASCII sequence on the mainframe. Procs and the data step recognize the non-binary sorting. Not everywhere, though.
- Firebird/TSPL is supported, but not documented, and they have withdrawn the documentation. They're adding security, which is good - SAS doesn't really do that now. And it has triggers in base SAS. I suggested adding shared hash objects across threads - that would be useful for some types of processing on very large data sets.
- Judging by the volume level at the plenary sessions, the conference organizers either think we're deaf, or want us to become deaf.
- Not much work has been done on managing BI objects. There were some papers last year that I'm following up, and I talked to several people about possible future directions.
Two good papers:
- "Evolve from a Carpenter’s Apprentice to a Master Woodworker: Creating a Plan for Your Reports and Avoiding Common Pitfalls in REPORT Procedure Coding", Allison Booth, <http://support.sas.com/resources/papers/proceedings10/133-2010.pdf>.
- "Aggregation without Aggravation: Determining Spatial Contiguity and Joining Geographic Areas Using Hashing", Gwen LaSelva, <http://support.sas.com/resources/papers/proceedings10/223-2010.pdf>. "
ANSWER-2: The second item to generate (second-most) interest on SAS-L is :: "Is R of interest to SAS programmers or not?" FYI.

QUESTION: Can someone tell me what are the High Level Feature differences between JMP and SAS's Analytic Pro offering which is a bundling of SAS BASE, STAT, and GRAPH. I am looking to see if I am missing something because they both appear to be have many similar features. Which are missing in JMP that I might be missing?
ANSWER-1: Think of the full SAS package as your soccer-van to carry the whole team; and JMP as your sports racing car to explore the data world.
ANSWER-2:
ANSWER-3: