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

Monday, July 4, 2022

SAS Date Calculator Now Available

SAS Date Calculator* Date: Days since 1/1/1960: ...

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...

View web version

Powered by Blogger.