How to format a macro variable

October 16, 2017
By

Would you like to format your macro variables? Easy!  Just use the %FORMAT function, like this: What?! You never heard of the %FORMAT function? Of course not, cuz it doesn't exist! No problem. Just create it, like this: %macro format(value,format); %if %datatyp(&value)=CHAR %then %sysfunc(putc(&value,&format)); %else %left(%qsysfunc(putn(&value,&format))); %mend format; The %FORMAT

The post Read more »

Graphs for multiple comparisons of means: The lines plot

October 16, 2017
By
Graphs for multiple comparisons of means: The lines plot

Last week Warren Kuhfeld wrote about a graph called the "lines plot" that is produced by SAS/STAT procedures in SAS 9.4M5. (Notice that the "lines plot" has an 's'; it is not a line plot!) The lines plot is produced as part of an analysis that performs multiple comparisons of

The post Read more »

Cisco Information Server (CIS) and MS OLAP

October 12, 2017
By

Ok, so my recent issue was integrating CIS with Microsoft OLAP cubes. The normal way to do this is to set up MS OLAP (SSAS) with a website and use XML/A to connect. I started down that path and decided to try a different tack based some StackOverflow articles. Here is my approach that...
Read more »

PROC FORMAT Error with CNTLIN

October 12, 2017
By

What I was doing:Using a SQL Server table to feed a PROC FORMAT using CNTLIN.Error message seen:ERROR: Cannot mix missing and nonmissing values in the same rangeCause:START column was defined as character and END column was defined as a numeric (decimal)
Read more »

Transforming Analytics into an Art Form

October 11, 2017
By

As analytics advances into more areas of our everyday life there is an increased need to understand just what it is that analytics is accomplishing for us.  I find there is a quicker acceptance of an analytical solution and even excitement if there is a good conceptual understanding of what

The post Read more »

Scottish Festivals and Highland Games

October 11, 2017
By

I recently took a trip to Scotland, to attended the Highland Games! (ok - that statement might be a tiny bit misleading) It was a very cool and interesting event, and I wondered where and when other such events might be happening. What better way to an...
Read more »

Simulate correlations by using the Wishart distribution

October 11, 2017
By
Simulate correlations by using the Wishart distribution

The article "Fisher's transformation of the correlation coefficient" featured a Monte Carlo simulation that generated sample correlations from bivariate normal data. The simulation used three steps: Simulate B samples of size N from a bivariate normal distribution with correlation ρ. Use PROC CORR to compute the sample correlation matrix for

The post Read more »

Reading and writing GZIP files with SAS

October 10, 2017
By
Reading and writing GZIP files with SAS

SAS 9.4 Maintenance 5 includes new support for reading and writing GZIP files directly. GZIP files, usually found with a .gz file extension, are a different format than ZIP files. Although both are forms of compressed files, a GZIP file is usually a compressed copy of a single file, whereas

The post Read more »

An introduction to SAS Visual Analytics: the Parallel Period function of the Derived Item calculations

October 9, 2017
By

My new SAS Press book “An Introduction to SAS Visual Analytics” (written in collaboration with Tricia Aanderud and Rob Collum) covers all of the different aspects of SAS® Visual Analytics, including how to develop reports, load data, and handle administration. Below is an example of the types of tips that you can find

The post Read more »

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.

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: tal.galili@gmail.com
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.