SAS Users
Providing technical tips and support information, written for and by SAS users.
Challenge accepted: Learning data prep in CASL
As a long-time SAS 9 programmer, I typically accomplish my data preparation tasks through some combination of the DATA Step, Proc SQL, Proc Transpose and some housekeeping procs like Proc Contents and Proc Datasets. With the introduction of SAS Viya, SAS released a new scripting language called CASL – a
Automating SAS variable labels creation
SAS' Leonid Batkhan shows you how to automate creation of SAS variable labels so tables and reports are easier to read.
Accessing Excel files using LIBNAME XLSX
If you have been using SAS for long, you have probably noticed that there is generally more than one way to do anything. (For an example, see my co-author Lora Delwiche’s blog about PROC SQL.) The Little SAS Book has long covered reading and writing Microsoft Excel files with the