Posts Tagged ‘ ods ’

Order Matters: A Weird Behavior of SAS ODS Style Options

September 4, 2014
By
Order Matters: A Weird Behavior of SAS ODS Style Options

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...
Read more »

Tags: ,
Posted in SAS | Comments Off

Using PROC SGPLOT for Quick High-Quality Graphs

September 1, 2014
By
Using PROC SGPLOT for Quick High-Quality Graphs

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...
Read more »

Tags: , , , , ,
Posted in SAS | Comments Off

Using RTF codes in ODS RTF outputs

January 7, 2014
By

Using RTF codes in ODS RTF outputsEnhancing RTF Output with RTF Control Words and In-Line Formatting
Read more »

Tags: , ,
Posted in SAS | Comments Off

Adding Google Web Fonts to your SAS reports

January 6, 2014
By
Adding Google Web Fonts to your SAS reports

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
Read more »

Tags: , , , , , ,
Posted in SAS | Comments Off

3 Ways to Convert SAS Datasets to Plain Codes

November 5, 2013
By

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,...
Read more »

Tags: , , ,
Posted in SAS | Comments Off

SAS ODS Tagsets Guru Eric Gebhart on Github

September 17, 2013
By

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 ...
Read more »

Tags: , , ,
Posted in SAS | Comments Off

SAS ODS Report Writing Interface: A Quick Demo

February 18, 2013
By
SAS ODS Report Writing Interface: A Quick Demo

I personally nominated SAS ODS Report Writing Interface was the one of the best technology I found in SAS in 2012. It can generates reports cell by cell and row by row and has much flexibility to produce highly customized reports. Basically, to use it, first assign an ODS destination. Nothing new, and I...
Read more »

Tags: , , ,
Posted in SAS | Comments Off

An easy way to find variables in common to data sets

January 30, 2013
By

Over the holidays I was having a discussion with my cat, Ms. Trixie Lou. A question that often arises during the first programming class is the following: how do I find the variables that are in common to these two or three data sets? As it turns out, ...
Read more »

Tags: , , , , , ,
Posted in SAS | Comments Off

Proc-x is looking for sponsors!

Dear readers, proc-x is looking for sponsors who would be willing to support the site in exchange for banner ads in the right sidebar of the site. If you are interested, please e-mail me at: [email protected]

Welcome!

SAS-X.com offers news and tutorials about the various SAS® software packages, contributed by bloggers. You are welcome to subscribe to e-mail updates, or add your SAS-blog to the site.

SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.