Posts Tagged ‘ tips and tricks ’

Simple Proc Print trick for grouped data

November 10, 2017
By

Here's a Proc Print trick for grouped data. Suppose your data is divided into groups, such as males and females. You could sort by the grouping variable before printing, like this: Suppose you want to better emphasize the groups. You could add a BY sta...
Read more »

Tags: , , ,
Posted in SAS | Comments Off on Simple Proc Print trick for grouped data

3 freaky ways PROC FREQ can work in your favor

October 31, 2017
By

A ghoulish Halloween Boo to all my readers! Hope my costume freaks you out, but even if it doesn't, I’m positive PROC FREQ will in a few amazing ways! Today’s Programming 2: Data Manipulation Techniques class asked about the power of PROC FREQ. Since I stopped to explain some of it's benefits to

The post Read more »

Tags: , , , ,
Posted in SAS | Comments Off on 3 freaky ways PROC FREQ can work in your favor

Finding your Dream Car with a little macro magic

October 25, 2017
By

Suppose you want a list of car manufacturers from the CARS dataset. Easy!  Call the %CHARLIST macro from a %PUT statement, like this: The CHARLIST macro generates a list of unique values of a selected variable from a selected dataset. So does PROC FREQ. But, if you don't need statistics, the CHARLIST

The post Read more »

Tags: , , , ,
Posted in SAS | Comments Off on Finding your Dream Car with a little macro magic

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 »

Tags: , , , , ,
Posted in SAS | Comments Off on How to format a macro variable

3 steps to prepare your data for accurate predictive models in SAS Enterprise Miner

August 10, 2017
By

In this post I describe the important tasks of data preparation, exploration and binning.These three steps enable you to know your data well and build accurate predictive models. First you need to clean your data. Cleaning includes eliminating variable...
Read more »

Tags: , , , ,
Posted in SAS | Comments Off on 3 steps to prepare your data for accurate predictive models in SAS Enterprise Miner

How severe is your missing data problem?

July 17, 2017
By

Datasets are rarely ready for analysis, and one of the most prevalent problems is missing data. This post is the first in a short series focusing on how to think about missingness, how JMP13 can help us determine the scope of missing data in a given ta...
Read more »

Tags: , , , ,
Posted in SAS | Comments Off on How severe is your missing data problem?

Take that SAS option

May 25, 2017
By

Elizabeth is courageous. Scoliosis since birth, corrective spinal surgery replaced her spine with steel, tripping on stairs permanently broke her right ankle. Then she decided to come take yoga with me. To help ease back pain & reduce hip stress, I offered options like bent legs not cross. In class

The post Read more »

Tags: , , ,
Posted in SAS | Comments Off on Take that SAS option

Determining the size of a SAS data set

April 25, 2017
By

When developing SAS® data sets, program code and/or applications, efficiency is not always given the attention it deserves, particularly in the early phases of development. Since data sizes and system performance can affect a program and/or an application’s behavior, SAS users may want to access information about a data set’s

The post Read more »

Tags: , , , ,
Posted in SAS | Comments Off on Determining the size of a SAS data set

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.