Dictionary Tables, Proc Datasets, and Macros

From sasCommunity
Jump to: navigation, search

by Justin Fuller

This paper discusses a clever way to pass a SAS dataset name as an argument and get a count of null and non-null entries for each variable.

This paper presents a SAS macro program that will count the number of null and non-null observations for each variable in a SAS dataset using Dictionary Tables, Proc Datasets, and Proc SQL.



Presented at a State of Oregon SAS Users Group meeting.

Find more SOSUG presentations, as well as other tips, tricks, and tools created by or recommended by SOSUG members here.