SAS Tips by Hal

A SAS user's site featuring a free SAS date calculator, a free SAS datetime calculator (JavaScript), code snippets, and brief discussions

Sunday, December 6, 2015

Proc SQL: Using Joins in an Update Statement

I ran into simple use case the other day -- with a surprising outcome. There was a parent and a child table, and I wanted to use an UPDATE ...

Saturday, June 13, 2015

Two Methods to Create a CSV: Proc Export and the Data Step

Sample PROC Export procedure to export a SAS dataset to CSV: proc export data =work.DATASET_NAME; outfile = 'c:\users\public\EX...

Friday, March 20, 2015

SAS Macro to Print Record Counts for All Tables in a Library

/*----- PRINT RECORD COUNTS OF ALL TABLES IN LIBRARY -----*/ /* Looping code from Paper 93-26 by Edward Moore: http://www2.sas.com/procee...

Wednesday, March 18, 2015

SAS Macro to Import CSV Files into SAS

/*********************************************************** IMPORT CSV files into SAS Work Library June 10, 2011 http://sastipsbyhal.bl...

Tuesday, March 17, 2015

Need help choosing data visualization colors? Try ColorBrewer2.org

Are you making a data visualization and interested in adding a custom set of colors to make the information really fly off of the page? I...

View web version

Powered by Blogger.