There’s an old song that starts out, “You Can Get Anything You Want at Alice’s Restaurant.” Well, maybe you are too young to know that song, but if you’re a SAS users, you’ll be glad to know that you can capture anything produced by any SAS procedure (even if the […]
The post Capturing output from any procedure with an ODS OUTPUT statement appeared first on SAS Learning Post.
The ODS statement controls most aspects of how SAS creates your output results. You use it to specify the destination type (HTML, PDF, RTF, EXCEL or something else), as well as the details of those destinations: file paths, appearance styles, graphics behaviors, and more. The most common use pattern is […]
The post Using the ODS statement to add layers in your ODS sandwich appeared first on The SAS Dummy.
The codes to push a dataset to Excel (technically XML): ods tagsets.excelxp file=”test.xls”; *#1; ods tagsets.excelxp options( sheet_name=’test 1′); proc print data=sashelp.class noobs; var height / style={tagattr=’format:text’} style(column)={cellwidth=.5 in}; run; *#2; ods tagsets.excelxp options( sheet_name=’test 2′); proc print data=sashelp.class noobs; var height / style(column)={cellwidth=.5 in} style={tagattr=’format:text’} ; run; ods tagsets.excelxp close; […]
Soon I will travel to San Jose for the Western Users of SAS Software 2014 Educational Forum and Conference. I’m looking forward to doing a hands-on workshop on one of my favorite topics, ODS Graphics, specifically the PROCs SGPLOT and SGPANEL. Here is the abstract: New with SAS 9.2, ODS Graphics introduced a whole new […]
Using RTF codes in ODS RTF outputsEnhancing RTF Output with RTF Control Words and In-Line Formatting
Because I began my SAS career in the Publications division, I like to think that I have a keen eye when it comes to SAS documentation. When I first visited the SAS 9.4 online documentation, I immediately noticed that it had a different look. Examine the image below; can you […]
1. If you have SAS Enterprise Guide installed Try one of Chris Hemedinger’s EG plug-ins, “Data Set to DATA Step”. Chris also wrote a post for it, Turn your data set into a DATA step program. 2. If you need to embed the dataset to SQL Clauses Use one of Eric Gebhart’s ODS tagsets, “SQL […]
Check it out:
https://github.com/EricGebhart
Also, his homepage:
http://ericgebhart.com/
Shameless Ad: I will have a talk on Github for SAS programmers in the forthcoming SESUG (Oct 20-23, 2013) at St.Pete Beach, FL. Welcome to drop by if you are on …