topic Re: Is Dataset Empty in Developers

Is Dataset Empty

DavidPhillips2 — Fri, 28 Aug 2015 18:43:08 GMT

Is there a simple way to check if a SAS dataset is empty in 9.2?

I could do a proc sql with count(*) but I was hoping for something with less lines.

Steelers_In_DC — Fri, 28 Aug 2015 19:10:51 GMT

Either one will give you the same thing, could save time if the dataset turns out to be huge, you wouldn't have to wait for the count():

proc datasets lib=work nolist;contents data=have;quit;run;

proc contents data=work.have;

Quentin — Fri, 28 Aug 2015 20:08:39 GMT

I like these macros for counting obs and checking if a dataset is empty.