When making a new piece of code, I like to use the smallest font I can read. This lets me fit more text on the screen at once. When presenting code to others, especially in a classroom setting, I like to make the font large enough to see from the back…
Tag: tips and tricks
“Wide” versus “Tall” data: PROC TRANSPOSE v. the DATA step
Datasets can present themselves in different ways. Identical data can bet arranged differently, often as wide or tall datasets. Generally, the tall dataset is better. Learn how to convert wide data into tall data with PROC TRANSPOSE.
The post "Wid…
Deleting global macro variables
Do you periodically delete unneeded global macro variables? You should! Deleting macro variables releases memory and keeps your symbol table clean. Learn how the macro language statement that deletes global macro variables and about the %DELETEALL st…
Jedi @ SASGF: Working with Big Data in SAS
The SAS Jedi Mark Jordan presents his SAS Global Forum 2018 paper “Working with Big Data in SAS”
The post Jedi @ SASGF: Working with Big Data in SAS appeared first on SAS Learning Post.
SAS Enterprise Guide tools for programmers
If you are a SAS programmer, you may wonder why you should read this. After all isn’t SAS Enterprise Guide just for folks who don’t want to be bothered writing SAS code? SAS Enterprise Guide is just point, click, and get results, right? Well there is a…
Simple Proc Print trick for grouped data
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…
3 freaky ways PROC FREQ can work in your favor
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 3 freaky ways PROC FREQ can work in your favor appeared first on SAS Learning Post.
Finding your Dream Car with a little macro magic
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 Finding your Dream Car with a little macro magic appeared first on SAS Learning Post.