topic Re: how to detect how many obs in one dataset in SAS Programming

how to detect how many obs in one dataset

Bal23 — Tue, 05 Sep 2017 12:45:18 GMT

Someone suggest:

proc sql noprint;
select count(*) into :observations from library.dataset;
quit;

Would anybody tell me what to do next? Thanks.

Re: how to detect how many obs in one dataset

PeterClemmensen — Tue, 05 Sep 2017 12:47:39 GMT

What is your goal? What do you want to achieve?

Re: how to detect how many obs in one dataset

Bal23 — Tue, 05 Sep 2017 13:11:44 GMT

get the total number of obs

Re: how to detect how many obs in one dataset

Astounding — Tue, 05 Sep 2017 13:15:43 GMT

This creates a macro variable holding the count. You could write it out:

%put &observations;

Or a DATA step could use it:

n_obs = &observations;

When the emoticon replacing your actual code, it's difficult to determine what the exact name of your macro variable is ... &observations, or &n_observations, or something similar.

Re: how to detect how many obs in one dataset

Reeza — Tue, 05 Sep 2017 17:17:26 GMT

Try SASHELP.VTABLE or the corresponding dictionary table.

proc sql noprint;
select nobs into :nobs_class TRIMMED
from sashelp.vtable 
where libname='SASHELP' and memname='CLASS';
quit;

%put Number of obs = &nobs_class;